SAP Knowledge Base Article - Preview

2049902 - Unable to deploy a star schema to oracle database - EA

Symptom

  • Deploying a star schema from a SQL Server database to an Oracle database doesn’t work
  • The following error message is displayed:

'Star Schema,Star1,Processing of dimension 'Category' failed. Data not copied into Star Schema table 'XXX_CATEGORY'.Star Schema,Star1,The OLE DB provider
"OraOLEDB.Oracle.1" for linked server "XXXX"supplied inconsistent metadata for a column. The column "NAME" (compile-time ordinal 3) of object ""XXX"."XXX_CATEGORY"" was reported to have a "LENGTH" of 12 at compile time and 24 at run time.
Star Schema,XXX,Cannot deploy star schema for deployment 'Star1' with 'Star1' table prefix
Star Schema,XXX,Star schema building of 'XXX' deployment with 'XXX' table prefix failed.'


Read more...

Environment

SAP Financial Consolidation (FC) Cube Designer (CD) 10.0

Product

SAP Financial Consolidation 10.0

Keywords

KBA , EPM-EA-DES , Designer , Bug Filed

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.