cancel
Showing results for 
Search instead for 
Did you mean: 

[ASE Error SQL1105]Can't allocate space for object 'syslogs' in database

Former Member
0 Kudos

Hi Experts,

We are currently performing a stack upgrade on SAP ECC 6.0 EHP6 to SP11 and got struck in pre-processing phase because DB is not available :

When checked understood from trans.log that log segment is full:

***LOG BY0=>[ASE Error SQL1105]Can't allocate space for object 'syslogs' in database 'ECD' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

So tried dumping the transaction log and increasing the log file by 8MB and restarted but same error ::

isql -Usa Password:<SA_PASSWORD> 1> use master 2> go 1> dump transaction master with no_log 2> go

1> alter database master 2> log on master = 8 3> with override 4> go

Then we tried increasing the size of the segment 'logsegment' as mentioned in the errorlog with :

1> sp_extendsegment logsegment, master, master

2> go

But it returned:

Msg 17793, Level 16, State 1:

Server 'ECD', Procedure 'sp_extendsegment', Line 349:

System Administrator (SA) must set database 'master' to single-user mode with

sp_dboption before using 'sp_extendsegment'.

(return status = 1)

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is

missing. Previous count = 0, Current count = 1.

I tried logging in with sa user and put master to single user mode it returned as below :

1> use master

2> go

1> EXEC sp_dboption master, 'Single User', True

2> go

Msg 17422, Level 16, State 1:

Server 'ECD', Procedure 'sp_dboption', Line 387:

The 'master' database's options cannot be changed.

(return status = 1)

Iam clueless now. could you please advice ?

Regards,

Srikanth

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Siva,

Also could you please let us know how to stop and start my sap database ?

I give shutdown, it stops the ASE server and Iam unable to login isql ?

Please advice..

Regards,

Srikanth G

sivakumar_kilari3
Active Contributor
0 Kudos

startdb

stopdb

Thanks

siva

Former Member
0 Kudos

Hi Siva,

I have tried it already but it throws below error :

hnpclecd:ecdadm 54> stopdb

stopping database ECD ...

Error: stopping database failed.

stop database failed

/usr/sap/ECD/SYS/exe/run/stopdb: Terminating with error code 13

Regards,

Srikanth G

sivakumar_kilari3
Active Contributor
0 Kudos

please paste stopdb log here.

Thanks

Siva

Former Member
0 Kudos

------------------------------ Mon Apr 14 01:47:51 CDT 2014

check if Sybase ASE processes are running

