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.
Flat file parsing error (APT_ParseError) ?
Moderators: chulett, rschirm, roy
Flat file parsing error (APT_ParseError) ?
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 !"
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 !"
See if you have any Unicode in Extended tab of the column definitions.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]
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
Where's the "Any" key?-Homer Simpson