Import validation failed

nitin376 · Post by **nitin376** » Thu Oct 05, 2006 12:59 pm

hi,

The job details as follows:
Source is a sequentail stage , thus extracting flat file and then loading into the transformer to add some rows into the input data .

The issue: Import validation failed error

Error details:

sq_CurrentShipList: Import validation failed

sq_CurrentShipList: At field "Balanced_Qty": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=10, scale=0, round=trunc_zero, ascii}
At field "Balanced_Qty": Error validating import/export function

please help me to resolve the above issue

thanks,
nitin

thumsup9 · Post by **thumsup9** » Thu Oct 05, 2006 1:23 pm

Check your metadata for Balanced_Qty, did you mention the same scale and precision for the field as it appears in the data.

nitin376 · Post by **nitin376** » Thu Oct 05, 2006 1:36 pm

I did check the metadata for Balanced_Qty, there is no dissimilarity. Both are numeric (10) ...I don't know why its giving the validation failed error ?

us1aslam1us · Post by **us1aslam1us** » Thu Oct 05, 2006 2:21 pm

I think you need to specify the width in you environment variable setting ,APT_GFIX_Decimal.

Sam

ray.wurlod · Post by **ray.wurlod** » Thu Oct 05, 2006 2:37 pm

Is this a delimited or fixed-width file?

nitin376 · Post by **nitin376** » Sat Oct 07, 2006 5:18 pm

hi ray !

this is fixed width

kumar_s · Post by **kumar_s** » Sun Oct 08, 2006 12:53 am

Is it a compilation error or runtime or error during import?
Is Balanced_Qty not a decimal field?
BTW: Are you adding up some extra rows or columns in the transformer?
Were you able to view the data from the sequential file?

ray.wurlod · Post by **ray.wurlod** » Sun Oct 08, 2006 5:41 am

Read this part of the error message very carefully again.

Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property?

What property do you think you need to set?

TonyInFrance · Post by **TonyInFrance** » Tue Apr 17, 2012 2:48 am

us1aslam1us wrote:I think you need to specify the width in you environment variable setting ,APT_GFIX_Decimal.

Is this done by adding an environment variable APT_GFIX_Decimal in the Administrator module? The type would be String I guess. What value should we pit as default?

Thanks