cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

DB error SQL error 1105 occurred

Former Member
0 Likes
8,629

Dears,

I have working on SAP ERP 6 EHP5 NW 7.02 on Sybase, and get the following error" DB error: SQL error 1105 occurred "also when try to open TCode: dbacockpit to extend the table space, the SAP GUI terminated and show the following error also <SID>: SAP System Message: Work process restated; session terminated.

so please advice how I can solve this issue, thanks in advance.

View Entire Topic
Former Member
0 Likes

Hi,

In order to avoid these kind of scenarios, we have implemented seperate tempdb for sapsa user which will allow us login using isql when we face this kind of full situations.

, what is the output of the this statement.

sp_helpsegment logsegment

Former Member
0 Likes

thanks for your information

the output of sp_helpsegment logssegment is as the following

segment                  name                            
     status             

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

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

   2                  logsegment                      
      0             
device               size                   

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

master               248.0MB                

free_pages 

-----------

   13883

Objects on segment 'logsegment':

table_name                        
     index_name                           indid       
     partition_name                                     

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

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

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

syslogs                           
     syslogs                                  0       
     syslogs_8                                          

Objects currently bound to segment 'logsegment':

table_name                        
     index_name                           indid       

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

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

syslogs                           
     syslogs                                  0       

total_size    total_pages free_pages  used_pages

     reserved_pages 

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

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

248.0MB       15872       13883       68       
     0         

(return status = 0)

so what you see?