R3trans fails from RHEL6 application server

[john_lewis5]

I have an SCM 7.0 Linux/MaxDB application server that was working fine, but now that it has been upgraded to RHEL6, won't connect back to the db server.  From the application server, I run R3trans -dwv, and it returns this: 

> R3trans -dwv

This is R3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/APP/SYS/exe/run') or dbms_type ('ada')"

R3trans finished (0012).

I've already verified that dbms_type = ada and DIR_LIBRARY = /usr/sap/APP/SYS/exe/run in the environment.

When I look at the trans.log file that is created, here is what I'm seeing;

> more trans.log

4 ETW000 R3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 10.11.2014 - 17:05:32

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -dwv

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Mon Nov 10 17:05:32 2014                                                  44  0.0

00044

4 ETW000  [     dev trc,00000]  db_con_init called                                                        13  0.0

00057

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)

4 ETW000                                                                                                  18  0.0

00075

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  13  0.0

00088

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                  7  0.0

00095

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/APP/SYS/exe/run/dbsdbslib.so' ...            25  0.0

00120

4 ETW000  [    dlux.c  ,00000]  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/APP/SYS/exe/run/dbsdbsli

b.so") FAILED

4 ETW000                          "libSQLDBC77.so: cannot open shared object file: No such file or directory"

4 ETW000                                                                                                 709  0.0

00829

4 ETW000  [    dbcon.c ,00000]  *** ERROR => Couldn't load library '/usr/sap/APP/SYS/exe/run/dbsdbslib.so'

4 ETW000                                                                                                  61  0.0

00890

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/APP/SYS/exe/run') or d

bms_type ('ada')"

I'm concerned about the libSQLDBC77.so error - as it lives in /sapdb/programs/lib on the db server, but /sapdb isn't mounted on the application server.

Any help will be appreciated...

Thanks,

John

[Former Member · Accepted solution]

Hi John,

R3trans utility requires the MAXDB client for connecting to a MAXDB database.

As shown in the logs, the Shared Object library file of R3 Kernel (/usr/sap/APP/SYS/exe/run/dbsdbslib.so) has got dependancy on the maxdb client shared object (libSQLDBC77.so).

To reproduce the error, you can type "ldd /usr/sap/APP/SYS/exe/run/dbsdbslib.so" and this will show you that the SQLDBC Shared Object lib file is not found.

For avoiding this error, your LD_LIBRARY_PATH env should contain a path that has the libSQLDBC77.so file.

And since you have mentioned that the /sapdb mount (which normally contains the SQLDBC file )is missing from app server, you can proceed with the one of the following methods :

1) share the /sapdb mount from db server to app server.

2) check LD_LIBRARY_PATH and it should contain the path "/sapdb/programs/lib". if not add this line  "setenv LD_LIBRARY_PATH $LD_LIBRARY_PATH:/sapdb/programs/lib" in one of your corresponding shell rc file (if shell is csh, then the file would be  ~/.cshrc).

or if you prefer not to share the /sapdb mount between db and app server,

1) install  maxdb client in local app server (client version should be similar to db version)

2) next, set the path of the client sw location installed, to LD_LIBRARY_PATH as mentioned above in step 2.

Regards,

Lalu George