Need a urgent help from all PX Guru's
![Cool 8)](./images/smilies/icon_cool.gif)
I have got a situation, all of my jobs are compiling well except one its failing when I add a otherwise condition in constraints .
I have rejects set to a "@TRUE" Condition and "Otherwise" to Inserts in transformer ,when I validate my values in stage variable . I have tried most of combinations but it never works . Where as all the other job r working fine and all my conversions are right .
=============================
Without constraints this job compiles well
=============================
It Fails with following error :-
Output from transformer compilation follows:
##I TFCN 000001 17:19:18(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 17:19:18(001) <main_program> The open files limit is 100; raising to 1000.
##I TOSH 000002 17:19:18(002) <main_program> orchgeneral: loaded
##I TOSH 000002 17:19:18(003) <main_program> orchsort: loaded
##I TOSH 000002 17:19:18(004) <main_program> orchstats: loaded
##I TFSC 000001 17:19:18(007) <main_program> APT configuration file: /opt/product/Ascential/DataStage/Configurations/FourOption.apt
##I TFSC 000000 17:19:18(008) <main_program>
This step has no datasets.
It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
NumberOneOfTwo[op0,p0]
)}
It runs 1 process on 1 node.
##I TFOP 000094 17:19:20(000) <APT_LicenseCountOp in APT_LicenseOperator,0> Output 0 produced 1 records.
##I TLIC 000163 17:19:20(001) <APT_LicenseCheckOp in APT_LicenseOperator,0> Input 0 consumed 1 records.
##W TCOS 000049 17:19:20(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E TBLD 000000 17:32:29(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256.
##E TFSR 000019 17:32:29(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 17:32:29(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W TFCP 000025 17:32:29(003) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 17:32:29(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 17:32:29(005) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 17:32:29(006) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 17:32:29(007) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(008) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(009) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(010) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(011) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(012) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(013) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(014) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(015) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(016) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(017) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(018) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(019) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(020) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(021) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(022) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(023) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(024) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(025) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(026) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(027) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(028) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(029) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(030) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(031) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(032) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(033) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(034) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(035) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(036) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(037) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(038) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(039) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(040) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(041) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(042) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(043) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(044) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(045) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(046) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(047) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(048) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(049) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(050) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(051) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(052) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(053) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(054) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(055) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(056) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(057) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(058) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(059) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(060) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(061) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(062) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(063) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(064) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(065) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(066) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(067) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(068) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(069) <transform> Error when checking composite operator: Converting decimal to string.
##W TFCP 000000 17:32:29(070) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "String".
##W TFCP 000025 17:32:29(071) <transform> Error when checking composite operator: Converting string to decimal.
##W TFCP 000000 17:32:29(072) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W TFCP 000025 17:32:29(073) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 17:32:29(074) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TBLD 000000 17:32:29(075) <main_program> Error when checking composite operator: Output from subprocess: CC: Fatal error in iropt: Segmentation Fault
##I TFCP 000000 17:32:29(076) <transform> Error when checking composite operator: /opt/product/SUNWspro/bin/CC -KPIC -O -I/opt/product/Ascential/DataStage/PXEngine/include -dalign -O -PIC -library=iostream -c /opt/product/Ascential/DataStage/Projects/CHUB_Development/RT_BP318.O/V0S10_Contract_Validate_Fields_test_ValidateFields.C -o /opt/product/Ascential/DataStage/Projects/CHUB_Development/RT_BP318.O/V0S10_Contract_Validate_Fields_test_ValidateFields.tmp.o.
##E TCOS 000029 17:32:29(077) <main_program> Creation of a step finished with status = FAILED. (Contract_Validate_Fields_test.ValidateFields)
Regards
Yajuwendra
![Sad :(](./images/smilies/icon_sad.gif)
[/code]