Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

For a query you are getting an error about "INCONSISTENCY". The exception is raised as in the query containing elements are missing.  Please go through the following points to solve the issue.   

 

Overview:

ParagraphDescription
1 - Where does the error occur?The INCONSISTENCY error can occur while using different Frontends.
2 - In Tx ST22 the following dump may be found afterwards If the error has occured then you will find a corresponding INCONSISTENCY dump in Tx ST22.
3 - Identify the missing elements With these steps you can identify the missing elements which cause the error.
4 - Possible Solutions You will find recommendations how to solve the problem. 

1 - Where does the error occur?

1.1 - In BEx Query Designer:

1.1.1 - You open a Query: 

You open a query, following error occurs:

  • You open a query or you create a new query.

  • Following message is shown in message window:

  • Please read point 3 why this error occurs.
  • Follow point 4 to identify the missing elements.
  • Follow point 5 to solve the issue. 
1.1.2 - You expand the RKF / CKF tree:
  • You open a query or you create a new query.
  • In InfoProvider tree you expand the node 'Restricted Key Figures' or 'Calculated Key Figures', following message is shown in message window:
  • Please read point 3 why this error occurs.
  • Follow point 4 to identify the missing elements.
  • Follow point 5 to solve the issue. 

1.2 - In backend in Tx RSRT:

The execution or generation of the query ends with error like this:

Query definition ... could not be read  Message / Number BRAIN 252 
Query ... could not be opened / Message Number BRAIN 635 
Row: 37 Inc: CONSTRUCTOR Prog: CL_RSR_OLAP_VAR / Error when generating dataProvider

1.3 - In JAVA WEB:

You open a query, you see an error like this:

1.4 - During transport in the after-import method:

A transport couldn't be imported into target system. The activation of objects fails while activation. In transport request log you find messages like: 

Start of the after-import method RS_AFTER_IMPORT for object type(s) ELEM
Error when activating element ...  
  • Please read point 3 why this error occurs.
  • Follow point 4 to identify the missing elements and point 5 to solve the issue.
  • You can also follow the note 1942767 "transport not successfully: Error when activating element" to solve the issue. 

2 - In Tx ST22 the following dump may be found afterwards

Category               ABAP Programming Error    
Runtime Errors         RAISE_EXCEPTION    
ABAP Program           SAPLRZX0    
Application Component  BW-BEX-ET  

Date and Time          28.02.2014 12:54:55
Short text = Exception condition "INCONSISTENCY" raised.

3 - Identify the the missing elements 

Please perform following steps to identify all missing elements: 

  1. In Tx SE37 view the function module RSZ_DB_ELT_GET.
  2. Set a break in row 'RAISE inconsistency':
  3. Reproduce the issue (execute query in Tx RSRT).
  4. Before error occurs the debugger starts.
  5. In code double click on variable 'e_th_missing_elements' to get the variable.
  6. In our example above you can see that variable 'e_th_missing_elements' contains 7 missing elements:
  7. In variable window (right side) double click on the variable 'e_th_missing_elements' to get all missing elements:
  8. In Tx SE16 have a look in following tables to find important information about the missing elements:
In table ...RSZELTDIRRSZCOMPDIRTADIR
... you find... the type of element.... the technical name of element.... the source system of element.
fieldDEFTP + SUBDEFTPCOMPIDSRCSYSTEM
example
 
 
 

 

4 - Possible Solutions

 Identified problemSolution
1The missing element does not exist.Transport the missing element.
2The A version of missing element does not exist, but the D version exists.Activate the missing element from SAP Business Content.
3The A version of missing element does not exist, but the M version exists.Activate the missing element.
  • In general it is recommended to run report ANALYZE_RSZ_TABLES to check the RSZ tables and find any inconsistencies.
  • If report identifies errors (shown as red alerts) you can fix it with help of the repair function of the report:
  1. In Tx SE38 execute report ANALYZE_RSZ_TABLES.
  2. Navigate to all warnings and errors.
  3. Go to detail view.
  4. See the 'Question mark' to get detail actions which needs to be performed to fix the problems.

 

 Link to this page: http://wiki.scn.sap.com/wiki/x/EQEjFg