Content Server- SQLConnect failed - Invalid Command State

[#1]

Dear experts

Recently I have installed a SAP Content Server (7.53) with MaxDB 7.9 on SLES 15 SP1

When creating access the server info file, I get the following error:

contRepStatus="offline";contRepStatusDescription="SQLConnect failed (DBPARAMETERS): [SAP AG][LIBSDBOD SO][SAP MaxDB] General error;-10210 Invalid command state (No prepared SQL command), ec=-10210, rc=-1

This is my cs.info file:

Also when checking OAC0 I am able to connect to the repositories, but they are showing as offline.

I am able to connect to the database in MaxDB studio and use SQL editor, so it's not an issue with accessing the database I think.

Help is appreciated.

Thanks in advance!

Kr,
Brent

[kathleen_a_sales]

Hi brent Im having the same issue can you please elaborate how you did this?

"This issue has been resolved by adjusting the existing UID & GID of several DB owner accounts, which were unable to execute some SQL scripts."

[kathleen_a_sales]

how di you know whats the right UID and GID?

[beernab]

Hi Kathleen

Are you performing a clean install? For me this was a migration from an existing Content Server.
I've checked the old user & group id and made sure it was the same for the database software owner (sdb) & instance software owner (SIDsdb)

You can also set this for SIDadm user.

Please refer to https://www.thegeekdiary.com/how-to-correctly-change-the-uid-and-gid-of-a-user-group-in-linux/
Also check /etc/fstab if all UID entries are correct.

[kathleen_a_sales]

Will try this one, im also doing migration from an existing content server. Thanks for this!

[kathleen_a_sales]

Hi brent I would like to clarify that the sdb and sqdsdb UID and GID are the same? and they are patterned to the Old Content Server?

[karan_moudgil]

Thanks Kathleen, I was facing the same issue and it was resolved by changing the UID of database software owner and instance software owner