DlLoadLib()==DLENOACCESS - dlopen dbsdbslib.o

[Former Member]

Hello experts,

We are doing our SCM upgrade from 4.1 to 7.0 with migration. We have completed with the upgrade but before doing the LC upgrade we need to upload the data to the LC using the /SAPAPO/OM_LC_UPGRADE_70, while doing this it gives an error for connectivity to the LC. From DB59, i checked the connection test fails for "Native SQL" (LCA) step.

+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:            4+

From the workprocess we get the below error

B  Loading DB library '/usr/sap/EAD/DVEBMGS59/exe/dbsdbslib.o' ...
M  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/EAD/DVEBMGS59/exe/dbsdbslib.o") FAILED
  "#0509-130 Symbol resolution failed for /usr/sap/EAD/DVEBMGS59/exe/dbsdbslib.o because:
#0509-136   Symbol getData__Q2_6SQLDBC10SQLDBC_LOBFPvPLLT3T1T3T2b (number 197) is not exported from
##   dependen"  (errno=8,Exec format error) [dlux.c       445]
M  {root-id=4D87070E166501B0E1008002A7E41451}_{conn-id=00000000000000000000000000000000}_0
B  *** ERROR => Couldn't load library '/usr/sap/EAD/DVEBMGS59/exe/dbsdbslib.o'
 [dbcon.c      5263]
B  {root-id=4D87070E166501B0E1008002A7E41451}_{conn-id=00000000000000000000000000000000}_0
B  ***LOG BYG=> could not load library for database connection LCA        [dbds         886]

We have upgrade the sap kernel and also the above said dbsl library, and it exists in the exe directory, But still nothing seems to work...

Can someone give any ideas ??

Thx

Ananth

[former_member415892]

Dear experts,

We are currently experiencing the same issue. We receive the same error but the libraries are in the exe/run.

Please advice... since we have a message open but haven't received a response yet.

thank you,

kind regards

[Former Member]

Hi All,

I am facing the same issue. Could please let me know if it is resolved and how?

Here the is error I am seeing in TP.ECO

TRACE-INFO: 1: [ dev trc,00000] Fri Oct 28 23:41:56 2011 4174 0.004174

