2313818 - BI 4.x: "A database error has occured" error appears when refreshing a WebI report based on an OLAP universe | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2313818 - BI 4.x: "A database error has occured" error appears when refreshing a WebI report based on an OLAP universe

Symptom

  • Error message appears when refreshing an existing Web Intelligence report, or when creating a new one based on an OLAP universe.
    "The following database error occurred: A database error has occured. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)(Error: INF )"

dialog run error.jpg

  • Issue occurs since updating the BW version from 7.30 to 7.40
  • During the investigation we could narrow down the issue that it's related to a specific hierarchy object.
  • The following error message appears when creating a new WebI report using a BICS connection and adding the problematic hierarchy object:
    "BW System <SID> returned state 'DATA_ACCESS_PROBLEMS'. Message = Error while retrieving data: JCO_ERROR_SYSTEM_FAILURE: Inconsistency in the dictionary for the structure /BI0/OTHIER_NODE. (WIS 00000)"

2016-05-04_14-45-39.png

  • The following short dump occurs when running the same BEx query in transaction RSRT: DDIC_TYPE_INCONSISTENCY
  • When checking the DDIC object in transaction SE11 using Utilities -> Runtime Object -> Recursive Check we can observe the following inconsistency:

BI0_OTHIER_NODE.png


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x
  • SAP BW 7.40
  • Web Intelligence
  • OLAP universe

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP NetWeaver 7.4

Keywords

web intelligence, webi, olap universe, bics, bw, structure,  DATA_ACCESS_PROBLEMS, DDIC_TYPE_INCONSISTENCY, BI0/OTHIER_NODE, JCO_ERROR_SYSTEM_FAILURE, SAP Knowledge Base Article 2054721 , KBA , BI-RA-WBI , Web Intelligence , 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.