2476311 - Planning Area Activation Failed due to Syntax Error | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2476311 - Planning Area Activation Failed due to Syntax Error

Symptom

You cannot activate planning area. In the log you observe similar error as below:
E - An exception of type 'CX_AMDP_EXECUTION_FAILED' occurred, that was not caught anywhere in the call hierarchy. It was not handled locally or declared using a RAISING clause.
E - An error occurred when the database procedure    /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ALTER_TABLES  was called. Potentially, the procedure    /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ALTER_TABLES  was called by another database procedure. The method called from ABAP is    /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLSET  Database connection used: "" (default connection if empty)  SQL error on the database: "129"  SQL message on the database: "transaction rolled back by an internal error: search table error: "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLSET#stb2#20170724122723": line 8 col 3 (at pos 196): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLSET": line 28 col 5 (at pos 1593): [129] (range 3): transaction rolled back by an internal error: transaction rolled back by an internal error: search table error: "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLANOBJ": line 190 col 13 (at pos 11859): [129] (range 3): transaction rolled back by an internal error: sql syntax error: search table error: "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ALTER_TABLES": line 105 col 11 (at pos 4734): [257] (range 3) sql syntax error exception: sql syntax error: incorrect syntax near "XXXXXX": line 1 col 60 (at pos 60)"
E -  Error at: /IBP/CL_SAP_SFND_SOPDM========CP, /IBP/CL_SAP_SFND_SOPDM========CM00J:101


Read more...

Environment

  • SAP Supply Chain Management (SCM)
  • SAP Sales and Operations Planning (SCM-SOP)
  • SAP Integrated Business Planning (SCM-IBP)

Product

SAP Integrated Business Planning 1608 ; SAP Integrated Business Planning 1611 ; SAP Integrated Business Planning 1702 ; SAP Integrated Business Planning 1705 ; SAP Integrated Business Planning 1708 ; SAP Integrated Business Planning 1711 ; SAP Integrated Business Planning 1802 ; SAP Integrated Business Planning 4.0 ; SAP Integrated Business Planning 5.0 ; SAP Integrated Business Planning 6.0 ; SAP Integrated Business Planning 6.1 ; SAP Integrated Business Planning 6.2

Keywords

Naming Restrictions, Activation, 'CX_AMDP_EXECUTION_FAILED', sql syntax error, incorrect syntax, IBP, SOP , KBA , SCM-IBP-CNF , IBP Configuration , SCM-IBP-CNF-ACT , IBP Activation , 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.