Failed to commit objects to server : Undefined Info Store

[miroslav_123]

After upgrade of BO from 4.3 sp2 to 4.3 sp4, I got error "Failed to commit objects to server : Undefined Info Store" when I try to create new user or when I try to update current one. Would you please give me any tips to to solve the problem.

[TommyC]

SP4 Patch 500 don't solve the problem.

[ayman_salem]

Check the Rights for the user you use to create and update users.

[tumula_somesh]

I am getting the same error, when creating a new user. This is new installation for BI 4.3 SP3. I am logged in as Administrator to create the new user, still getting the same error.

[miroslav_123]

The problem is not the rights. I checked them out. I tried some other solutions, but the problem remains.

[ayman_salem]

Are you using CMC?
Have you tried using the user “Administrator”?

[ayman_salem]

also check your license?

[SK74]

how can you check the rights of user, before creating a new one.

[ayman_salem]

To anyone having this issue:
Make sure your CMS DB supports the AL32UTF8 character set.
Since SP04, the SAP BI development team has added/made some changes to CMS query parameters (the parameter strings are sent in UTF-8 to use the “cached execution plan”), which affects correct writing and reading to/from the Aliases table and others.

To check your CMS DB, run the following SQL command on your database and see the result
(example: Oracle DB)

If you get different results, you are having problems adding/modifying groups and users.

Unless SAP changes this in the next patches, there is unfortunately NO workaround to solve this problem. You should migrate your CMS database to a database that has the ALU32UTF8 character set.

[lionel_rison]

Hi Tommyc, no i don't search another solution because this note satisfy me and the customer has accepted the solution.

[lionel_rison]

3437779 - Failed to commit objects to server : Undefined Info Store error while creating Users/Groups, logging in with LDAP authentication In BI 4.3 SP04

 

Symptom

• After update to 4.3 SP4 Patch 1, when trying to create a user or a group an error message shows up:
  "Failed to commit objects to server : Undefined Info Store error"
  
  
• Not able to create Enterprise Users, Groups, Add new AD mapped groups. 
• Issue seem to be happening only to customers using Oracle 19c or an Oracle DB as the CMS DB with BI version 4.3 SP4 Patch 100+
• The issue may also occur when logging in with LDAP authentication:
  Account information not recognized: Internal error: An unknown exception has occurred

CMS logs may contain the following messages:

"CheckType: Not a valid type 3"

"Assert Failure: (Infostore.cpp:12526). (False : Unknown Exception caught while committing. Someone must be held accountable.)."

"InfoStoreSubSystem::CommitSingleObjectWithRetry"

"Unknown internal error encountered."

"OracleStatement.cpp"

Other Terms

User, group, ad, error, BI 4.3 SP4, Oracle, parameterization, CMS, DB, database,

Reason and Prerequisites

 Environment:

• SAP BusinessObjects Business Intelligence Platform 4.x (BI 4.2 / 4.3)
• Windows
• Linux / Unix 
  
• Oracle 19c

Steps to Reproduce:

1. Update BI to 4.3 SP4 Patch 1
2. Logon to CMC
3. Go to Users and Groups
4. Try to create a user or a group, receives an error: "Failed to commit objects to server : Undefined Info Store error"

Cause:

• The issue is caused by a unsupported non-unicode NLS character set configured on the database level.
  

  Oracle has two values 'NLS_CHARACTERSET' and 'NLS_NCHAR_CHARACTERSET'
  which are responsible for data type of CHAR, VARCHAR2, LONG, CLOB data and NCHAR, NVARCHAR2, and NCLOB data respectively.
  When either of the 2 Character set values are set to anything that isn’t AL16UTF16 or AL32UTF8, then we encounter issues with the CMS converting UTF-16 strings to UTF-8 because of the use of a non-unicode character set.

• For example 'WE8MSWIN1252’ (which is a Western European character set) is unsupported character set because it is non-unicode

• We can determine those values by running the below SQL query:
  
  SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');

Solution

• The supportability of CMS Character sets for use in a CMS DB are documented in KBA 1462274
• This is a limitation and restriction of the BI Platform product, where the CMS DB is required to use a unicode character set
• If encountering this issue, please refer to your database vendor for further support on how to change your database's character set -- from our knowledge the character set cannot be modified once the database has been created otherwise there is a chance of data corruption, it must be set before the database is created.
• The database must be configured as per our documentation, otherwise if using a unsupported configuraton the issue falls outside of SAP scope of supportability

[miroslav_123]

Thank you 🙂

[TommyC]

I have the same problem and it look like the 3437779. Anyone have found a way to resolve without converting their DB ? All the previous version work with our DB before that.

[lionel_rison]

Hello everybody, i think having find the solution with this SAP's note : 3437779 - Failed to commit objects to server : Undefined Info Store error while creating Users/Groups, logging in with LDAP authentication In BI 4.3 SP04

Best regards.

Lionel

[miroslav_123]

HI, thank you for the info. I can't find this SAP's note : 3437779. Would you please, check the note's number.number

[TommyC]

The link https://me.sap.com/notes/3437779 but the solution is build a new DB. Do you found a better solution ?

[lionel_rison]

Hi Miroslav, did you find a solution ? I have the same problem after upgrade to SAP BI 4.3 SP4 Patch 400 ?

Best regards.

Lionel RISON

[miroslav_123]

No, I couldn't find a solution to the problem

[lionel_rison]

Hi AYMEN, did you find a solution ? I have the same problem after upgrade ?

Best regards.

Lionel RISON

[ayman_salem]

My question was:
Have you tried using the “Administrator” user, not a user with administrative privileges?

Second, what type of user do you want to add? If the user is a "named" user and you exceed the number of named users allowed by your license, you cannot add a user of that type

[miroslav_123]

HI, yes I am using user Administrator. The user I'm trying to create is of type 'named' user. We have free licenses for a few more users. The current issue occurs not only when I try to create a new user or group, but also when I try to edit some of the available one. I can only delete a user or group. In all other cases, the error message comes out.

[ayman_salem]

It seems to me that the "Edit Object" and "Add Objects" rights are denied for the root folder "Groups and Users". Check the top level security for “Users and Groups".

    

[ayman_salem]

.

[samjohn]

Check your BO server system log to see the error or warning related information which indicate the root cause of the error. 

[miroslav_123]

Hi yes, I am using CMC and I am a administrator. Our licenses are up to date. Yesterday I did a new installation of BI 4.3 sp4 Patch 3 , but the problem with user's creation is the same.

[ayman_salem]

My question was:
Have you tried using the “Administrator” user, not a user with administrative privileges?

Second, what type of user do you want to add? If the user is a "named" user and you exceed the number of named users allowed by your license, you cannot add a user of that type.