Skip to Content
Author's profile photo Masayuki Sekihara

SAP Fiori LL11 – Consultants should know about OData troubleshooting

SAP Fiori Lessons Learned 11

Consultants should know about OData troubleshooting

Background:

SAP Fiori apps are out of the solution but you face several issues because main functions are in backend ERP and each customer has different backend setup/configuration. OData is the communication channel to the backend servers via get/post/put method.

Lessons Learned:

Understanding OData and backend function are must requirements for consultants.

  • 应用顾问应该learn about OData technical and runtime behavior
  • Technical consultants should learn about ERP application functions
  • Both application consultants and technical consultants should work together

Consultants should know following steps.

Step 1. Identity the OData service call

1.1 Run the app

1.2 Inspect element

Right click -> Inspect element (Chrome), F12 (IE), then go to Network tab

/wp-content/uploads/2013/11/inspect_322841.png

Ignore the warning or error message in the Console tab at this point in time. Focus on OData troubleshooting.

1.3 Refresh the app or browser

/wp-content/uploads/2013/11/refresh_322851.png

1.4 Find the last called OData URI

Scroll down to the bottom of inspect element and find the OData/sap/opu/odata/sap/.. from bottom.

/wp-content/uploads/2013/11/odata_322877.png

http://.:/sap/opu/odata/sap/GBAPP_POAPPROVAL;mo/WorkflowTaskCollection(SAP__Origin=’ONE_800′,WorkitemID=’000001104681′)/HeaderDetails?$expand=ItemDetails,Notes,Attachments,ItemDetails/Limits

Step 2. Test OData in the Gateway client

2.1 Copy & Paste the OData URI

Transaction: /IWFND/GW_CLIENT. You should logon with the application user same as Fiori app logon.

/wp-content/uploads/2013/11/gw_client_322879.png

2.1 Check the OData response

/wp-content/uploads/2013/11/data_322895.png

If http response is not 200, you may have some connection setting issue.

If tttp response is 200 but OData service does not return application data, you should go Step.5 debug section.

Step 3. Check error log

3.1 Transaction /IWFND/ERROR_LOG

/wp-content/uploads/2013/11/error_log_322917.png

Select the “Error Context”

/wp-content/uploads/2013/11/call_stack_322919.png

Call Stack helps you to set external break points.

/wp-content/uploads/2013/11/stack_322920.png

3.2 Transaction /IWFND/APPS_LOG

/wp-content/uploads/2013/11/app_log_322921.png

Reference:Troubleshooting a SAP Netweaver Gateway Service

Step 4. Find the Runtime Data Provider class

4.1 Transaction /IWFND/MAINT_SERVICE

/wp-content/uploads/2013/11/maint_service_322937.png

/wp-content/uploads/2013/11/class_322938.png

4.2 Transaction SE24

Open the Data Provider Class. Go to Property tab.

/wp-content/uploads/2013/11/package_322942.png

4.3 Transaction SE80

Open the package.

/wp-content/uploads/2013/11/class2_322949.png

Class -> Runtime Data Provider Class -> Method -> Redefinitions

The example OData URI has &expand oprion, so you should look at the method GET_EXPANDED_ENTITY.

/wp-content/uploads/2013/11/map2_322950.png

Step 5. Set External break points and debug

5.1 Check the user

Go to Utilities -> Settings

/wp-content/uploads/2013/11/debug2_322951.png

Make sure the user is application user.

/wp-content/uploads/2013/11/debug_user_322964.png

5.2 Set external break points

/wp-content/uploads/2013/11/method_322965.png

5.3 Debug

Test the OData URI from Gateway Client. You can now debug the code. Most of case, issue is related with ERP customizing or master data.

Each customer has different customizing setting and master data.

Regards,

Masa

SAP Rapid Innovation Group – RIG

