Failure of Job: Load parts of data and then stopped due to error

[Former Member]

Hi there,

I'm doing a load job to load data from SAP ERD to SQL datawarehouse. The job  has run well for a few seconds and then stopped due to error. Only 3600 out of 9401 records loaded to the target table in SQL DW. The error message hidden for some reason. I did the User Security setting in CMC, however, it still did not display the details. Any hint would be appreciated!

[former_member187605 · Accepted solution]

A target field is not big enough to hold your data. This can be due to a difference in character set. Use nvarschar datatype for your SQL columns.

[Former Member · Accepted solution]

Hi Dirk,

I did find the problem. I made a couple of mistakes on the type of columns when I created the target table. But I realized it until I checked the columns one by one. How did you catch the problem from the error log? Which line gave you signal? It did not make sense for me since the error detail was hidden. Thanks a lot for your answer!

Cindy

[former_member187605 · Accepted solution]

First line: String or binary data would be truncated.