Problem to connect SAP on Sybase

[former_member309601]

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.

[ryan_hansen]

Hi Jose,

I haven't worked with the SAP side, but with standalone SDK/ASE.

The error message suggests you have made a connection to the ASE,

but tables were not found when queried.

This looks very similar to Sybase CR# 708904.

This CR is in the buglist for:
SDK 15.7 ESD#5.

Not 100% sure this is your issue, however testing a newer driver could help determine if this is a fixed issue.

Remember you may need to update your ASE MDA scripts when upgrading ODBC drivers.

ASE command to check version:
sp_version

ASE MDA script version needs to be >= ODBC driver.

Regards,
Ryan

[former_member309601]

Hi, I have read this SAP note: 1590719 - SYB: Updates for SAP Adaptive Server Enterprise (SAP ASE)

I am downloading last Sybase updates for SAP, there includes ODBC drivers. With this update I will upgrade my database to 15.7.0.121 (15.7.0 SP121), and I will try again.

But I think that problem is some with database user SAPSR3 and database schema or like this.

Thanks.

[Former Member]

Dear Mr. Araujo,

Since you decided to update SAP ASE to SP121, which contains many fixes, except for the ODBC driver, please also update the DBSL - for example current version on SAP kernel 7.20 is 610.

Before you start, could you please provide us the output of the following query:

use master
go
select CONVERT(VARCHAR(28),object_cinfo) as object_cinfo,
CONVERT(VARCHAR(128),char_value) as char_value,
CONVERT(VARCHAR(128),comments) as comments
from sysattributes where char_value IS NOT NULL AND
char_value not like '$mon%' and class = 23
go

I presume you have also implemented one of the following notes:

SAP Note 1946164 SYB: DDIC patch collection for release 7.02

SAP Note 1965664 SYB: DDIC patch collection for release 7.30

SAP Note 1965754 SYB: DDIC patch collection for release 7.31

SAP Note 1965755 SYB: DDIC patch collection for release 7.40

Another SAP Note which might be of interess for you is 2000203 - SYB: Release information for SAP ASE 15.7.0.121 with SAP
Business Suite.

Kind Regards,

Ionut

[former_member309601]

Hi, I update some days ago my kernel to 600 level. my DBSL is 610 too.

This is sql output:

Reading some notes indicate, I need apply thems by SNOTE transaction, but my SAP Server is down. I can not get up for the problem write here.

Thanks!

[Former Member]

Dear Mr. Araujo,

Considering your current SAP ASE  and kernel SP level, I would recommend the patch.

Regarding your DBSL level, it seems like you have level 521:

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)

Kind Regards,

Ionut

[former_member309601]

Thanks, for clarify, I must download ODBC driver for ASE, because it does not come in database upgrade.

Regards,

Araujo.

[Former Member]

Dear Mr. Araujo,

For detailed upgrade instructions, refer to the following SAP Notes:

1599814  SYB: Installing Service Packs for ASE 15.7 (UNIX +

Linux)

1607816  SYB: Installing Service Packs for ASE 15.7

(Windows)

Kind Regards,

Ionut

[former_member309601]

Dear Ionut, I install all updates on my ASE server just as note: 1607816

My output:

Problem continue, any suggestion? ....

Regards,

Araujo.

[Former Member]

Dear Mr. Araujo,

It looks to me like you updated SAP ASE to SP 61, not SP121.

The software available on SMP for SP121, released on 04/04/2014 is the following:

Sybase ASE 15.7 FOR BUS. SUITE SP121

Sybase ASE 15.7 FOR BUS. SUITE DBCLIENT.SAR SP13_1

According to SAP Note 1590719 - SYB: Updates for SAP Adaptive Server Enterprise (SAP
ASE),:

Versions contained in installation media and  patches
We recommend updating both server and  driver software to versions that were delivered at the same point in time.

Please check SAP Note 1898535 - SYB: SAP Sybase ASE service pack update
compatibility for any SAP ASE update compatibility in the future. Luckly, all SAP Sybase ASE versions 15.7 up to and including SP61 and ASE 15.7 SPs 100, 101, 102, 103, and 110 can directly be updated to ASE 15.7 SP121. Up to SP121, SP50/SP51/SP60/SP61 could not be updated to ASE 15.7 SP1xx.

