Apr 24, 2014 at 03:18 PM

Problem to connect SAP on Sybase

1141 Views

Hi, I have just same symptom as note 1900976:

You are running SAP Applications or Business Suite on SAP Adaptive Server Enterprise. SAP GUI, AS ABAP, or tools like R3trans and tp fail to connect and error messages like to following are written to the dev trace files:

4 ETW000  [     dev trc,00000]  ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 29298]
4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DBPROPERTIES not found. Specify
4 ETW000  [     dev trc,00000]   owner.objectname or use sp_help to check whether the object exists (sp_help may
4 ETW000  [     dev trc,00000]   produce lots of output).

You may see likewise error message referencing tables SVERS, DDNTT, or XXXXT.

When checking with native tools like isql you find that the mentioned tables are present in the database.

My SAP system is down, my version ECC 606 with Sybase ASE 15.7.

On note 1900976, this is solution:

Revoke "sa_role" from database server login SAPSR3.

But, when I check, SAPSR3 is not "sa_role" , just sa user is "sa_role".

I have read following sap notes: 1639578, 1797040, 1643080, but nothing.

I run r3trans -d:

r3trans.log:

4 ETW000 r3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 24.04.2014 - 09:44:27

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

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

4 ETW000 [ dev trc,00000] Thu Apr 24 09:44:28 2014 76 0.000076

4 ETW000 [ dev trc,00000] db_con_init called 49 0.000125

4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000 122 0.000247

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

4 ETW000 33 0.000280

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

4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 44 0.000343

4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, addr 000007FEF0430000

4 ETW000 495 0.000838

4 ETW000 [ dev trc,00000] using "D:\usr\sap\D15\SYS\exe\uc\NTAMD64\dbsybslib.dll" 18 0.000856

4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 19 0.000875

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbsybslib.dll 19 0.000894

4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "720.00", patchlevel (0.521) 393 0.001287

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbsybslib.dll 27 0.001314

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbsybslib.dll 18 0.001332

4 ETW000 [ dev trc,00000] New connection 0 created 28 0.001360

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 34 0.001394

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 19 0.001413

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

4 ETW000 22 0.001435

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 17 0.001452

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 32 0.001484

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 17 0.001501

4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 33 0.001534

4 ETW000 ==> connect info for default DB will be read from ssfs

4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 32 0.001566

4 ETW000 ==> Using default key set to get connect info from ssfs

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 61 0.001627

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

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

4 ETW000 98 0.001782

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "D:\usr\sap\D15\SYS\global\security\rsecssfs\data\SSFS_D15.DAT" opened for read [rsecssfs.c 2539]

4 ETW000 117 0.001899

4 ETW000 [ dev trc,00000] RSecSSFs: Key read from key file "D:\usr\sap\D15\SYS\global\security\rsecssfs\key\SSFS_D15.KEY" [rsecssfs.c 1466]

4 ETW000 95 0.001994

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 940]

4 ETW000 337 0.002331

4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs

4 ETW000 27 0.002358

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 18 0.002376

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 21 0.002397

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

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

4 ETW000 86 0.002509

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "D:\usr\sap\D15\SYS\global\security\rsecssfs\data\SSFS_D15.DAT" opened for read [rsecssfs.c 2539]

4 ETW000 101 0.002610

4 ETW000 [ dev trc,00000] RSecSSFs: Key read from key file "D:\usr\sap\D15\SYS\global\security\rsecssfs\key\SSFS_D15.KEY" [rsecssfs.c 1466]

4 ETW000 73 0.002683

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 940]

4 ETW000 243 0.002926

4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs

4 ETW000 28 0.002954

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 18 0.002972

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 21 0.002993

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

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

4 ETW000 87 0.003105

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "D:\usr\sap\D15\SYS\global\security\rsecssfs\data\SSFS_D15.DAT" opened for read [rsecssfs.c 2539]

