Hi everyone,

I recently upgraded from Cognos 12.0.4 to 12.1.1, and while most things look good, I've noticed a few unexpected behaviors in user management that I'm not sure are environment-specific or part of the new release.

Here's what I've seen so far:

• In 12.0.4, I could add users to groups before their first login, and Cognos would automatically create their profile when they logged in.
• In 12.1.1, doing the same seems to cause issues:
• If I add a user to a group before their first login or before I create their profile, the user cannot log in and gets errors like:
  CM-REQ-4159, CM-CAM-4005, and CAF-WRN-2082.
• The user profile becomes a "phantom" profile:
• No Delete button in the UI.
• Create Profile fails with CM-REQ-4036 (object already exists).
• Even MotioPI couldn't delete the corrupted profile.

I'm curious:

• Has anyone else seen this behavior in 12.1.1?
• Are there other issues or improvements you've noticed after upgrading?

Please share your experiences, tips, or workarounds. It'll help all of us understand if these are bugs or configuration quirks.

Thanks!

Abbas

Hi Abbas,

Yes these are known issues. Attain Insight has been in discussion with IBM since June when Attain Insight first ran into this.  

The good news that I know IBM are working on it and all the discussions and test cases Attain Insight has provided have been processed by IBM with constructive follow up discussions. 

Offering Management may be able to provide a newer update.  I hope that is of some help.

Best Paul

paul.hulford@attaininsight.com

CEO Attain Insight - Specialists in User Provisioning and Security Governance for IBM Cognos Analytics. 

Hi everyone,

I recently upgraded from Cognos 12.0.4 to 12.1.1, and while most things look good, I've noticed a few unexpected behaviors in user management that I'm not sure are environment-specific or part of the new release.

Here's what I've seen so far:

• In 12.0.4, I could add users to groups before their first login, and Cognos would automatically create their profile when they logged in.
• In 12.1.1, doing the same seems to cause issues:
• If I add a user to a group before their first login or before I create their profile, the user cannot log in and gets errors like:
  CM-REQ-4159, CM-CAM-4005, and CAF-WRN-2082.
• The user profile becomes a "phantom" profile:
• No Delete button in the UI.
• Create Profile fails with CM-REQ-4036 (object already exists).
• Even MotioPI couldn't delete the corrupted profile.

I'm curious:

• Has anyone else seen this behavior in 12.1.1?
• Are there other issues or improvements you've noticed after upgrading?

Please share your experiences, tips, or workarounds. It'll help all of us understand if these are bugs or configuration quirks.

Thanks!

Abbas

Hi Abbas,

Yes these are known issues. Attain Insight has been in discussion with IBM since June when Attain Insight first ran into this.  

The good news that I know IBM are working on it and all the discussions and test cases Attain Insight has provided have been processed by IBM with constructive follow up discussions. 

Offering Management may be able to provide a newer update.  I hope that is of some help.

Best Paul

paul.hulford@attaininsight.com

CEO Attain Insight - Specialists in User Provisioning and Security Governance for IBM Cognos Analytics. 

Hi everyone,

I recently upgraded from Cognos 12.0.4 to 12.1.1, and while most things look good, I've noticed a few unexpected behaviors in user management that I'm not sure are environment-specific or part of the new release.

Here's what I've seen so far:

• In 12.0.4, I could add users to groups before their first login, and Cognos would automatically create their profile when they logged in.
• In 12.1.1, doing the same seems to cause issues:
• If I add a user to a group before their first login or before I create their profile, the user cannot log in and gets errors like:
  CM-REQ-4159, CM-CAM-4005, and CAF-WRN-2082.
• The user profile becomes a "phantom" profile:
• No Delete button in the UI.
• Create Profile fails with CM-REQ-4036 (object already exists).
• Even MotioPI couldn't delete the corrupted profile.

I'm curious:

• Has anyone else seen this behavior in 12.1.1?
• Are there other issues or improvements you've noticed after upgrading?

Please share your experiences, tips, or workarounds. It'll help all of us understand if these are bugs or configuration quirks.

Thanks!

Abbas

Hi everyone,

I recently upgraded from Cognos 12.0.4 to 12.1.1, and while most things look good, I've noticed a few unexpected behaviors in user management that I'm not sure are environment-specific or part of the new release.

