RUN TIME ERROR: "[ASE Error SQL1105]

[Former Member]

Hi Experts..

Category               Installation Errors

Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                CX_SY_OPEN_SQL_DB

Date and Time          29.10.2014 11:09:56

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Short text                                                                                        |

|    SQL error 7412 when accessing table "VRSMODISRC".                                             |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|What happened?                                                                                    |

|    Error Text of the Database: "[ASE Error SQL1105]Can't allocate space for object               |

|     'syslogs' in database 'PCD' 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 th"                                    |

----------------------------------------------------------------------------------------------------

Here it is .. i need immediate help ...

spam_error.txt.zip

[former_member187136 · Accepted solution]

Dear Anoop,

Buddy the error 1105 occurs when the segment(log/data) runs out of the space to store the data.

Run the below two commands and extend your PCD database log segment.

1. Find the log segment name of the PCD database from the below command by logging through isql

sp_helpdb PCD

go

2. Disk resize and alter the database will fix this issue:

disk resize name = "<Identified Log devicen Name>" , size = "500M"

go

alter database PCD log on "<Identified Log devicen Name>" = "500M"

go

if incase this still didnt help this process repeat the step 2 untill you get rid of the error in chunks of 200M , if still this is not solved, provide me the ASE log after the activity I will look and provide you updates.

Regards

Kiran Kumar A