4 ETW000 129 0.003234

4 ETW000 [ dev trc,00000] RSecSSFs: Key read from key file "D:\usr\sap\D15\SYS\global\security\rsecssfs\key\SSFS_D15.KEY" [rsecssfs.c 1466]

4 ETW000 85 0.003319

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 101 0.003420

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 66 0.003486

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 32 0.003518

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 18 0.003536

4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 7883 0.011419

4 ETW000 [ dev trc,00000] Thread ID:14180 50 0.011469

4 ETW000 [ dev trc,00000] lib_dbsl 720 11/06/2013 11:15:00 14 0.011483

4 ETW000 [ dev trc,00000] 720_EXT build 11 0.011494

4 ETW000 [ dev trc,00000] Using dynamic link library 'D:\usr\sap\D15\SYS\exe\uc\NTAMD64\dbsybslib.dll'

4 ETW000 21 0.011515

4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 44 0.011559

4 ETW000 [ dev trc,00000] SAP patchlevel 0 13 0.011572

4 ETW000 [ dev trc,00000] SAP patchno 600 11 0.011583

4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 12 0.011595

4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 521 11 0.011606

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

4 ETW000 21 0.011627

4 ETW000 [ dev trc,00000] lpc:(local) connection used on SAPDES2 31 0.011658

4 ETW000 [ dev trc,00000] lpc:(local) connection used on SAPDES2 667678 0.679336

4 ETW000 [ dev trc,00000] spid 30 comm rd ODBC 40574 0.719910

4 ETW000 [ dev trc,00000] spid 12 unc rd ODBC 298 0.720208

4 ETW000 [ dev trc,00000] Thu Apr 24 09:44:29 2014 231651 0.951859

4 ETW000 [ dev trc,00000] Driver: Adaptive Server Enterprise Driver release: 15.7.0.105 28 0.951887

4 ETW000 [ dev trc,00000] Driver full version: Sybase ASE ODBC Driver/15.7.0/ESD#1/P/x86/Windows/drvmain/Build 105/32-bit/Normal/Wed Feb 15 UTC 18:35:16 2012

4 ETW000 42 0.951929

4 ETW000 [ dev trc,00000] dbs/syb/cache_size: 2000 19 0.951948

4 ETW000 [ dev trc,00000] GetServerInfo version: Adaptive Server Enterprise/15.7.0/EBF 19783 SMP Refresh #4/P/X64/Windows Server/aseasapga/2823/64-bit/OPT/Wed Dec 14 16:46:51 2011

4 ETW000 528 0.952476

4 ETW000 [ dev trc,00000] GetServerInfo release: 15.7.0.009 451 0.952927

4 ETW000 [ dev trc,00000] GetServerInfo architecture: x86_64 27 0.952954

4 ETW000 [ dev trc,00000] GetServerInfo edition: P 18 0.952972

4 ETW000 [ dev trc,00000] GetServerInfo byte width: 64 bit 18 0.952990

4 ETW000 [ dev trc,00000] ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 29721]

4 ETW000 56689 1.009679

4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DBPROPERTIES not found. Specify

4 ETW000 36 1.009715

4 ETW000 [ dev trc,00000] owner.objectname or use sp_help to check whether the object exists (sp_help may

4 ETW000 27 1.009742

4 ETW000 [ dev trc,00000] produce lots of output). 18 1.009760

4 ETW000 [ dev trc,00000] DbSlConnect hdl: 0 846 1.010606

4 ETW000 [ dev trc,00000] trace file set 27 1.010633

4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 21 1.010654

4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20241] 83281 1.093935

4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]SVERS not found. Specify owner.

4 ETW000 39 1.093974

4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000 27 1.094001

4 ETW000 [ dev trc,00000] e lots of output). 17 1.094018

4 ETW000 [ dev trc,00000] sql statement is ==> SELECT VERSION FROM SVERS 27 1.094045