ASE instance running (pid of engine #0 is:  29124  )

/usr/sap/ECD/SYS/exe/run/stopdb: Terminating with error code 13

./stopdb: Terminating with error code 13

Regards,

Srikanth G

sivakumar_kilari3
Active Contributor
sivakumar_kilari3
Active Contributor
0 Kudos

Issue Resolved ?

Former Member
0 Kudos

Hi Siva,

Issue is still on we came to know whenever we execute SUM tool it gets disconnected from database because the number of user connections are getting exhausted.

I have increased the number of connections from 200 to 800, but still utilizing all the connections !!!!

Clueless how this can be resolved !!

Regards,

Srikanth G

sivakumar_kilari3
Active Contributor
Former Member
0 Kudos

Hi Siva,

The above note worked thanks a lot, awarded full points.

But I have got error in phase MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRA_ORG!

Last error code set: 1 processes failed, check 'SCEXEC_G.*' for details


When checked the SCEXEC_G.001 log says :


hnpclecd:ecdadm 81> cat SCEXEC_G.001

SAPup> Starting subprocess with PID 11501 in phase 'SCEXEC_GRA_ORG' at

20140414114523

ENV: DIR_LIBRARY=/sapdump/SUM/SUM/abap/bin

ENV:

LD_LIBRARY_PATH=/sapdump/SUM/SUM/abap/bin:/sapdump/SUM/SUM/jvm/jre/lib/am

d64/server:/sapdump/SUM/SUM/jvm/jre/lib/amd64:/sapdump/SUM/SUM/jvm/jre/..

/lib/amd64:/usr/sap/ECD/SYS/global/syb/linuxx86_64/sybodbc:/sybase/ECD/AS

E-15_0/lib:/sybase/ECD/OCS-15_0/lib:/sybase/ECD/OCS-

15_0/lib3p64:/sybase/ECD/OCS-

15_0/lib3p:/usr/sap/ECD/SYS/exe/run:/usr/sap/ECD/SYS/exe/uc/linuxx86_64

ENV: PATH=/sapdump/SUM/SUM/abap/bin:/sybase/ECD/ASE-

15_0/jobscheduler/bin:/sybase/ECD/ASE-15_0/bin:/sybase/ECD/ASE-

15_0/install:/sybase/ECD/DBISQL/bin:/sybase/ECD/OCS-

15_0/bin:/usr/lib64/qt-

3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/ECD/SYS/exe/uc/linuxx86_64:

/usr/sap/ECD/SYS/exe/run:/home/ecdadm:.

ENV: SAPSYSTEMNAME=ECD

ENV: dbms_type=syb

ENV: dbs_syb_dbname=ECD

ENV: dbs_syb_port=4901

ENV: dbs_syb_schema=SAPSR3

ENV: dbs_syb_server=hnpclecd

EXECUTING /sapdump/SUM/SUM/abap/bin/SAPuptool execdb ../var/PTALORGR.XQLLogging to '/sapdump/SUM/SUM/abap/log/PTALORGR.LOG'

FATAL ERROR: DBSL error 99: Connect failed

[ASE Error SQL30274:08S01]Error setting up connection

SAPup> Process with PID 11501 terminated with status 20 at

20140414114529!

Any idea ?

Regards,

Srikanth G

sivakumar_kilari3
Active Contributor
0 Kudos

Great,

Close this thread

Open another thread and paste this PTALORGR.LOG'

Thanks

siva

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Simon,

I was able to add a log segment to ECD with the below command :

sp_extendsegment logsegment, ECD, ECD_log_001

After that R3trans -d was giving 0000 code.

But as soon as I start SAP application it again gives the same error with R3trans

***LOG BY0=>[ASE Error SQL1105]Can't allocate space for object 'syslogs' in database 'ECD' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.


Please help me understand.


Regards,

Srikanth

simon_ogden
Participant
0 Kudos

Hi,

You need to take a look at the output of sp_helpdevice, take a look at where your existing devices are, you should be able to work the rest out. If necessary, you may need to run 'disk init' to create an additional device, but you will need to 'alter database' most likely. To check syntax etc use infocenter.sybase.com.

Cheers,

Simon

Former Member
0 Kudos

Hi Simon,

I am new to Sybase so getting bit confused :

1> sp_helpdevice

2> go

ECD_data_001

         /sybase/ECD/sapdata_1/ECD_data_001.dat                                                                                       

         file system device, special, dsync off, directio on, physical disk, 901

         12.00 MB, Free: 0.00 MB                                                                                                                                                                                                                                             

              2                           0

              5                         0

         46137343

ECD_log_001

         /sybase/ECD/saplog_1/ECD_log_001.dat                                                                                         

         file system device, special, dsync off, directio on, physical disk, 102

         40.00 MB, Free: 0.00 MB                                                                                                                                                                                                                                             

              2                           0

              6                         0

          5242879

So I believe our data device name is ECD_data_001 and log device is ECD_log_001. Correct me if wrong.

Now I tried creating the log on logdevice ECD_log_001 and it fails as there is no space :

1> use master

2> go

1> alter database ECD log on ECD_log_001 = 1024

2> go

Msg 1816, Level 16, State 1:

Server 'ECD', Line 1:

CREATE or ALTER DATABASE failed because the device 'ECD_log_001' has no space

available either for log or for data.

So I tried creating device as below, but issued a warning message below :

1> disk init name = ECD_log_002, physname='\sybase\ECD\saplog_2\ECD_log_002.dat', size = '1024M'

2> go

Warning: Relative path name '\sybase\ECD\saplog_2\ECD_log_002.dat' used for

physical device. Device may become unavailable if the server's current directory

changes.

Could you please advice if it is the correct procedure to follow.

Thanks !!!

Regards,

Srikanth

simon_ogden
Participant
0 Kudos

You've not looked carefully at sp_helpdevice output (slashes).Once you've done that make sure the folder exists and you should be OK.

Former Member
0 Kudos

Hi Simon,

Thanks for that

When I try to create now it says ot already exists

1> disk init name = ECD_log_002, physname='/sybase/ECD/saplog_2/ECD_log_002.dat', size = '1024M'

2> go

Msg 5148, Level 16, State 1:

Server 'ECD', Line 1:

Device 'ECD_log_002' already exists.

Can we delete the device that we have created ?

Regards,

Srikanth

sivakumar_kilari3
Active Contributor
0 Kudos

Hi Srikanth,

Can you paste here  sp_helpdevice output

if ECD_log_002 available use below command

1> use master

2> go

1> alter database ECD log on ECD_log_002 = 1024

2> go


or


1> use master

2> go

1> disk resize name 'ECD_log_001' , size = '1024M'

2> go

1> alter database ECD log on ECD_log_001 = '1024M'

2> go


Thanks

siva

Former Member
0 Kudos

Hi Siva,

I have created a new log device and R3trans -d returns 0000 after that. How when I start the patch upgrade from SUM tool it again fails in Pre-Processing phase while copying files to shadow instance.

and R3trans  fails again after running SUM tooll.

the DBCLONE log shows :

hnpclecd:ecdadm 91> tail DBCLONE.LOG

2 ETQ399 2014/04/13 02:09:59: sleeping 30 seconds

1 ETQ359 RFC Login to: System="ECD", AsHost="hnpclecd" Nr="00", GwHost="hnpclecd", GwService="sapgw00"

2EETQ231 RFC Login failed

3EETQ399 Checking job #0 'RSUPG_CLONE_TABLES' failed with RFC login to system ECD ashost hnpclecd nr 00 gwhost hnpclecd gwservice sapgw00 failed with code 2 key RFC_LOGON_FAILURE: 00024No connect to database, session terminated

2 ETQ399 2014/04/13 02:10:40: sleeping 30 seconds

1 ETQ359 RFC Login to: System="ECD", AsHost="hnpclecd" Nr="00", GwHost="hnpclecd", GwService="sapgw00"

2EETQ231 RFC Login failed

3EETQ399 Checking job #0 'RSUPG_CLONE_TABLES' failed with RFC login to system ECD ashost hnpclecd nr 00 gwhost hnpclecd gwservice sapgw00 failed with code 2 key RFC_LOGON_FAILURE: 00024No connect to database, session terminated

1EETQ399 Last error code set is: Batch jobs (DBCLONE1) may still be running: started 6, finished/aborted/running 0/0/6, check SM37 and SM21 for details

1EETQ204 Upgrade phase "DBCLONE" aborted with severe errors ("20140413021120")

Clueless why all the time R3trans fails after executing SUM tool :

hnpclecd:ecdadm 94> R3trans -d

This is R3trans version 6.24 (release 721 - 26.09.13 - 20:13:07 ).

unicode enabled version

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

R3trans finished (0012).

hnpclecd:ecdadm 95> tail trans*

4 ETW000                                                                                               39826  0.051507

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

4 ETW000                                                                                                  14  0.051521

4 ETW000  [     dev trc,00000]  syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                          14  0.051535

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

4 ETW000                                                                                                  23  0.051558

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

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

4 ETW000                                                                                                  13  0.051685

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

hnpclecd:ecdadm 96>

Please advice..

Regards,

Srikanth

sivakumar_kilari3
Active Contributor
0 Kudos

Hi,

You Apply Latest database Library patches DBSL .

Its available in kernel patches ( Database Dependent).

Thanks

Siva

Former Member
0 Kudos

Hi Siva,

We have already applied it, but no luck..

Regards,

Srikanth G

sivakumar_kilari3
Active Contributor
0 Kudos

can you paste latest r3trans log file

Former Member
0 Kudos

Hi Siva,

Please find the below :

hnpclecd:ecdadm 109> cat trans.log

4 ETW000 R3trans version 6.24 (release 721 - 26.09.13 - 20:13:07 ).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 13.04.2014 - 04:25:31

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]  Sun Apr 13 04:25:31 2014                                                  33  0.000033

