SAP Additional App Server unable to recognize sybase DB on PAS

[Former Member]

Hi Experts,

We have Primary App Server(PAS) + DB installed on a single box which is up and running fine, now we are trying to install an additional application server(AAS) and we have NFS mounted /sapmnt/SID and /usr/sap/trans from PAS onto the Addtln App Server but got some error when SWPM is starting the instance. When checked the logs dev_w0 says that it is unable to establish connection with the sybase database :

ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4531]

C  (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection

C  syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

C  Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=hnpclecp;port=4901;uid=SAPSR3;db=ECP;pwd=xxxxxxxxxxxx;TextSize=21

47483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=1;E

nableLOBLocator=0;app=R3D000 01 comm rd ODBC;logintimeout=30;ProtocolCapture=cap_w0_comm_rd;supresstdscontroltokens=1;SuppressRowFormat=1

;SuppressParamFormat=1;

C

B  ***LOG BV3=> severe db error 30012     ; work process is stopped [dbsh         1241]

B  ***LOG BY2=> sql error 30012  performing CON [dblink       544]

B  ***LOG BY0=> [ASE Error SQL30012:08001]Client unable to establish a connection [dblink       544]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1521]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11445]

Both the servers are on the same network and hence all the ports will be open already.

Also /sapmnt/<SID> is mounted and in /usr/sap/SID/D01/exe of app server has the latest sybase library files.

Kindly advice if I have missed any mandatory steps for AAS intance installtion...

Thanks !!!

Regads,

Srikanth

[Former Member]

Hi ,

Issue got resolved after making making an entry of the app server host name in the interfaces file under  $SYBASE on database host.

Earlier file looks like below :

[sybecp@hnpclecp ~]$ cat interfaces

ECP

        master tcp ether <DBHOST> 4901

        query tcp ether <DBHOST> 4901

We have made app server entry as well now :

[sybecp@hnpclecp ~]$ cat interfaces

ECP

        master tcp ether <DBHOST>,<APP-SERVER-HOST> 4901

        query tcp ether <DBHOST>,<APP-SERVER-HOST> 4901

This has done the trick:)

Thanks for your assistance..

Regards,

Sri

[Former Member]

Hi Juan,

We are using Sybase ASE and SWPM has not asked for any client software(I believe its not required for Sybase). And R3trans -X returns 0012 with trans log saying ;

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872]          11  0.017067

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4359]

4 ETW000                                                                                                  40  0.017107

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "/usr/sap/ECP/SYS/global/security/rsecssfs/data/SSFS_ECP.DAT" opened for read [rsecssfs.c 2539]

4 ETW000                                                                                                  63  0.017170

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "/usr/sap/ECP/SYS/global/security/rsecssfs/key/SSFS_ECP.KEY" not found, using default key [rsecssfs.c 1424]

4 ETW000                                                                                                  35  0.017205

4 ETW000  [     dev trc,00000]  RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2561]

4 ETW000                                                                                                  33  0.017238

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage) [rsecssfs.c 940]

4 ETW000                                                                                                  38  0.017276

4 ETW000  [     dev trc,00000]  read_ssfs_record(): not found is accepted, RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage

4 ETW000                                                                                                  13  0.017289

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                     7  0.017296

4 ETW000  [     dev trc,00000]  load of SQLLEN8 SYB library libsybdrvodb8.so successful.                4328  0.021624

4 ETW000  [     dev trc,00000]  lib_dbsl 721 12/12/2013 15:20:00                                         761  0.022385

4 ETW000  [     dev trc,00000]  connection unquiesced                                                     17  0.022402

4 ETW000  [     dev trc,00000]  721_EXT build                                                             12  0.022414

4 ETW000  [     dev trc,00000]  dbsybslib.dll patch info                                                  17  0.022431

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                       11  0.022442

4 ETW000  [     dev trc,00000]    SAP patchno  213                                                         9  0.022451

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchlevel 0                                           10  0.022461

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchno         213                                    11  0.022472

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchcomment IBM i: Multi-connect to SYBASE IQ (1946327)

4 ETW000                                                                                                  17  0.022489

4 ETW000  [     dev trc,00000]  Fri May 16 02:18:33 2014                                             30001377  30.023866

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4531]

4 ETW000                                                                                                  26  30.023892

4 ETW000  [     dev trc,00000]  (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection

4 ETW000                                                                                                  19  30.023911

4 ETW000  [     dev trc,00000]  syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                          22  30.023933

4 ETW000  [     dev trc,00000]  Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=hnpclecp;port=4901;uid=SAPSR3;db=ECP;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=1;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=30;ProtocolCapture=cap_p21766_comm_rd;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;

4 ETW000                                                                                                 

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 30012  performing CON                              221  30.024200

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>[ASE Error SQL30012:08001]Client unable to establish a connection

4 ETW000                                                                                                  19  30.024219

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

Please assist.

Regards,

Srikanth G

[JPReyes]

Have you checked that port=4901 is open?...

[Former Member]

Hi Srikanth,

As mentioned in trans.log:

4 ETW000  [     dev trc,00000]  Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=hnpclecp;port=4901;uid=SAPSR3;db=ECP;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=1;EnableLOBLocator=0;app=R3 000 00 comm rd

Please check port 4901 from server hnpclecp, also please check password for SAPSR3.

Regards,

Jitendra

[Former Member]

Hi Srikanth,

Which kernel version you are using for this installation? There might be bug with this kernel verson, you can try installation with other kernel version.

Regards,

Jitendra

[Former Member]

Hi Srikanth,

Please run R3trans -x and provide details of trans.log file.

Hopefully this will help to find the cause.

Regards,

Jitendra

[JPReyes]

Read a few threads and this seems to be a common issue.

Try updating the dbsl patch (dbsyblib.so) on the kernel to the latest one.

Regards, Juan

[Former Member]

Hi Juan,

dbsl patch is already the latest one, /sapmnt/SID is mounted but still the same error.

From sybase perspective to accept an connection from a dialog instance do we need to maintain any DB parameters ?

Regards,

Srikanth

[JPReyes]

No, you should install the db client software as per normal and the kernel should have the correct dbsl package... that's about it.

As Jitendra mentioned,post the result of R3trans -d

Regards, JP