SAP BEX Query

[Former Member]

Hi Bex Experts,

We have  to create a bex query and import it to UAT system,

but due to  some reasons the query was deleted and recreated with same technical name.

We have imported the  TRs  i.e   deletion query TR and  recreate query TR however we are getting the following error in UAT system.

Query definition 00O2TKGB7IXH98ERQUE8I0NH5 could not be read.

Query ZZXXX_XXX3 could not be opened.

Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION

"DATAPROVIDER" of type "QUERY_VIEW_DATA_PROVIDER" could not be generated

and the same report was working  with different technical name but the client was not happy to change the technical name.

Could you please  help me to how  to resolve  the above issue

[Former Member]

Hi,

Since you said existing query deleted in development system, how about creating new query with same technical name as before.

But if transport fails this time do not delete it, better to correct it by collecting it.

[cornelia_lezoch]

Regenerate the query in transaction RSRT

[karthik_vasudevan]

Hi

Please execute the program ANALYZE_RSZ_TABLES to check if you have any inconsistencies.

Check the below link and follow the steps to delete the query completely.

Then you could reimport the query and it should be fine then

Regards

Karthik

[former_member220624]

Hi,

Please check the table RSRREPDIR.

It can be that there might bbe a GENUNIID clash.

Regards,

Amit