Query definition could not be read BRAIN252

[Former Member]

Hi All,

I have faced below issue in staging system after transport. The query is running fine on dev & quality. I can't even find the element in error in the RSZ* tables. Please share if any solution.

Note: I have collected and transport the query again, still I face the error.

During run in RSRT

During query generation in RSRT

Thanks,

Angavai Elangovan

[jarek_przybylek · Accepted solution]

I had quite a similar problem.

The reason was that the records in RSRREPDIR table were duplicated i.e. records for dev, quality and production were not identical.

The solution I found was:

1) SE38 run ANALYZE_RSZ_TABLES

•Select database table: RSRREPDIR

•Object Version: A

Then execute the report

2) On the check report find section Table RSRREPDIR

•View details of this section

•The detail list will contain the queries which are incorrect, and probably your query among them as well. 

Then execute: Performing a rep air

You can find more information about  ANALYZE_RSZ_TABLES  in SAP Note 792779 - Report ANALYZE_RSZ_TABLES

[benshee · Accepted solution]

The same error happends to me twice. You can do this also direct editing table in RSRREPDIR SE16.

Just put your query ID in field COMPID and execute. Than select duplicate record for the specific query in table and delete record (Shift+F2).