Reporter Job Run Extraction aborts with SQL data type error message

book

Article ID: 195375

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

Extract aborting with the following message:

Process ABORTED. Status changed to ABORTED. 
Reason: java.util.concurrent.ExecutionException: com.microsoft.sqlserver.jdbc.SQLServerException: 
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

 

Enabling Tracing in Reporter's log4j.xml file shows the same error message:

[ERROR] 16 Jul 2020 18:43:45 [pool-1-thread-14] com.orsyp.reppub.server.reporter.extractor.owls.OwlsExecutionsExtractor - ReporterExtractManager process - error raised from EXECUTIONS
[TRACE] 16 Jul 2020 18:43:45 [pool-1-thread-14] com.orsyp.reppub.server.reporter.extractor.owls.OwlsExecutionsExtractor - Root cause for failed execution:
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
 at com.orsyp.reppub.server.reporter.extractor.owls.OwlsExecutionsExtractor.process(OwlsExecutionsExtractor.java:479)
 at com.orsyp.reppub.server.reporter.extractor.owls.OwlsExecutionsExtractor.process(OwlsExecutionsExtractor.java:41)
 at com.orsyp.reppub.server.reporter.extractor.owls.OwlsAbstractExtractor.handle(OwlsAbstractExtractor.java:156)
 at com.orsyp.reppub.server.reporter.extractor.owls.OwlsExecutionsExtractor$1.add(OwlsExecutionsExtractor.java:190)
 at com.orsyp.reppub.server.reporter.extractor.owls.OwlsExecutionsExtractor$1.add(OwlsExecutionsExtractor.java:187)
 at com.orsyp.owls.impl.hr.HrDatMsgHelper.populateList(HrDatMsgHelper.java:293)
 at com.orsyp.owls.impl.hr.OwlsDatListImpl$OwlsDatSelector.populateList(OwlsDatListImpl.java:89)
 at com.orsyp.owls.impl.hr.OwlsDatListImpl$OwlsDatSelector.populateList(OwlsDatListImpl.java:70)
 at com.orsyp.owls.impl.AbstractSelector$DefaultHandler.handle(AbstractSelector.java:171)
 at com.orsyp.owls.impl.AbstractSelector.select(AbstractSelector.java:230)
 at com.orsyp.owls.impl.AbstractSelector.select(AbstractSelector.java:147)
 at com.orsyp.owls.impl.AbstractSelector.select(AbstractSelector.java:123)
 at com.orsyp.owls.impl.hr.OwlsDatListImpl.extract(OwlsDatListImpl.java:55)
 at com.orsyp.reppub.server.reporter.extractor.owls.OwlsExecutionsExtractor.extract(OwlsExecutionsExtractor.java:196)
 at com.orsyp.reppub.server.reporter.extractor.owls.OwlsAbstractExtractor.call(OwlsAbstractExtractor.java:195)
 at com.orsyp.reppub.server.reporter.extractor.owls.OwlsAbstractExtractor.call(OwlsAbstractExtractor.java:18)
 at java.util.concurrent.FutureTask.run(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)
[ERROR] 16 Jul 2020 18:43:46 [pool-1-thread-14] com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL - Error in ExtractionSourceETL:runETL() process. Reason: 
java.util.concurrent.ExecutionException: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Cause

When the extraction has a problem with a date, the Reporter extraction aborts.

Environment

Release : 6.x
Component : Reporter Server

 

Resolution

Update to a fix version listed below or a newer version if available.

Fix version(s): 
Component: Reporter.Server
Dollar Universe 6.10.51 - Released 28th October 2020




Additional Information

Workaround:
Get a uxtrace and then reinitialize the u_fmhr60 data file, which contains Statistics and Reporter information.
This may clean out the record that is causing the data type error.