SAP Knowledge Base Article - Preview

1992276 - SSM Load PAS Model in Cube Builder or E&A fails

Symptom

When loading a PAS Model in Cube Builder or Entry and Approval (E&A) after a new installation or update of SAP Strategy Management (SSM) you receive a database error such as;

(SQL104N) An unexpected token "create table cpms_cbtmp1 as select id, name," was found following BEGIN-OF-STATEMENT

or

ORA-00904: "IFNULL": invalid identifier


Read more...

Environment

  • SAP Strategy Management 7.5
  • SAP Strategy Management 10.0
  • SAP Strategy Management 10.1

 

Product

SAP Strategy Management 10.0 ; SAP Strategy Management 10.1 ; SAP Strategy Management 7.5

Keywords

cube builder entry approval EA E&A load pas model , KBA , load , ssm , epm , pas , model , sql , ora , db2 , syb , sybase , EPM-SM-APP-CB , HTML Cube Builder , EPM-SM-APP-EA , Entry & Approval , 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.