Starting job jb_hxeu_migrated_policy_job at 13:20 07/08/2023.
[statistics] connecting to socket on port 3931
[statistics] connected
[ tLogger_1 ], Logger Id is missing. The job will write its log to the console (Talend environment)
Exception in component tDBInput_1 (jb_hxeu_migrated_policy_job)
org.talend.components.api.exception.ComponentException: SQL_ERROR:{message=The multi-part identifier "context.timeDifferenceToPolicyCreation" could not be bound.}
at org.talend.components.jdbc.CommonUtils.newComponentException(CommonUtils.java:588)
at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:239)
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
at hiscox.jb_hxeu_migrated_policy_job_0_1.jb_hxeu_migrated_policy_job.tDBInput_1Process(jb_hxeu_migrated_policy_job.java:2126)
at hiscox.jb_hxeu_migrated_policy_job_0_1.jb_hxeu_migrated_policy_job.tDBConnection_1Process(jb_hxeu_migrated_policy_job.java:988)
at hiscox.jb_hxeu_migrated_policy_job_0_1.jb_hxeu_migrated_policy_job.runJobInTOS(jb_hxeu_migrated_policy_job.java:7987)
at hiscox.jb_hxeu_migrated_policy_job_0_1.jb_hxeu_migrated_policy_job.main(jb_hxeu_migrated_policy_job.java:7761)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The multi-part identifier "context.timeDifferenceToPolicyCreation" could not be bound.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:232)
... 5 more
[ tLogger_1 ], error : SQL_ERROR:{message=The multi-part identifier "context.timeDifferenceToPolicyCreation" could not be bound.}
org.talend.components.api.exception.ComponentException: SQL_ERROR:{message=The multi-part identifier "context.timeDifferenceToPolicyCreation" could not be bound.}
at org.talend.components.jdbc.CommonUtils.newComponentException(CommonUtils.java:588)
at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:239)
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
at hiscox.jb_hxeu_migrated_policy_job_0_1.jb_hxeu_migrated_policy_job.tDBInput_1Process(jb_hxeu_migrated_policy_job.java:2126)
at hiscox.jb_hxeu_migrated_policy_job_0_1.jb_hxeu_migrated_policy_job.tDBConnection_1Process(jb_hxeu_migrated_policy_job.java:988)
at hiscox.jb_hxeu_migrated_policy_job_0_1.jb_hxeu_migrated_policy_job.runJobInTOS(jb_hxeu_migrated_policy_job.java:7987)
at hiscox.jb_hxeu_migrated_policy_job_0_1.jb_hxeu_migrated_policy_job.main(jb_hxeu_migrated_policy_job.java:7761)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The multi-part identifier "context.timeDifferenceToPolicyCreation" could not be bound.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:232)
... 5 more
[ tLogger_1 ], Logger Id is missing. The job will write its log to the console (Talend environment)
[statistics] disconnected
Job jb_hxeu_migrated_policy_job ended at 13:20 07/08/2023. [Exit code = 1]