BusinessObjects Board

String or binary data would be truncated

dataservices rapidmarts
#1

Hi,

Please advise on the following error on job execution.

11872 14724 DBS-070401 1/17/2014 11:49:01 AM |Sub data flow DF_LedgerFactNewGLActual_SAP_2|Loader OrderingQuery_LEDGER_FACT_VR
11872 14724 DBS-070401 1/17/2014 11:49:01 AM ODBC data source error message for operation : <[Microsoft][SQL Server Native Client 10.0][SQL
11872 14724 DBS-070401 1/17/2014 11:49:01 AM Server]String or binary data would be truncated.
11872 14724 DBS-070401 1/17/2014 11:49:01 AM [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.

its_ranjan (BOB member since 2011-02-16)

#2

Sai, I bet this error is posted in forum and we have discussed. Could you search it through?

ganeshxp :us: (BOB member since 2008-07-17)

#3

Hi Ganesh,

This one seems to be not found in the earlier posts.

The issue came up apparently when fact table was modified to add more fields and job give for run. Though the fields are correctly mapped and unique constraints verified properly set with ‘delete data before loading’ in target table properties to ensure no duplicates, the error seem to be not clear enough to debug further.
DT transform splits into sub data flows, 1st one works well though 2nd one fails.

its_ranjan (BOB member since 2011-02-16)

#4

Well, what I remember vaguely is this is actually an issue with codepage…

Are you doing bulk loading to the target?

ganeshxp :us: (BOB member since 2008-07-17)

#5

Hi Ganesh.

I checked there is not bulk loading used in target.

The log message has:-

The specified locale <eng_gb.cp1252> has been coerced to <Unicode (UTF-18)

its_ranjan (BOB member since 2011-02-16)