Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
4.8 kB
1
Indexable
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]