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

• 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.

SAP Adaptive Server Enterprise 16.0

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