Question Re: Failed to commit objects to server : Undefined Info S... in Technology Q&A

Failed to commit objects to server : Undefined Info Store

miroslav_123 — Tue, 09 Apr 2024 05:41:15 GMT

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.

Re: Failed to commit objects to server : Undefined Info S...

ayman_salem — Fri, 12 Apr 2024 09:54:21 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

tumula_somesh — Tue, 16 Apr 2024 13:35:10 GMT

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.

Re: Failed to commit objects to server : Undefined Info S...

samjohn — Tue, 16 Apr 2024 21:56:22 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

miroslav_123 — Wed, 17 Apr 2024 05:17:01 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

ayman_salem — Wed, 17 Apr 2024 11:06:28 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

ayman_salem — Wed, 17 Apr 2024 11:08:03 GMT

also check your license?

Re: Failed to commit objects to server : Undefined Info S...

miroslav_123 — Wed, 17 Apr 2024 11:48:14 GMT

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.

Re: Failed to commit objects to server : Undefined Info S...

ayman_salem — Wed, 17 Apr 2024 12:54:36 GMT

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.

Re: Failed to commit objects to server : Undefined Info S...

ayman_salem — Wed, 17 Apr 2024 12:55:12 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

miroslav_123 — Wed, 17 Apr 2024 13:13:18 GMT

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.

Re: Failed to commit objects to server : Undefined Info S...

ayman_salem — Wed, 17 Apr 2024 14:48:56 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

ayman_salem — Wed, 17 Apr 2024 14:50:13 GMT

Re: Failed to commit objects to server : Undefined Info S...

lionel_rison — Mon, 27 May 2024 15:09:28 GMT

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

Best regards.

Lionel RISON

Re: Failed to commit objects to server : Undefined Info S...

lionel_rison — Mon, 27 May 2024 20:02:49 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

lionel_rison — Tue, 28 May 2024 08:10:08 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

miroslav_123 — Tue, 28 May 2024 10:49:39 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

miroslav_123 — Tue, 28 May 2024 10:54:10 GMT

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

Re: Failed to commit objects to server : Undefined Info S...

lionel_rison — Tue, 28 May 2024 11:09:54 GMT

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:

Update BI to 4.3 SP4 Patch 1
Logon to CMC
Go to Users and Groups
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

Re: Failed to commit objects to server : Undefined Info S...

miroslav_123 — Tue, 28 May 2024 11:20:16 GMT

Thank you 🙂