on 04-12-2014 9:26 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Check this sap note
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
Hi,
You need to extend the log of 'ECD' database.
alter database ECD log on <x> = <y>
Cheers,
Simon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.