SQL connect to database connection LCA failed

[sunil_chipkar]

Dear Experts,

I am getting the following error when starting liveCache

" SQL connect to database connection LCA failed "

Tried to take LiveCache Backup through Database Manager 7.5 MaxDB but got the following error

-24988 sql error sql_connect ...; 1, cannot create

communication semaphore

Waiting for your reply

Thanks & Regards

Sunil

Edited by: Sunil Chipkar on Mar 19, 2008 8:08 AM

Edited by: Sunil Chipkar on Mar 19, 2008 8:09 AM

[roland_mallmann]

Hi,

as you're using liveCache, you must be an official SAP customer: please also open an official OSS message for your issue.

As to the issue; it seems likely that you're out of semaphores or the ulimits are set incorrectly (or a wrong user used to start the liveCache instance or xserver). I suggest to take a look at OSS note 628131.

You can check the connection to LCA using transaction DB59.

Regards,

Roland

[Former Member]

Hello,

Please check the DB connectivity in DB02.

Rgds,

Mat

[Former Member]

Hi.

Your database is not up or you do not have enough authorization.

Read the note 442944.

Regards.

[sunil_chipkar]

Dear Sergo ,

thanks for the reply

This is what is get after running the dbmcli command--

dbmcli -d <SID> -u <controluser>,< controlpassword> db_state

OK

State

ONLINE

Regards

Sunil

[Former Member]

Hi. Are you check <IndepDataPath>/config/<SID>.cfg file has 0 bytes ot no?

regards.

[sunil_chipkar]

Hi,

Am using Solaris 10, can you guide me the exact path

Regards

Sunil

[Former Member]

I am not familiar with SOLARIS... in win 2003 is drive:\sapdb\data\config.

Try to find the file SID.cfg (like QAS.cfg) in HP-UX the command : " find / -name SID.cfg",i repeat I am not familiar with SOLARIS.

regards.

[sunil_chipkar]

Hi,

have found that the file size is 5K (GLQ.cfg)

Regads,

Sunil

[Former Member]

I'm think it's ok. Can you go to transaction LC10 and connect to your Live Cache?

Also have you a installation Guide for LiveCashe ? Download this document and read " 5.1.1 Setting Up the Connection to the liveCache Instance" -->

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f17e2746-0a01-0010-e7bc-a2b071f0...

Regards.

Edited by: Sergo Beradze on Mar 19, 2008 2:18 PM

[sunil_chipkar]

Hi,

I have started Livecache

It shows operational state as it was before

but displays message at the bottom

SQL connection to database connection LCA failed

Regards,

Sunil

Edited by: Sunil Chipkar on Mar 19, 2008 1:05 PM

[Former Member]

Give so:

Do step by step as it is written to instructions (5.1.1 Setting Up the Connection to the liveCache Instance)

on what step you see an error?

Regards.