4 ETW000 /* R3::0 T:SVERS */

4 ETW000 [ dblink ,00000] ***LOG BZA=>table SVERS does not exist on database 62 1.094107

4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20241] 58923 1.153030

4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.

4 ETW000 40 1.153070

4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000 27 1.153097

4 ETW000 [ dev trc,00000] e lots of output). 18 1.153115

4 ETW000 [ dev trc,00000] sql statement is ==> SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000 /* R3::0 T:DDNTT 35 1.153150

4 ETW000 [ dev trc,00000] */ 31 1.153181

4 ETW000 [ dev trc,00000] NTAB: SELECT COMPCNT, UNICODELG FROM DDNTT WHERE TABNAME = 'SVERS' FAILED

4 ETW000 87 1.153268

4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20241] 1181 1.154449

4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.

4 ETW000 39 1.154488

4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000 27 1.154515

4 ETW000 [ dev trc,00000] e lots of output). 17 1.154532

4 ETW000 [ dev trc,00000] sql statement is ==> SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000 /* R3::0 T:DDNTT */ 35 1.154567

4 ETW000 [ dev trc,00000] */ 15 1.154582

4 ETW000 [ dev trc,00000] NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' FAILED 23 1.154605

4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20241] 1137 1.155742

4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.

4 ETW000 39 1.155781

4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000 27 1.155808

4 ETW000 [ dev trc,00000] e lots of output). 17 1.155825

4 ETW000 [ dev trc,00000] sql statement is ==> SELECT DBASE FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000 /* R3::0 T:DDNTT */ 35 1.155860

4 ETW000 [ dev trc,00000] */ 15 1.155875

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT WHERE TABNAME = 'SVERS' FAILED

4 ETW000 41 1.155916

4 ETW000 [ dbntab ,00000] ***LOG BZY=>unexpected return code 103 calling NTAB 33 1.155949

4 ETW000 [ dev trc,00000] NTAB: db_ntab(): init_ntab failed, returning 2 50 1.155999

4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20241] 1152 1.157151

4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.

4 ETW000 38 1.157189

4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000 27 1.157216

4 ETW000 [ dev trc,00000] e lots of output). 18 1.157234

4 ETW000 [ dev trc,00000] sql statement is ==> SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000 /* R3::0 T:XXXXT 35 1.157269

4 ETW000 [ dev trc,00000] */ 16 1.157285

4 ETW000 [ dev trc,00000] NTAB: SELECT COMPCNT, UNICODELG FROM XXXXT WHERE TABNAME = 'SVERS' FAILED

4 ETW000 30 1.157315

4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20241] 1138 1.158453

4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.

4 ETW000 38 1.158491

4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000 27 1.158518

4 ETW000 [ dev trc,00000] e lots of output). 18 1.158536

4 ETW000 [ dev trc,00000] sql statement is ==> SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000 /* R3::0 T:XXXXT */ 56 1.158592

4 ETW000 [ dev trc,00000] */ 16 1.158608

4 ETW000 [ dev trc,00000] NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' FAILED 22 1.158630

4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20241] 1131 1.159761

4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.

4 ETW000 38 1.159799

4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000 27 1.159826

4 ETW000 [ dev trc,00000] e lots of output). 17 1.159843

4 ETW000 [ dev trc,00000] sql statement is ==> SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000 /* R3::0 T:XXXXT */ 35 1.159878

4 ETW000 [ dev trc,00000] */ 16 1.159894

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM XXXXT WHERE TABNAME = 'SVERS' FAILED

4 ETW000 35 1.159929

4 ETW000 [ dbntab ,00000] ***LOG BZY=>unexpected return code 103 calling NTAB 29 1.159958

4 ETW000 [ dev trc,00000] NTAB: db_ntab(): init_ntab failed, returning 2 25 1.159983

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [ dev trc,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0) 1804 1.161787

Any opinion? ....

Thanks.