Page 1 of 1

GIVING FAILURE WHEN EXTRACT DATA

Posted: Tue Sep 01, 2009 5:34 am
by deesh
Hi Friends,
When I am extracting data, job has been failure. I checked OPJAGA Column has Nvarchar(6) but its giving problem,
Can any one tell what the exact problem


Failure:

ODB_TABLE: [IIS-CONN-DAAPI-000399] Schema reconciliation detected a size mismatch for column OPJAGA. When reading database column WVARCHAR(min=0,max=36) into column WVARCHAR(min=0,max=6), truncation, loss of precision or data corruption can occur. (CC_DBSchemaRules::reportSizeMismatch, file CC_DBSchemaRules.cpp, line 1 616)

Posted: Tue Sep 01, 2009 5:36 am
by ArndW
Your database allows nVarChar(36) and that won't fit into your jobs nvarchar(6). Correct your column width in your job to match that of the data.