GIVING FAILURE WHEN EXTRACT DATA

deesh · Post by **deesh** » Tue Sep 01, 2009 5:34 am

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)

ArndW · Post by **ArndW** » Tue Sep 01, 2009 5:36 am

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.