SAP Knowledge Base Article - Preview

2793738 - Errors 102 and 11031 when parameter deferred name resolution enabled

Symptom

After upgrading to ASE 16.0 SP02 PL08 a procedure which uses Dynamic SQL started to failed due the following errors:

=====

1> EXECUTE proc01 @param ='x'
2> go
Msg 102, Level 15, State 181:
Server 'xxxxxxxx', Procedure 'proc01', Line 24:
Incorrect syntax near 'SELECTSELECT'.
Msg 11031, Level 16, State 1:
Server 'xxxxxxxx', Procedure 'proc01', Line 24:
Execution of procedure proc01 failed because of errors
parsing the source text in syscomments during upgrade. Please drop and recreate dbo.proc01.

======

These errors also occur on ASE 16.0 SP03 PL06.


Read more...

Environment

  • SAP Adaptive Server Enterprise 16.0 SP02 PL08
  • SAP Adaptive Server Enterprise 16.0 SP03 PL06 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

102 11031 Incorrect syntax near  failed because of errors parsing the source text in syscomments during upgrade deferred name resolution 819306 , 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.