Lightweight consumption: Creating OData Queries check "by OData" doesn't trigger service generation

[S0021332585]

Hi Guys,

I'm working on BW 7.40 SP7 and I'm facing issue trying to generate the required service from BEx Query Designer in order to consume a OData query into my custom Fiori Application.

What I need to do, is to mark the query as "By OData" flag enabled in the "Release methods" as I did under Extend tab section (look at below screenshot)

That's wonderful! BUT the happiness was gone away soon. 🙂

As per my expectation and as per standard behaviour as well, all the needed services should be automatcally generated on the Gataway after saving all from BEx Query Designer.

Reading the SAP standard documentation

https://help.sap.com/saphelp_nw74/helpdata/en/f3/0c7316de924a98bb173904f7a61b4a/frameset.htm?framese...

This sentence:

If the By OData property is set, the gateway service is generated automatically when the query is saved.

is not declaring the truth!

So after checking that and saving the BEx Query the expected behaviour is this:

No DPC & MPC class have been generated.

No service can be added & published from T-Code /IWFND/MAINT_SERVICE.

Only one single message is appearing on my side and no one service was created on backend Gateway side.

Any clue why it is not working as expected?

I've followed some thread (see link below) and I perform all the steps highlighted in the Gateway Configuration Guide on the 7.4 Help to activate Gateway services, etc. , but the problem still persist on my end

https://blogs.sap.com/2016/02/08/bex-queries-and-odata-in-bw-74/

As last tentative, I've generated manually the needed classes by function module "RSEQ_NAT_GENERATION" and the service is magically created.

BUT, the defeat is around corner... When I tried to register the service in Gateway, below new error message appears

No Model assigned to Service assign Model first

Any hint will be really appreciated.

Regards,

Luca

[maialii]

Hi, Luca

Did you work out what the issue was?

Regards,
Maia-Lii

[former_member251760]

Hi Users,

Please check if the system is configured to allow for EQ and OData generation:

Here is the SAP note: https://launchpad.support.sap.com/#/notes/1944258

Thanks

[former_member214732]

Hi Luca, Did you ever get this solved?

I'm having the exact same problem. Unfortunately I cannot view your OSS note...

[S0021332585]

Hi Maia,

I have not received any suggestions from anyone yet. I had to raise a OSS note in order to have some kind of support.

If you are interested on the topic, you can find my OSS note below:

383982 / 2017 Lightweight consumption: Creating OData Queries check "by OData" doesn't trigger servi...

Let me know if you will find any useful hints.

Regards

Luca