Error in job

Anonymous — Mon, 01 Jul 2019 11:32:25 GMT

Hello!

I am running a job with Webhook which gets triggered when user uploads a file in an application. The job was running fine until yesterday. There was no change done to the job but it fails with following error. I am not able to understand the exact issue. Can anyone help?

Task 'job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook' failed at Mon Jul 01 09:41:50 UTC 2019.

Failure details:
Failure type: UNDEFINED_ERROR
Failure message: Step 9db9a801-9ea5-46fa-b5dd-1236c2c362ed failed with code -1 and error Job stopped with errors or unable to run. ### Job STARTED at 2019/07/01 11:41:41 (jobId=f09a26baa43e171536713, jobExecutionId=20190701114141_21jxn) ### Info: Parameter "Conn_AzureSQLDB_Schema_DQ" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_Schema_EM" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DM_AdditionalParams" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DM_Database" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DM_Login" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DM_Password" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DM_Port" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DM_Schema" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DM_Server" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DQ_AdditionalParams" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DQ_Database" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DQ_Login" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DQ_Password" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DQ_Port" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DQ_Schema" is a new parameter of Implicit_Context_Context Info: Parameter "Conn_AzureSQLDB_DQ_Server" is a new parameter of Implicit_Context_Context Info: Parameter "EBK_Application_CodeFilePath" is a new parameter of Implicit_Context_Context Info: Parameter "Metadata_STD_FK_MISSINGINPUT" is a new parameter of Implicit_Context_Context Info: Parameter "Metadata_STD_FK_NOMATCH" is a new parameter of Implicit_Context_Context Info: Parameter "Metadata_STD_VALID_FROM_DATE" is a new parameter of Implicit_Context_Context Info: Parameter "Metadata_STD_VALID_TO_DATE" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_AKV_Secrets_Name_AzureSQLDB_TalendContextUser" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_AKV_Secrets_Name_AzureSQLDB_TalendDQUser" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_AKV_Secrets_Name_Dalux_API_Key" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_AKV_Secrets_Version_AzureSQLDB_TalendContextUser" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_AKV_Secrets_Version_AzureSQLDB_TalendDQUser" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_AKV_Secrets_Version_Dalux_API_Key" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_AKV_Secrets_Name_RegAppSP_ClientSecret" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_AKV_Secrets_Verison_RegAppSP_ClientSecret" is a new parameter of Implicit_Context_Context Info: Parameter "OP_AzureAS_Refresh_BaseURL" is a new parameter of Implicit_Context_Context Info: Parameter "OP_AzureAS_Refresh_Server" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_RegAppSP_Tenant" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_RegAppSP_ClientID" is a new parameter of Implicit_Context_Context Info: Parameter "Sec_RegAppSP_ClientSecret" is a new parameter of Implicit_Context_Context Warning: Parameter "SPClientSecret" has not been set by Implicit_Context_Context Warning: Parameter "Sec_AKV_Secrets_Name_TalendServicePrincipalClientID" has not been set by Implicit_Context_Context Warning: Parameter "SPClientID" has not been set by Implicit_Context_Context Warning: Parameter "resource_webhook_payload" has not been set by Implicit_Context_Context Warning: Parameter "Sec_AKV_Secrets_Name_TalendServicePrincipalKey" has not been set by Implicit_Context_Context Warning: Parameter "Sec_AKV_Secrets_Version_ADLS_FSErfaringsbasertKalkyle" has not been set by Implicit_Context_Context Warning: Parameter "webhook_payload" has not been set by Implicit_Context_Context Warning: Parameter "Sec_AKV_Secrets_Name_ADLS_FSErfaringsbasertKalkyle" has not been set by Implicit_Context_Context 2019-07-01 11:41:42|20190701114141_21jxn|20190701114141_21jxn|20190701114141_21jxn|4300|TALEND_INNSIKTSFABRIKKEN|job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook|_pXkawUV4EemAarxQRpYUOA|0.4|Default||begin|| 2019-07-01 11:41:49|20190701114141_21jxn|20190701114141_21jxn|20190701114141_21jxn|TALEND_INNSIKTSFABRIKKEN|job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook|Default|6|Java Exception|tMap_1|java.lang.NullPointerException:null|1 2019-07-01 11:41:49|20190701114141_21jxn|20190701114141_21jxn|20190701114141_21jxn|4300|TALEND_INNSIKTSFABRIKKEN|job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook|_pXkawUV4EemAarxQRpYUOA|0.4|Default||end|failure|7238 Exception in component tMap_1 (job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook) java.lang.NullPointerException at talend_innsiktsfabrikken.job_sa_ebk_solibri_mengdedata_webhook_0_4.job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook.tFileInputExcel_1Process(job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook.java:23363) at talend_innsiktsfabrikken.job_sa_ebk_solibri_mengdedata_webhook_0_4.job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook.tJava_1Process(job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook.java:20684) at talend_innsiktsfabrikken.job_sa_ebk_solibri_mengdedata_webhook_0_4.job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook.runJobInTOS(job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook.java:27980) at talend_innsiktsfabrikken.job_sa_ebk_solibri_mengdedata_webhook_0_4.job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook.main(job_SA_EBK_SOLIBRI_MENGDEDATA_Webhook.java:27614) ### Job ENDED WITH ERROR at 2019/07/01 11:41:49 (jobId=f09a26baa43e171536713, jobExecutionId=20190701114141_21jxn) ###

Regards

Priya

Re: Error in job

Anonymous — Thu, 04 Jul 2019 08:04:26 GMT

Hello,

Would you mind posting your job setting screenshots on community which will be helpful for us to address your issue?

Best regards

Sabrina

Re: Error in job

Anonymous — Tue, 09 Jul 2019 08:27:25 GMT

Hello!

The error got resolved by itself! The next few runs had no issue.

Regards

Priya

topic Error in job in Talend Studio

Error in job

Re: Error in job

Re: Error in job