No Entity Sets in service

[Former Member]

Hi

I have an issue when creating odata services using segw.

We have a HUB gateway system set up with an ERP back end.

Gateway - 7.4

ERP - 7.01

I have created some odata feeds using segw and published them to the gateway server.

In segw I can see that entitysets have been created and generated for the services.

But no entitysets are available in the meta data???????

Metadata

Has anyone an idea on why the entitySets are not in the metadata??

I notice sap:schema-version="0"?????

I have created lots of odata services on different systems before and never had an issue.

Thanks

Andrew

[AshwinDutt · Accepted solution]

Hello Andrew,

Delete the service in /iwfnd/maint_service. Add it again and activate. Clear /iwfnd/cache_cleanup and check again.

/sap/opu/odata/ZGW_AB_TEST_SRV/$metadata

Regards,

Ashwin

[Former Member · Accepted solution]

Hi

Yes I have tried clearing of the cache, deleting/re-registering, creating new feeds and they all are no showing NO entity sets!!

No newly created feed has entity sets in the meta data?

I am very confused at this and am continuing to investigate.

Thanks

Andrew

[Former Member · Accepted solution]

Hi All

FYI......

I worked out what the issue was: authorizations.

I had the correct authorizations in the front-end to access the odata feed, but I didn't have the correct authorization in the back-end!!!

So I could access the feed but not the entity sets which were built in the back-end.

Thanks

Andrew

[Former Member · Accepted solution]

Dear Andrew,

Can you please confirm the Exact Authorization and Role name you are talking about, due to which Entity set is not getting populated in Gateway Client?

In my case my Service Soft State Status is Not Supported and i am also facing the same problem i.e. on click of Entity Set in gateway Client, It's returning the message 'No values found'.

Thanks In Advance.

Regards,

Ayas.

[Former Member · Accepted solution]

Hi Ayas

My issue was that I didn't have a custom authorization role which had the odata feed added in the back-end.

e.g. you would need to create a role that would allow access to the odata model.

Authorization Default : TADIR SERVICE

Program ID : R3TR

Obj. Type: IWSV

Then add the odata feed that is required.

Cheers

Andrew

[AshwinDutt]

Hello Andrew,

Delete the service in /iwfnd/maint_service. Add it again and activate. Clear /iwfnd/cache_cleanup and check again.

/sap/opu/odata/ZGW_AB_TEST_SRV/$metadata

Regards,

Ashwin

[kammaje_cis]

Most probably a cache issue.

Did you run /iwfnd/cache_cleanup in Hub?

[Former Member]

Hi Krishna

Thanks for answering,

I have run /iwfnd/cache_cleanup on the hub and also clean up cache on the back end.

Makes no difference......

Thanks

Andrew

[kammaje_cis]

Hope you have generated runtime artefacts after you added the entity/set.

Also check in Gateway client so that browser cache is eliminated.

[Former Member]

Hi Krishna

Thanks,

Yes objects are generated after entityset created (see segw screenshot)

Not testing in the browser, I am testing in the gateway client.

When I click EntitySets in the gateway client I get "No Values Found"

I can;t understand why???

Thanks

Andrew

[kedarT]

Run transaction /IWFND/MAINT_SERVICE and reload the metadata of oData service.

Hope this helps.