cancel
Showing results for 
Search instead for 
Did you mean: 

ASE Error SQL30012:08001]Client unable to establish a connection

Former Member
0 Kudos

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 --- "

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member206552
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi ,

Please help me its very urgent for me

Thanks

former_member188883
Active Contributor
0 Kudos

Hi,

Copy the library to kernel directory usr/sap/sid/sys/exe

Regards,

Deepak Kori

former_member206552
Active Contributor
0 Kudos

Hi

do you have version 430 ?

lib_dbsl_430-10010165.sar

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

Former Member
0 Kudos

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 --- "

Former Member
0 Kudos

Hi Deepak,

same has been copied but still I ma facing the issue ,

Please suggest I need to copy TP as well

former_member206552
Active Contributor
0 Kudos

Hi

this tread ?

http://scn.sap.com/thread/3240488

Best Regards

Marius

Former Member
0 Kudos

HI Marius,

There is no solution in the thread

Please sugegst any other possibility to resolve the issue.

Former Member
0 Kudos

Hi All,

Any one please suggest me on above

Its very urgent for me

former_member206552
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Dear all,

Please helpme its very urgent

Former Member
0 Kudos

HI all,

any sugegstion on above its urgent

former_member215961
Contributor
0 Kudos

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

Former Member
0 Kudos

Hi,

As per your sugegstion ,

I have maintained the env varibales already

RSEC_SSFS_DATAPATH=\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data

RSEC_SSFS_KEYPATH=\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key

I need maintain any thing apart from this

Please suggest

former_member215961
Contributor
Former Member
0 Kudos

But in RSEC_SSFS_KEYPATH=\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key

key folder there is no data esists

How can we add file in this directory

former_member215961
Contributor
0 Kudos

Please apply sap note Note 1639578 - SSFS as password storage for primary database connect

Proceed as follows:

  • Log on to SAPGLOBALHOST as the <sid>adm user.
  • Make sure that the environment variables RSEC_SSFS_DATAPATH and RSEC_SSFS_KEYPATH are set.
  • Use the command line tool of the secure storage rsecssfx from the SAP kernel to add entries for the user <name> and the password <pwd>, and to add any information about the target database as follows:

    rsecssfx put DB_CONNECT/DEFAULT_DB_USER <name> -plain
    rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <pwd>

           If required, also use:

           rsecssfx put DB_CONNECT/DEFAULT_DB_CON_ENV <con_env>  -plain

Former Member
0 Kudos

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

former_member215961
Contributor
0 Kudos

Hi,

Check this thread:

http://scn.sap.com/thread/3299815

Cheers

Former Member
0 Kudos

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 --- "

former_member215961
Contributor
0 Kudos

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,

Former Member
0 Kudos

Hi ,

I have run the below conad r3trans -d RC-12

C:\Users\devadm>isql -Usapsa -SDEV -w2000

Password:

1>

How can retrive the my passwords etc

former_member215961
Contributor
0 Kudos

Hi,

Check with your password:

isql -Uusername -Ppassword -ofile_name

C:\Users\devadm>isql -Usapsa -SDEV -PWelcome12345

Cheers

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Sagar,

Please help me

Former Member
0 Kudos

Hi all,

any one help me one baove

Former Member
0 Kudos

Hi all,

any suggestions on above

Former Member
0 Kudos

Hi all any sugegstions

former_member206552
Active Contributor
0 Kudos

Hi

If this is an urgent matter I would suggest to open a message to SAP, as i'm unable to assist any further

Hope you find a solution

Best Regards

Marius

former_member215961
Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Sagar,

In that key location there is no file available in my system.

MY solman system up and running in that also there is no key file

Please sugegst

former_member184473
Active Contributor
0 Kudos

Hello,

Check if you have the right configuration as per note 1643080:

  • profile parameter: rsdb/ssfs_connect = 1 and
  • environment variable for <sid>adm: rsdb_ssfs_connect with value 1

Regards,

Eduardo Rezende

Former Member
0 Kudos

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:

  • Log on to SAPGLOBALHOST as the <sid>adm user.
  • Make sure that the environment variables RSEC_SSFS_DATAPATH and RSEC_SSFS_KEYPATH are set.
  • Use the command line tool of the secure storage rsecssfx from the SAP kernel to add entries for the user <name> and the password <pwd>, and to add any information about the target database as follows:

    rsecssfx put DB_CONNECT/DEFAULT_DB_USER <name> -plain
    rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <pwd>

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 --- "

former_member184473
Active Contributor
0 Kudos

Hi,

Ensure you have the following variables set for user <sid>adm:

dbs_syb_port = 4901

dbs_syb_schema = SAPSR3

dbs_syb_server = KBINDEV01

dbs_syb_dbname = DEV

dbms_type = syb


Regards,

Eduardo

Former Member
0 Kudos

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 --- "

Former Member
0 Kudos

Hi

in case you didnt do it before, check  sap note 1861476

In case you already did, ignore me

cheer

a

former_member184473
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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 --- "

former_member215961
Contributor
0 Kudos

Check the version that you need:

Note 1590719 - SYB: Updates for SAP Sybase ASE

Hope this help you

Cheers


Former Member
0 Kudos

Thanks sagar I will go through the note and if any idea please suggest on my latest R3trans log

any idea for the above issue

former_member184473
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi All,

Any one suggest me how can we chek the ODBC driver version I gone through the above note but I ma not able to to do,After downloading latest pacth where we need to deploy the ODBC file

Former Member
0 Kudos

HI all,

I am able to see the veriosn odbc how can i update the patches which location I need to update

Thanks

former_member215961
Contributor
0 Kudos

Hi,

Read the note carefully and update the odbc driver according your sybase release.

After mark as answered this thread .

Cheers

Former Member
0 Kudos

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 --- "

former_member215961
Contributor
0 Kudos

Search for :

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

Ans please mark answer this thread

former_member184473
Active Contributor
0 Kudos

Hello,

On server KBINDEV01 are you able to direct logon to the database?

isql -SDEV -Usapsa -P<password>

Regards,

Eduardo

Former Member
0 Kudos

Hi All,

The issue resolved ,I have rasied with this to SAP.Its SAP bug,becuse of DBSL 430 .

Soon they will relase dbsl 431

Thanks