error while compiling

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
lory
Participant
Posts: 21
Joined: Tue Apr 13, 2004 9:05 am

error while compiling

Post by lory »

When i am trieng to compile a parallel job it is giving the following error. My job consits of three oracle Enterprise stage as source one transformer and sequential file as target, it is direct mapping from source to target, there are some stage variables.

Output from transformer compilation follows:

##I TFCN 000000 16:56:38(000) <main_program>
DataStage XE Parallel Extender V6.0.1
Copyright (C) 1997 - 2002 Ascential Software, Inc.
All Rights Reserved


##I TOSH 000010 16:56:38(001) <main_program> orchgeneral: loaded
##I TOSH 000010 16:56:38(002) <main_program> orchsort: loaded
##I TOSH 000010 16:56:38(003) <main_program> orchstats: loaded
##I TFSC 000000 16:56:38(004) <main_program> APT configuration file: /softwcetl2/app/Ascential/Ascential/DataStage/Configurations/conf14Nodi.apt
##I TFPA 000005 16:56:38(005) <main_program> APT Startup script: /softwcetl2/app/Ascential/Ascential/DataStage/PXEngine/etc/startup.apt
hostname=dwh14 windowid=49
hostname=ptgnl8 windowid=57
hostname=ptgnl6 windowid=55
hostname=ptgnl2 windowid=51
hostname=ptgnl3 windowid=52
hostname=ptgnl10 windowid=59
hostname=ptgnl5 windowid=54
hostname=ptgnl14 windowid=63
hostname=ptgnl13 windowid=62
hostname=ptgnl9 windowid=58
hostname=ptgnl4 windowid=53
hostname=ptgnl12 windowid=61
hostname=ptgnl7 windowid=56
hostname=ptgnl11 windowid=60
WARNING:TFCP 16:56:45(000) <transform> transform/transform.C(1.9.2.16),885: The number of reject datasets "0"is less than the number of input datasets "1".
WARNING:TFCP 16:56:45(001) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(002) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(003) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(004) <transform> transform/evalexp.C(1.8.2.22),3271: Possible range limitation
WARNING:TFCP 16:56:45(005) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Int32" to result type "Decimal".
WARNING:TFCP 16:56:45(006) <transform> transform/evalexp.C(1.8.2.22),3271: Possible range limitation
WARNING:TFCP 16:56:45(007) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Int32" to result type "Decimal".
WARNING:TFCP 16:56:45(008) <transform> transform/transform.C(1.9.2.16),885: The number of reject datasets "0"is less than the number of input datasets "1".
WARNING:TFCP 16:56:45(009) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(010) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(011) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(012) <transform> transform/evalexp.C(1.8.2.22),3271: Possible range limitation
WARNING:TFCP 16:56:45(013) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Int32" to result type "Decimal".
WARNING:TFCP 16:56:45(014) <transform> transform/evalexp.C(1.8.2.22),3271: Possible range limitation
WARNING:TFCP 16:56:45(015) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Int32" to result type "Decimal".
##E TBLD 001017 16:56:45(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 512
##E TFSR 000059 16:56:45(001) <main_program> Could not check all operators because of previous error(s)
##W TBLD 001014 16:56:45(002) <main_program> Error when checking composite operator: Output from subprocess: Error 92: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # Character '' (value 1) was unexpected.
mpCNC_D_DAT[0]=input0TimeStampCNC_D_DAT_COMP[0];
^
Error 20: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # ';' expected before 'COMP'.
pCNC_D_DAT_COMP[0]=input0TimeStampCNC_D_DATCOMP[0];
^^^^
Error 403: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # Undeclared variable 'input0TimeStampCNC_D_DAT'. Perhaps 'input0TimeStampCNC_D_DAT_COMP' as in "APT_InputAccessorToTimeStamp APT_TransformOperatorImplJob_T2::input0TimeStampCNC_D_DAT_COMP" ["/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 91] was intended.
output0TimeStampCNC_D_DAT_EMISSIONE_COMP[0]=input0TimeStampCNC_D_DATCOMP[0];
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Error 172: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # Undeclared variable 'COMP'.
pCNC_D_DAT_COMP[0]=input0TimeStampCNC_D_DATCOMP[0];
^^^^

............
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Lory,

