Gel connection to DWH database does not work starting 16.2.0

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Gel scripts that run sql update on DWH database will run the same queries on the Clarity database instead.

<gel:setDataSource dbId="Datawarehouse" var="dwhDS"/>
<sql:update dataSource="${dwhDS}"/>

Steps to Reproduce:

1. Use the attached GEL script to create a custom process that creates a table on the DWH database
2. Run the process on 16.1.3, note it works
3. Run the same process on 16.2.0 and 16.2.1

Expected Results: The process to run as expected

Actual Results: The SQL update runs on Clarity database instead of DWH

Cause

DE80017

Resolution

DE80017 is fixed in 16.2.2.

Workaround:

1. Run the command on Clarity server:
   admin toggle-feature GEL_CONNECTION_POOL_S253100 0
2. Clear the caches

Additional Information

Note that a variable will have to be used to hold the pointer to DWH Data Source, in the gel:setDataSource element. This variable will have to be used in turn in the sql:update element, as shown in the 'Introduction' section above.