TRACE-INFO: 2: [ dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/QAS/upg/abap/exenew/dboraslib.o") FAILED

TRACE-INFO: 3: " 0509-130 Symbol resolution failed for /usr/sap/QAS/upg/abap/exenew/dboraslib.o because:

TRACE-INFO: 4: 0509-136 Symbol strcat (number 149) is not exported from 14 0.004188

TRACE-INFO: 5: dependent module /oracle/client/10x_64/instant" (errno=8,Exec format error)

We are upgrading the R3 4.7 to ECC6 EHP5.

Thanks & Regards,

N.Amarnath

[Former Member]

Hi All,

I got it resolved sipmly by updating the new kernel(/usr/sap/<SID>/upg/abap/exenew) with the latest dbsl patch(lib_dbsl_109-20005193.sar).

Thanks & Regards,

N.Amarnath

[Former Member]

Hi Mark,

I did check the env variables, and they seemed to be Ok.. It has the DIR_LIBRARY path pointing to the SYS/exe/run directory .

Natalia,

1. What is the version and patch level of the MAXDB DBSL library '/usr/sap/EAD/DVEBMGS59/exe/dbsdbslib.o' ?

< Check in the dev log of the WP 0 or run

"what /usr/sap/EAD/DVEBMGS59/exe/dbsdbslib.o" and see the Info at the end >

-- The Version and patch level is 720 - patch 81

2. What is the version and patch level of the SAP kernel on the application server?

The Kernel is Release 720 patch 72

3. What is the version of the MAXDB/liveCache client on the application server?

=> ./sdbregview -l

DB Analyzer /sapdb/programs 7.6.01.05 64 bit valid

Server Utilities /sapdb/programs 7.5.00.09 64 bit valid

PCR 7300 /sapdb/programs 7.3.00.58 valid

PCR 7301 /sapdb/programs 7.3.01.21 valid

PCR 7500 /sapdb/programs 7.5.00.46 64 bit valid

SAP Utilities /sapdb/programs 7.7.03.22 64 bit valid

APO LC APPS /sapdb/EAS/db/sap 4.10.001 64 bit valid

Redist Python /sapdb/programs 7.7.03.22 32 bit valid

Base /sapdb/programs 7.7.03.22 64 bit valid

JDBC /sapdb/programs 7.6.04.03 valid

Messages /sapdb/programs MSG 0.6238 valid

ODBC /sapdb/programs 7.7.03.22 64 bit valid

Database Kernel /sapdb/EAS/db 7.5.00.09 64 bit valid

SQLDBC 77 /sapdb/programs 7.7.03.22 64 bit valid

Loader /sapdb/programs 7.7.03.22 64 bit valid

SQLDBC /sapdb/programs 7.7.03.22 64 bit valid

SQLDBC 76 /sapdb/programs 7.6.03.11 64 bit valid

Fastload API /sapdb/programs 7.7.03.22 64 bit valid

PCR 7403 /sapdb/programs 7.4.03.50 64 bit valid

I get the below error for db_enum and inst_enum

dbmcli db_enum

Error! Connection failed to node (local) for database (no dbname):

database instance not found

dbmcli inst_enum

Error! Connection failed to node (local) for database (no dbname):

database instance not found

Although the other APO systems on the same host are running fine.

Thx Ananth

[former_member229109]

Hello,

1. According PAM the SCM 7.0 released with SAP KERNEL 7.01 .

Another system, which is running fine on this server, has the SAP kernel 7.01 version. Correct?

2. Go to market place/patches < SAP link>

and see that SAP kernel 7.20 is released for for Basis 720/702,

the SCM 7.0 is released with Basis 701.

3. I got information from my colleague that you already created the SAP message: 0000241211/2011 ,

where this issue is reported.

In the message you gave more information about SAP Basis release 702 of the system and your target upgrade release is SCM 7.0 EHP1, which released with SAP kernel 7.20.

=>

Pay attention to already recommended notes:

822239 FAQ: SAP MaxDB Interfaces

"f) SAP kernel version 7.20 (including NW 7.20)

The SQLDBC runtime versions required by the DBSL (dbsdbslib) are:

- 7.7.04 Build 9 or higher all available platforms"

822271 FAQ: SAP MaxDB client software

And you have the SQLDBC runtime version 7.7.03.22 currently on the application server according the output of "sdbregview -l" command.

Please update the liveCache client software as recommended by my colleague in the SAP message to solve reported issue.

I recommend to close this thread and in case of further questions related to the dbsdbslib library please update the message.

You are in good hands from SAP support.

4.

"I get the below error for db_enum and inst_enum

dbmcli db_enum

Error! Connection failed to node (local) for database (no dbname):

database instance not found

dbmcli inst_enum

Error! Connection failed to node (local) for database (no dbname):

database instance not found

"

You installed the liveCache instance on another server. I saw the database kernel software:

"Database Kernel /sapdb/EAS/db 7.5.00.09 64 bit valid"

listed as installed by "sdbregview -l", but this installation is not registered.

You could address the question in another message or forrum thread on this issue.

Did you install the database instance on the application server?

Regards, Natalia Khlopina

Edited by: Natalia Khlopina on Mar 21, 2011 2:33 PM

[Former Member]

Hi,

Was there a solution for this issue. I am upgrading to SCM 7.0 EhP1. My kernel is 7.20, and my SQLDBC is 7.7.07.10 which meets the requirements for the kernel.

I am getting the error:

Test the SQL connection (Native SQL at CON_NAME)

sql_neg: 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 connect

SQL code:

Please check with SM50 the following work process: 8

Thank you,

Imran

[former_member229109]

Hello Imran

-> "Was there a solution for this issue."

What issue? Create the new thread and post your question in the new thread!

-> Best, create the SAP message and get SAP support.

-> Don't change the env variables manually, use SAP scripts - see SAP note 1066891 about LCENV.SAR package

Regards, Natalia Khlopina

[former_member229109]

Hello,

1. What is the version and patch level of the MAXDB DBSL library '/usr/sap/EAD/DVEBMGS59/exe/dbsdbslib.o' ?

< Check in the dev log of the WP 0 or run

"what /usr/sap/EAD/DVEBMGS59/exe/dbsdbslib.o" and see the Info at the end >

2. What is the version and patch level of the SAP kernel on the application server?

3. What is the version of the MAXDB/liveCache client on the application server?

< run on the application server "sdbregview -l" and post the output. >

Review the SAP notes:

822271 FAQ: SAP MaxDB client software

822239 FAQ: SAP MaxDB Interfaces

4. As SAP client you have option to create the SAP message and get SAP support, component "BC-DB-LVC".

Regards, Natalia Khlopina

[Former Member]

Thanks Mark, Manoj for replying..

Here is the asnwers to your questions

+on your startup are you using SAPCPE ?+

I have the exe directory in the DEVBMGS folder pointed to the /sapmnt/<SID>/exe so SAPCPE will not make any difference since both point to the same location

+What is your O/S+

My OS is AIX 6.1, the APO database is on db2 9.7 , the livecache is currently on 7.5.

+Note 538849 - UNIX: DLENOACCESS when loading dboraslib and libclntsh+

I check this note and, it didnt help me much. I have the dbsl library for sdb already upgarded too.

Thx Ananth

[Former Member]

Hi,

thanks for that...

To me it looks like your environment variables issue...

What does you variables look like ?

Mark

[Former Member]

Please check attached note. It is old but may help you.

Note 538849 - UNIX: DLENOACCESS when loading dboraslib and libclntsh

[Former Member]

Hi,

on your startup are you using SAPCPE ?

Mark

[Former Member]

Hi,

What is your O/S

Mark