Kind Regards,

Ionut

[former_member309601]

Hi, I update to SP121, but problem continues.

Here my output:

Any suggestion? ...

Best regards,

OScar.

[madhvi_pai]

Hi Jose,

Can  you please post the DBClient / driver version installed at present on this system? Is it also the latest - SP13_1? Also, I assume DBSL  been updated as well.

Sorry if I missed this piece of information through the notes above..

Thanks,

Madhvi Pai

SAP AGS

[former_member309601]

Hi this es my r3trans -d output:

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   : 28.04.2014 - 18:54:38

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]  Mon Apr 28 18:54:38 2014                                                  70  0.000070

4 ETW000  [     dev trc,00000]  db_con_init called                                                        42  0.000112

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

4 ETW000                                                                                                 118  0.000230

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

4 ETW000                                                                                                  34  0.000264

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dbsybslib.dll' ...                                    45  0.000328

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

4 ETW000                                                                                                 505  0.000833

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

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

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

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

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

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

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  27  0.001338

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                                                                                                  35  0.001373

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

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

4 ETW000                                                                                                  23  0.001416

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

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.001465

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

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

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                   35  0.001562

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                                                                                                  63  0.001625

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

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

4 ETW000                                                                                                  99  0.001776

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                                                                                                 113  0.001889

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                                                                                                  94  0.001983

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

4 ETW000                                                                                                 336  0.002319

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

4 ETW000                                                                                                  28  0.002347

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

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

4 ETW000                                                                                                  21  0.002386

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

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

4 ETW000                                                                                                  88  0.002500

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                                                                                                 103  0.002603

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.002676

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

4 ETW000                                                                                                 244  0.002920

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

4 ETW000                                                                                                  28  0.002948

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

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

4 ETW000                                                                                                  21  0.002987

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

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

4 ETW000                                                                                                  87  0.003099

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                                                                                                 134  0.003233

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.003318

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                                                                                                  99  0.003417

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.003483

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                                                                                                  34  0.003517

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

4 ETW000  [     dev trc,00000]  database is local: connect_timeout: 3                                   7534  0.011069

4 ETW000  [     dev trc,00000]  Thread ID:1036                                                            48  0.011117

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

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

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

4 ETW000                                                                                                  21  0.011163

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

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                       14  0.011221

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

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchlevel 0                                           11  0.011243

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchno         521                                    14  0.011257

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

4 ETW000                                                                                                  19  0.011276

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

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

4 ETW000  [     dev trc,00000]  spid 27 comm rd ODBC                                                   89546  0.333984

4 ETW000  [     dev trc,00000]  spid 28 unc rd ODBC                                                      440  0.334424

4 ETW000  [     dev trc,00000]  Driver: Adaptive Server Enterprise Driver release: 15.7.0.1250           821  0.335245

4 ETW000  [     dev trc,00000]  Driver full version: SAP ASE ODBC Driver/15.7/SP125 PL/P/AMD64/Windows/drvmain/Build 1250/64-bit/Normal/Wed Feb 19 UTC 00:28:47 2014/SQLLEN8

4 ETW000                                                                                                  51  0.335296

4 ETW000  [     dev trc,00000]  Driver uses SQLLEN8                                                       19  0.335315

4 ETW000  [     dev trc,00000]  dbs/syb/cache_size: 2000                                                  18  0.335333

4 ETW000  [     dev trc,00000]  GetServerInfo version: Adaptive Server Enterprise/15.7/EBF 22232 SMP SP121 /P/X64/Windows Server/ase157sp12x/3660/64-bit/OPT/Thu Mar 20 03:16:27 2014

4 ETW000                                                                                                 451  0.335784

4 ETW000  [     dev trc,00000]  GetServerInfo release: 15.7.0.121                                        444  0.336228

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

4 ETW000  [     dev trc,00000]  GetServerInfo edition: P                                                  17  0.336272

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

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

4 ETW000                                                                                                 979  0.337269

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

