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

[sumitjais]

Hi Brent,

Please try the below and let's see if it helps.

Add the below two entries alongwith others in cs.conf for each of the contRep.

AdminSecurity=0

PSEDir=<path to security directory>

Restart the apache.

Go to tcode OAC0 and exchange the certificate. Confirm the same in CSADMIN tcode.

[beernab]

Hi Sumit Jaiswal

Thanks for your reply.

As per SAP Content Server 7.5 some parameters are deprecated (https://launchpad.support.sap.com/#/notes/2786364)
PSEDir is obsolete as the repository certificates are now stored in the instance's security directory (SECUDIR).
AdminSecurity parameters are handled by the authentication handler in the profiles (icm/HTTP/auth_0).

I forgot to mention that this was a migration from a SAP Content Server 6.4. This issue has been resolved by adjusting the existing UID & GID of several DB owner accounts, which were unable to execute some SQL scripts.

Kind regards,
Brent

[sumitjais]

Thanks for the update Brent.

Glad to know that the issue got resolved.

[kathleen_a_sales]

Hi brent im having the same issues and we are doing the same thing how did you od this? can you please elaborate?

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