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.
- Application consultants should 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
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
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.
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.
2.1 Check the OData response
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
Select the “Error Context”
Call Stack helps you to set external break points.
3.2 Transaction /IWFND/APPS_LOG
Reference: Troubleshooting a SAP Netweaver Gateway Service
Step 4. Find the Runtime Data Provider class
4.1 Transaction /IWFND/MAINT_SERVICE
4.2 Transaction SE24
Open the Data Provider Class. Go to Property tab.
4.3 Transaction SE80
Open the package.
Class -> Runtime Data Provider Class -> Method -> Redefinitions
The example OData URI has &expand oprion, so you should look at the method GET_EXPANDED_ENTITY.
Step 5. Set External break points and debug
5.1 Check the user
Go to Utilities -> Settings
Make sure the user is application user.
5.2 Set external break points
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
Excellent Stuff and it's covered GW Debugging also
Thanks,
Syam
Great stuff, thanks for sharing.
Excellent stuff Masa
Keep posting more
Cheers 😉
Pradyp
Super stuff. The most useful stuff I come a cross for a long time.
Johan
very nice. very userfull suff.............t
Tauhid
What does it mean if the status code returns 500 when I execute my oData URI in Transaction: /IWFND/GW_CLIENT instead of 200
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.
Hello Masu,
thanks a lot - great stuff. Helps me a lot for understanding.
Regards Toni
Hi
Excellent blog
I can see the tiles in Chrome and not in IE. I also can see the OData URI in Chrome and not in IE. Any idea of what might be the cause?
Kind regards
thank you! very helpful doc!
Thank you. This helped me to resolve an issue.
Thanks you...very use full document.
Thank you! It is a great document.
BTW, is there any list for all LL documents for Fiori?
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
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 a creative search might help you.
I really like that someone taking time to put this valuable information. This document helped me to resolve some issues.
Regards,
Yogesh
Hello Masa, thank you for sharing. Martin
Many Many thanks!
it is very helpful!
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
Hi Srikanth, Please post is as a question. https://answers.sap.com/index.html
Hi Masayuki 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