4 ETW000                                                                                                  37  0.337306

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

4 ETW000                                                                                                  26  0.337332

4 ETW000  [     dev trc,00000]  y produce lots of output).                                                19  0.337351

4 ETW000  [     dev trc,00000]  DbSlConnect hdl: 0                                                       861  0.338212

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

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

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

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

4 ETW000                                                                                                  38  0.340151

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

4 ETW000                                                                                                  27  0.340178

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       18  0.340196

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

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

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

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

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

4 ETW000                                                                                                  26  0.341297

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

4 ETW000                                                                                                  17  0.341314

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       11  0.341325

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

4 ETW000                        /* R3::0 T:DDNTT                                                          29  0.341354

4 ETW000  [     dev trc,00000]   */                                                                       10  0.341364

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

4 ETW000                                                                                                  69  0.341433

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

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

4 ETW000                                                                                                  25  0.342270

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

4 ETW000                                                                                                  17  0.342287

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       12  0.342299

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

4 ETW000                        /* R3::0 T:DDNTT */                                                       21  0.342320

4 ETW000  [     dev trc,00000]   */                                                                       10  0.342330

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

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

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

4 ETW000                                                                                                  25  0.343214

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

4 ETW000                                                                                                  17  0.343231

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       11  0.343242

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

4 ETW000                        /* R3::0 T:DDNTT */                                                       22  0.343264

4 ETW000  [     dev trc,00000]   */                                                                       10  0.343274

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

4 ETW000                                                                                                  29  0.343303

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

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

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

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

4 ETW000                                                                                                  25  0.344209

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

4 ETW000                                                                                                  18  0.344227

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       11  0.344238

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

4 ETW000                        /* R3::0 T:XXXXT                                                          22  0.344260

4 ETW000  [     dev trc,00000]   */                                                                       10  0.344270

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

4 ETW000                                                                                                  21  0.344291

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

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

4 ETW000                                                                                                  25  0.345117

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

4 ETW000                                                                                                  17  0.345134

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       21  0.345155

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

4 ETW000                        /* R3::0 T:XXXXT */                                                       23  0.345178

4 ETW000  [     dev trc,00000]   */                                                                       11  0.345189

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

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

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

4 ETW000                                                                                                  25  0.346168

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

4 ETW000                                                                                                  18  0.346186

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       11  0.346197

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

4 ETW000                        /* R3::0 T:XXXXT */                                                       22  0.346219

4 ETW000  [     dev trc,00000]   */                                                                       10  0.346229

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

4 ETW000                                                                                                  25  0.346254

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

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

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)                   1826  0.348115

My SAP kernel is 600 level.

Thanks!

[Former Member]

Dear Mr. Araujo,

As mentioned before, as best practive I would recommend you to update the database library to latest version, which is 610.

Your current version is :

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

Could you also please give us the output from:

sp_displaylogin SAPSR3

go

Kind Regards,

Ionut

[former_member309601]

Hi Ionut, I update to 610 and get same error.

Here output to sp_displaylogin:

I think problem is with database user or schema, is like sap user on database have not access or rights, but I compare with PRD server and everythings about roles are similar.

r3trans -d:

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   : 29.04.2014 - 22:42:42

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]  Tue Apr 29 22:42:44 2014                                                  75  0.000075

4 ETW000  [     dev trc,00000]  db_con_init called                                                        45  0.000120

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

4 ETW000                                                                                                  96  0.000216

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

4 ETW000                                                                                                  22  0.000238

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dbsybslib.dll' ...                                    33  0.000285

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

4 ETW000                                                                                                 294  0.000579

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

4 ETW000  [     dev trc,00000]  Library 'dbsybslib.dll' loaded                                            13  0.000605

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

4 ETW000  [     dev trc,00000]  Version of 'dbsybslib.dll' is "720.00", patchlevel (0.610)               652  0.001270

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

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

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  24  0.001324

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                                                                                                  23  0.001347

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

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

4 ETW000                                                                                                  15  0.001375

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          10  0.001385

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                                                                                                  21  0.001406

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

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

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                   21  0.001461

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                                                                                                  43  0.001504

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

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