I am assuming you have a design with 3 separate transforms i.e. ORA->Trans->Seq 3 times. A quick look at the errors show that you might be using a column definition of "input0TimeStampCNC_D_DAT_-COMP" (DS doesn't like a hyphen in the definition). And you probably specified the output link in the transform to be a reject; which explains another compiler error. Then do an explicit "cast" of datatypes to get rid of all the type warnings and see if the job runs!
Top
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Re: error while compiling

Post by T42 »

lory wrote:transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
Fix this.
WARNING:TFCP 16:56:45(002) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
Fix this.
WARNING:TFCP 16:56:45(003) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
Fix this.
WARNING:TFCP 16:56:45(004) <transform> transform/evalexp.C(1.8.2.22),3271: Possible range limitation
Fix this.
WARNING:TFCP 16:56:45(005) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Int32" to result type "Decimal".
Fix this.

I could go on, but as you should be aware: When they complain, fix the complaint.

Also...
##W TBLD 001014 16:56:45(002) <main_program> Error when checking composite operator: Output from subprocess: Error 92: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # Character '' (value 1) was unexpected.
mpCNC_D_DAT[0]=input0TimeStampCNC_D_DAT_COMP[0];
^
You forgot a parenthesis.
Error 20: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # ';' expected before 'COMP'.
pCNC_D_DAT_COMP[0]=input0TimeStampCNC_D_DATCOMP[0];
^^^^
Forgot it here too.
output0TimeStampCNC_D_DAT_EMISSIONE_COMP[0]=input0TimeStampCNC_D_DATCOMP[0];
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
And here too.
Error 172: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # Undeclared variable 'COMP'.
pCNC_D_DAT_COMP[0]=input0TimeStampCNC_D_DATCOMP[0];
^^^^
And here too.

You can view your Orchestrate code (if it was enabled.) But again, do not assume that DataStage can handle it. Sure, it can handle it, but geez... fix the warning messages. That's your job.
Top
chalasaniamith
Participant
Posts: 36
Joined: Wed Feb 16, 2005 5:20 pm
Location: IL

Re: error while compiling

Post by chalasaniamith »

lory wrote:When i am trieng to compile a parallel job it is giving the following error. My job consits of three oracle Enterprise stage as source one transformer and sequential file as target, it is direct mapping from source to target, there are some stage variables.

Output from transformer compilation follows:

##I TFCN 000000 16:56:38(000) <main_program>
DataStage XE Parallel Extender V6.0.1
Copyright (C) 1997 - 2002 Ascential Software, Inc.
All Rights Reserved


##I TOSH 000010 16:56:38(001) <main_program> orchgeneral: loaded
##I TOSH 000010 16:56:38(002) <main_program> orchsort: loaded
##I TOSH 000010 16:56:38(003) <main_program> orchstats: loaded
##I TFSC 000000 16:56:38(004) <main_program> APT configuration file: /softwcetl2/app/Ascential/Ascential/DataStage/Configurations/conf14Nodi.apt
##I TFPA 000005 16:56:38(005) <main_program> APT Startup script: /softwcetl2/app/Ascential/Ascential/DataStage/PXEngine/etc/startup.apt
hostname=dwh14 windowid=49
hostname=ptgnl8 windowid=57
hostname=ptgnl6 windowid=55
hostname=ptgnl2 windowid=51
hostname=ptgnl3 windowid=52
hostname=ptgnl10 windowid=59
hostname=ptgnl5 windowid=54
hostname=ptgnl14 windowid=63
hostname=ptgnl13 windowid=62
hostname=ptgnl9 windowid=58
hostname=ptgnl4 windowid=53
hostname=ptgnl12 windowid=61
hostname=ptgnl7 windowid=56
hostname=ptgnl11 windowid=60
WARNING:TFCP 16:56:45(000) <transform> transform/transform.C(1.9.2.16),885: The number of reject datasets "0"is less than the number of input datasets "1".
WARNING:TFCP 16:56:45(001) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(002) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(003) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(004) <transform> transform/evalexp.C(1.8.2.22),3271: Possible range limitation
WARNING:TFCP 16:56:45(005) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Int32" to result type "Decimal".
WARNING:TFCP 16:56:45(006) <transform> transform/evalexp.C(1.8.2.22),3271: Possible range limitation
WARNING:TFCP 16:56:45(007) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Int32" to result type "Decimal".
WARNING:TFCP 16:56:45(008) <transform> transform/transform.C(1.9.2.16),885: The number of reject datasets "0"is less than the number of input datasets "1".
WARNING:TFCP 16:56:45(009) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(010) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(011) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Decimal" to result type "DFloat".
WARNING:TFCP 16:56:45(012) <transform> transform/evalexp.C(1.8.2.22),3271: Possible range limitation
WARNING:TFCP 16:56:45(013) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Int32" to result type "Decimal".
WARNING:TFCP 16:56:45(014) <transform> transform/evalexp.C(1.8.2.22),3271: Possible range limitation
WARNING:TFCP 16:56:45(015) <transform> transform/evalexp.C(1.8.2.22),3275: Implicit conversion from source type "Int32" to result type "Decimal".
##E TBLD 001017 16:56:45(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 512
##E TFSR 000059 16:56:45(001) <main_program> Could not check all operators because of previous error(s)
##W TBLD 001014 16:56:45(002) <main_program> Error when checking composite operator: Output from subprocess: Error 92: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # Character '' (value 1) was unexpected.
mpCNC_D_DAT[0]=input0TimeStampCNC_D_DAT_COMP[0];
^
Error 20: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # ';' expected before 'COMP'.
pCNC_D_DAT_COMP[0]=input0TimeStampCNC_D_DATCOMP[0];
^^^^
Error 403: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # Undeclared variable 'input0TimeStampCNC_D_DAT'. Perhaps 'input0TimeStampCNC_D_DAT_COMP' as in "APT_InputAccessorToTimeStamp APT_TransformOperatorImplJob_T2::input0TimeStampCNC_D_DAT_COMP" ["/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 91] was intended.
output0TimeStampCNC_D_DAT_EMISSIONE_COMP[0]=input0TimeStampCNC_D_DATCOMP[0];
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Error 172: "/dstagecetl2/Projects/PC/RT_BP1852.O/Job_T2.C", line 1917 # Undeclared variable 'COMP'.
pCNC_D_DAT_COMP[0]=input0TimeStampCNC_D_DATCOMP[0];
^^^^

............

First do the Implicit conversion from source type "Decimal" to result type "DFloat". Then run the job agian if there is again errors or warinigns solve them and if ur still facing the problems post the problem then we can figure it out ok
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”