4 ETW000  [     dev trc,00000]  db_con_init called                                                        10  0.000043

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

4 ETW000                                                                                                  13  0.000056

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

4 ETW000                                                                                                   9  0.000065

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

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/ECD/SYS/exe/run/dbsybslib.so' ...            18  0.000091

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/ECD/SYS/exe/run/dbsybslib.so"), hdl 0

4 ETW000                                                                                                 178  0.000269

4 ETW000  [     dev trc,00000]  Library '/usr/sap/ECD/SYS/exe/run/dbsybslib.so' loaded                     8  0.000277

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/ECD/SYS/exe/run/dbsybslib.so

4 ETW000                                                                                                  11  0.000288

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/ECD/SYS/exe/run/dbsybslib.so' is "721.02", patchlevel (0.213)

4 ETW000                                                                                                 113  0.000401

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library /usr/sap/ECD/SYS/exe/run/dbsybslib.so

4 ETW000                                                                                                  10  0.000411

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library /usr/sap/ECD/SYS/exe/run/dbsybslib.so

4 ETW000                                                                                                   9  0.000420

4 ETW000  [     dev trc,00000]  New connection 0 created                                                   9  0.000429

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                                                                                                  15  0.000444

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

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

4 ETW000                                                                                                   7  0.000460

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                           5  0.000465

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                                                                                                  12  0.000477

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

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

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                   20  0.000511

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                                                                                                  10  0.000521

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

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