Assigned Tags

      21 Comments
      You must be登录to comment or reply to a post.
      Author's profile photo Syambabu Allu
      Syambabu Allu

      Excellent Stuff and it's covered GW Debugging also

      Thanks,

      Syam

      Author's profile photo Hemendra Sabharwal
      Hemendra Sabharwal

      Great stuff, thanks for sharing.

      Author's profile photo Former Member
      前成员

      Excellent stuff Masa

      Keep posting more

      Cheers

      Pradyp

      Author's profile photo Former Member
      前成员

      Super stuff. The most useful stuff I come a cross for a long time.

      Johan

      Author's profile photo Former Member
      前成员

      very nice. very userfull suff.............t

      Tauhid

      Author's profile photo Former Member
      前成员

      What does it mean if the status code returns 500 when I execute my oData URI in Transaction: /IWFND/GW_CLIENT instead of 200

      Author's profile photo Masayuki Sekihara
      Masayuki Sekihara
      Blog Post Author

      500 means internal server error.List of HTTP status codes - Wikipedia, the free encyclopedia. Most of cases, system connection has not been setup or there was short dump in he backend. Please create new discussion if you need further support.Start a discussion.

      Author's profile photo Former Member
      前成员

      Hello Masu,

      thanks a lot - great stuff. Helps me a lot for understanding.

      Regards Toni

      Author's profile photo Timothy Muchena
      Timothy Muchena

      Hi

      Excellent blog

      I can see the tiles in Chrome and not in IE. I also can see theOData URI in Chrome and not in IE. Any idea of what might be the cause?

      Kind regards

      Author's profile photo Former Member
      前成员

      thank you! very helpful doc!

      Author's profile photo Former Member
      前成员

      Thank you. This helped me to resolve an issue.

      Author's profile photo Deborshi De Sarkar
      Deborshi De Sarkar

      Thanks you...very use full document.

      Author's profile photo Liang Hu
      Liang Hu

      Thank you! It is a great document.

      顺便说一句,有列表对所有会做的cuments for Fiori?

      Author's profile photo Michael Appleby
      Michael Appleby

      SAP Fiori

      will take you to the Fiori community Overview page. Check out the All Things SAP Fiori right in the middle. It is where all things Fiori are organized for easy access.

      Cheers, Mike

      SAP Technology RIG

      Author's profile photo Jeremy Good
      Jeremy Good

      As Mike mentioned the more recent "SAP Fiori LL" blogs are located in the SAP Fiori space, and as you've seen with this one, the older blogs are located in the SAP for Mobile space. There is no master list, but you will find them linked on their correlated topic pages in the All Things SAP Fiori document. The title format is consistent, and Masa is the author, so acreative searchmight help you.

      Author's profile photo Yogesh Patel
      Yogesh Patel

      I really like that someone taking time to put this valuable information. This document helped me to resolve some issues.

      Regards,

      Yogesh

      Author's profile photo Martin Schlegel
      Martin Schlegel

      Hello Masa, thank you for sharing. Martin

      Author's profile photo Wendy Li
      温迪李

      Many Many thanks!
      it is very helpful!

      Author's profile photo Srikanth Subramanian
      Srikanth Subramanian

      Hi Masa,

      is there a link for FIORI DEMO Trail version and also to know difference between timesheet entry Version1 & Version 2.

      I am using below link and it is not working.

      https://www.sapfioritrial.com/

      Regards,

      Srikanth

      Author's profile photo Masayuki Sekihara
      Masayuki Sekihara
      Blog Post Author

      Hi Srikanth, Please post is as a question. https://answers.sap.com/index.html

      Author's profile photo Andre Julius
      Andre Julius

      HiMasayuki Sekihara,

      Thanks for the sharing. In my case, it seems there is some kind of timeout. i.e: when my UI5 trigger my breakpoint in GET_ENTITYSET, after a while the debug window is gone. Another weird thing is that my debug window appears 2 times. I wonder what cause this. Can enlighten me based on your experience?

      Best Regards

      Andre Julius