Skip to Content

Gui session terminated

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Dec 26, 2013 at 11:44 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 08:17 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 31, 2013 at 06:06 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.