Skip to Content

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

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?frameset=/en/c9/384c774bcc4837b84bee3679520fb4/frameset.htm¤t_toc=/en/22/c927d9cd6f48d18cf4793ccce1cb71/plain.htm&node_id=110

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 08, 2017 at 12:00 PM

    Hi, Luca

    Did you work out what the issue was?

    Regards,
    Maia-Lii

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2017 at 08:33 AM

    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 service generation

    Let me know if you will find any useful hints.

    Regards

    Luca

    Add comment
    10|10000 characters needed characters exceeded