Job can run in Talend Open Studio but failed in TIC Fall 18 ( Talend Management Console)

[Anonymous]

Hi, 

I have a job which job can run on talend open studio, but when I publish into TIC, the job can't running successfully. 
I use Talend Open Studio Version 7.0.1. 

Error on TIC : Job ENDED WITH ERROR at 2018/11/29 12:49:47 (jobId=5bff56abbffc2d357f25470a_3.6, jobExecutionId=20181129124947_8w5Nu) ### Exception in component tFileInputDelimited_2 (lyr3_etrack_dim_sp_progress_status_cek) java.lang.RuntimeException: Couldn't parse value for column 'id' in 'row1', value is .....

Thanks,

[manodwhb]

@TSR,what was the data type in id column in file and the component?

[Anonymous]

Hi Manohar,

The data type in column both of file and component is integer. 

Thanks, 

[Anonymous]

Hi,

   You will have to build your job in the subscription version if you have to schedule the job in Talend Cloud. You will not be able to create the job in Open Studio and schedule them in Talend Cloud.

    If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

[Anonymous]

Hi Nikhil, 

I already re-build the new job and still same issue. 

Actually, I used a context for the delimiter for TIC.

And the error seems cannot convert the string value into a number value.

I tried to change to hardcode the context, and re-publish the job.
And the job can run successfully.

is there any bug for new tic version?

thanks,

[Anonymous]

@TSR,

     Could you please share the screenshots of the job and the details of the context what you are going to pass? It will help us to do better analysis.

Warm Regards,

Nikhil Thampi