I am running a job where source is oracle and target is oracle.
My source contain user defined SQL where i perform left outer join and based on a filter condition in tranformer i move data to target oracle table(truncate and load)
job is aborting with below error message.There are total 6 columns 4( 2 are nullable) are character fields and 2 are date fields.
Code: Select all
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]