Sm59 connection test to livecache failed

[former_member246694]

Dear All,

The following errors are coming when I tried to take a connection test (SM59) to livecache server from my APO system

Application Server: pspdciscp_SCP_65 ( AIX )

1. Connect. test with "dbmcli db_state" Unsuccessful

no_client_software

2. Connect. test with command mode "dbmrfc db_state" Unsuccessful

no_client_software

3. Connect. test with session mode "dbmrfc db_state" Unsuccessful

no_client_software

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: 2

Pls help .

Regards,

kiran

[former_member229109 · Accepted solution]

Hello Kiran,

login to the server pspdciscp as SCPadm user & check if the liveCache client software installed on the server.

cd /sapdb/programs/bin

sdbregview -l

xinstinfo

See the SAP note:

822271 FAQ: SAP MaxDB client software

Regars, Natalia Khlopina

[former_member246694 · Accepted solution]

Hello Natalia,

Thanks for the quick response.

I just found out that /sapdb does not contain any data in the application server.

can I copy the same data/files as present in the /sapdb of livecache to the application server?

or any particular directories to be copied?

( FYI: Livecache is a copy of our existing Prod server LC )

Thanks,

kiran

[former_member229109 · Accepted solution]

Hello Kiran,

No. It's not recommended/supported.

Please install the liveCache client software on the application server.

I already gave you SAP note.

To install the liveCache client software => follow the SAP note ::

649814 Updating MaxDB/liveCache client software

Please read SAP Note 822239 that answers frequently asked questions (FAQ) about MaxDB interfaces.

Regards, NK

[former_member246694 · Accepted solution]

Hello Natalia,

I was trying to download the MAXDBART since morning.The file isnt getting downloaded.

Actually we had our DR system built in the manner as i told you earlier .( By making a full file sys copy ..both apo and LC).

So i has this basic doubt to copy the /sapdb directories in the application server.

Since the server im talking about is a training system,can i give a try once ?..

Also do i need to stop the Apo server application and db and Lc xserver during the installation of client on application server?

Thanks,

Kiran.

[former_member229109 · Accepted solution]

Hello Kiran,

1. If the Apo server application and db and Lc server have the same OS.

Run u201Cuname u2013au201D to compare.

Use the liveCache software SAR file to install the liveCache client, see the note 649814 u2013 4. And 5. Steps.

As you installed the liveCache instance, you should have it.

2. If you donu2019t know what to copy, you will have further issues u2026

Which will lead you to install the database client software using SDBINST => 1.

3. You could open the SAP message on the reported issue.

Thank you & best regards, Natalia Khlopina

[former_member246694 · Accepted solution]

Hello Natali,

We are using Aix version 6, but available MAXDBART is avaialble for version 5.

However I tried to use that version, but i got the following errors

pspdciscp:scpadm 66> SAPCAR -xvf MAXDBART7707_20-10004350.SAR

SAPCAR: processing archive MAXDBART7707_20-10004350.SAR (version 2.00)

x maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20

x maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20/SDBBAS.TGZ

SAPCAR: error decompressing maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20/SDBBAS.TGZ; error code is -22

Let me know if i'm wrong somewhere.

Thanks n Regards,

Kiran

[former_member246694 · Accepted solution]

Hello Natalia,

These are the errors that occured when i tried to install the client

INSTALLER_INFO: Version = 7.7.02 Build 008-123-149-275

INSTALLER_INFO: Changelist = 149275

INSTALLER_INFO: MakeId = 230698

INSTALLER_INFO: Type = installed

SYS_INFO: Host name = pspdciscp

SYS_INFO: System = AIX

SYS_INFO: Architecture = PowerPC

SYS_INFO: Version = 6.1.0.0

ERR: Collector: no MaxDB software package found in directory /sapdb/programs/bin

MSG: collector found 1 archives

MSG: initializing package "Base"

MSG: calling preinstall...

MSG: service "sql6" in "/etc/services" found

MSG: service "sapdbni72" in "/etc/services" found

MSG: selected new installation in ""

MSG: selected new installation in "/sapdb/programs"

MSG: InstallRegistry: space check ok: 2860192 kb on /sapdb (3145728 kb total) available

MSG: install registry successfully locked

MSG: read 15 PACKAGES

MSG: net registry size = 78274 bytes

WRN: InstallRegistry::reserveSpace(): file >= 1024 kb

MSG: no installation data to migrate for "Database Kernel"

SYS: slibclean

MSG: SYS: slibclean:

STDOUT: start extraction test run of "/tmp/SAPCAR/maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20/SDBBAS.TGZ"

STDERR: test bin/dbmcli failed: unexpected end of archive /tmp/SAPCAR/maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20/SDBBAS.TGZ

Error: Checking package Base failed!: Software archive is damaged:

unexpected end of archive /tmp/SAPCAR/maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20/SDBBAS.TGZ

MSG: packagedata of package Base not changed

MSG: install registry successfully unlocked

Also I decompressed the .tgz file manually and this is the result

root@pspdciscp:/tmp/SAPCAR/maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20#ls

PACKAGEDATA SDBBAS.TGZ base.lst bin instbase

root@pspdciscp:/tmp/SAPCAR/maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20#cd bin

t@pspdciscp:/tmp/SAPCAR/maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20/bin#ls

dbmcli

t@pspdciscp:/tmp/SAPCAR/maxdb-as_runtime-aix5-64bit-ppc-7_7_07_20/bin#dbmcli

exec(): 0509-036 Cannot load program dbmcli because of the following errors:

0509-120 An offset in the .loader section header is too large.

0509-193 Examine the .loader section header with the

'dump -Hv' command.

Well im not able to proceed with the client installation.

Am i missing something there?

Regards,

kiran

[former_member229109 · Accepted solution]

Hello Kiran,

1. Was you able to unpack the SAR file using SAPCAR

2. SAP note:

212876 The new archiving tool SAPCAR

Download the new SAPCAR tool.

3. Run the unpack the MAXDBART7707_20-10004350.SAR again.

If you failed, please check that you downloaded the MAXDBART7707_20-10004350.SAR

From the Market SAP place completely. For example, by size.

-> Create the SAP MESSAGE in case of further problems.

Thank you and best regards, Natalia Khlopina

[former_member246694 · Accepted solution]

Thank u Natalia,

I have installed LC client and thus solved all the problems.

Regards,

kiran