Problem with my SAP Fiori Elements app

[EdsonBravo93]

Hello Experts, good evening.

I'm having a problem with a Fiori Elements app.

Let me explain the two problems I'm having.

The first is that I have an Elements app, which displays purchase orders, some messages we need to review, among other values.

Now, when I try to scroll through the app, it starts displaying the elements, which at this point are around 1,935 records.

but at some point while scrolling, the app crashes

and in the browser console, it displays the following message

“Request failed with status code 500: GET ZZ1_MM_LOG_CREAOV?sap-client=220&$skip=120&$top=20&$orderby=PURCHASEORDER%20desc,PURCHASEORDERITEM%20asc&$select=PURCHASEORDER%2cPURCHASEORDERITEM%2cMATERIAL%2cSUPPLIER%2cSALESORDER%2cSALESORDERITEM%2cPROCESADA%2cRESPUESTA%2cDATESALESORDER%2cSAP_CreatedDateTime%2cSAP_CreatedByUser%2cSAP_CreatedByUser_Text%2cSAP_LastChangedDateTime%2cSAP_LastChangedByUser%2cSAP_LastChangedByUser_Text%2cSAP_UUID - [{"code":"0050569259751EE4BA9710043F8A5115","message":"In the context of Data Services an unknown internal server error occurred","persistent":true,"targets":[""],"type":"Error"}] sap.ui.model.odata.ODataMessageParser”

So, when I tried to review the app, as you know, I only had the annotations and some help with Guided Development. I don't usually work with these apps much, so I don't know where else I could check what might be happening.

Now, the second point that also has a problem is that when you want to use one of its filters, and want to search for a single Purchase Order

The app crashes just like when I try to scroll and shows a similar screen

and the browser console displays the following message

“Request failed with status code 500: GET ZZ1_MM_LOG_CREAOV?sap-client=220&$skip=0&$top=20&$orderby=PURCHASEORDER%20desc,PURCHASEORDERITEM%20asc&$filter=PURCHASEORDER%20eq%20%273000001803%27&$select=PURCHASEORDER%2cPURCHASEORDERITEM%2cMATERIAL%2cSUPPLIER%2cSALESORDER%2cSALESORDERITEM%2cPROCESADA%2cRESPUESTA%2cDATESALESORDER%2cSAP_CreatedDateTime%2cSAP_CreatedByUser%2cSAP_CreatedByUser_Text%2cSAP_LastChangedDateTime%2cSAP_LastChangedByUser%2cSAP_LastChangedByUser_Text%2cSAP_UUID&$inlinecount=allpages - [{"code":"0050569259751EE4BA9710043F8A5115","message":"In the context of Data Services an unknown internal server error 

Any ideas on where I could look or check to see why this error is occurring? Any way to try to find the error?

I'd appreciate any help, as well as any recommendations or blogs or documentation I could use.

Regards

EBZ.

[junwu · Accepted solution]

it is backend error. usually data type mismatch will cause that error.

https://help.sap.com/docs/service-asset-manager/sap-service-and-asset-manager-configuration-guide/sa...

[EdsonBravo93 · Accepted solution]

Hi Junwu I checked the Error_LOG by entering the query that appeared in the console, and indeed, it showed a problem with "SAP_CreatedDateTime" The property 'SAP_CreatedDateTime' has an invalid value of '739379.0000000' What do you recommend doing next? Should I check something else to get more context in this case? Thanks EBZ

[junwu · Accepted solution]

you have to ask yourself why it has that value?

[EdsonBravo93 · Accepted solution]

Hi Junwu Thank you so much for sharing the blog. We were able to find the error and are working on a fix. Best regards. EBZ