on 06-03-2013 6:07 AM
Hi All,
I am facing error while upgrading erp 6.0 ehp6 ,R3trans-d RC=12
Below is the r3trans log
4 ETW000 r3trans version 6.22 (release 720 - 09.02.12 - 18:31:00 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 03.06.2013 - 10:35:48
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 Jun 03 10:35:48 2013 87 0.000087
4 ETW000 [ dev trc,00000] db_con_init called 42 0.000129
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 68 0.000197
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 38 0.000235
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 21 0.000256
4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 56 0.000312
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, addr 000007FEEE1D0000
4 ETW000 785 0.001097
4 ETW000 [ dev trc,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll" 27 0.001124
4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 27 0.001151
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbsybslib.dll 28 0.001179
4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "720.00", patchlevel (0.210) 57752 0.058931
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbsybslib.dll 55 0.058986
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbsybslib.dll 28 0.059014
4 ETW000 [ dev trc,00000] New connection 0 created 31 0.059045
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 58 0.059103
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 25 0.059128
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 35 0.059163
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 23 0.059186
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 50 0.059236
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 23 0.059259
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol 44 0.059303
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2
4 ETW000 47 0.059350
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 850] 51 0.059401
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3965]
4 ETW000 215 0.059616
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2351]
4 ETW000 1156 0.060772
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1271]
4 ETW000 728 0.061500
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 911]
4 ETW000 934 0.062434
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 46 0.062480
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 850] 32 0.062512
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3965]
4 ETW000 116 0.062628
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2351]
4 ETW000 1291 0.063919
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1271]
4 ETW000 684 0.064603
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 911]
4 ETW000 859 0.065462
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 45 0.065507
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 850] 32 0.065539
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3965]
4 ETW000 115 0.065654
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2351]
4 ETW000 1312 0.066966
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1271]
4 ETW000 682 0.067648
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2373]
4 ETW000 219 0.067867
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 911]
4 ETW000 539 0.068406
4 ETW000 [ dev trc,00000] read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage
4 ETW000 55 0.068461
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 23 0.068484
4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 6053 0.074537
4 ETW000 [ dev trc,00000] Thread ID:17684 49 0.074586
4 ETW000 [ dev trc,00000] lib_dbsl 720_REL 02/23/2012 10:32:00 29 0.074615
4 ETW000 [ dev trc,00000] Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll'
4 ETW000 50 0.074665
4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 64 0.074729
4 ETW000 [ dev trc,00000] SAP patchlevel 0 28 0.074757
4 ETW000 [ dev trc,00000] SAP patchno 210 23 0.074780
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 25 0.074805
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 210 25 0.074830
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment Sybase ASE R3load fastload is failing (1688468)
4 ETW000 42 0.074872
4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 46 0.074918
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3081]
4 ETW000 20462 0.095380
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 54 0.095434
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 49 0.095483
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3081]
4 ETW000 15520 0.111003
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 47 0.111050
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 30 0.111080
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=KBINDEV01;port=4901;uid=SAPSR3;db=DEV;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=ServerDefault;EncryptPassword=2;EnableLOBLocator=0;app=R3 00 comm rd ODBC;logintimeout=3;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
4 ETW000 89 0.111169
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 30012 performing CON 231 0.111400
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL30012:08001]Client unable to establish a connection[ASE Error SQL30012:08001]Client unable to establish a connection
4 ETW000 67 0.111467
2EETW169 no connect possible: "DBMS = SYBASE --- "
Hi
Source : http://scn.sap.com/thread/3328183
I resolve my problem by restart the installation and stop it in the first step.
I chenged the dbsyblib.so to the most recent, changed the number off parallel jobs and the default memory in the summary.html and import_monitor_cmd.properties.
I restarted the installation and the installation has complete without error.
Best Regards
Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Leonor,
Thanks for your response
Please suggest me dbsyblib latest version i have copied in SUM folder already,I need copy usr/sap/sid/sys/exe as well.
where can we get the summary.html and import_monitor_cmd .properties
can you please tell me the how much values I ned to put its very help full for me .
Thanks
Hi
do you have version 430 ?
yes in the kernel directory,
this will be in the upgrade log directoy, in windows it should be
source : http://wiki.sdn.sap.com/wiki/display/MaxDB/Heterogeneous+system+copy
c:\program files\sapinst_instdir (Windows)
have a look in the active log running for the upgrade it will show you where the log files are being kept
best regards
Marius
Hi,
Yes same dbsl file I am having now i have copied all dbsl files to usr/sap/sid sys/exe and started the installation ,I am running SUM tool to upgrade ,Please suggest on below
Now I am afcing r3 trans -d
4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 93 0.072816
4 ETW000 [ dev trc,00000] SAP patchlevel 0 27 0.072843
4 ETW000 [ dev trc,00000] SAP patchno 430 24 0.072867
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 24 0.072891
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 430 29 0.072920
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: Short dump - SAPSQL_ARRAY_INSERT_DUPREC (1861476)
4 ETW000 43 0.072963
4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 60 0.073023
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 95556 0.168579
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 67 0.168646
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 41 0.168687
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 4919 0.173606
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 50 0.173656
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 32 0.173688
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=KBINDEV01;port=4901;uid=SAPSR3;db=DEV;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=2;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
4 ETW000 88 0.173776
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 30012 performing CON 312 0.174088
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL30012:08001]Client unable to establish a connection[ASE Error SQL30012:08001]Client unable to establish a connection
4 ETW000 70 0.174158
2EETW169 no connect possible: "DBMS = SYBASE --- "
Hi,
did you check the network and also did you try and connect to the ip ?
http://nntp-archive.sybase.com/nntp-archive/action/article/%3C4c13f18e@forums-1-dub%3E
Best Regards
Marius
Hi ,
I am able to ping the server ,
Below is the sql.ini entries ,I need to add any thing and need to put env variables
[DEV_XP]
master=NLWNSCK,KBINDEV01,4904
query=NLWNSCK,KBINDEV01,4904
[DEV]
master=NLWNSCK,KBINDEV01,4901
query=NLWNSCK,KBINDEV01,4901
[DEV_BS]
master=NLWNSCK,KBINDEV01,4902
query=NLWNSCK,KBINDEV01,4902
[DEV_JSAGENT]
master=NLWNSCK,KBINDEV01,4903
query=NLWNSCK,KBINDEV01,4903
Hi,
Your sap cannot start because the secure store is not defined.
You must set the environtment variable and define the secure storage with the password of schema user sapsr3 :
0.060772
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1271]
4 ETW000 728 0.061500
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 911]
4 ETW000 934 0.062434
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 46 0.062480
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 850] 32 0.062512
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3965]
4 ETW000 116 0.062628
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2351]
4 ETW000 1291 0.063919
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1271]
4 ETW000 684 0.064603
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 911]
4 ETW000 859 0.065462
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 45 0.065507
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 850] 32 0.065539
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3965]
4 ETW000
Please apply the following sap notes:
Note 1797040 - Sybase ASE: saphostctrl/sapdbctrl - Using secure storage
Note 1643080 - SYB: Database connect information for Sybase ASE
Hope this help you
Cheers
Please apply the following sap notes:
Note 1797040 - Sybase ASE: saphostctrl/sapdbctrl - Using secure storage
Note 1643080 - SYB: Database connect information for Sybase ASE
Hope this help you
Cheers
Please apply sap note Note 1639578 - SSFS as password storage for primary database connect
Proceed as follows:
If required, also use:
rsecssfx put DB_CONNECT/DEFAULT_DB_CON_ENV <con_env> -plain
Hi sagar,,
Please check the below I have run the comands still same issue
C:\Users\devadm>rsecssfx put DB_CONNECT/DEFAULT_DB_USER sa
C:\Users\devadm>rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD Welcome12345
C:\Users\devadm>r3trans -d
This is r3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).
unicode enabled version
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
2EETW169 no connect possible: "DBMS = SYBASE --- "
r3trans finished (0012).
C:\Users\devadm>r3trans -d
This is r3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).
unicode enabled version
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
2EETW169 no connect possible: "DBMS = SYBASE --- "
r3trans finished (0012).
Hi Sagar ,
After running comands
C:\Users\devadm>rsecssfx put DB_CONNECT/DEFAULT_DB_USER sa
C:\Users\devadm>rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD Welcome12345
4 ETW000 r3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 03.06.2013 - 14:37:35
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 Jun 03 14:37:35 2013 91 0.000091
4 ETW000 [ dev trc,00000] db_con_init called 41 0.000132
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 68 0.000200
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 37 0.000237
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 26 0.000263
4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 55 0.000318
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, addr 000007FEF1230000
4 ETW000 846 0.001164
4 ETW000 [ dev trc,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll" 24 0.001188
4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 26 0.001214
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbsybslib.dll 30 0.001244
4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "720.00", patchlevel (0.430) 467 0.001711
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbsybslib.dll 36 0.001747
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbsybslib.dll 26 0.001773
4 ETW000 [ dev trc,00000] New connection 0 created 35 0.001808
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 55 0.001863
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 24 0.001887
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 37 0.001924
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 23 0.001947
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 50 0.001997
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 24 0.002021
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 45 0.002066
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 48 0.002114
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 107 0.002221
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 63 0.002284
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 126 0.002410
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 1026 0.003436
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 534 0.003970
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 1100 0.005070
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 44 0.005114
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 24 0.005138
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 35 0.005173
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 33 0.005206
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 120 0.005326
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 897 0.006223
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 511 0.006734
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 800 0.007534
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 42 0.007576
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 24 0.007600
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 35 0.007635
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 33 0.007668
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 118 0.007786
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 884 0.008670
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 508 0.009178
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]
4 ETW000 302 0.009480
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 919]
4 ETW000 431 0.009911
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 53 0.009964
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 24 0.009988
4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 145230 0.155218
4 ETW000 [ dev trc,00000] Thread ID:4228 57 0.155275
4 ETW000 [ dev trc,00000] lib_dbsl 720 05/22/2013 09:05:00 32 0.155307
4 ETW000 [ dev trc,00000] 720_EXT build 23 0.155330
4 ETW000 [ dev trc,00000] Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll'
4 ETW000 53 0.155383
4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 89 0.155472
4 ETW000 [ dev trc,00000] SAP patchlevel 0 27 0.155499
4 ETW000 [ dev trc,00000] SAP patchno 430 23 0.155522
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 28 0.155550
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 430 29 0.155579
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: Short dump - SAPSQL_ARRAY_INSERT_DUPREC (1861476)
4 ETW000 88 0.155667
4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 62 0.155729
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 83655 0.239384
4 ETW000 [ dev trc,00000] (4002) [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Login failed.
4 ETW000 51 0.239435
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 26202 0.265637
4 ETW000 [ dev trc,00000] (4002) [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Login failed.
4 ETW000 50 0.265687
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=KBINDEV01;port=4901;uid=Welcome12345;db=DEV;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=2;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
4 ETW000 101 0.265788
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 4002 performing CON 303 0.266091
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL4002]Login failed. 43 0.266134
4 ETW000 [ASE Error SQL4002]Login failed.
2EETW169 no connect possible: "DBMS = SYBASE --- "
Hi,
Can you check if the password is correct ?
4 ETW000 [ dev trc,00000] (4002) [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Login failed.
4 ETW000 50 0.265687
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=KBINDEV01;port=4901;uid=Welcome12345;db=DEV;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=2;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
Try to connect to sapsa to your database:
isql -Usapsa -SSID -w2000
Cheers
Cheers,
Hi Now I am bale to login
R3trans -d
4 ETW000 r3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 03.06.2013 - 15:19:21
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 Jun 03 15:19:22 2013 90 0.000090
4 ETW000 [ dev trc,00000] db_con_init called 44 0.000134
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 67 0.000201
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 38 0.000239
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 26 0.000265
4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 56 0.000321
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, addr 000007FEF1230000
4 ETW000 876 0.001197
4 ETW000 [ dev trc,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll" 26 0.001223
4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 27 0.001250
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbsybslib.dll 30 0.001280
4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "720.00", patchlevel (0.430) 474 0.001754
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbsybslib.dll 37 0.001791
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbsybslib.dll 26 0.001817
4 ETW000 [ dev trc,00000] New connection 0 created 39 0.001856
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 58 0.001914
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 28 0.001942
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 36 0.001978
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 22 0.002000
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 51 0.002051
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 24 0.002075
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 45 0.002120
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 49 0.002169
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 115 0.002284
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 66 0.002350
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 125 0.002475
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 1037 0.003512
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 540 0.004052
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 1149 0.005201
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 44 0.005245
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 24 0.005269
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 36 0.005305
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 33 0.005338
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 119 0.005457
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 896 0.006353
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 512 0.006865
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 912 0.007777
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 43 0.007820
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 24 0.007844
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 35 0.007879
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 33 0.007912
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 118 0.008030
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 886 0.008916
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 511 0.009427
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]
4 ETW000 361 0.009788
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 919]
4 ETW000 432 0.010220
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 53 0.010273
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 25 0.010298
4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 133352 0.143650
4 ETW000 [ dev trc,00000] Thread ID:5356 56 0.143706
4 ETW000 [ dev trc,00000] lib_dbsl 720 05/22/2013 09:05:00 32 0.143738
4 ETW000 [ dev trc,00000] 720_EXT build 25 0.143763
4 ETW000 [ dev trc,00000] Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll'
4 ETW000 52 0.143815
4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 89 0.143904
4 ETW000 [ dev trc,00000] SAP patchlevel 0 26 0.143930
4 ETW000 [ dev trc,00000] SAP patchno 430 23 0.143953
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 28 0.143981
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 430 29 0.144010
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: Short dump - SAPSQL_ARRAY_INSERT_DUPREC (1861476)
4 ETW000 44 0.144054
4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 58 0.144112
4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 365402 0.509514
4 ETW000 [ dev trc,00000] spid 84 comm rd ODBC 70818 0.580332
4 ETW000 [ dev trc,00000] spid 85 unc rd ODBC 827 0.581159
4 ETW000 [ dev trc,00000] Driver: Adaptive Server Enterprise Driver release: 15.7.0.105 91739 0.672898
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 94 0.672992
4 ETW000 [ dev trc,00000] GetServerInfo version: Adaptive Server Enterprise/15.7.0/EBF 20076 SMP ESD#01 Refresh#1/P/X64/Windows Server/aseasap/2926/64-bit/OPT/Thu May 24 01:24:50 2012
4 ETW000 3585 0.676577
4 ETW000 [ dev trc,00000] GetServerInfo release: 15.7.0.012 696 0.677273
4 ETW000 [ dev trc,00000] GetServerInfo architecture: x86_64 46 0.677319
4 ETW000 [ dev trc,00000] GetServerInfo edition: P 25 0.677344
4 ETW000 [ dev trc,00000] GetServerInfo byte width: 64 bit 25 0.677369
4 ETW000 [ dev trc,00000] ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 29662]
4 ETW000 47057 0.724426
4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DBPROPERTIES not found. Specify
4 ETW000 54 0.724480
4 ETW000 [ dev trc,00000] owner.objectname or use sp_help to check whether the object exists (sp_help may
4 ETW000 42 0.724522
4 ETW000 [ dev trc,00000] produce lots of output). 24 0.724546
4 ETW000 [ dev trc,00000] DbSlConnect hdl: 0 1532 0.726078
4 ETW000 [ dev trc,00000] trace file set 44 0.726122
4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 28 0.726150
4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20185] 32293 0.758443
4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]SVERS not found. Specify owner.
4 ETW000 75 0.758518
4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc
4 ETW000 43 0.758561
4 ETW000 [ dev trc,00000] e lots of output). 23 0.758584
4 ETW000 [ dev trc,00000] sql statement is ==> SELECT VERSION FROM SVERS 36 0.758620
4 ETW000 /* R3::0 T:SVERS */
4 ETW000 [ dblink ,00000] ***LOG BZA=>table SVERS does not exist on database 75 0.758695
4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20185] 40687 0.799382
4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.
4 ETW000 74 0.799456
4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc
4 ETW000 43 0.799499
4 ETW000 [ dev trc,00000] e lots of output). 24 0.799523
4 ETW000 [ dev trc,00000] sql statement is ==> SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS'
4 ETW000 /* R3::0 T:DDNTT 53 0.799576
4 ETW000 [ dev trc,00000] */ 47 0.799623
4 ETW000 [ dev trc,00000] NTAB: SELECT COMPCNT, UNICODELG FROM DDNTT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 46 0.799669
4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20185] 1791 0.801460
4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.
4 ETW000 69 0.801529
4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc
4 ETW000 42 0.801571
4 ETW000 [ dev trc,00000] e lots of output). 23 0.801594
4 ETW000 [ dev trc,00000] sql statement is ==> SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS'
4 ETW000 /* R3::0 T:DDNTT */ 51 0.801645
4 ETW000 [ dev trc,00000] */ 22 0.801667
4 ETW000 [ dev trc,00000] NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' FAILED 28 0.801695
4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20185] 1684 0.803379
4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.
4 ETW000 66 0.803445
4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc
4 ETW000 41 0.803486
4 ETW000 [ dev trc,00000] e lots of output). 22 0.803508
4 ETW000 [ dev trc,00000] sql statement is ==> SELECT DBASE FROM "DDNTT" WHERE TABNAME = 'SVERS'
4 ETW000 /* R3::0 T:DDNTT */ 52 0.803560
4 ETW000 [ dev trc,00000] */ 22 0.803582
4 ETW000 [ dbntab.c,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 96 0.803678
4 ETW000 [ dbntab ,00000] ***LOG BZY=>unexpected return code 103 calling NTAB 39 0.803717
4 ETW000 [ dev trc,00000] NTAB: db_ntab(): init_ntab failed, returning 2 70 0.803787
4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20185] 1714 0.805501
4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.
4 ETW000 63 0.805564
4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc
4 ETW000 41 0.805605
4 ETW000 [ dev trc,00000] e lots of output). 23 0.805628
4 ETW000 [ dev trc,00000] sql statement is ==> SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS'
4 ETW000 /* R3::0 T:XXXXT 52 0.805680
4 ETW000 [ dev trc,00000] */ 21 0.805701
4 ETW000 [ dev trc,00000] NTAB: SELECT COMPCNT, UNICODELG FROM XXXXT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 42 0.805743
4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20185] 1666 0.807409
4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.
4 ETW000 67 0.807476
4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc
4 ETW000 42 0.807518
4 ETW000 [ dev trc,00000] e lots of output). 22 0.807540
4 ETW000 [ dev trc,00000] sql statement is ==> SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS'
4 ETW000 /* R3::0 T:XXXXT */ 63 0.807603
4 ETW000 [ dev trc,00000] */ 22 0.807625
4 ETW000 [ dev trc,00000] NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' FAILED 29 0.807654
4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 20185] 1666 0.809320
4 ETW000 [ dev trc,00000] (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.
4 ETW000 64 0.809384
4 ETW000 [ dev trc,00000] objectname or use sp_help to check whether the object exists (sp_help may produc
4 ETW000 41 0.809425
4 ETW000 [ dev trc,00000] e lots of output). 23 0.809448
4 ETW000 [ dev trc,00000] sql statement is ==> SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS'
4 ETW000 /* R3::0 T:XXXXT */ 51 0.809499
4 ETW000 [ dev trc,00000] */ 21 0.809520
4 ETW000 [ dbntab.c,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM XXXXT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 55 0.809575
4 ETW000 [ dbntab ,00000] ***LOG BZY=>unexpected return code 103 calling NTAB 37 0.809612
4 ETW000 [ dev trc,00000] NTAB: db_ntab(): init_ntab failed, returning 2 36 0.809648
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) 3674 0.813322
Hi,
You must check
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 511 0.009427
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]
SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' FAILED
Cheers
Hello,
Check if you have the right configuration as per note 1643080:
Regards,
Eduardo Rezende
HI All,
I have maintained the rsdb_ssfs_connect with value 1 and Mainatine below process rebooted the server R3trans result 000 and I am able to login through GUI as well,fter that again I started SUM tool it configuration phase support pack inclusion again databse down and r3trans -0012
Proceed as follows:
R3trans LOg:
4 ETW000 r3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 03.06.2013 - 21:10:30
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 Jun 03 21:10:30 2013 122 0.000122
4 ETW000 [ dev trc,00000] db_con_init called 64 0.000186
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 88 0.000274
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 52 0.000326
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 33 0.000359
4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 64 0.000423
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, addr 000007FEEE070000
4 ETW000 1113 0.001536
4 ETW000 [ dev trc,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll" 38 0.001574
4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 35 0.001609
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbsybslib.dll 39 0.001648
4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "720.00", patchlevel (0.430) 494 0.002142
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbsybslib.dll 48 0.002190
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbsybslib.dll 34 0.002224
4 ETW000 [ dev trc,00000] New connection 0 created 43 0.002267
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 71 0.002338
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 36 0.002374
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 50 0.002424
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 30 0.002454
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 64 0.002518
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 31 0.002549
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 52 0.002601
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 62 0.002663
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 123 0.002786
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 71 0.002857
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 142 0.002999
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 248 0.003247
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" empty; using default key [rsecssfs.c 1289]
4 ETW000 181 0.003428
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 933 0.004361
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 57 0.004418
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 31 0.004449
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 49 0.004498
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 40 0.004538
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 131 0.004669
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 210 0.004879
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" empty; using default key [rsecssfs.c 1289]
4 ETW000 160 0.005039
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 662 0.005701
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 56 0.005757
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 30 0.005787
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 49 0.005836
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 39 0.005875
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 130 0.006005
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 207 0.006212
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" empty; using default key [rsecssfs.c 1289]
4 ETW000 162 0.006374
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]
4 ETW000 419 0.006793
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 919]
4 ETW000 131 0.006924
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 66 0.006990
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 30 0.007020
4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 16623 0.023643
4 ETW000 [ dev trc,00000] Thread ID:6548 65 0.023708
4 ETW000 [ dev trc,00000] lib_dbsl 720 05/22/2013 09:05:00 40 0.023748
4 ETW000 [ dev trc,00000] 720_EXT build 32 0.023780
4 ETW000 [ dev trc,00000] Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll'
4 ETW000 66 0.023846
4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 93 0.023939
4 ETW000 [ dev trc,00000] SAP patchlevel 0 38 0.023977
4 ETW000 [ dev trc,00000] SAP patchno 430 30 0.024007
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 34 0.024041
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 430 37 0.024078
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: Short dump - SAPSQL_ARRAY_INSERT_DUPREC (1861476)
4 ETW000 57 0.024135
4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 67 0.024202
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 54594 0.078796
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 67 0.078863
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 47 0.078910
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 15931 0.094841
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 64 0.094905
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 44 0.094949
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=KBINDEV01;port=4901;uid=SAPSR3;db=DEV;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=2;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
4 ETW000 111 0.095060
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 30012 performing CON 321 0.095381
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL30012:08001]Client unable to establish a connection[ASE Error SQL30012:08001]Client unable to establish a connection
4 ETW000 84 0.095465
2EETW169 no connect possible: "DBMS = SYBASE --- "
Hi Eduardo,
Thanks for u r prompt response
All the ENV varibales are set Now I am facing below issue in r3trans
4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 93 0.023939
4 ETW000 [ dev trc,00000] SAP patchlevel 0 38 0.023977
4 ETW000 [ dev trc,00000] SAP patchno 430 30 0.024007
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 34 0.024041
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 430 37 0.024078
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: Short dump - SAPSQL_ARRAY_INSERT_DUPREC (1861476)
4 ETW000 57 0.024135
4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 67 0.024202
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 54594 0.078796
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 67 0.078863
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 47 0.078910
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 15931 0.094841
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 64 0.094905
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 44 0.094949
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=KBINDEV01;port=4901;uid=SAPSR3;db=DEV;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=2;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
4 ETW000 111 0.095060
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 30012 performing CON 321 0.095381
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL30012:08001]Client unable to establish a connection[ASE Error SQL30012:08001]Client unable to establish a connection
4 ETW000 84 0.095465
2EETW169 no connect possible: "DBMS = SYBASE --- "
Hi,
Checking above:
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
As per note 1711269:
Reason and Prerequisites
You require at least:
- database version Sybase ASE 15.7.0.009
- SAP Kernel pl 210
- lib_dbsl pl 210
- ODBC Driver Version 15.7.0.107
to be able to use the Software Update Manager (SUM).
Regards,
Eduardo
Hi ,
I have laredy update the dbsyl,tp,r3trans ,how can we check odbc driver version ?
PLease find the latest below Trans .log
4 ETW000 r3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 03.06.2013 - 21:10:30
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 Jun 03 21:10:30 2013 122 0.000122
4 ETW000 [ dev trc,00000] db_con_init called 64 0.000186
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 88 0.000274
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 52 0.000326
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 33 0.000359
4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 64 0.000423
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, addr 000007FEEE070000
4 ETW000 1113 0.001536
4 ETW000 [ dev trc,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll" 38 0.001574
4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 35 0.001609
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbsybslib.dll 39 0.001648
4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "720.00", patchlevel (0.430) 494 0.002142
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbsybslib.dll 48 0.002190
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbsybslib.dll 34 0.002224
4 ETW000 [ dev trc,00000] New connection 0 created 43 0.002267
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 71 0.002338
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 36 0.002374
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 50 0.002424
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 30 0.002454
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 64 0.002518
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 31 0.002549
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 52 0.002601
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 62 0.002663
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 123 0.002786
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 71 0.002857
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 142 0.002999
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 248 0.003247
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" empty; using default key [rsecssfs.c 1289]
4 ETW000 181 0.003428
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 933 0.004361
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 57 0.004418
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 31 0.004449
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 49 0.004498
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 40 0.004538
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 131 0.004669
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 210 0.004879
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" empty; using default key [rsecssfs.c 1289]
4 ETW000 160 0.005039
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 662 0.005701
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 56 0.005757
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 30 0.005787
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 49 0.005836
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 39 0.005875
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 130 0.006005
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 207 0.006212
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" empty; using default key [rsecssfs.c 1289]
4 ETW000 162 0.006374
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]
4 ETW000 419 0.006793
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 919]
4 ETW000 131 0.006924
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 66 0.006990
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 30 0.007020
4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 16623 0.023643
4 ETW000 [ dev trc,00000] Thread ID:6548 65 0.023708
4 ETW000 [ dev trc,00000] lib_dbsl 720 05/22/2013 09:05:00 40 0.023748
4 ETW000 [ dev trc,00000] 720_EXT build 32 0.023780
4 ETW000 [ dev trc,00000] Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll'
4 ETW000 66 0.023846
4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 93 0.023939
4 ETW000 [ dev trc,00000] SAP patchlevel 0 38 0.023977
4 ETW000 [ dev trc,00000] SAP patchno 430 30 0.024007
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 34 0.024041
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 430 37 0.024078
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: Short dump - SAPSQL_ARRAY_INSERT_DUPREC (1861476)
4 ETW000 57 0.024135
4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 67 0.024202
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 54594 0.078796
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 67 0.078863
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 47 0.078910
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 15931 0.094841
4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection
4 ETW000 64 0.094905
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 44 0.094949
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=KBINDEV01;port=4901;uid=SAPSR3;db=DEV;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=2;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
4 ETW000 111 0.095060
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 30012 performing CON 321 0.095381
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL30012:08001]Client unable to establish a connection[ASE Error SQL30012:08001]Client unable to establish a connection
4 ETW000 84 0.095465
2EETW169 no connect possible: "DBMS = SYBASE --- "
Check the version that you need:
Note 1590719 - SYB: Updates for SAP Sybase ASE
Hope this help you
Cheers
Hi,
You can check it in the workprocess log file:
e.g.
dev_w0
C Driver: Adaptive Server Enterprise (ANSI) Driver release: 15.7.0.506
C Driver full version: Sybase ASE ODBC Driver/15.7.0/ESD#5 N-OFF/P/x86_64/Linux/drv157esd5/Build 506/64-bit/Normal/Mon Mar 11 UTC 19:55:20 2013/SQLLEN8
Regards,
Eduardo
Hi Sagar,
I have updated the ODBC as well,still I am facing the issue
My doubt is SUM tool is doing some thing wrong can i use to upgrade through SAINT at this time ,system is ERP6.0 EHP6 ready system and we are upgrading other components
Please suggest
Trans.log:
4 ETW000 r3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 04.06.2013 - 11:03:10
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 Jun 04 11:03:10 2013 88 0.000088
4 ETW000 [ dev trc,00000] db_con_init called 41 0.000129
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 69 0.000198
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 40 0.000238
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 26 0.000264
4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 55 0.000319
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, addr 000007FEECFF0000
4 ETW000 876 0.001195
4 ETW000 [ dev trc,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll" 25 0.001220
4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 28 0.001248
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbsybslib.dll 31 0.001279
4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "720.00", patchlevel (0.430) 472 0.001751
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbsybslib.dll 37 0.001788
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbsybslib.dll 27 0.001815
4 ETW000 [ dev trc,00000] New connection 0 created 36 0.001851
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 58 0.001909
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 26 0.001935
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 37 0.001972
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 23 0.001995
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 52 0.002047
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 24 0.002071
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 45 0.002116
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 49 0.002165
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 114 0.002279
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 68 0.002347
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 124 0.002471
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 222 0.002693
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" empty; using default key [rsecssfs.c 1289]
4 ETW000 163 0.002856
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 819 0.003675
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 43 0.003718
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 24 0.003742
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 36 0.003778
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 32 0.003810
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 117 0.003927
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 193 0.004120
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" empty; using default key [rsecssfs.c 1289]
4 ETW000 144 0.004264
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 582 0.004846
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 42 0.004888
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 25 0.004913
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 35 0.004948
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 32 0.004980
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 116 0.005096
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 192 0.005288
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "E:\usr\sap\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" empty; using default key [rsecssfs.c 1289]
4 ETW000 145 0.005433
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]
4 ETW000 587 0.006020
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_CON_ENV read successfully from ssfs
4 ETW000 43 0.006063
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 23 0.006086
4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 14020 0.020106
4 ETW000 [ dev trc,00000] Thread ID:7584 55 0.020161
4 ETW000 [ dev trc,00000] lib_dbsl 720 05/22/2013 09:05:00 31 0.020192
4 ETW000 [ dev trc,00000] 720_EXT build 24 0.020216
4 ETW000 [ dev trc,00000] Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll'
4 ETW000 51 0.020267
4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 85 0.020352
4 ETW000 [ dev trc,00000] SAP patchlevel 0 27 0.020379
4 ETW000 [ dev trc,00000] SAP patchno 430 23 0.020402
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 27 0.020429
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 430 29 0.020458
4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: Short dump - SAPSQL_ARRAY_INSERT_DUPREC (1861476)
4 ETW000 44 0.020502
4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 61 0.020563
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 7330 0.027893
4 ETW000 [ dev trc,00000] (30006) [28000] [Sybase][ODBC Driver]Invalid authorization specification
4 ETW000 53 0.027946
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]
4 ETW000 1603 0.029549
4 ETW000 [ dev trc,00000] (30006) [28000] [Sybase][ODBC Driver]Invalid authorization specification
4 ETW000 56 0.029605
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=KBINDEV01;port=4901;uid=;db=DEV;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=2;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;ProtocolCapture=cap_p7792_comm_rd;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
4 ETW000 103 0.029708
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 30006 performing CON 341 0.030049
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL30006:28000]Invalid authorization specification[ASE Error SQL30006:28000]Invalid authorization specification
4 ETW000 63 0.030112
2EETW169 no connect possible: "DBMS = SYBASE --- "
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.