Untitled
plain_text
2 months ago
4.8 kB
1
Indexable
Never
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]