Skip to Content

SAP BEX Query

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 03, 2015 at 11:44 AM

    Hi,

    Please check the table RSRREPDIR.

    It can be that there might bbe a GENUNIID clash.


    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2015 at 11:49 AM

    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.

    BEx Delete Duplicate queries

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

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2015 at 12:36 PM

    Regenerate the query in transaction RSRT

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 01:07 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded