Import validation failed
Moderators: chulett, rschirm, roy
Import validation failed
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
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
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 288
- Joined: Tue May 27, 2008 3:42 am
- Location: Luxembourg
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?us1aslam1us wrote:I think you need to specify the width in you environment variable setting ,APT_GFIX_Decimal.
Thanks
Tony
BI Consultant - Datastage
BI Consultant - Datastage