SAP Knowledge Base Article - Preview

2918013 - UDF causes procedure recompiling after upgrading ASE 16.0 SP03 PL07 & PL08 - SAP ASE.

Symptom

  • When performing nested procedures after ASE upgrade to ASE16.0 SP03 PL07 and PL08, some of called procedures are recompiled though the procedures didn’t have ‘with recompile’ option.
  • sp_w result shows that the procedure was compiling every time the problematic procedure is running. 
    fid    spid   command                                                        execution_time       physical_io blocked
    ------ ------ -------------------------------------------------------------- -------------------- ----------- ------- 
      0    338 COMPILING                                                                       100           0       0
  • The problematic procedure references a UDF(User Define Function)
  • When checking the status value of sysprocedures, the status contains 0x40(procedure no cache) like 1090, 1218 ,1238.
    You can check the procedure name which contains 0x40 in the status as follows.
    select distinct (id), left(object_name(id),50),status  from sysprocedures where status & 0x40=64
    go


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL07 and PL08

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.