SQLConnect to database LCA failed

[Former Member]

Hi All,

When I do LC10 transaction in SAP GUI, I get this error at the bottom of the page.

These are my Connection details,

Name of the Database connection : LCA

liveCache Name : MHS

liveCache Server : discus

DBM : MHSDBM,xxx

Standard liveCache User : MHSUSER,xxx

I am able to connect to database MHS as user MHSUSER through sqlcli,

But from GUI, I am able to start/stop liveCache but always do keep getting this error

cannot open SQL connection to liveCache MHS.

Please let me if I can find any additional info from any logs or how to resolve this error.

This needs to resolved ASAP.

Thanks in Advance

[markus_doehr2]

You can also use transaction DB59 and "test" the connection to find out, what type of connection is failing.

Markus

[former_member229109]

Hello,

1. "This needs to resolved ASAP."

=> as SAP customer you could create the SAP message and get SAP support.

Create high or very high priority SAP message, if it's ....

2. If you would like to solve the issue by yourself:

a) Check the LCA/LDA/LEA connections settings.

It could be done in LC10-> Integration

/ndb59 => connection test

b) What liveCache user and password did you set for the LCA connection?

< if the issue with LCA connection. >

Check if you connect to the liveCache with those user/password:

dbmcli -d MHS -u MHSDBM,<pwd>

<enter>

dbmcli on MHS>sql_connect MHSUSER,<pwd>

<enter>

Did you get the error?

c) Check the errors in the system log - /nsm21

Check the errors details in the corresponding dev log, could be displayed in /nst11, for example.

d) Please update with the Additional information:

-> What is the version of your system?

-> What is the version of the liveCache?

-> Is it the brand new installation or a System copy?

-> Is it unicode system?

-> Is the liveCache standard user set for the LCA connection listed in the output of the SQL statement:

select * from users

?

-> Did you restart the liveCache in LC10? Check the lcinit.log if it's done successfuly.

Regards, Natalia Khlopina

Edited by: Natalia Khlopina on Jul 6, 2011 12:34 PM