Skip to Content

Fiori : Initialization of BEx Query Failed

I am implementing Trial Balance(Version 2) FPM/Webdynpro App from Fiori Apps Library

following App Implementation : Trial Balance guide for S/4 Hana 1610.

When I launch the Trial Balance App.It says "Initialization of query 2CCFITRIALBALQ0001 Failed"(PFA for the error ).

Please let me know how to Initialize or Activate BEx Query.

Regards,

Rehan Sayed

trial-balance.png (34.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 30, 2016 at 11:12 AM

    Hi Saurabh,

    Thanks for the help.


    The issue is resolved following the below steps :

    1) Set a BW-client: Transaction SE37 RS_MANDT_UNIQUE_SET. If you use only one client, then fill I_MANDT with this one. If you use multiple clients, choose one of these.

    2) Set user parameters RSWAD_DEV_MDVERSION = ‘072’ and RSWAD_SKIP_JAVA = ‘X’ for user DDIC(Its setting in transaction SU01 under parameter tab)

    3) Logon to system with user DDIC in the client you used in step 1 and perform transaction RSTCO_ADMIN in order to activate the technical objects, which are needed for the engine. The parameters set in step 2 avoid, that unnecessary objects (related to BI tools based on JAVA) are activated here.

    4) If you don't look at the OLAP-statistics you should deactivate these: Transaction SE38 - execute Report SAP_RSADMIN_MAINTAIN: with OBJECT = RSDDSTAT_GLOBAL_OFF and VALUE = X in insert mode. If you need the statistics, you can switch these on by running the program with that object but VALUE = space in update mode.

    5) If you want to use OData-Services run report EQ_RS_AUTO_SETUP (transaction SE38)

    6) If you want to use the BW time hierarchies, go to transaction RSRHIERARCHYVIRT and mark the hierarchies you need - for this you have to wait until the job triggered in step 3 has finished successfully
    7) Call function module RSEC_GENERATE_BI_ALL.


    Regards,

    Rehan Sayed

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2016 at 01:20 PM

    Please check if this note helps you: 2335917 - A RABAX short dump occurs while accessing an ABAP web application

    I had a similar issue with the Trial Balance app in my 1610 system and this note solved it for me.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 06 at 10:25 AM

    Hi,

    This query is not exist in the system. You can check by go to transaction code: RSRV -> All elementary tests -> Query

    input you query name. you will see the error that the query is not exist. Please contact with you basis team and import query if it is a standard query.

    Add comment
    10|10000 characters needed characters exceeded