2525086 - 1205 deadlock messages reported in the client log without writing it to errorlog - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2525086 - 1205 deadlock messages reported in the client log without writing it to errorlog - SAP ASE

Symptom

  • On the heavy load systems, sometime in the application you may see the deadlock information in the application log but it is not logged to ASE server error log even though the ASE configuration parameter "print deadlock information" has been configured as run value 1.
  • In the application log we can see the below information logged but not reported in the ASE log
    [Thread-285] ERROR DBConnection executeStatement - ExecutionException in executeStatement.com.sybase.jdbc3.jdbc.SybSQLException: Your server command (family id #0, process id #XXXX) encountered a deadlock situation.Please re-run your command.
    [Thread-285] ERROR DAO XXXXXXXXX- Error No. 1205:Your server command (family id #0, process id #XXXX) encountered a deadlock situation. Please re-run your command

Read more...

Environment

  • SAP Adaptive Server Enterprise CE 15.7.x
  • SAP Adaptive Server Enterprise CE 16.x

Product

Sybase Adaptive Server Enterprise Cluster Edition 15.7

Keywords

deadlock, 1205, sp_altermessage, 778228, "print deadlock information" , KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem

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.