SAP Knowledge Base Article - Preview

2551838 - Msg 2843, Level 16, State 2 on Update Trigger - SAP ASE

Symptom

After loading database dump (taken from ASE15.7 SP101) to SP137 and SP138, running update trigger reports error 2843,

1>update <tablename> set duration = 10 where ris_order_id = 20006
2>go

Msg 2843, Level 16, State 2:
Server '<servername>', Procedure '<triggername>', Line 33:
The dynamic statement '*sh1810175724_1510999106ss*' could not be found. This may be due to insufficient metadata descriptors. Increase the serverwide 'number of open objects' parameter or the 'procedure cache size' parameter.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP137
  • SAP Adaptive Server Enterprise (ASE) 15.7 SP138

Product

SAP Adaptive Server Enterprise 15.7

Keywords

ASEServer, CR#811427, Msg 2843, update trigger , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.