SAP Knowledge Base Article - Preview

1923758 - Error 724 or Abstract Plan Errors may be raised when table names are also abstract plan operator names - SAP ASE

Symptom

  • Internal Error 724 or Abstract Plan Errors may be raised when modifying the schema of a table with a table name that is also an abstract plan operator name.
  • The exact error, or where it occurs depends on datasets/schema , and the version of ASE it was executed on.
  • Sample Error when modifying the schema of a table to include a name also used by an operator within an Abstract Plan:

Warning: a default (object id <id>) is defined on column 'location' being modified. Check the validity of the default value after this ALTER TABLE operation. Abstract Plan (AP)

  • Warning: An error occured while applying the AP This may also include Msg 1530 , for example:

Msg 1530, Level 16, State 2:
Server '<ASE SERVER NAME>', Line 1:
Create index with sorted_data was aborted because of row out of order.  Primary
key of first out of order row is '"119040-033A", 20102, " ", "N/A131346", 0, 0'

  • For certain ASE 15.7 versions such as ESD#4.2 or SP100, there will be an Internal Error 724 together with a stacktrace will be printed in the ASE Errorlog, for example:

Error: 724, Severity: 20, State: 1
Internal Error: Function 'memalloc' was passed an illegal size value (-8).
************************************
SQL causing error :
************************************
SQL Text: ALTER TABLE store ADD storeno_i int default 0 NOT NULL

  •  The associated stacktrace  contains the following function calls:

memalloc
LeSQLRep::LeSQLRep
IdentifierType::IdentifierType
app__parse
ap_parse
ApPlan::ApInit
OptGlobal::_GblInit
OptGlobal::GblOptimize
Optimize


Read more...

Environment

SAP Sybase Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

SQL names, AP identifiers AP, memalloc, LeSQLRep, IdentifierType, app__parse, ApPlan, OptGlobal, Optimize, 737139, CR737139, CR#737139 , 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.