4 ETW000                                                                                                7473  0.008010

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

4 ETW000                                                                                                  31  0.008041

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

4 ETW000                                                                                                  17  0.008058

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

4 ETW000                                                                                                 126  0.008184

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

4 ETW000                                                                                                   9  0.008193

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                     6  0.008199

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

4 ETW000                                                                                                   8  0.008207

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

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

4 ETW000                                                                                                  22  0.008237

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

4 ETW000                                                                                                  27  0.008264

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

4 ETW000                                                                                                  14  0.008278

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

4 ETW000                                                                                                  98  0.008376

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

4 ETW000                                                                                                   8  0.008384

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                     6  0.008390

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

4 ETW000                                                                                                   7  0.008397

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

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

4 ETW000                                                                                                  26  0.008430

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

4 ETW000                                                                                                  23  0.008453

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

4 ETW000                                                                                                  14  0.008467

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

4 ETW000                                                                                                  18  0.008485

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

4 ETW000                                                                                                  23  0.008508

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                                                                                                   9  0.008517

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                     6  0.008523

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

4 ETW000  [     dev trc,00000]  database is local: connect_timeout: 3                                    462  0.011601

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

4 ETW000  [     dev trc,00000]  connection unquiesced                                                      9  0.011624

4 ETW000  [     dev trc,00000]  721_EXT build                                                              6  0.011630

4 ETW000  [     dev trc,00000]  dbsybslib.dll patch info                                                  12  0.011642

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                        7  0.011649

4 ETW000  [     dev trc,00000]    SAP patchno  213                                                         7  0.011656

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchlevel 0                                            6  0.011662

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchno         213                                     9  0.011671

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

4 ETW000                                                                                                  10  0.011681

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

4 ETW000                                                                                               39826  0.051507

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

4 ETW000                                                                                                  14  0.051521

4 ETW000  [     dev trc,00000]  syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                          14  0.051535

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

4 ETW000                                                                                                  23  0.051558

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

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

4 ETW000                                                                                                  13  0.051685

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

Regards,

Srikanth G

sivakumar_kilari3
Active Contributor
0 Kudos

What is your operating system ?

What is DBSL patch no?

Thanks

Siva

Former Member
0 Kudos

Hi Siva,

It is RHEL 6.0, DBSL patch is 213 of Kernel 721_EXT UC.

Sybase version is 15.7.0.101

Regads,

Srikanth

simon_ogden
Participant
0 Kudos

Hi,

You need to extend the log of 'ECD' database.

alter database ECD log on <x> = <y>

Cheers,

Simon

Former Member
0 Kudos

Hi Simon,

Thanks for the quick response!!

Sorry, could you please advice the possible value for x, y

Thanks !!

Regards,

Srikanth G