Saturday, January 30, 2016

1969210 - Error " UJO_READ_EXCEPTION_018 table config for index xxxx is not valid" after BPC HANA system copy

Symptom
  • After a copy of the BPC system on HANA, user cannot see any data in any EPM Excel report, and  the Web Consolidation Monitor, Controls Montor, Ownership Manager and Journals show errors. For example, user will get error "Some errors occurred while processing the dimension" when try to process dimension.
  • When execute some reports, user gets error UJO_READ_EXCEPTION_018 saying "table config for index **** index is not valid" .
         Error.JPG



Environment
  • SAP  Planning and Consolidation 10 for Netweaver


Reproducing the Issue
  1. After HANA system copy, run a report in EPM Add-in.


Cause
  1. User forgot to adjust SAP HANA Calculation Views after the copy.


Resolution
  1. follow OSS Note 1844468 - Homogeneous system copy on SAP HANA.
  2. Follow step  "Adjusting the SAP HANA calculation views. " If you copied a BW system, you must adjust the SAP HANA calculation to the new system names views after the migration. This is done when calling the report RS_BW_POST_MIGRATION with all options"



Keywords

MDX statement, HANA license

No comments:

Post a Comment