Symptom
- ASE raises error 1157 after change the table exp_row_size on update or insert. For example:
Insert free space value -11315 in page header of DOL datapage 1355 belonging to object id 592002109 in database 'repro' is incorrect. It has been recomputed and is now -11315.
- This can lead to Replication Server DSI connection being shutdown with the following message:
THREAD FATAL ERROR #5049 DSI EXEC(125(1) <server name>.<database name>) - neric/dsi/dsiqmint.c(5108)
The DSI thread for database '<server name>.<database name>' is being shutdown. DSI received data server error #1157 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The data server error was caused by output command #1 mapped from input command #5 of the failed transaction.
- This issue will also be reported by dbcc checktable:
Msg 9990, Level 16, State 1:
Server 'ase16', Line 1:
The insert free space value (-11894) in the page header of DOL datapage 425809,
partition ID 12524047 is greater than the sum of cfs and ncfs (143) in the
page.
Insert free space' value in the page header of DOL datapage 425809, partition ID
12524047, has been corrected to -11894.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- SAP Adaptive Server Enterprise Cluster Edition (ASE CE)
Product
Keywords
sybase, ASEServer, SAPASE, dataserver, replication, CR823906, CR#823906, 823906, trace, flag, 1134 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.