LiveCashe issue LCA03 genete dump

[Former Member]

Hi all,

After we have implemented SCM + LiveCashe which worked fine during months, now we are facing an issue.

Ideed, we could not connect to LiveCashe even if the DB can start correctly.

The dump generetad is the following

Runtime Errors DBIF_DSQL2_CONNECTERR

Except. CX_SY_NATIVE_SQL_ERROR

Date and Time 04.02.2009 11:16:18

Error in the syslog

LCA0 BY G No shared library found for the database with ID LCA

LCA0 AB 0 Run-time error "DBIF_DSQL2_CONNECTERR" occurred

LCA0 AB 1 > Short dump "090204 111618 s90dbcip kg_S90_10 " generated

But at the OS level we can see that everything seems to be OK

dbmcli on eowyn : L90>db_start

OK

---

dbmcli on eowyn : L90>db_state

OK

State

ADMIN

---

dbmcli on eowyn : L90>db_activate

OK

---

dbmcli on eowyn : L90>db_state

OK

State

ONLINE

Someone has an idea ?

If so ... many thanks for your help

Yacine

[Former Member · Accepted solution]

Hi,

you are using kernel release 700 which needs to have the SQLDBC runtime version 7.6.

tis client has to be installed on the application server as well.

So please check with the following command which Clients are installed on the application server side:

'sdbregview -l grep -i SQLDBC'

You will get a list of he installed client versions.

Is a SQLDBC Client version 7.6 available on the application server side?

Regards, Christiane

[Former Member · Accepted solution]

Hi Christiane,

Many thanks for your help

I have solved my issue

I just forget to mentionned that we are in HA MC/SG clustering

And apparently LiveCashe files should be shared to SAP (which is running on another node)

I had to use automount technoligy and then noyw it works fine

Many thanks for your help

Yacine

root@eowyn L90]# cat /etc/auto.import

sapmnt -fstype=nfs,rw,udp,nosymlink s90dbcipkgp:/export/sapmnt/S90

S90 -fstype=nfs,rw,udp,nosymlink s90dbcipkgp:/export/usr/sap/S90

spool -fstype=nfs,rw,udp,nosymlink l90lcpkgp:/export/usr/spool

data -fstype=nfs,rw,udp,nosymlink l90lcpkgp:/export/sapdb/data

L90 -fstype=nfs,rw,udp,nosymlink l90lcpkgp:/export/sapdb/L90

programs -fstype=nfs,rw,udp,nosymlink l90lcpkgp:/export/sapdb/programs

SAPTS_TRACE_FILTER

SAPTS_UPDATE_TIMESERIES

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

Installation successfully finished

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

Enabling user L90ADM

liveCache L90 successfully initialized.

-

---

04.02.2009

15:56

• END ******************************

[Former Member]

Hi Christiane,

Thanks for your quick answer

The client has already patched, but if this action as done now we can connect via the Database Manager Gui but from SAP we still have the same issue (dump)

Patch client :

----

---

Patch Info -

---

same package already installed

checking consistence of package data in install registry...

check files... ok

check rte registration of package... ok

skipping package

installation of SAP liveCache APO LiveCache finished successfully We, Feb 04, 2009 at 11:44:21

finding instance type...

checking mmap support...

starting release already known

apo starting release already known

migration strategy already known

running finalize check...

current liveCache state is OFFLINE

checking parameters...

switch liveCache state to ADMIN

switch liveCache state to ONLINE

loading system tables...

checking catalog...

registering liveCache application procedures...

switch to offline

MaxDB instance "L90" updated successfully We, Feb 04, 2009 at 11:44:43

-

---

Otherwise here is the answer of your questions

SAP note 822239 Question 4. Which version of the precompiler runtime is used in which SAP versions?

f) Version 6.40 Basis, 6.40 AKK (including NetWeaver 04, Web AS 6.40, SCM 4.1, 6.30 J2EE)

The precompiler runtime versions required by the DBSL (dbadaslib) are:

- 7.4.03 Build 11 or higher (Windows NT and UNIX)

- 7.4.03 Build 17 or higher (Linux IA64)

- 7.4.03 Build 26 or higher (HP IA64)

- 7.5.00 Build 16 or higher (LINUX PPC64 and LINUX AMD64)

- 7.5.00 Build 15 or higher (LINUX s390)

- 7.5.00 Build 24 or higher (NT AMD64)

The system is an SCM 5.1 with Kernel 159

-

---

Kernel version -

---

dispwork information+

----

---

kernel release 700

kernel make variant 700_REL

compiled on Linux GNU SLES-9 x86_64 cc3.3.3

compiled for 64 BIT

compilation mode UNICODE

-

---

-

---

Client version -

---

starting preparing phase of package PCR 7500 7.5.00.50 64 bit

same package already installed

checking consistence of package data in install registry...

check files... ok

check rte registration of package... ok

-

---

I will check all the other topics

Best regards and many thanks for your qucik answer

Yacine

[Former Member]

Hi,

additionally please check note 1066891.

When you get further problems please open an official SAP customer-Call on component BC-DB-LVC.

Regards, Christiane

[Former Member]

Hi,

it looks like the Client software on the application side cannot be found.

Which SAP-Kernel version are you suing?

Please check the errors in system log TA /nsm21 & the corresponding

dev log, could be displayed in /nst11 or /nsm50.

You have to check that the precompiler runtime versions or if you are using SCM 4.1 with 640-ext2 Kernel SQLDBC Runtime version

required by the DBSL (dbadaslib) are installed on the application

servers, review the answer on 4. question in SAP Note No. 822239.

The liveCache client software could be updated using the note 649814.

Regards, Christiane