topic Initialization of Query Failed in Application Development and Automation Discussions

Initialization of Query Failed

keega — Mon, 27 Sep 2021 19:04:02 GMT

Hi all,

I modified one of our analytical queries (Material Inventory Values) by adding a field from nsdm_e_mard. Now when I invoke the app in Fiori, I get an error message saying "Initialization of query 2CCMLBALSUM failed".

I found a couple of potential fixes, but none have panned out. I don't know if it's related to the field (LABST) in the table (nsdm_e_mard) I'm using or if it's something entirely unrelated.

I'd appreciate any help on this issue.

Thank you in advance.

Re: Initialization of Query Failed

Sandra_Rossi — Tue, 28 Sep 2021 03:46:18 GMT

It seems you have analyzed the problem, could you tell us what you have tried, so that we don't ask you the questions you have already investigated? (also SAP notes checked)

Re: Initialization of Query Failed

former_member660513 — Tue, 28 Sep 2021 06:13:33 GMT

Blind guess: the query has (mandatory) variables and they have no default values?

Re: Initialization of Query Failed

keega — Tue, 28 Sep 2021 19:28:56 GMT

Hi,

I apologize for the delay.

I'm a bit embarrassed to say, but it was one of the annotations.

Offending one:

@AnalyticsDetails.query.axis:  #ROWS
@EndUserText.label: 'ValueUnrstdStock'
ValUnrestUseStock

Good one:

@AnalyticsDetails.query.axis: #COLUMNS
@UI.lineItem: { label: 'Val.Unrest.Stock', position: 50 }

This took care of the error that spurred the initial plea for help, but I am still just getting 0.00 (redundant) in each SLOC. I read something about redundancies occurring in MARD (specifically the field LABST), so I used nsdm_e_mard and am still getting the 0.00

I'm a little stumped at this point.

Thank you both for your responses. Much appreciated.

Re: Initialization of Query Failed

keega — Wed, 29 Sep 2021 14:59:13 GMT

Quick update:

I think I was getting redundant data returned because of the implementation of the StorageLocation field in the extension. Once I removed it, everything returned to normal. I'm going to figure out another way to get the requirement met.

Thanks all for your responses.

Closing this thread.