SAP Knowledge Base Article - Preview

3601557 - Missing deferred compilation options in ASE stored procedure sp_procxmode - SAP ASE for Business Suite

Symptom

Disabling the deferred compilation for procedure sp_js_check_id in ASE throws the following error message:

sp_procxmode "sp_js_check_id", "disable_dc"

go

Msg 7981, level 16, State 1:

Server 'SID', Procedure 'sp_procxmode', Line xxx:
"The new procedure execution mode must be 'unchained', 'chained', 'anymode' or '[not] dynamic [ownership chain]'.

(return status = 1)


Read more...

Environment

  •  Adaptive Server Enterprise 16.0 SP03 PL12 HF1



Product

SAP Adaptive Server Enterprise all versions ; SAP NetWeaver 7.5

Keywords

7981,sp_procxmode, sp_js_check_id , disable_dc,  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.