Content Server connection problem

[Former Member]

I am getting this error while starting the Content Server .

I have install the Content Server in Windows Machine.

can anyone rectify the error?

[Former Member · Accepted solution]

Hello Indranil,

Please check the following screenshots and maintain.

Please update and check again.

Regards

Anand

[Former Member · Accepted solution]

Yes i have done ContentStorgeHost and security to 0

But the result is same.

Wether i have to refresh or restart anything.

[JamesZ · Accepted solution]

Hi Indranil,

I do not think restarting will help without knowing the cause.
Are you able to contact maxdb via dbmcli?

Best regards,
James

[Former Member · Accepted solution]

yes i type dbmcli in command line it is working...

I used to get

dbmcli>

[JamesZ · Accepted solution]

the dbmcli command should be"

dbmcli -d <dbid> -u <username>,<password> db_state

if this command is ok, then we can say the database himself is, in this case, please check if sap note 1764842 helps.

[Former Member · Accepted solution]

Now i am getting the following error....

[Former Member · Accepted solution]

Hi,

i believe you have not tested content server after installation.

You need to check the all the post steps suggested after content server installation.

Please go through following link for further insight.

SAP Content Server Connectivity issue | SCN

Regards

Anand

[JamesZ · Accepted solution]

As mentioned, I would like to verify the maxdb state, what is the result of previous dbmcli command?

If just looking at the latest error, it has nothing to do with maxdb any more...

[Former Member · Accepted solution]

dbmcli -d <dbid> -u <username>,<password> db_state

It is providing

Error Coneection failed to node <local> for database sdb - 24950,ERR_USRFAIL: User authorization failed.

[JamesZ · Accepted solution]

well, seems you do not know the database user password?

[Former Member · Accepted solution]

yes i used the password which i have used for MaxDB and through services.msc is started.

the user is Administrator.

Is there any another userid and password for MaxDB.

[JamesZ · Accepted solution]

usually, we have three user for maxdb: superdba, control, sapsr3. the three password was set during installation. do you know the password?

what username and password you maintained in csadmin?

[Former Member · Accepted solution]

yes i have used superdba and it is corresponding password.

It produce out put:

Ok

State

ONLINE

[JamesZ · Accepted solution]

ok, then maxdb himself should be ok now. if you are an SAP customer, you can raise a ticket to SAP under content server component, because right now, this is not a database issue any more and this forum is mainly focusing on maxdb area

[Former Member · Accepted solution]

Hello,

Please check following SAP note:-

794919 - Error Analysis : ICM_HTTP_TIMEOUT and Internal error

This might help you.

Regards

Anand

[Former Member · Accepted solution]

Again same error:

[Former Member · Accepted solution]

my repository status is "defined" it is not running...i think that is problem for SQL conncetion.

how to change the status "define" to "running"

[Former Member · Accepted solution]

Hello,

Can you please follow the steps suggested in SAP note:-

2036696 - SAP Content Server: Connection to a repository is not possible

I hope this resolves the issue.

Regards

Anand

[Former Member · Accepted solution]

Ok thanks I got that repository status "running" now.

A Great Thanks to all..

Now the contRespStatus is running and no SqlConnection error.

Now my question is how the data will save to that content server path from sap.

[Former Member · Accepted solution]

Hello Indranil,

Good to know that issue got resolved. can you please mark this thread as answered and open a new thread in http://scn.sap.com/community/plm/document-management

Regards

Anand

[Former Member · Accepted solution]

Hello,

please notice. Do not use the user SYSDBA (SUPERDBA) as user for the Contentserver.

The usage of the SUPERDBA will lead into into upgrade and migration problems afterwards.

The default username for the ContentServer user is SAPR3. If this not exist create one and use this user.

The user must be a DBA user with DEFAULTCODE ASCII. The SYSDBA did not has these CODE attributes.

'CREATE USER SAPR3 PASSWORD SAP DBA DEFAULTCODE ASCII'

Kind regards,

Burkhard

[Former Member · Accepted solution]

used create user but ginving error

dbmcli>sql_execute CREATE USER SAPR3 PASSWORD <pass> SAP DBA DEFAULTCODE ASCII

err-24948,ERR_NODBNAME:Datase name required

[Former Member · Accepted solution]

Hi,

it seems you are not connected with dbmcli. See dbmcli -d for options.

However for executing SQL command sqlcli should be the preferred tool from the command line

sqlcli -d <db_name> -u SUPERDBA,<password>

>CREATE USER SAPR3 PASSWORD <pass> SAP DBA DEFAULTCODE ASCII