It's all about the answers!

Ask a question

Data Warehouse "Requirements" Job Fails Every Night

Dave Evans (14812846) | asked Feb 18 '14, 8:01 p.m.
edited Feb 18 '14, 8:07 p.m.


Ever since we upgraded from 401 to 405, the "Requirements" Data Collection Job has failed almost every night. It runs for about 2 hours and 40 minutes. I notice errors in both the jts-etl and jts-etl-driver logs at the time of failure:

java.sql.sqlexception: Connection reset

Any ideas what would be causing the connection to be reset/this failure to occur?



jts-etl.log snippet:

ERROR ouse.service.rrc.internal.RemoteRRCSnapshotService  - java.sql.SQLException: Connection reset
 WARN  - Preceding event: 'CALL' from 'RRCRequirementETL::resetInitialCounts()'
 WARN  - Preceding event: 'CALL' from 'RRCCustomAttributeETL::initPrepareStatements(?)'
 WARN  - Preceding event: 'CALL' from 'RRCCustomAttributeETL::resetInitialCounts'
 WARN  - Preceding event: 'CALL' from 'RRCRequirementsLookupsETL::initPrepareStatements(?)'
 WARN  - Preceding event: 'CALL' from 'RRCRequirementsLookupsETL::resetInitialCounts()'
 WARN  - Preceding event: 'CALL' from 'RRCExternalLinkETL::initPrepareStatements(?)'
 WARN  - Preceding event: 'CALL' from 'RRCExternalLinkETL::resetInitialCounts()'
 WARN  - Preceding event: 'Get page - RRC requirements' from 'RemoteRRCSnapshotService::updateSnapshot(?)'
 WARN  -  Event subject: 0
 WARN  - Preceding event: 'CALL' from 'RemoteRRCSnapshotService::getNextResourcesPage(Connection con, String resourceGroupName, String modifiedSince, int pageSize, boolean linksOnly, boolean[] more'
 WARN  -  Event subjects:
 WARN  -
 WARN  -  2014-01-30 00:00:00.0
 WARN  -  100
 WARN  -  [Z@2a77a15b
 WARN  - Suspect event: 'Querying the XDC table' from 'RemoteRRCSnapshotService::getNextResPage(?,...)'

HÃ¥kan Kristiansson commented Feb 19 '14, 1:37 a.m.

What do you see in the rm.log and jts.log at the same you get the above error? It might shed some lights on what's going on.

Dave Evans commented Feb 19 '14, 3:16 p.m.

Nothing is reported in the jts or rm logs within an hour of the error reported in jts-etl and jts-etl-driver logs.

One answer

permanent link
Ralph Schoon (63.1k33646) | answered Feb 19 '14, 2:18 a.m.
Dave, you probably want to open a PMR with support, or open a work item to be able to share logs and collaborate on this.

Dave Evans commented Feb 19 '14, 3:17 p.m.

Yes... I always forget about the comment length limitation. I will open a PMR tomorrow if a change I am trying doesn't fix it tonight. Thanks!

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.