Installation Error IN IMPORT ABAP phase:ECC6 ehp 7 ,red hat Linux SYSBASE BD

[Former Member]

Hi Friends,

During Import ABAP Phase we are facing an Error: R3load -testconnect failed .

Could not load SYB library libsybdrvodb.so. No database connection possible.2EETW169 no connect possible: "DBMS = SYBASE --- "

Please suggest how to solve this issue .

[Former Member]

Hi Ankam,

Please check following SAP note.

1817091 - SYB: Could not load SYB library sybdrvodb64.dll. when connecting to a Sybase ASE database

Thanks

[Former Member]

Hi Sumit,

Thanks for the reply,

1. we have given 777 permissions to the Kernal.

2.we have downloaded latest R3trans , but same issue.

1639578 :snote we are following now, i think this could help us.

[Former Member]

When we execute

./R3trans -d  

[root@ linuxx86_64]# ./R3trans -d

This is ./R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09).

unicode enabled version

2EETW169 no connect possible: "environment variable DIR_LIBRARY is not set."

./R3trans finished (0012).

[root@ linuxx86_64]# export DIR_LIBRARY=/usr/sap/xxx/SYS/exe/run

[root@ linuxx86_64]# echo $DIR_LIBRARY

/usr/sap/xxx/SYS/exe/run

[root@q linuxx86_64]# ./R3trans -d

This is ./R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09).

unicode enabled version

2EETW169 no connect possible: "environment variable dbms_type is not set."

./R3trans finished (0012).

[root@inuxx86_64]# export dbms_type=sybase

[root@ linuxx86_64]# ./R3trans -d

This is ./R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09).

unicode enabled version

2EETW169 no connect possible: "DBMS = SYBASE --- "

./R3trans finished (0012).

Please suggest how to set env variables for SYSBASE RED hat

Regards,

Harish

[Former Member]

Hi Harish,

,

What's the error in trans.log file ? Please also check below params are set in DEFAULT profile or not.

dbs/syb/server = <database host>
dbs/syb/port = <port>

and following ENV params should be set

dbs_syb_server

dbs_syb_port

Thanks

[Reagan]

Try setting the environment variables (temporarily) of the <SID>adm user for root and see if that helps. In fact the dbms_type should have the value SYB and not sybase.

2181942 - SYB: R3load.exe -testconnect exits with error code 2 - SAP ASE

[Former Member]

Hi Dash,

Sysbase was successfully installed . We don't find any trans.log.

Any how thanks for your suggestion.

Next i will set ENV params

dbs_syb_server

dbs_syb_port

&will get back to you....

Regards,

Harish.

[Sriram2009]

Hi Harish.

Could you check this SAP KBA 2115940 for the error message "Could not load SYB library libsybdrvodb.so. No database connection"

BR

SS

[Former Member]

Hi Sriram,

When we executed R3trans -d command we got the error:

This is ./R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09).

unicode enabled version

2EETW169 no connect possible: "DBMS = SYBASE --- "

./R3trans finished (0012).

We got the suggestion from SAP to execute below command to connect database:

1. Logon with 'root' into in a new session on the C shell.
2. Execute the following commands:

  source <homedirectory_sidadm>/.sapenv_ <hostname>.csh
  source <homedirectory_sidadm>/.dbenv_ <hostname>.csh

3. Execute these commands to check whether the connection is working:

   R3load -testconnect
   R3trans -x

4. If the commands are working fine, please start sapinst from this
   session and continue.

But when we execute we are getting below Error.

When we tried to execute the 1st command ( source home/udvadm/.sapenv_ qadevuacc.csh ) it executed fine why becasue the sapenv_qadevuacc.csh { host name} exists in the directory.

Where as coming to the second command the ( source home/udvadm/.dbenv. csh\sh ) these files exists in the directory. But we require  [ .dbenv_qadevuacc.csh ] this file is missing.

[Sriram2009]

Hi Harish.

Are you using the SIDADM user id to execute the R3trans -d (not on root user id) ?

BR

SS

[Former Member]

Hi SriRam,

Yes we are executed with sidadm User only.

Regards,

Harish

[Former Member]

From your screenshot, you are running from root. Please run whoami command to make sure you are running from sidadm.

[former_member209809]

Hi Ankam,

Could you please do below

1) Check for permissions for Kernel files on filesystem

2) Download latest R3trans and R3Load and replace in you current Kernel directory

3) check and attach import logs.

Warm Regards,

Sumit