Skip to Content
avatar image
Former Member

Live cache upgrade errors

Hello,

We are doing an upgrade on APO 4.1 to SCM 7.0 EHP2

We reached a phase where we had to upgrade the Live Cache and its client.

After the upgrade was done to 7.9 there are several errors in LC10.

@0S\QInformation Message@ IGS is not available (RC=1). No charts will be displayed.

@8O\QException@ LCA+ Exception CX_DBA_ADBC in class CL_SDB_ADBC method DBM_EXECUTE line 82 / RC=ADBC error

@5C\QError Message@ LCA SQL not possible

From DB59,

1 DBSL Library Availability @01\QTest successful@

2 Client Software Availability @01\QTest successful@

3 Execute an external operating system command (DBMCLI) @01\QTest successful@

4 Determine status using SQL connection @02\QAn error has occurred@

4 RC:        0 @02\QAn error has occurred@

4 Please check with SM50 the following work process:  4 @02\QAn error has occurred@

5 Test the SQL connection (Native SQL at CON_NAME) @02\QAn error has occurred@

5 sql_neg: no_connection @02\QAn error has occurred@

5 Error creating a secondary database connection @02\QAn error has occurred@

5 Set up of a secondary connection to the database system failed. It is possible that the data required for setting up the connect @02\QAn error has occurred@

5 SQL code: @02\QAn error has occurred@

5 o shared library found for the database with ID LCA @02\QAn error has occurred@

5 Please check with SM50 the following work process:  4 @02\QAn error has occurred@

DBM commands,

lcsadm@apo-l-lcs-02 % dbmcli inst_enum

OK

7.9.07.09    /sapdb/LCS/db

lcsadm@apo-l-lcs-02 % dbmcli db_enum

OK

LCS    /sapdb/LCS/db                          7.9.07.09      fast    running

LCS    /sapdb/LCS/db                          7.9.07.09      quick  offline

LCS    /sapdb/LCS/db                          7.9.07.09      slow    offline

LCS    /sapdb/LCS/db                          7.9.07.09      test    offline

lcsadm@apo-l-lcs-02 % xinstinfo LCS

IndepData          : /sapdb/data

IndepPrograms      : /sapdb/programs

InstallationPath    : /sapdb/LCS/db

Kernelversion      : KERNEL    7.9.07  BUILD 009-123-242-971

Rundirectory        : /sapdb/data/wrk/LCS 10:51

lcsadm@apo-l-lcs-02 % dbmcli -d LCS -u control,consdbaz db_state

OK

State

ONLINE

Can you help us?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 23, 2014 at 01:55 PM

    Hi Karunakar,

    Please execute the following to check consistency

    1) sbdverify

    2) sdbregview -l

    Post the results.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      according the posted information the liveCache upgrade failed at the end when the liveCache has to be initialized.

      - Post the entries written in the dbm.prt at the time when the lcinit with init run -

      23.12.2014

      11:56

      - What was the values of the liveCache parameter _UNICODE?

      -  Review the SAP note 1055588.

      - As "exec_lcinit init -e ascii" failed and the user was created - SAPLCS with DEFAULTCODE ASCII, I assume that your system is not unicode type. Correct?

      - Update the message with output of "select * from users" statement.

        Is the length of password of superdba user or SAPLCS grater as 9 characters?

      - See the SAP note 2074842 &upgrade to the latest LCA/liveCache releases for SCM 7.02 - SAP note 2087281.

      Check & be sure that the report /SAPAPO/DELETE_LC_ANCHORS has not been entered as a reprocessing report for any of the three database connections (LCA, LDA, or LEA), then you can use transaction LC10 to initialize the liveCache. Update with the results.

      - Create the SAP message to component BC-DB-LVC & get SAP support.


      Regards, Natalia Khlopina