on 12-22-2014 1:46 PM
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?
Hi Karunakar,
Please execute the following to check consistency
1) sbdverify
2) sdbregview -l
Post the results.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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 ******************************
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
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.