DSXchange

A short text to describe your forum
http://dsxchange.com./

error while compiling

http://dsxchange.com./viewtopic.php?f=8&t=91347

Page 1 of 1

error while compiling

Posted: Thu Feb 17, 2005 10:01 am
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];
^^^^

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

Posted: Thu Feb 17, 2005 10:31 am
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!

Re: error while compiling

Posted: Tue Feb 22, 2005 1:57 pm
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.

Re: error while compiling

Posted: Tue Feb 22, 2005 2:40 pm
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
All times are UTC-06:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited