Skip to Content
author's profile photo Former Member
Former Member

Getting error while trasporting BW query to ODATA

Hi Experts,

I am trying to export BW query as an ODATA service. I am following http://scn.sap.com/community/netweaver-gateway/blog/2012/12/08/transform-sap-bw-queries-into-odata-service-generation-and-activation link for achieving the same.

I am able to complete first 2 part of thatseries. I am able to see my ODATA service as an XML in the browser with metadata information.

http:// <Host> :< Port>/sap/opu/odata/sap/<service name>/$metadata

But when I try to do http:// <Host> :< Port>/sap/opu/odata/sap/<service name>/<queryname>Results , getting following error.

Please help me to resolve this error. I am also aware about easy query but my BW system is 7.02 so cannot use that functionality.

Regards,

Niket Talati

Capture1.JPG (283.8 kB)
Capture.JPG (99.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2014 at 09:34 AM

    Hi Niket,

    Could you please share the logs using the transaction /iwbep/error_log for the corresponding call.

    Thanks,

    Mohan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2014 at 10:19 AM

    Hello Niket,

    Please the below URL and you should be done 😊

    Use ' Z_FT_EMP_Z_FT_EMP_Q00001Results ' in place of ' Z_FT_EMP_Z_FT_EMP_Q00001Result '

    Regards,

    Ashwin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2014 at 07:28 PM

    I was getting this same error. I had to adjust the alias for the odata service to point to the data source instead of the local Gateway server. See Screen shot below of transaction /iwfnd/maint_service for my services. Local was the Gateway Hub and ES1clnt100 was the trusted RFC connection


    Capture.PNG (21.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2014 at 07:53 AM

    Former Member

    Is this issue resolved?

    Rgrds,

    JK

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.