SAP Knowledge Base Article - Preview

2690621 - Error 2824 may occur if a SQLJ function is executed on ASE without JAVA and PCI enabled - SAP ASE

Symptom

  • After loading a database dump obtained from ASE 15.7 to ASE 16.0, you may get a 2824 error with a stack trace by executing a SQLJ function on ASE 16.0.

Error 2824
Process %d cannot hold PROC_BUF 0x%p named '%.*s' because it holds another PROC_BUF 0x%p named '%.*s'. A process can only hold one view, rule, or default at a time.

  • Stack trace :

exc__raise
exc_raise
proc__linktopss
proc_get
s_getTreeOrPlan
n3_res_udf
n3_udf
norm3_expr
norm3_propagate
norm3_driver
s_normquery
s__call_normquery
s_normalize
s_reinstallProcTree
s_getTreeOrPlan
n3__sjfuncexec_res_udf
.......

  • ASE 15.7 is configured to enable Java and PCI and sybpcidb database and you can create and execute SQLJ functions.
  • On the other hand, ASE 16.0 is not configured to enable Java and PCI.

Read more...

Environment

SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

2824, 14216, PROC_BUF, SQLJ, JAVA, PCI, proc__linktopss, s_getTreeOrPlan, n3_res_udf, s_reinstallProcTree, n3__sjfuncexec_res_udf , 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 ONE Support launchpad (Login required).

Search for additional results

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