Truncation warning

stiantok · Post by **stiantok** » Mon Oct 27, 2014 3:07 am

I get the following warning when using the PXPivot-stage in a job:
"When checking operator: When binding output interface field "TYPE" to field "TYPE": Implicit conversion from source type "string" to result type "string[max=1]": Possible truncation of variable length string." I have looked over the data types and lengths, everything looks fine.

For some reason, the warning only appears in the production environment, and not in dev. or test.

What is the best way to get rid of this warning?

ray.wurlod · Post by **ray.wurlod** » Mon Oct 27, 2014 7:11 am

The input is a string type with no length (precision). The output is a VarChar with a length (precision) of 1. These do not match. Make them match.

stiantok · Post by **stiantok** » Mon Oct 27, 2014 7:36 am

I have checked the lengths, they all match, so that is not the source of the problem.

PaulVL · Post by **PaulVL** » Mon Oct 27, 2014 7:56 am

You misunderstood Ray's reply.

Make the METADATA match.

Mike · Post by **Mike** » Mon Oct 27, 2014 8:01 am

Your warning message says otherwise. I think you've missed the mismatch. Add the reporting environment variable that writes all schemas to the job log and look for the TYPE string field with no length specification. I don't recall the exact variable, but its something like $OSH_PRINT_SCHEMAS.

Mike

chulett · Post by **chulett** » Mon Oct 27, 2014 8:07 am

It is exactly like that.