liveCache connection Error

[Former Member]

Dear Experts,

I'm having an error everytime I start liveCache stating "lock Server not accessible"

I also checked the connection LCA in tx LC10. It displays a green light but a warning that says
"SQL access not possible". Same goes with tx DB59, there's an error while performing the test. See details below.

DB59 - Connection test:

General Connection Data
   Connection Name....: LCA
   Database Name......: LC1
   Database Server....: 10.206.110.72
   tp Profiles........: no_longer_used
   DBM User...........: CONTROL

   Test Scope
   1. Execute an external operating system command (DBMCLI)
   2. Determine status using TCP/IP connection SAPDB_DBM (DBMRFC command mode)
   3. Determine status using TCP/IP connection SAPDB_DBM_DAEMON (DBMRFC session mode)
   4. Test the SQL connection (Native SQL at CON_NAME)

Application Server:  MDCSAP07_AP1_00                          ( Windows NT )
   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:
      Error creating a secondary database connection
      Set up of a secondary connection to the database system failed. It is possible that the data required for setting up the con
      SQL code:
      For detailed information, see the developer trace for work process:           23

work proccess Dev_23:

B  Loading DB library 'C:\usr\sap\AP1\DVEBMGS00\exe\dbsdbslib.dll' ...
M  *** ERROR => DlLoadLib()==DLENOACCESS - LoadLibrary("C:\usr\sap\AP1\DVEBMGS00\exe\dbsdbslib.dll")
  Error 126 = "The specified module could not be found." [dlnt.c       255]
M  {root-id=0015C58921771ED2BD9D22A0E0973991}_{conn-id=00000000000000000000000000000000}_0
B  *** ERROR => Couldn't load library 'C:\usr\sap\AP1\DVEBMGS00\exe\dbsdbslib.dll'
[dbcon.c      5672]
B  {root-id=0015C58921771ED2BD9D22A0E0973991}_{conn-id=00000000000000000000000000000000}_0
B  ***LOG BYG=> could not load library for database connection LCA        [dbds         862]
C     OCIAttrSet(con=0, rc ln: 0 15, -1 32, 0 3, 0 😎 failed with SQL error 24960:
C     ORA-24960: the attribute  OCI_ATTR_MODULE is greater than the maximum allowable length of 48
C
C Thu Jul 25 14:21:53 2013
C     OCIAttrSet(con=0, rc ln: 0 32, -1 32, 0 3, 0 10) failed with SQL error 24960:
C     ORA-24960: the attribute  OCI_ATTR_MODULE is greater than the maximum allowable length of 48
C     OCIAttrSet(con=0, rc ln: 0 32, -1 32, 0 4, 0 10) failed with SQL error 24960:
C     ORA-24960: the attribute  OCI_ATTR_MODULE is greater than the maximum allowable length of 48
C
C Thu Jul 25 14:22:45 2013
C     OCIAttrSet(con=0, rc ln: 0 20, -1 32, 0 3, 0 😎 failed with SQL error 24960:
C     ORA-24960: the attribute  OCI_ATTR_MODULE is greater than the maximum allowable length of 48
C
C Thu Jul 25 14:22:49 2013
C     OCIAttrSet(con=0, rc ln: 0 27, -1 32, 0 3, 0 😎 failed with SQL error 24960:
C     ORA-24960: the attribute  OCI_ATTR_MODULE is greater than the maximum allowable length of 48
B  Loading DB library 'C:\usr\sap\AP1\DVEBMGS00\exe\dbsdbslib.dll' ...
M  *** ERROR => DlLoadLib()==DLENOACCESS - LoadLibrary("C:\usr\sap\AP1\DVEBMGS00\exe\dbsdbslib.dll")
  Error 126 = "The specified module could not be found." [dlnt.c       255]
M  {root-id=0015C58921771ED2BD9D22A0E0973991}_{conn-id=00000000000000000000000000000000}_0
B  *** ERROR => Couldn't load library 'C:\usr\sap\AP1\DVEBMGS00\exe\dbsdbslib.dll'
[dbcon.c      5672]
B  {root-id=0015C58921771ED2BD9D22A0E0973991}_{conn-id=00000000000000000000000000000000}_0
B  ***LOG BYG=> could not load library for database connection LCA        [dbds         862]
B  ***LOG BZY=> unexpected return code 8192       calling DBDS       [dbacds       1536]
C
C Thu Jul 25 14:22:50 2013
C     OCIAttrSet(con=0, rc ln: 0 32, -1 32, 0 2, 0 10) failed with SQL error 24960:
C     ORA-24960: the attribute  OCI_ATTR_MODULE is greater than the maximum allowable length of 48

[former_member188883 · Accepted solution]

Hi Neil,

Refer to thread Install scm/apo

Similar problem is mentioned and resolved by adjusting the user

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

Sorry for the duplicate thread.

I've read the solution on the link you sent. I would like to clarify what user are they pertaining to in the thread?

Upon checking our APO system, the standard liveCache user is already SAPLC1.

[Former Member]

Hi All,

We managed to solved to issue by upgrading the Kernel,

Thank you for all the helpful ideas.

Regards,

Neil

[former_member229109]

Hello Neil Bryan,

1.

After you started the liveCache in LC10 the post start report run, which set for LCA connection, second tab in Integration, LC10. If LEA connection was not setup properly, you got "lock Server not accessible" issue.

Test connection LEA in /ndb59, then check system log & corresponding dev log.

2.

You posted the dev log errors:

"

work proccess Dev_23: 

B  Loading DB library 'C:\usr\sap\AP1\DVEBMGS00\exe\dbsdbslib.dll' ...
M  *** ERROR => DlLoadLib()==DLENOACCESS - LoadLibrary("C:\usr\sap\AP1\DVEBMGS00\exe\dbsdbslib.dll")
  Error 126 = "The specified module could not be found." [dlnt.c       255]
M  {root-id=0015C58921771ED2BD9D22A0E0973991}_{conn-id=00000000000000000000000000000000}_0
B  *** ERROR => Couldn't load library 'C:\usr\sap\AP1\DVEBMGS00\exe\dbsdbslib.dll'

..."

=> Check the installation of liveCache client/MAXDB DBSL on application server.

     More details in SAP note

822271    FAQ: SAP MaxDB interfaces

Regards, Natalia Khlopina