Here's what I've seen so far:

• In 12.0.4, I could add users to groups before their first login, and Cognos would automatically create their profile when they logged in.
• In 12.1.1, doing the same seems to cause issues:
• If I add a user to a group before their first login or before I create their profile, the user cannot log in and gets errors like:
  CM-REQ-4159, CM-CAM-4005, and CAF-WRN-2082.
• The user profile becomes a "phantom" profile:
• No Delete button in the UI.
• Create Profile fails with CM-REQ-4036 (object already exists).
• Even MotioPI couldn't delete the corrupted profile.

I'm curious:

• Has anyone else seen this behavior in 12.1.1?
• Are there other issues or improvements you've noticed after upgrading?

Please share your experiences, tips, or workarounds. It'll help all of us understand if these are bugs or configuration quirks.

Thanks!

Abbas

Hi,

We have a quite same issue "CM-REQ-4159" in 12.0.4. It's an old problem.

But, in our case, the first time that user try to login, get this error. So, we need to restart CM to solve.

Theres a SQL that you can run against your content store database to check if there are some problems with AD folders also. If counts >1, there a procedure that you can do in your environment to fix, some SQL updates.

select  'query 1' query, count(*) qtdfrom CMOBJNAMESwhere CMID in (select d1.CMID from CMOBJPROPS1 d1 inner joinCMOBJPROPS1 d2 on d1.OBJID = d2.OBJID and d1.CMID != d2.CMID where d1.OBJID is not null )union select  'query 2', count(*) qtdfrom CMOBJPROPS1where CMID in ( select d1.CMID from CMOBJPROPS1 d1 inner join CMOBJPROPS1 d2 on d1.OBJID = d2.OBJID and d1.CMID !=d2.CMID where d1.OBJID is not null)unionselect 'cs lock',  count(*) qtd from CMCAPACITY where USAGE=4

------------------------------
Jeam Coelho
Cognos Solution Architect

IBM Champion

LinkedIn: https://www.linkedin.com/in/jeamcoelho/

Original Message:
Sent: Fri November 07, 2025 11:03 AM
From: Abbas Alnamar
Subject: Issues After Upgrading to Cognos 12.1.1 – Share Your Experience

Hi everyone,

I recently upgraded from Cognos 12.0.4 to 12.1.1, and while most things look good, I've noticed a few unexpected behaviors in user management that I'm not sure are environment-specific or part of the new release.

Here's what I've seen so far:

• In 12.0.4, I could add users to groups before their first login, and Cognos would automatically create their profile when they logged in.
• In 12.1.1, doing the same seems to cause issues:
• If I add a user to a group before their first login or before I create their profile, the user cannot log in and gets errors like:
  CM-REQ-4159, CM-CAM-4005, and CAF-WRN-2082.
• The user profile becomes a "phantom" profile:
• No Delete button in the UI.
• Create Profile fails with CM-REQ-4036 (object already exists).
• Even MotioPI couldn't delete the corrupted profile.

I'm curious:

• Has anyone else seen this behavior in 12.1.1?
• Are there other issues or improvements you've noticed after upgrading?

Please share your experiences, tips, or workarounds. It'll help all of us understand if these are bugs or configuration quirks.

Thanks!

Abbas

------------------------------
[Abbas] [Alnamar]
[Data Management and Analytics System Administrator]
[Emporia State University]
[Kansas, USA]
------------------------------

Hello Jeam,

Here is what I got after I ran the SQL scripts.

What do you think?

Thank you,

Abbas

------------------------------
[Abbas] [Alnamar]
[Data Management and Analytics System Administrator]
[Emporia State University]
[Kansas, USA]

Original Message:
Sent: Mon November 10, 2025 03:30 PM
From: Jeam Coelho
Subject: Issues After Upgrading to Cognos 12.1.1 – Share Your Experience

Hi,

We have a quite same issue "CM-REQ-4159" in 12.0.4. It's an old problem.

But, in our case, the first time that user try to login, get this error. So, we need to restart CM to solve.

Theres a SQL that you can run against your content store database to check if there are some problems with AD folders also. If counts >1, there a procedure that you can do in your environment to fix, some SQL updates.

