could not load library for database connection LCA

[Former Member]

Hi,

I am facing RFC connection prblem while connectiong to database. I have installed SCM5.1 and live cache in single server

Please find the logs.

Work process log:

B Mon Jul 20 11:19:13 2009

B create_con (con_name=LCA)

B Loading DB library 'E:\usr\sap\SC7\DVEBMGS03\exe\dbsdbslib.dll' ...

M *** ERROR => DlLoadLib: LoadLibrary(E:\usr\sap\SC7\DVEBMGS03\exe\dbsdbslib.dll) Error 126 [dlnt.c 241]

M Error 126 = "The specified module could not be found."

B *** ERROR => Couldn't load library 'E:\usr\sap\SC7\DVEBMGS03\exe\dbsdbslib.dll'

[dbcon.c 4731]

B ***LOG BYG=> could not load library for database connection LCA [dbds#1 @ 1035] [dbds 1035 ]

A

A Mon Jul 20 11:21:58 2009

A GENER starting remote generation: /SAPAPO/OM_SYNC_LC_DB (requested by W1).

B

SM21:

No shared library found for the database with ID LCA|

-

---

No shared library found for the database with ID LCA

/SAPAPO/OM17|/SAPAPO/OM_SYNC_LC_DB|K |SAP Web AS Problem|SBAC |

-

---

-

---

Documentation for system log message BY G :

As well as the standard connection, an attempt was made to set up

another database connection, under the specified ID. The Shared Library

for this second database could not be found.

The Shared Library is usually found in the the Executable

directory (profile parameter DIR_LIBRARY) under the name dbs

<dbs>slib<os_ext>. <dbs> stands for the database type and <os_ext>

stands for the operating system-specific extension of the Shared

Libraries.

The database type is determined from the entry that corresponds to the

specified DB ID in the table DBDCON. Check whether the data in this

entry is correct.

-

---

ST22

Runtime Errors DBIF_DSQL2_CONNECTERR

Exception CX_SY_NATIVE_SQL_ERROR

Date and Time 20.07.2009 11:22:21

-

---

-

---

Short text

Error setting up a secondary database connection

-

---

-

---

What happened?

Connection to database system not possible with identifier "LCA".

-

---

-

---

-

---

|----

---

System environment

SAP-Release 700

Application server... "

Network address...... "

Operating system..... "Windows NT"

Release.............. "5.2"

Hardware type........ "8x AMD64 Level"

Character length.... 16 Bits

Pointer length....... 64 Bits

Work process number.. 8

Shortdump setting.... "full"

Database server... "

Database type..... "ORACLE"

Database name..... "SC7"

Database user ID.. "SAPSC7"

Terminal................. " "

Char.set.... "C"

SAP kernel....... 701

created (date)... "Jul 6 2009 23:47:55"

create on........ "NT 5.2 3790 Service Pack 1 x86 MS VC++ 14.00"

Database version. "OCI_10201_SHARE (10.2.0.2.0) "

Patch level. 50

Patch text.. " "

Database............. "ORACLE 9.2.0.., ORACLE 10.1.0.., ORACLE 10.2.0.."

SAP database version. 701

Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2, Windows

NT 6.0"

-

---

-

---

Information on where terminated

Termination occurred in the ABAP program "SAPLSLCAPPS" - in

"LCA_EXISTS_LCA_ROUTINE".

The main program was "/SAPAPO/TS_BATCH_RUN ".

In the source code you have the termination point in line 23

of the (Include) program "LSLCAPPSU05".

The program "SAPLSLCAPPS" was started as a background job.

Job Name....... "MACROS"

Job Initiator.. "SC7GEN"

Job Number..... 10222002

The termination is caused because exception "CX_SY_NATIVE_SQL_ERROR" occurred

in

procedure "LCA_EXISTS_LCA_ROUTINE" "(FUNCTION)", but it was neither handled

locally nor declared

in the RAISING clause of its signature.

The procedure is in program "SAPLSLCAPPS "; its source code begins in line

1 of the (Include program "LSLCAPPSU05 ".

-

---

Please help me to resolve the issue.

Suraj

[former_member229109]

Hello Suraj kumar ,

-> As SAP customer you could open the OSS ticket & get the SAP support.

-> According the posted information you may be installed the SAP kernel 32bit version

and liveCache/MAXDB runtime software package of 64bit version on the same server.

The dbsdbs library could not be loaded, it need the SQLDBC runtime 32bit version.

< See the SAP note: 822239 FAQ: MaxDB Interfaces >

-> Please post the output of the following commands on the application server:

disp+work

< to see the SAP kernel version >

sdbregview -l

< to see the liveCache software versions>

What is the version of the of E:\usr\sap\SC7\DVEBMGS03\exe\dbsdbslib.dll?

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Natalia Khlopina,

I have raised OSS message to SAP.

Below is the information

E:\usr\sap\SC7\SYS\exe\uc\Copy_ of_NTAMD64_15062009>sdbregview -l

Server Utilities e:/sapdb/programs 7.7.02.08 64 bit valid

DB Analyzer e:/sapdb/programs 7.7.02.08 64 bit valid

PCR 7301 e:/sapdb/programs 7.3.01.21 valid

PCR 7500 e:/sapdb/programs 7.5.00.42 64 bit valid

SAP Utilities e:/sapdb/programs 7.7.02.08 64 bit valid

APO LC APPS f:/sapdb/lcs/db/sap 6.00.004 64 bit valid

Redist Python e:/sapdb/programs 7.7.02.08 64 bit valid

Base e:/sapdb/programs 7.7.02.08 64 bit valid

JDBC e:/sapdb/programs 7.6.03.02 valid

Messages e:/sapdb/programs MSG 0.5010 valid

ODBC e:/sapdb/programs 7.7.02.08 64 bit valid

SQLDBC 77 e:/sapdb/programs 7.7.02.08 64 bit valid

Database Kernel f:/sapdb/lcs/db 7.7.02.08 64 bit valid

Loader e:/sapdb/programs 7.7.02.08 64 bit valid

SQLDBC e:/sapdb/programs 7.7.02.08 64 bit valid

SQLDBC 76 e:/sapdb/programs 7.6.01.15 64 bit valid

Fastload API e:/sapdb/programs 7.7.02.08 64 bit valid

C:\Documents and Settings\sc7adm>disp+work

-

---

disp+work information

-

---

kernel release 701

kernel make variant 701_REL

compiled on NT 5.2 3790 Service Pack 1 x86 MS VC++ 14.00

compiled for 64 BIT

compilation mode UNICODE

compile time Jul 6 2009 23:47:55

update level 0

patch number 50

source id 0.050

-

---

supported environment

-

---

database (SAP, table SVERS) 700

701

operating system

Windows NT 5.0

Windows NT 5.1

Windows NT 5.2

Windows NT 6.0

Thanks for quick responce.

Suraj

[former_member229109]

Hello Suraj,

please update the MAXDB/liveCache client software on the application server.

Follow the SAP note 649814, download the "MAXDB 7.7.06.15 Application Runtime Package".

What is the SAP ticket number?

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Natalia Khlopina,

My problem is resolved.

Recently i have upgraded SAP SCM kernel. From that time onwards i am getting tis issue.

I have replaced SAPDBMRFC.exe, dbsdbslib.dll and dbsdbslib.pdb files from old kernel. Now Live cache working fine.

Thanks for immediate help.

Suraj

[former_member229109]

Hello Suraj,

I recommend you after the SAP kernel update to update the MAXDB/liveCache client software on the application server.

After that replace SAPDBMRFC.exe, dbsdbslib.dll and dbsdbslib.pdb files from new kernel.

What is the SAP ticket number, where you reported the issue?

Thank you and best regards, Natalia Khlopina