4 ETW000                                                                                                  67  0.001607

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                                                                                                  82  0.001689

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                                                                                                  68  0.001757

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

4 ETW000                                                                                                 218  0.001975

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

4 ETW000                                                                                                  19  0.001994

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    11  0.002005

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

4 ETW000                                                                                                  14  0.002019

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

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

4 ETW000                                                                                                  55  0.002091

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                                                                                                  69  0.002160

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                                                                                                  49  0.002209

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

4 ETW000                                                                                                 156  0.002365

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

4 ETW000                                                                                                  18  0.002383

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    12  0.002395

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

4 ETW000                                                                                                  13  0.002408

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

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

4 ETW000                                                                                                  55  0.002480

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                                                                                                  87  0.002567

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                                                                                                  56  0.002623

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                                                                                                  64  0.002687

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                                                                                                  44  0.002731

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                                                                                                  21  0.002752

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    12  0.002764

4 ETW000  [     dev trc,00000]  database is local: connect_timeout: 3                                   5536  0.008300

4 ETW000  [     dev trc,00000]  Thread ID:4404                                                            77  0.008377

4 ETW000  [     dev trc,00000]  lib_dbsl 720 03/10/2014 13:52:00                                          19  0.008396

4 ETW000  [     dev trc,00000]  720_EXT build                                                             12  0.008408

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

4 ETW000                                                                                                  21  0.008429

4 ETW000  [     dev trc,00000]  dbsybslib.dll patch info                                                  45  0.008474

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

4 ETW000  [     dev trc,00000]    SAP patchno  610                                                        11  0.008498

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchlevel 0                                           11  0.008509

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchno         610                                    14  0.008523

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchcomment SYB: avoid connect retries with unencrypted password (1989405)

4 ETW000                                                                                                  18  0.008541

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

4 ETW000  [     dev trc,00000]  Tue Apr 29 22:42:45 2014                                              931891  0.940473

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

4 ETW000  [     dev trc,00000]  spid 25 comm rd ODBC                                                  187758  1.128251

4 ETW000  [     dev trc,00000]  spid 27 unc rd ODBC                                                      301  1.128552

4 ETW000  [     dev trc,00000]  Driver: Adaptive Server Enterprise Driver release: 15.7.0.1250           579  1.129131

4 ETW000  [     dev trc,00000]  Driver full version: SAP ASE ODBC Driver/15.7/SP125 PL/P/AMD64/Windows/drvmain/Build 1250/64-bit/Normal/Wed Feb 19 UTC 00:28:47 2014/SQLLEN8

4 ETW000                                                                                                  32  1.129163

4 ETW000  [     dev trc,00000]  Driver uses SQLLEN8                                                       13  1.129176

4 ETW000  [     dev trc,00000]  dbs/syb/cache_size: 2000                                                  22  1.129198

4 ETW000  [     dev trc,00000]  GetServerInfo version: Adaptive Server Enterprise/15.7/EBF 22232 SMP SP121 /P/X64/Windows Server/ase157sp12x/3660/64-bit/OPT/Thu Mar 20 03:16:27 2014

4 ETW000                                                                                                 310  1.129508

4 ETW000  [     dev trc,00000]  GetServerInfo release: 15.7.0.121                                        310  1.129818

4 ETW000  [     dev trc,00000]  GetServerInfo architecture: x86_64                                        17  1.129835

4 ETW000  [     dev trc,00000]  GetServerInfo edition: P                                                  12  1.129847

4 ETW000  [     dev trc,00000]  GetServerInfo byte width: 64 bit                                          11  1.129858

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

4 ETW000                                                                                                 677  1.130535

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

4 ETW000                                                                                                  33  1.130568

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

4 ETW000                                                                                                  18  1.130586

4 ETW000  [     dev trc,00000]  y produce lots of output).                                                12  1.130598

4 ETW000  [     dev trc,00000]  DbSlConnect hdl: 0                                                       596  1.131194

4 ETW000  [     dev trc,00000]  trace file set                                                            19  1.131213

4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)                                       13  1.131226

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20274]                1376  1.132602

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

