Live cache upgrade errors

[Former Member]

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?

[former_member188883]

Hi Karunakar,

Please execute the following to check consistency

1) sbdverify

2) sdbregview -l

Post the results.

Regards,

Deepak Kori

[Former Member]

root@apo-l-lcs-02 # ./sdbregview -l

Installation: Global    /sapdb/programs

Global Listener                7.9.07.09    valid    64 bit

Installation Compatibility     7.9.07.09    valid    64 bit

Installer                      7.9.07.09    valid

SAP Utilities Compatibility    7.9.07.09    valid    64 bit

Installation: Legacy    /sapdb/programs

APO LC APPS        /sapdb/LCT/db/sap    4.10.021      valid    64 bit

APO LC APPS        /sapdb/LCQ/db/sap    4.10.021      valid    64 bit

APO LC APPS        /sapdb/LCD/db/sap    4.10.021      valid    64 bit

APO LC APPS        /sapdb/LCC/db/sap    4.10.021      valid    64 bit

DB Analyzer        /sapdb/programs      7.5.00.52     valid    64 bit

Database Kernel    /sapdb/LCC/db        7.5.00.52     valid    64 bit

Database Kernel    /sapdb/LCD/db        7.5.00.52     valid    64 bit

Database Kernel    /sapdb/LCQ/db        7.5.00.52     valid    64 bit

Database Kernel    /sapdb/LCT/db        7.5.00.52     valid    64 bit

Fastload API       /sapdb/programs      7.7.07.48     valid    64 bit

JDBC               /sapdb/programs      7.6.06.05     valid

Loader             /sapdb/programs      7.7.07.48     valid    64 bit

Messages           /sapdb/programs      MSG 0.8507    valid

ODBC               /sapdb/programs      7.7.07.48     valid    64 bit

PCR 7300           /sapdb/programs      7.3.00.60     valid

PCR 7301           /sapdb/programs      7.3.01.22     valid

PCR 7403           /sapdb/programs      7.4.03.50     valid    64 bit

PCR 7500           /sapdb/programs      7.5.00.55     valid    64 bit

Redist Python      /sapdb/programs      7.7.07.48     valid    32 bit

SQLDBC             /sapdb/programs      7.7.07.48     valid    64 bit

SQLDBC 76          /sapdb/programs      7.6.06.27     valid    64 bit

SQLDBC 77          /sapdb/programs      7.7.07.48     valid    64 bit

Installation: LCS    /sapdb/LCS/db

APO LC APPS         10.00.004      valid

Base                7.9.07.09      valid    64 bit

DB Analyzer         7.9.07.09      valid    64 bit

Database Kernel     7.9.07.09      valid    64 bit

Fastload API        7.9.07.09      valid    64 bit

JDBC                7.6.06.09      valid

Loader              7.9.07.09      valid    64 bit

Messages            MSG 0.10302    valid

ODBC                7.9.07.09      valid    64 bit

Redist Python       7.9.07.09      valid    64 bit

SAP Utilities       7.9.07.09      valid    64 bit

SQLDBC              7.9.07.09      valid    64 bit

SQLDBC 76           7.6.06.19      valid    64 bit

SQLDBC 77           7.9.07.09      valid    64 bit

Server Utilities    7.9.07.09      valid    64 bit

[Former Member]

SDBUPDMsg1419335764.log

ERR:  Upgrade failed

ERR:    error upgrading

ERR:      Finalize upgrade failed: Setting up ascii liveCache...

Setting up liveCache failed

exec_lcinit init -e ascii

ERR

-24964,ERR_EXECUTE: Error in program execution

0,sap/lcinit LCS init -e ASCII -uDBM *,* -uDBA *,* -uSQL *,*

liveCache LCS (init)

The liveCache state is ADMIN

DBMServer 7.9.07   Build 009-123-242-971

Stopping LCS

Starting LCS into ADMIN

Executing ACTIVATE SERVERDB

Loading SYSTEM TABLES

Creating user SAPLCS with DEFAULTCODE ASCII

Stopping LCS

Starting LCS into ONLINE

Creating liveCache application procedures

Enabling user SAPLCS

ERROR : liveCache LCS not initialized (see "/sapdb/data/wrk/LCS/lcinit.log").

lcinit.log

==================================

Installation successfully finished

==================================

Enabling user SAPLCS

ERR

-24988,ERR_SQL: SQL error

-3014,Invalid end of SQL statement

ERROR : liveCache LCS not initialized

------------------------------------------------------------

23.12.2014

11:56

************************* END ******************************

[former_member188883]

Hi Karunakar,

Please change password for SAPLCS with Database studio.

Also use command user_sap to update upc file.

Hope this helps.

Regards,

Deepak Kori

[former_member229109]

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