Transformer Compilation Error

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
nani0907
Participant
Posts: 155
Joined: Wed Apr 18, 2007 10:30 am

Transformer Compilation Error

Post by nani0907 »

Hi ,

Iam getting below compilation error.


##I TUTL 000031 05:34:20(001) <main_program> The open files limit is 4506; raising to 65536.
##I TOSH 000002 05:34:20(002) <main_program> orchgeneral: loaded
##I TOSH 000002 05:34:20(003) <main_program> orchsort: loaded
##I TOSH 000002 05:34:20(004) <main_program> orchstats: loaded
##I TFSC 000001 05:38:05(000) <main_program> APT configuration file: /ETL/Ascential/DataStage/Configurations/EDM.apt
##W TCOS 000049 05:38:11(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W TFCP 000000 05:38:11(001) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##E TFCP 000011 05:38:11(002) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(003) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(004) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(005) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(006) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(007) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(008) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(009) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(010) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(011) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(012) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(013) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(014) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(015) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(016) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(017) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(018) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(019) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(020) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(021) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(022) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(023) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(024) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(025) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(026) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(027) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(028) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(029) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(030) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(031) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(032) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(033) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].
##E TFCP 000011 05:38:11(034) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
Could not find type: decimal[0,0].


Please help me where the problem is .
Note:When i am rename to new job or save it as new job,it goes i.e is compilation is happening correctly.
thanks n regards
nani
antonyraj.deva
Premium Member
Premium Member
Posts: 138
Joined: Wed Jul 16, 2008 9:51 pm
Location: Kolkata

Post by antonyraj.deva »

Hi Kumar,
nani0907 wrote:##W TFCP 000000 05:38:11(001) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
In the transformer when reject conditions are specified and no reject file is present then this error will occur.
nani0907 wrote:##E TFCP 000011 05:38:11(002) <transform> Error when checking composite operator: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"
When you mention the data type to be decimal, precision value has to be set as not equal to zero.

--Tony
nani0907
Participant
Posts: 155
Joined: Wed Apr 18, 2007 10:30 am

Post by nani0907 »

Thanks,After specify the scale the error has gone :D
thanks n regards
nani
Post Reply