Data Truncation error in store procedure job

Shafee — Wed, 13 Dec 2017 14:27:26 GMT

I have placed the Store Procedure in the tMSSqlSP component.

Data truncation error appear in talend job but no error when store procedure is executed manually.

Starting job Job_Clarity_Resource_by_Practice_000_Staging_To_Cdl at 19:13 13/12/2017.

[statistics] connecting to socket on port 3474
[statistics] connected
Data truncation
[ERROR]: imss.job_clarity_resource_by_practice_000_staging_to_cdl_0_1.Job_Clarity_Resource_by_Practice_000_Staging_To_Cdl - talendStats_DB - Data truncation
Data truncation
[ERROR]: imss.job_clarity_resource_by_practice_000_staging_to_cdl_0_1.Job_Clarity_Resource_by_Practice_000_Staging_To_Cdl - talendStats_DB - Data truncation
[statistics] disconnected
Job Job_Clarity_Resource_by_Practice_000_Staging_To_Cdl ended at 19:13 13/12/2017. [exit code=0]

Re: Data Truncation error in store procedure job

Anonymous — Fri, 15 Dec 2017 06:43:05 GMT

Hello,

Could you please post your job setting screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

topic Re: Data Truncation error in store procedure job in Talend Studio

Data Truncation error in store procedure job

Re: Data Truncation error in store procedure job