Skip to Content
0

Fiori : Initialization of BEx Query Failed

Dec 18, 2016 at 08:24 AM

2.8k

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Rehan Sayed Dec 30, 2016 at 11:12 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Rehan,

I am working at S4hana 1511 FPS02 , and i have the same error "Initialization of query 2CCFITRIALBALQ0001 Failed".

Is it a must to have a BW server in our landscape?

Regards,

Ahmed Saleh.

0

Hi Ahmed,

It is not must to have BW Server in your landscape.

Regards,

Rehan Sayed

0
saurabh vakil Dec 23, 2016 at 01:20 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 06 at 10:25 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded