cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to commit objects to server : Undefined Info Store

miroslav_123
Explorer
0 Kudos
1,064

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
Discoverer
0 Kudos
SP4 Patch 500 don't solve the problem.

Accepted Solutions (0)

Answers (8)

Answers (8)

ayman_salem
Active Contributor

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

tumula_somesh
Explorer
0 Kudos
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
Explorer
0 Kudos
The problem is not the rights. I checked them out. I tried some other solutions, but the problem remains.
ayman_salem
Active Contributor
0 Kudos

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

ayman_salem
Active Contributor
0 Kudos

also check your license?

lionel_rison
Explorer
0 Kudos

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

lionel_rison
Explorer
0 Kudos

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
Explorer
0 Kudos
Thank you 🙂
TommyC
Discoverer
0 Kudos
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
Explorer
0 Kudos

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
Explorer
0 Kudos
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
Discoverer
0 Kudos
The link https://me.sap.com/notes/3437779 but the solution is build a new DB. Do you found a better solution ?
lionel_rison
Explorer
0 Kudos

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
Explorer
0 Kudos
No, I couldn't find a solution to the problem
lionel_rison
Explorer
0 Kudos

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

Best regards.

Lionel RISON

ayman_salem
Active Contributor
0 Kudos

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
Explorer
0 Kudos
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
Active Contributor
0 Kudos

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

B_20240417_1.JPG    B_20240417_2.JPG

ayman_salem
Active Contributor
0 Kudos

.

samjohn
Discoverer
0 Kudos

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

 

miroslav_123
Explorer
0 Kudos
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
Active Contributor
0 Kudos

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.