select  'query 1' query, count(*) qtdfrom CMOBJNAMESwhere CMID in (select d1.CMID from CMOBJPROPS1 d1 inner joinCMOBJPROPS1 d2 on d1.OBJID = d2.OBJID and d1.CMID != d2.CMID where d1.OBJID is not null )union select  'query 2', count(*) qtdfrom CMOBJPROPS1where CMID in ( select d1.CMID from CMOBJPROPS1 d1 inner join CMOBJPROPS1 d2 on d1.OBJID = d2.OBJID and d1.CMID !=d2.CMID where d1.OBJID is not null)unionselect 'cs lock',  count(*) qtd from CMCAPACITY where USAGE=4

------------------------------
Jeam Coelho
Cognos Solution Architect

IBM Champion

LinkedIn: https://www.linkedin.com/in/jeamcoelho/

Original Message:
Sent: Fri November 07, 2025 11:03 AM
From: Abbas Alnamar
Subject: Issues After Upgrading to Cognos 12.1.1 – Share Your Experience

Hi everyone,

I recently upgraded from Cognos 12.0.4 to 12.1.1, and while most things look good, I've noticed a few unexpected behaviors in user management that I'm not sure are environment-specific or part of the new release.

Here's what I've seen so far:

• In 12.0.4, I could add users to groups before their first login, and Cognos would automatically create their profile when they logged in.
• In 12.1.1, doing the same seems to cause issues:
• If I add a user to a group before their first login or before I create their profile, the user cannot log in and gets errors like:
  CM-REQ-4159, CM-CAM-4005, and CAF-WRN-2082.
• The user profile becomes a "phantom" profile:
• No Delete button in the UI.
• Create Profile fails with CM-REQ-4036 (object already exists).
• Even MotioPI couldn't delete the corrupted profile.

I'm curious:

• Has anyone else seen this behavior in 12.1.1?
• Are there other issues or improvements you've noticed after upgrading?

Please share your experiences, tips, or workarounds. It'll help all of us understand if these are bugs or configuration quirks.

Thanks!

Abbas

------------------------------
[Abbas] [Alnamar]
[Data Management and Analytics System Administrator]
[Emporia State University]
[Kansas, USA]
------------------------------

Hi,

We have a quite same issue "CM-REQ-4159" in 12.0.4. It's an old problem.

But, in our case, the first time that user try to login, get this error. So, we need to restart CM to solve.

Theres a SQL that you can run against your content store database to check if there are some problems with AD folders also. If counts >1, there a procedure that you can do in your environment to fix, some SQL updates.

select  'query 1' query, count(*) qtdfrom CMOBJNAMESwhere CMID in (select d1.CMID from CMOBJPROPS1 d1 inner joinCMOBJPROPS1 d2 on d1.OBJID = d2.OBJID and d1.CMID != d2.CMID where d1.OBJID is not null )union select  'query 2', count(*) qtdfrom CMOBJPROPS1where CMID in ( select d1.CMID from CMOBJPROPS1 d1 inner join CMOBJPROPS1 d2 on d1.OBJID = d2.OBJID and d1.CMID !=d2.CMID where d1.OBJID is not null)unionselect 'cs lock',  count(*) qtd from CMCAPACITY where USAGE=4

Hi everyone,

I recently upgraded from Cognos 12.0.4 to 12.1.1, and while most things look good, I've noticed a few unexpected behaviors in user management that I'm not sure are environment-specific or part of the new release.

Here's what I've seen so far:

• In 12.0.4, I could add users to groups before their first login, and Cognos would automatically create their profile when they logged in.
• In 12.1.1, doing the same seems to cause issues:
• If I add a user to a group before their first login or before I create their profile, the user cannot log in and gets errors like:
  CM-REQ-4159, CM-CAM-4005, and CAF-WRN-2082.
• The user profile becomes a "phantom" profile:
• No Delete button in the UI.
• Create Profile fails with CM-REQ-4036 (object already exists).
• Even MotioPI couldn't delete the corrupted profile.

I'm curious:

• Has anyone else seen this behavior in 12.1.1?
• Are there other issues or improvements you've noticed after upgrading?

Please share your experiences, tips, or workarounds. It'll help all of us understand if these are bugs or configuration quirks.

Thanks!

Abbas