topic Re: [XS Advanced] HDBEXT - Error during pool.acquire() in Application Development and Automation Discussions

[XS Advanced] HDBEXT - Error during pool.acquire()

Former Member — Fri, 19 May 2017 13:30:17 GMT

Hello everyone,

in our projekt we are having a NodeJS application that connects to the HANA database via the node-module "sap-hdbext". Just like in several example regarding that matter we use ExpressJS as our REST-Interface.
The code where we connect the HDB-Middleware to Express looks like this:

Then in the express routes we use "var db = req.db" to get a database session from the middleware. On that we are able to call db.exec(...) and so on. Everything works fine so far...at least most of the time. Sometimes we get the following error message as soon as we call one of the routes:

„error: SAP_HDBEXT MIDDLEWARE: error during pool.acquire(): {"message":"the predefined session variable cannot be set via SET command: XS_APPLICATIONUSER","code":455,"sqlState":"HY000","level":1,"position":0,"status":500}

Error: the predefined session variable cannot be set via SET command: XS_APPLICATIONUSER”

So express apparently fails to retrieve a connection from the middleware offered by sap-hdbext. Restarting or redeploying the application doesn't help and it usually affects all NodeJS application using that method of creating db sessions. It does not always affect all users at a time but it does happen to every user once in while without ANY pattern noticable.

Usually after a couple of hours or on the next day everything works fine again without having changed anything.

Has anyone had the same issue or has an idea where it originates?

I'm thankful for any help!

Best Regards,

Henrik Lawall

Re: [XS Advanced] HDBEXT - Error during pool.acquire()

TomaszWilk — Tue, 17 Oct 2017 11:51:51 GMT

Did you find answer to this question? We have a similar issue with node.js on XSA/ODATA. After few dates, when sapui5 application is run, odata returns set XS_APPLICATIONUSER error. We are doing an investigation, at the moment we think it may be connected to limited resources (we have a minimal set), problem with acquiring connections from db pool, some wrong configuration of JS <-> DB connection (but I believe we have standard set).

Re: [XS Advanced] HDBEXT - Error during pool.acquire()

lsubatin — Wed, 01 Nov 2017 01:41:13 GMT

What is the version of hdbext you are using?

Re: [XS Advanced] HDBEXT - Error during pool.acquire()

Former Member — Mon, 05 Feb 2018 14:22:15 GMT

Hi,

I just stumbled over the same error. I was able to fix it by switching two lines of code. It works by first connecting to the HANA middleware before calling the passport authentication.

Cheers,

Markus

Re: [XS Advanced] HDBEXT - Error during pool.acquire()

Former Member — Tue, 22 Oct 2019 10:17:42 GMT

Worked for me! Thanks

Re: [XS Advanced] HDBEXT - Error during pool.acquire()

sachinbr — Wed, 01 Dec 2021 07:33:46 GMT

Hi markus.kurz,
It worked for me as well

Thanks,Sachin