Flat file parsing error (APT_ParseError) ?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mctny
Charter Member
Charter Member
Posts: 166
Joined: Thu Feb 02, 2006 6:55 am

Flat file parsing error (APT_ParseError) ?

Post by mctny »

I am having big difficulties in running a simple job that I designed, it just takes a text file which I produced from MS access by exporting with delimiter | and no text qualifier.
however my DataStage job cannot parse this file and abort it. The message is below,

any suggestions?

Event #:35
Timestamp:8/4/2006 11:37:31 AM
Event type:Warning
User:dsadmin
Message:
main_program: An NLS character map <windows-1252> is specified, but no entry was found in $APT_ORCHHOME/etc/oracle_cs.txt.

Event #:36
Timestamp:8/4/2006 11:37:31 AM
Event type:Fatal
User:dsadmin
Message:
main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Parsing parameters "max=0" for schema type "ustring": Max length must be positive, got: "0"
Could not find type: ustring[max=0]

Event #:37
Timestamp:8/4/2006 11:37:37 AM
Event type:Control
User:dsadmin
Message:
Job State_Agency_Ach_Rate_v0 aborted.
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Parsing parameters "max=0" for schema type "ustring": Max length must be positive, got: "0"
Could not find type: ustring[max=0]
See if you have any Unicode in Extended tab of the column definitions.
Changing char to varchar may do the trick I am not sure about it but try changing data types.To better analyze your problem can you post your schema/defintion.
Kris

Where's the "Any" key?-Homer Simpson
Post Reply