DSXchange

Posted: **Thu Jul 29, 2010 6:56 pm**

Job Design

DatasetStage--> Copy --> InvestigateStage--> Peek

Warning

Code: Select all

CopyToAll: When checking operator: When binding output schema variable "outRec": When binding output interface field "NameDomain_USPREP" to field "NameDomain_USPREP": Implicit conversion from source type "ustring[max=100]" to result type "string[max=100]": Possible truncation of variable length ustring when converting to string using codepage UTF-8.

In Investigate stage uses Character Concatenate Investigate option, whenever this investigation option is selected we see the above error. As there is no option to set NULL VALUE=" " how to eliminate this warning apart from supression using message handler?

Thanks for all your replies
Prasad

Posted: **Thu Jul 29, 2010 8:40 pm**

Your use of the extended property Unicode is inconsistent across the stage. A ustring[max=100] is a VarChar(100) with Unicode set, a string[max=100] is a VarChar(100) with Unicode not set. Find this discrepancy and fix it.

Posted: **Fri Jul 30, 2010 10:52 am**

Yes I have given all the columns SqlType as Varchar and Extended Unicode, still I am getting the error.
The error occurs only when used Character Concatenate investigate type, for the same column (no change in the job or column name, ....) when Character Discrete Investigate type is selected the job runs fine without warning.

Posted: **Fri Jul 30, 2010 1:51 pm**

Are you able to remove Unicode from all the fields you are mentioning in the concatenation as a test? It may be that the internal result of concatenation is the "field" that is at fault here.

Posted: **Mon Aug 02, 2010 2:42 pm**

With or Without Unicode, I get the same warning

Posted: **Mon Aug 02, 2010 4:35 pm**

OK, use a message handler to demote the warning to informational. This is a message that is unlikely to impact your processing of data.

Posted: **Mon Aug 02, 2010 5:12 pm**

Thanks.

DSXchange

QS - character concatenate investigate - warning message

QS - character concatenate investigate - warning message