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.

[YvanB]

Hi ! Thank you very much for this info.

Can you tell me: once a new schema in UTF-8 is available, what is the best option to create the repository on it ?
You mention a migration, but this is a fresh install and I don't want to burden the new CMS repository with any compatibility issue.

[ayman_salem]

@YvanBIf this is a new installation and the database uses AL32UTF8 as the supported character set, then everything should be fine—no action is required.

To create new or migrate an existing repository, use the CMS Database Setup located in the Central Configuration Manager.

[YvanB]

Thanks again for your answer.

I meant that I have this issue, but requested a new UTF-8 schema to replace the current one.
Don't you think that migrating the CMS repository could bring new issues ?
I thought about initializing a new CMS repository, but I don't see how it is done.

And do you know if this issue also concerns the Audit repository ?

[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.