Skip to Content
0

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

Jul 18, 2017 at 04:03 PM

267

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

Hi, Luca

Did you work out what the issue was?

Regards,
Maia-Lii

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 22, 2017 at 08:33 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded