Skip to Content
avatar image
Former Member

Cannot open SQL connection to liveCache LCA

Hi All,

when I'm trying to start liveCache I'm getting an error: "Cannot open SQL connection to liveCache LCA".

Operational state is online.

Kernel - 7.7.07

Next steps are successful:

"LC10 -> liveCache monitoring -> Tools -> dbmcli ::

a) sql_execute select * from users"

From Alert monitor I see an error: "Instance ONLINE, but no SQL access possible". If i try connection test, thenI see:

"

1. Connect. test with "dbmcli db_state" Successful

2. Connect. test with command mode "dbmrfc db_state" Successful

3. Connect. test with session mode "dbmrfc db_state" Successful

4. Connect. test with "native SQL" ( LCA ) No connection

SQL Code: 4025

For detailed information, see the developer trace for work process: 2

"

How to see this developer trace I do not know...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 30, 2010 at 11:17 AM

    Thanks!

    In SM50 I found that "*** ERROR => different codepage: application=UNICODE, LVC=ASCII"

    But during liveCache installation I cheched "Unicode SAP system". How can I check in MAXDB it's codepage version?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      The codepage of MaxDB can be checked via the database manager -> configuration -> Parameters -> Extended -> DefaultCodePage

      Or via dbmcli> param_getvalue DefaultCodePage

      Kind regards,

      Mark

  • avatar image
    Former Member
    Nov 30, 2010 at 08:42 AM

    Hi,

    Please check this thread: problems connecting Live Cache

    How to see this developer trace I do not know...

    Go to transaction sm50 -> select work process no. 2 -> select "display file".

    This is the developer trace of your work process.

    Kind regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2010 at 02:16 PM

    Thanks! It helps.

    I've changed it to UNICODE, but now I'm facing another error in SM50: "C *** ERROR => execute() of C_0010, #rec=0, rc=1, rcSQL=-28530 (POS(0) Incompatible Version: LiveCache: 777016, LC-Apps: 774029"

    It is because I've installed SCM with 7.7.4029 liveCache version. During liveCache server installation there were errors (MAXDB behaves very strange, after db_start it returns ok, but if I execute db_state afterwards, then runtime error occurs). That's why I've installed liveCache 7.7.7016 and proceed with liceCache Server installation which was successfull.

    How can I install client part 7.7.7016 to avoid this error?

    In MAXDB installed components I see that SAP Utilities are 7.7.04.29. Looks like this should be updated?

    Edited by: kleva82 on Nov 30, 2010 3:28 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2010 at 02:24 PM

    28530 (POS(0) Incompatible Version: LiveCache: 777016, LC-Apps: 774029"

    -> something went really wrong here

    "

    That's why I've installed liveCache 7.7.7016 and proceed with liceCache Server installation which was successfull."

    -> what is the name of the .SAR file you have used for this installation ?

    ->, I would usggest following

    1) drop liveCache instance and use SDBUNINST utility to uninstall everything from liveCache server

    2) use SAP installation DVD with "liveCache server" and install liveCache again

    3) if you decide to upgrade liveCache (apply patch) than make sure you are uing correct liveCache package

    name of .SAR file usually starts with LCA*.SAR

    Regards

    Ivan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2010 at 02:58 PM

    "

    I've downloaded and installed MaxDB from http://www.sdn.sap.com/irj/scn/maxdb-downloads. Is it incorrect? "

    no it is not correct for 2 reasons:

    1)

    as SAP customer you should be downloading the software from SAP service marketplace , not from SDN

    2)

    when you want to install liveCache, use liveCache package, not MaxDB package, the one you used was MaxDB package

    SDBUNINST should be part of liveCache installation (/sapdb/programs/bin)

    Regards

    Ivan

    Edited by: Ivan Levrinc on Nov 30, 2010 3:58 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes, it was in host file.

      Finally I've cheated and named my server as localhost, proceed with installation which was fine and then renamed it back to kleva. So now, I'm ok!

      Mark, many thanks for helping me!