Clarity

 View Only

 GEL Script not using the correct connection pool

Jump to Best Answer
Christoph Schubert's profile image
Christoph Schubert posted Jun 24, 2024 11:46 AM

Hi,

since we upgraded Clarity from 16.1.2.1 to 16.2.1.1 we face a lot of bg-ca.log ERROR messages.

GEL Script not using the correct connection pool! - ApplicationName: null

This is thrown everytime, when an sql statement in a GEL Script (sql:query oder sql:udpate) is executed.

Although the script is executed fine with no errors in the end and also the results are good, the log file is messed up with those messages.

I cannot find any information about this message and what could be configured wrong?

I test this with a very simple GEL script and get this message for every execution:

<gel:script xmlns:core="jelly:core" 
			xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary" 
			xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" 
			xmlns:sql="jelly:sql" xmlns:xog="http://www.niku.com/xog"
			xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
			xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<gel:setDataSource dbId="niku"/>

<sql:query var="testquery"><![CDATA[
SELECT id from INV_INVESTMENTS
]]></sql:query>

</gel:script>

Any hints about this error message?

Thanks and regards

Christoph

Jeevan.S's profile image
Broadcom Employee Jeevan.S Best Answer

Turns out this was related to the issue described at https://knowledge.broadcom.com/external/article/280824/gel-connection-to-dwh-database-does-not.html .

Jeevan.S's profile image
Broadcom Employee Jeevan.S

Hi Christoph,

Could you provide a bit more of the error stack, please? The method that throws this message, and the beginning of error message etc. You can remove any sensitive content from it.

Christoph Schubert's profile image
Christoph Schubert

That's all from bg-ca.log, from starting the process till the end, with the testing script from previous post.

INFO  2024-06-25 09:12:13,824 [Dispatch Einen Prozess ausführen : bg@**hostname**> (tenant=clarity)] njs.scheduler (clarity:caadmin:14742136__FBEE9160-6F45-44AD-83AC-1D5D6B9D3DAF:Einen Prozess ausführen) () BGTask.run: Job ID: 6317048; fired date: 2024-06-25 09:12:13.824
ERROR 2024-06-25 09:12:14,467 [Custom script execution pool-8-thread-15] union.gel (clarity:caadmin:14742115__86A15782-596E-466B-933A-72BD7D5424DC:none) () GEL Script not using the correct connection pool! - ApplicationName: null
INFO  2024-06-25 09:12:16,559 [Dispatch Einen Prozess ausführen : bg@**hostname** (tenant=clarity)] njs.scheduler (clarity:caadmin:14742115__86A15782-596E-466B-933A-72BD7D5424DC:Einen Prozess ausführen) () BGTask.run: Job ID: 6317048; start date: 2024-06-25 09:12:13.824 with Status: COMPLETED, finish date: 2024-06-25 09:12:13.916, job code: EXECUTE_NON_OBJECT_PROCESS, duration: 00:00:00.092