Gui session terminated

[former_member251537]

Sap ECC6.0 EHP6

Database SYBASE ASE 15.7.009

as per dev_w0

***LOG BY4=> sql error 1105   performing INS on table DDLOG [dbsynseq

586]

B  ***LOG BY0=> [ASE Error SQL1105]Can't allocate space for object 'DDLOG' in database 'F01' because 'default' 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.

I extended dataF01_1 and logf01_1 using sybase central 6.0

but still I am getting the same error

Kindly advice step by step procedure to increase the size

Thanks & Regards,

kathir

[former_member186228 · Accepted solution]

Dear Kathir,

Please check your database transactional log is full. If it is full Take a log bakup, it will clear the logs,

Regards,

jithin

[former_member251537 · Accepted solution]

Hi Jithin,

I have taken the backup of transcational log, still i am facing the same Error.

Actually  I was doing client refresh from production system to quality system for existing client, i using export/import method, didnot delete the client,while importing the process ended with this error. kindly advice what I have to do now,thoug i took transactional log back up, some standard job running in the background and ending with same error and gui gets terminated.kindly advice increasing the size of database will solve my problem.

Regards,

kathir

[former_member186228 · Accepted solution]

Dear Kathir,

Check any tablespace is full. if it is full increase the space

Regards,

Jithin

[former_member251537 · Accepted solution]

Dear jithin,

I extended the size of I extended dataF01_1 and logf01_1 using sybase central 6.0.

i did not altered the database now i altered the databse using the thread

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

now I could able to login through gui after login i  see all this standard background jobs was started before GUI gets terminated few standard job which runned are

ARV_BC_XMB_WRP20131226003039

SAP_CCMS_MONI_BATCH_DP

SAP_CCMS_MONI_BATCH_STARTUP_DP

SAP_CHECK_ACTIVE_JOBS

SAP_COLLECTOR_FOR_JOBSTATISTIC

SAP_COLLECTOR_FOR_NONE_R3_STAT

SAP_COLLECTOR_FOR_PERFMONITOR

SAP_COLLECTOR_PERFMON_RSAMON40

SAP_COLLECTOR_PERFMON_RSDB_DAILY

SAP_COLLECTOR_PERFMON_RSDB_HRLY

SAP_COLLECTOR_PERFMON_RSDB_HRLY

SAP_COLLECTOR_PERFMON_RSDB_PAR

SAP_COLLECTOR_PERFMON_RSDB_TDB

SAP_COLLECTOR_PERFMON_RSDBPREV

any advice on this please, now i am able login, will this job will start again and terminates the session.

Regards,

kathir

[former_member186228 · Accepted solution]

Dear Kathir,

Inspect job log there you will get information.

Regards,

Jithin

[former_member251537]

Hi all,

Isuue is resolved by altering the table space,using

disk resize name = "data<SID>_1", size = "XXXM"

go

alter database <SID> on data<SID>_1= 'XXXM'

go

alter database <SID> log on log<SID>_1 = 'XXXM'

Thank you all for your support.

[Former Member]

Dear Kathir,,

It seem all the background job was pending and just after start its started running and terminated the GUI as high load on the server ,,,,Standard job sud be running and i will suggest you to delete the background jobs starting with Z ,,,,as no need of these job in quality server other wise it will keeps running everytime.

Rableen