Defect in Global Delivery Adapters: Database connection leak. Data extraction component is having a DB connection leak and one connection kept open even though component execution is completed.

book

Article ID: 207805

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Bug Number: DE0002
Bug Title: Database connection leak. Data extraction component is having a DB connection leak and one connection kept open even though component execution is completed.

Cause

Steps to Reproduce:

  1. Login to clarity with Administrative access.
  2. Go to Administration -> Data Administration -> Reports and Jobs -> Job definitions.
  3. Identify the Data extraction job (Executable type is Java and File name is com.niku.configobj.dataextractionjob.DataExtractionJob)
  4. Navigate to Home -> Reports and Jobs -> Jobs and select one of the Data extraction job (preferably whose execution time is less than a minute).
  5. Pass the parameters if any and click on submit.

Actual

The job completes successfully, and the Data extraction output file will be generated and placed in the output file path configured. An active connection has been kept open for every instance of data extraction.

 

Expected:

The job completes successfully, and the Data extraction output file will be generated and placed in the output file path configured. There should not be any active or idle connections post job completion.

Environment

Platform: GCP
 

Version: 15.8 and 15.9

Resolution

Fixed the database connection leak issue and the same has been certified on 15.9 release

 

The fix is be applied with the coming upgrades to 15.9.1

 

Additional Information

Clarity Upgrade Schedule for 15.9.1

https://support.broadcom.com/external/content/product-advisories/UPGRADE-SCHEDULE-FOR-CLARITY-SAAS-15.9.1/16255