Register Login

LiveCache Connection Error

Updated May 18, 2018

Dear Experts,

I am receiving an error every time 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:usrsapAP1DVEBMGS00exedbsdbslib.dll' ...
M *** ERROR => DlLoadLib()==DLENOACCESS - LoadLibrary("C:usrsapAP1DVEBMGS00exedbs dbslib.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:usrsapAP1DVEBMGS00exedbsdbslib.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 8) 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 8) 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 8) 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:usrsapAP1DVEBMGS00exedbsdbslib.dll' ...
M *** ERROR => DlLoadLib()==DLENOACCESS - LoadLibrary("C:usrsapAP1DVEBMGS00exedbs dbslib.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:usrsapAP1DVEBMGS00exedbsdbslib.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


Comments

  • 25 Jul 2013 11:57 am Sushma
    Hello,

    Update the MaxDB client software.
    Follow this SAP Note
    Note 649814 - Updating SAP MaxDB / liveCache client software
  • 26 Jul 2013 7:26 am Sushma
    Hi,

    You are missing a DLL file:

    C:usrsapAP1DVEBMGS00exedbsdbslib.dll

    To get it, go get a new SAP kernel and make sure you choose SAPEXEDB.sar for MaxDB. It will contain this DLL file and you can save it in the right location.

    Good luck.
  • 26 Jul 2013 7:26 am Sushma
    I'm a colleague of Neil, and we are both investigating this issue. We have checked the path C:usrsapAP1DVEBMGS00exe and we can see that the file dbsdbslib.dll is there.

    Please advise on how to proceed.
    Thanks!
  • 26 Jul 2013 7:26 am Sushma
    Hi,

    Then, check the version of this file and make sure it is equivalent in version and patch level compared to dboraslib.dll or dbmssslib.dll (depending on the database you use).

    Check stderr* files and other dev_* trace files in the work directory for more info on why this could be failing. I do not remember exactly which of the trace files contains info related to DB connections.
  • 26 Jul 2013 11:49 am Sushma
    Hello,

    If I were you I would follow this procedure :
    1 - Update the Database Library files (dbsl_XXXX.sar)
    If that doesn't hep then
    2 - Update the kernel on the system
    If the problem is still there then
    3 - Update the MaxDB client software.

×