Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Shafee
Contributor
Contributor

Data Truncation error in store procedure job

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]

 

 

Labels (2)
1 Reply
Anonymous
Not applicable

Hello,

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

Best regards

Sabrina