SAP Knowledge Base Article - Preview

3010154 - ASE can incorrectly raise 1157 errors when exp_row_size is set which can cause replication to stop

Symptom

ASE raises error 1157 whith invalid free space on a page before and after it is recalculated:

  • Message: 1157, State 1, Severity 10

    Insert free space value -2463 in page header of DOL datapage 769306604 belonging to object id 1355929667 in database '<dbname>' is incorrect. It has been recomputed and is now -2463.

This can generally be ignored as an informational message but it can in turn can cause the Repserver DSI thread to shutdown:

  • H. 2021/01/05 15:27:37. THREAD FATAL ERROR #5049 DSI EXEC(125(1) <server name>.<database name>) - neric/dsi/dsiqmint.c(5108)
    The DSI thread for database 'KWSTRAN_2.bifrost' 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.
    H. 2021/01/05 15:27:37. THREAD FATAL ERROR #5273 DSI EXEC(125(1) <server name>.<database name>) - neric/dsi/dsiqmint.c(5136)
    To write the failed transaction into log, please execute 'sysadmin log_first_tran, <server name>, <database name>'. Please analyze the transaction and provide an appropriate fix based on your analysis, then resume the connection.
    I. 2021/01/05 15:27:37. The DSI thread for database '<server name>.<database name>' is shutdown.

This issue will also be reported by DBCC CHECKSTORAGE as error 100034 insert free space error.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)

  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE)

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Keywords

sybase, ASEServer, SAPASE, dataserver, DSI, replication, CR823906, CR#823906, 823906 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.