Question Re: Content Server- SQLConnect failed - Invalid Command State in Technology Q&A

Content Server- SQLConnect failed - Invalid Command State

Former Member — Wed, 18 Nov 2020 15:17:53 GMT

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

Re: Content Server- SQLConnect failed - Invalid Command State

sumitjais — Thu, 19 Nov 2020 09:46:08 GMT

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.

Re: Content Server- SQLConnect failed - Invalid Command State

beernab — Sat, 21 Nov 2020 08:08:13 GMT

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

Re: Content Server- SQLConnect failed - Invalid Command State

sumitjais — Sat, 21 Nov 2020 10:29:42 GMT

Thanks for the update Brent.

Glad to know that the issue got resolved.

Re: Content Server- SQLConnect failed - Invalid Command State

kathleen_a_sales — Tue, 09 Mar 2021 06:08:08 GMT

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

Re: Content Server- SQLConnect failed - Invalid Command State

kathleen_a_sales — Tue, 09 Mar 2021 06:08:35 GMT

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

Re: Content Server- SQLConnect failed - Invalid Command State

kathleen_a_sales — Tue, 09 Mar 2021 06:12:36 GMT

how di you know whats the right UID and GID?

Re: Content Server- SQLConnect failed - Invalid Command State

beernab — Tue, 09 Mar 2021 07:35:57 GMT

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.

Re: Content Server- SQLConnect failed - Invalid Command State

kathleen_a_sales — Tue, 09 Mar 2021 08:21:28 GMT

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

Re: Content Server- SQLConnect failed - Invalid Command State

kathleen_a_sales — Tue, 09 Mar 2021 09:38:34 GMT

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?

Re: Content Server- SQLConnect failed - Invalid Command State

kathleen_a_sales — Tue, 09 Mar 2021 11:42:04 GMT

My issues are now fixed, thank you so much for this post.

Re: Content Server- SQLConnect failed - Invalid Command State

beernab — Tue, 09 Mar 2021 11:46:40 GMT

No problem, glad I could help.

Re: Content Server- SQLConnect failed - Invalid Command State

Sarikar_Dharmanna — Fri, 17 Sep 2021 20:56:17 GMT

Hi Kathleen Sales,

I had similar issues after installed a SAP Content Server (7.53) with MaxDB 7.9 on SLES 12.sp5, while accessing content server in browser getting errors like ontRepStatusDescription="SQLConnect failed (DBPARAMETERS): [SAP AG][LIBSDBOD SO][SAP MaxDB] General error;-10210 Invalid command state (No prepared SQL command), ec=-10210, rc=-1";

Any support on prioirty is highly appriciated , thank you

Sarikar

Re: Content Server- SQLConnect failed - Invalid Command State

karan_moudgil — Thu, 04 Jul 2024 10:58:04 GMT

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