Bods job failed - process is not dumped

[siba_pkd21]

Hi All

A Data Services Job failed with below error. Please anyone assist me with this error.

Regards

Siba

[RichS]

Compare the actual column data types in MS SQL for your source table(s) with those in the corresponding schema(s) imported into Data Services. I think you will find that one or more columns had an unsupported datatype and was created in BODS with a shorter length (or as a LONG).

[akhileshkiran]

Hi @siba_pkd21 

The data which you are sending from the source side is having more length than the expected value that is restricted in the filed target side.

Please validate the data max source data length and target filed column filed data type.

Example: 

Source Mapping: varchar(15),
Data: '000000000012345' 

Target Mapping: varchar(14),
Data: '000000000001234'

due to the truncation of the data the job is getting failed.