4 ETW000                                                                                                  25  1.132627

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

4 ETW000                                                                                                  18  1.132645

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       11  1.132656

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

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

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

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20274]              116160  1.248871

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

4 ETW000                                                                                                  34  1.248905

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

4 ETW000                                                                                                  22  1.248927

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       12  1.248939

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

4 ETW000                        /* R3::0 T:DDNTT                                                          31  1.248970

4 ETW000  [     dev trc,00000]   */                                                                       56  1.249026

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

4 ETW000                                                                                                  28  1.249054

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20274]                 898  1.249952

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

4 ETW000                                                                                                  25  1.249977

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

4 ETW000                                                                                                  17  1.249994

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       12  1.250006

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

4 ETW000                        /* R3::0 T:DDNTT */                                                       22  1.250028

4 ETW000  [     dev trc,00000]   */                                                                       10  1.250038

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

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20274]                 784  1.250838

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

4 ETW000                                                                                                  25  1.250863

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

4 ETW000                                                                                                  17  1.250880

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       11  1.250891

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

4 ETW000                        /* R3::0 T:DDNTT */                                                       22  1.250913

4 ETW000  [     dev trc,00000]   */                                                                       10  1.250923

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

4 ETW000                                                                                                  29  1.250952

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

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

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20274]                 820  1.251834

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

4 ETW000                                                                                                  24  1.251858

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

4 ETW000                                                                                                  18  1.251876

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       11  1.251887

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

4 ETW000                        /* R3::0 T:XXXXT                                                          23  1.251910

4 ETW000  [     dev trc,00000]   */                                                                       10  1.251920

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

4 ETW000                                                                                                  23  1.251943

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20274]                 786  1.252729

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

4 ETW000                                                                                                  25  1.252754

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

4 ETW000                                                                                                  17  1.252771

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       21  1.252792

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

4 ETW000                        /* R3::0 T:XXXXT */                                                       24  1.252816

4 ETW000  [     dev trc,00000]   */                                                                       10  1.252826

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

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20274]                 805  1.253646

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

4 ETW000                                                                                                  25  1.253671

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

4 ETW000                                                                                                  17  1.253688

4 ETW000  [     dev trc,00000]  ce lots of output).                                                       11  1.253699

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

4 ETW000                        /* R3::0 T:XXXXT */                                                       22  1.253721

4 ETW000  [     dev trc,00000]   */                                                                       10  1.253731

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

4 ETW000                                                                                                  25  1.253756

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

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

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)                   2007  1.255798

Thanks!

[Former Member]

Dear Mr. Araujo,

Please assign mon_role role as default for SAPSR3 user using sapsso login or any other login that has sso_role role:

alter login SAPSR3 add auto activated roles mon_role

go

Kind Regards,

Ionut

[former_member309601]

Hi, I put mon_role and error continue.

Thanks!

[Former Member]

Dear Mr. Araujo,

My guess is that there is something related to the active roles assigned to sap_mon and sap_adm roles, but I believe it would be better for you to open an incident towards SAP in order to have this fixed faster.

I can see you have the right ODBC, library now, so everything should be okay, as I was able to check on another system also.

One question, just to be sure: did you restarted the SAP system, both database and R3 after you revoked sa_role?

Kind Regards,

Ionut

[former_member309601]

Hi, yes I restart SAP system and database, and problem continues.I will open a ticket SAP.

Thank you very much!

[Former Member]

Hi again,

Please keep this discussion updated if possible, I am curious what was the cause in your case.

I was not able to replicate it while having latest SP, ODBC and dbsybslib.

Kind Regards,

Ionut

[sivakumar_kilari3]

Hi ,

Database is up and running?

Did you set environmental variables with sidadm user?

Did you upgrade dbsl patch?

Thanks

siva

[Former Member]

Dear Mr. Araujo,

Please read the following SAP Note:

1706410 - SYB: Security - Changing passwords for database users

My guess is that someone changed the password or DEFAULT_DB_USER in ABAP Secure Storage, directly or while adding another dialog instance to your SAP system. Please focus on step 5 of the SAP Note.

Kind Regards,

Ionut