Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

JDBC Query Timeout occurring while executing Query using the process in subsets- Bw5.x


Recommended Posts

Hi,

JDBC Query is timing out while executing below query.

The activity is desgined to process in subsets, subset count is 300 . Timeout happens before5to 6k recordsleft to be processed.

This issue is occuring very inconsistantly Most of the time it runs good only few times faill with timeout.

The total count of the records in DB would be arround 50k.

I tried increase memory and decrease the sbubset count from 500 to 300 still it is ocuuring. timeout value also incresed huge 10 min.

appricate your suggestions to resolve the issue.

 

Also Ihave a question when subset is defined in JDBC Query activity, does the DB invoked only one time or multiple times(for each sbusetcount retrival)

 

SELECT *

FROM B_msg

WHERE created_dt >= TO_DATE('07-14-2020 00:00:00', 'MM-DD-YYYY HH24:MI:SS')

AND created_dt

Link to comment
Share on other sites

×
×
  • Create New...