Cloud foundry/ XSODATA compatibility layer. Status 500 Internal error.

[lewingan]

Hi all,

We are currently developing a UI5 app that connects to a XSODATA service that in running on the Node JS XSJS compatibility layer. Everything, including our HANA instance is on SAP Cloud Platform Cloud Foundry.

The problem we are facing is if we leave the UI5 app idle for about 5 minutes from the last call to the Odata service, and we navigate to any parts of the app that will call the same service again, we will get a status 500 internal error.

After some debugging I suspect there is something wrong when the sap/xsjs Nodejs package tries to use the previous connection to the HANA DB.

Anyone has any ideas how to fix this or where else I should debug?

db::connect"}

db::_connectInternal"}

db::use opener"}

db::_openConnection"}

db::connection is usable"}

error processor::process"}

[caretti_andrea]

I have a similar issue, is possible to run a xsodata app form BAS?

I get this error :

Error: Invalid HANA settings provided. OData services are disabled.

[Ivan-Mirisola · Accepted solution]

Hi lewin.gan,

Are you using an SAP App Router to provide your html5 application? Is it using a destination? If so, how is it performing SSO with your HANA Service?

Usually, App Router gets disconnected from its session after a timeout occurs. Since there isn't a valid session on BTP, it will trigger a new login procedure. Hence, you won't get any authentication errors provided that SSO is happening properly at the destination level on your App.

Best regards,
Ivan