CRJAZ0367I error closing after fetching rows
Hello,
I'm using CLM 4.0.5 and oracle as database and i've recently encountered the following errors:
CRJAZ1992E The "com.ibm.team.process.RequestRemoteEnterpriseProcessUpdatesTask" task could not be completed and is now unscheduled. Error details: "CRJAZ0367I Error closing after fetching rows stmt = select distinct t1.ITEM_ID, t1.STATE_ID, t1.INTERNAL_LAST_UPDATE_ATTEMPTED from JTS.PROCESS_PROCESS_PROVIDR_CCH_TM t1 order by t1.INTERNAL_LAST_UPDATE_ATTEMPTED asc"
Does anyone have an idea what this error means?
Accepted answer
You need to check the log files and see the full stack in order to understand the error message. In a few cases that I can see, the error was caused by a closed connection (or CLM lost the database connection). Without further debugging, the general approach is to increase the JDBC pool size. If you need to know the cause before doing anything, you need to involve your Oracle DBA to check the database log files, and you can also open a ticket with Support.