Hi,
I am trying to use view data from oracle Enterprise stage. The user defined sql is running fine from sqlplus. I have null values set for some columns in user defien dsql columns as follows:
null INTERFACE_HEADER_CONTEXT,
null INTERFACE_LINE_CONTEXT,
null INTERFACE_LINE_ATTRIBUTE1
on view data command I get error:
APT_ParseError: In field "INTERFACE_HEADER_CONTEXT": Parsing parameters "max=0" for schema type "ustring": Max length must
be positive, got: "0"
I have searched the previous posts and one of the possible solution is that I change these values to some non-null value and then set them to null in later stages like transformer stage. Is this the only solution? I mean this would require an additional stage.
For the time being though, I have changed these null values to some non values as follows:
'abcd' INTERFACE_HEADER_CONTEXT,
'abcd' INTERFACE_LINE_CONTEXT,
'abcd' INTERFACE_LINE_ATTRIBUTE1,
Now that error is gone but I get a new error:
Here is the erro log from view data command:
##E IIS-DSEE-TFOR-00089 12:12:22(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFOR-00089 12:12:22(002) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFPM-00040 12:12:22(003) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
##E IIS-DSEE-TFSC-00011 12:12:28(000) <main_program> Step execution finished with status = FAILED.
The complete log from view data command is as follows:
##I IIS-DSEE-TFCN-00001 12:12:17(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4668
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:12:17(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:12:17(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:12:17(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:12:17(004) <main_program> Parameter specified but not used in flow: SrcDbDetails
##W IIS-DSEE-TOSH-00049 12:12:17(005) <main_program> Parameter specified but not used in flow: scrdbuid
##W IIS-DSEE-TOSH-00049 12:12:17(006) <main_program> Parameter specified but not used in flow: srcdbpwd
##W IIS-DSEE-TOSH-00049 12:12:17(007) <main_program> Parameter specified but not used in flow: FromDate
##W IIS-DSEE-TOSH-00049 12:12:17(008) <main_program> Parameter specified but not used in flow: ToDate
##W IIS-DSEE-TOSH-00049 12:12:17(009) <main_program> Parameter specified but not used in flow: PeriodName
##W IIS-DSEE-TOSH-00049 12:12:17(010) <main_program> Parameter specified but not used in flow: RegionCode
##W IIS-DSEE-TOSH-00049 12:12:17(011) <main_program> Parameter specified but not used in flow: srcdbname
##W IIS-DSEE-TDOR-00158 12:12:17(012) <main_program> The NLS character map <ISO-8859-1> specified may not be compatible with
the character set specified by NLS_LANG;
you may get unexpected results from your database.
##W IIS-DSEE-TDOR-00062 12:12:19(001) <Oracle_Enterprise_1> Column AMT_T floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(002) <Oracle_Enterprise_1> Column AMT_B floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(003) <Oracle_Enterprise_1> Column TRANSFER_PRICE_B floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(004) <Oracle_Enterprise_1> Column STD_COST_G floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(005) <Oracle_Enterprise_1> Column STD_COST_C floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(006) <Oracle_Enterprise_1> Column QTY_ORDERED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(007) <Oracle_Enterprise_1> Column QTY_CREDITED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(008) <Oracle_Enterprise_1> Column QTY_INVOICED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(009) <Oracle_Enterprise_1> Column QTY_COSTING floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(010) <Oracle_Enterprise_1> Column LABOR_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(011) <Oracle_Enterprise_1> Column TRAVEL_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(012) <Oracle_Enterprise_1> Column QTY_MATERIAL_USED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:19(013) <Oracle_Enterprise_1> Column ALLOC_AMOUNT floating point decimal is not fully supported; adjusting the scale.
##I IIS-DSEE-TFSC-00001 12:12:19(018) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
##I IIS-DSEE-TFSU-00016 12:12:19(019) <main_program>
This step has 1 dataset:
ds0: {op0[1p] (sequential Oracle_Enterprise_1)
->eCollectAny
op1[1p] (sequential APT_CombinedOperatorController:_EowGenerator)}
It has 2 operators:
op0[1p] {(sequential Oracle_Enterprise_1)
on nodes (
node1[op0,p0]
)}
op1[1p] {(sequential APT_CombinedOperatorController:
(_EowGenerator)
(_Head)
(_PEEK_IDENT_)
(_ABORT_IDENT_)
) on nodes (
node2[op1,p0]
)}
It runs 2 processes on 2 nodes.
##W IIS-DSEE-TFIP-00072 12:12:19(020) <Oracle_Enterprise_1> When checking operator: When binding output interface field "AMT_T" to field "AMT_T": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(021) <Oracle_Enterprise_1> When checking operator: When binding output interface field "AMT_B" to field "AMT_B": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(022) <Oracle_Enterprise_1> When checking operator: When binding output interface field "TRANSFER_PRICE_B" to field "TRANSFER_PRICE_B": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,5]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(023) <Oracle_Enterprise_1> When checking operator: When binding output interface field "STD_COST_G" to field "STD_COST_G": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,5]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(024) <Oracle_Enterprise_1> When checking operator: When binding output interface field "STD_COST_C" to field "STD_COST_C": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,5]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(025) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_ORDERED" to field "QTY_ORDERED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(026) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_CREDITED" to field "QTY_CREDITED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(027) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_INVOICED" to field "QTY_INVOICED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(028) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_COSTING" to field "QTY_COSTING": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00075 12:12:19(029) <Oracle_Enterprise_1> When checking operator: When binding output interface field "CONTRACT_FK" to field "CONTRACT_FK": Conversion from source type "string[max=246]" to result type "ustring[max=240]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00075 12:12:19(030) <Oracle_Enterprise_1> When checking operator: When binding output interface field "CSR_FK" to field "CSR_FK": Conversion from source type "string[max=290]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00072 12:12:19(031) <Oracle_Enterprise_1> When checking operator: When binding output interface field "LABOR_HOURS" to field "LABOR_HOURS": Implicit conversion from source type "decimal[38,10]" to result type "decimal[5,2]": Possible range/precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(032) <Oracle_Enterprise_1> When checking operator: When binding output interface field "TRAVEL_HOURS" to field "TRAVEL_HOURS": Implicit conversion from source type "decimal[38,10]" to result type "decimal[5,2]": Possible range/precision limitation.
##W IIS-DSEE-TFIP-00072 12:12:19(033) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_MATERIAL_USED" to field "QTY_MATERIAL_USED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00075 12:12:19(034) <Oracle_Enterprise_1> When checking operator: When binding output interface field "BOOK_CONVERSION_FK" to field "BOOK_CONVERSION_FK": Conversion from source type "string[max=138]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00075 12:12:19(035) <Oracle_Enterprise_1> When checking operator: When binding output interface field "BUDGET_CONVERSION_FK" to field "BUDGET_CONVERSION_FK": Conversion from source type "string[max=138]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00075 12:12:19(036) <Oracle_Enterprise_1> When checking operator: When binding output interface field "PY_BUDGET_CONVERSION_FK" to field "PY_BUDGET_CONVERSION_FK": Conversion from source type "string[max=138]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00072 12:12:19(037) <Oracle_Enterprise_1> When checking operator: When binding output interface field "ALLOC_AMOUNT" to field "ALLOC_AMOUNT": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TDOR-00062 12:12:22(000) <Oracle_Enterprise_1,0> Column AMT_T floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(001) <Oracle_Enterprise_1,0> Column AMT_B floating point decimal is not fully supported; adjusting the scale.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 12:12:22(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 12:12:22(001) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
##W IIS-DSEE-TDOR-00062 12:12:22(002) <Oracle_Enterprise_1,0> Column TRANSFER_PRICE_B floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(003) <Oracle_Enterprise_1,0> Column STD_COST_G floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(004) <Oracle_Enterprise_1,0> Column STD_COST_C floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(005) <Oracle_Enterprise_1,0> Column QTY_ORDERED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(006) <Oracle_Enterprise_1,0> Column QTY_CREDITED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(007) <Oracle_Enterprise_1,0> Column QTY_INVOICED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(008) <Oracle_Enterprise_1,0> Column QTY_COSTING floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(009) <Oracle_Enterprise_1,0> Column LABOR_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(010) <Oracle_Enterprise_1,0> Column TRAVEL_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(011) <Oracle_Enterprise_1,0> Column QTY_MATERIAL_USED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:12:22(012) <Oracle_Enterprise_1,0> Column ALLOC_AMOUNT floating point decimal is not fully supported; adjusting the scale.
>##E IIS-DSEE-TFOR-00089 12:12:22(002) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
##I IIS-DSEE-USBP-00001 12:12:22(000) <APT_CombinedOperatorController,0> called postFinalRunLocally
>##E IIS-DSEE-TFPM-00040 12:12:22(003) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 12:12:28(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 12:12:28(001) <main_program> Startup time, 0:08; production run time, 0:03.
Thanks in advance!
View data error in oracle enterprise stage
Moderators: chulett, rschirm, roy
-
just4geeks
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
View data error in oracle enterprise stage
Attitude is everything....
-
just4geeks
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
As mentioned in previous posts, I set APT_DISABLE_COMBINATION to 'TRUE' and now I am gettign following error message:
##E IIS-DSEE-TFOR-00089 12:24:26(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFPM-00040 12:24:26(002) <_ABORT_IDENT_,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
##E IIS-DSEE-TFSC-00011 12:24:32(000) <main_program> Step execution finished with status = FAILED.
Detailed log is as follows:
##I IIS-DSEE-TFCN-00001 12:24:24(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4668
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:24:24(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:24:24(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:24:24(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:24:24(004) <main_program> Parameter specified but not used in flow: SrcDbDetails
##W IIS-DSEE-TOSH-00049 12:24:24(005) <main_program> Parameter specified but not used in flow: scrdbuid
##W IIS-DSEE-TOSH-00049 12:24:24(006) <main_program> Parameter specified but not used in flow: srcdbpwd
##W IIS-DSEE-TOSH-00049 12:24:24(007) <main_program> Parameter specified but not used in flow: FromDate
##W IIS-DSEE-TOSH-00049 12:24:24(008) <main_program> Parameter specified but not used in flow: ToDate
##W IIS-DSEE-TOSH-00049 12:24:24(009) <main_program> Parameter specified but not used in flow: PeriodName
##W IIS-DSEE-TOSH-00049 12:24:24(010) <main_program> Parameter specified but not used in flow: RegionCode
##W IIS-DSEE-TOSH-00049 12:24:24(011) <main_program> Parameter specified but not used in flow: srcdbname
##W IIS-DSEE-TDOR-00158 12:24:24(012) <main_program> The NLS character map <ISO-8859-1> specified may not be compatible with
the character set specified by NLS_LANG;
you may get unexpected results from your database.
##W IIS-DSEE-TDOR-00062 12:24:25(001) <Oracle_Enterprise_1> Column AMT_T floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(002) <Oracle_Enterprise_1> Column AMT_B floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(003) <Oracle_Enterprise_1> Column TRANSFER_PRICE_B floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(004) <Oracle_Enterprise_1> Column STD_COST_G floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(005) <Oracle_Enterprise_1> Column STD_COST_C floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(006) <Oracle_Enterprise_1> Column QTY_ORDERED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(007) <Oracle_Enterprise_1> Column QTY_CREDITED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(008) <Oracle_Enterprise_1> Column QTY_INVOICED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(009) <Oracle_Enterprise_1> Column QTY_COSTING floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(010) <Oracle_Enterprise_1> Column LABOR_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(011) <Oracle_Enterprise_1> Column TRAVEL_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(012) <Oracle_Enterprise_1> Column QTY_MATERIAL_USED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(013) <Oracle_Enterprise_1> Column ALLOC_AMOUNT floating point decimal is not fully supported; adjusting the scale.
##I IIS-DSEE-TFSC-00001 12:24:25(018) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
##I IIS-DSEE-TFSU-00016 12:24:25(019) <main_program>
This step has 4 datasets:
ds0: {op0[1p] (sequential Oracle_Enterprise_1)
->eCollectAny
op1[1p] (sequential _EowGenerator)}
ds1: {op1[1p] (sequential _EowGenerator)
->eCollectAny
op2[1p] (sequential _Head)}
ds2: {op2[1p] (sequential _Head)
->eCollectAny
op3[1p] (sequential _PEEK_IDENT_)}
ds3: {op3[1p] (sequential _PEEK_IDENT_)
->eCollectAny
op4[1p] (sequential _ABORT_IDENT_)}
It has 5 operators:
op0[1p] {(sequential Oracle_Enterprise_1)
on nodes (
node1[op0,p0]
)}
op1[1p] {(sequential _EowGenerator)
on nodes (
node2[op1,p0]
)}
op2[1p] {(sequential _Head)
on nodes (
node3[op2,p0]
)}
op3[1p] {(sequential _PEEK_IDENT_)
on nodes (
node4[op3,p0]
)}
op4[1p] {(sequential _ABORT_IDENT_)
on nodes (
node1[op4,p0]
)}
It runs 5 processes on 4 nodes.
##W IIS-DSEE-TFIP-00072 12:24:25(020) <Oracle_Enterprise_1> When checking operator: When binding output interface field "AMT_T" to field "AMT_T": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(021) <Oracle_Enterprise_1> When checking operator: When binding output interface field "AMT_B" to field "AMT_B": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(022) <Oracle_Enterprise_1> When checking operator: When binding output interface field "TRANSFER_PRICE_B" to field "TRANSFER_PRICE_B": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,5]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(023) <Oracle_Enterprise_1> When checking operator: When binding output interface field "STD_COST_G" to field "STD_COST_G": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,5]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(024) <Oracle_Enterprise_1> When checking operator: When binding output interface field "STD_COST_C" to field "STD_COST_C": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,5]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(025) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_ORDERED" to field "QTY_ORDERED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(026) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_CREDITED" to field "QTY_CREDITED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(027) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_INVOICED" to field "QTY_INVOICED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(028) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_COSTING" to field "QTY_COSTING": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00075 12:24:25(029) <Oracle_Enterprise_1> When checking operator: When binding output interface field "CONTRACT_FK" to field "CONTRACT_FK": Conversion from source type "string[max=246]" to result type "ustring[max=240]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00075 12:24:25(030) <Oracle_Enterprise_1> When checking operator: When binding output interface field "CSR_FK" to field "CSR_FK": Conversion from source type "string[max=290]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00072 12:24:25(031) <Oracle_Enterprise_1> When checking operator: When binding output interface field "LABOR_HOURS" to field "LABOR_HOURS": Implicit conversion from source type "decimal[38,10]" to result type "decimal[5,2]": Possible range/precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(032) <Oracle_Enterprise_1> When checking operator: When binding output interface field "TRAVEL_HOURS" to field "TRAVEL_HOURS": Implicit conversion from source type "decimal[38,10]" to result type "decimal[5,2]": Possible range/precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(033) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_MATERIAL_USED" to field "QTY_MATERIAL_USED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00075 12:24:25(034) <Oracle_Enterprise_1> When checking operator: When binding output interface field "BOOK_CONVERSION_FK" to field "BOOK_CONVERSION_FK": Conversion from source type "string[max=138]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00075 12:24:25(035) <Oracle_Enterprise_1> When checking operator: When binding output interface field "BUDGET_CONVERSION_FK" to field "BUDGET_CONVERSION_FK": Conversion from source type "string[max=138]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00075 12:24:25(036) <Oracle_Enterprise_1> When checking operator: When binding output interface field "PY_BUDGET_CONVERSION_FK" to field "PY_BUDGET_CONVERSION_FK": Conversion from source type "string[max=138]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00072 12:24:25(037) <Oracle_Enterprise_1> When checking operator: When binding output interface field "ALLOC_AMOUNT" to field "ALLOC_AMOUNT": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TDOR-00062 12:24:26(000) <Oracle_Enterprise_1,0> Column AMT_T floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(001) <Oracle_Enterprise_1,0> Column AMT_B floating point decimal is not fully supported; adjusting the scale.
##I IIS-DSEE-USBP-00001 12:24:26(000) <_EowGenerator,0> called postFinalRunLocally
##W IIS-DSEE-TDOR-00062 12:24:26(002) <Oracle_Enterprise_1,0> Column TRANSFER_PRICE_B floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(003) <Oracle_Enterprise_1,0> Column STD_COST_G floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(004) <Oracle_Enterprise_1,0> Column STD_COST_C floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(005) <Oracle_Enterprise_1,0> Column QTY_ORDERED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(006) <Oracle_Enterprise_1,0> Column QTY_CREDITED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(007) <Oracle_Enterprise_1,0> Column QTY_INVOICED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(008) <Oracle_Enterprise_1,0> Column QTY_COSTING floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(009) <Oracle_Enterprise_1,0> Column LABOR_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(010) <Oracle_Enterprise_1,0> Column TRAVEL_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(011) <Oracle_Enterprise_1,0> Column QTY_MATERIAL_USED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(012) <Oracle_Enterprise_1,0> Column ALLOC_AMOUNT floating point decimal is not fully supported; adjusting the scale.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 12:24:26(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 12:24:26(001) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFPM-00040 12:24:26(002) <_ABORT_IDENT_,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 12:24:32(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 12:24:32(001) <main_program> Startup time, 0:06; production run time, 0:01.
Thanks!
##E IIS-DSEE-TFOR-00089 12:24:26(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFPM-00040 12:24:26(002) <_ABORT_IDENT_,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
##E IIS-DSEE-TFSC-00011 12:24:32(000) <main_program> Step execution finished with status = FAILED.
Detailed log is as follows:
##I IIS-DSEE-TFCN-00001 12:24:24(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4668
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:24:24(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:24:24(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:24:24(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:24:24(004) <main_program> Parameter specified but not used in flow: SrcDbDetails
##W IIS-DSEE-TOSH-00049 12:24:24(005) <main_program> Parameter specified but not used in flow: scrdbuid
##W IIS-DSEE-TOSH-00049 12:24:24(006) <main_program> Parameter specified but not used in flow: srcdbpwd
##W IIS-DSEE-TOSH-00049 12:24:24(007) <main_program> Parameter specified but not used in flow: FromDate
##W IIS-DSEE-TOSH-00049 12:24:24(008) <main_program> Parameter specified but not used in flow: ToDate
##W IIS-DSEE-TOSH-00049 12:24:24(009) <main_program> Parameter specified but not used in flow: PeriodName
##W IIS-DSEE-TOSH-00049 12:24:24(010) <main_program> Parameter specified but not used in flow: RegionCode
##W IIS-DSEE-TOSH-00049 12:24:24(011) <main_program> Parameter specified but not used in flow: srcdbname
##W IIS-DSEE-TDOR-00158 12:24:24(012) <main_program> The NLS character map <ISO-8859-1> specified may not be compatible with
the character set specified by NLS_LANG;
you may get unexpected results from your database.
##W IIS-DSEE-TDOR-00062 12:24:25(001) <Oracle_Enterprise_1> Column AMT_T floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(002) <Oracle_Enterprise_1> Column AMT_B floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(003) <Oracle_Enterprise_1> Column TRANSFER_PRICE_B floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(004) <Oracle_Enterprise_1> Column STD_COST_G floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(005) <Oracle_Enterprise_1> Column STD_COST_C floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(006) <Oracle_Enterprise_1> Column QTY_ORDERED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(007) <Oracle_Enterprise_1> Column QTY_CREDITED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(008) <Oracle_Enterprise_1> Column QTY_INVOICED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(009) <Oracle_Enterprise_1> Column QTY_COSTING floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(010) <Oracle_Enterprise_1> Column LABOR_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(011) <Oracle_Enterprise_1> Column TRAVEL_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(012) <Oracle_Enterprise_1> Column QTY_MATERIAL_USED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:25(013) <Oracle_Enterprise_1> Column ALLOC_AMOUNT floating point decimal is not fully supported; adjusting the scale.
##I IIS-DSEE-TFSC-00001 12:24:25(018) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
##I IIS-DSEE-TFSU-00016 12:24:25(019) <main_program>
This step has 4 datasets:
ds0: {op0[1p] (sequential Oracle_Enterprise_1)
->eCollectAny
op1[1p] (sequential _EowGenerator)}
ds1: {op1[1p] (sequential _EowGenerator)
->eCollectAny
op2[1p] (sequential _Head)}
ds2: {op2[1p] (sequential _Head)
->eCollectAny
op3[1p] (sequential _PEEK_IDENT_)}
ds3: {op3[1p] (sequential _PEEK_IDENT_)
->eCollectAny
op4[1p] (sequential _ABORT_IDENT_)}
It has 5 operators:
op0[1p] {(sequential Oracle_Enterprise_1)
on nodes (
node1[op0,p0]
)}
op1[1p] {(sequential _EowGenerator)
on nodes (
node2[op1,p0]
)}
op2[1p] {(sequential _Head)
on nodes (
node3[op2,p0]
)}
op3[1p] {(sequential _PEEK_IDENT_)
on nodes (
node4[op3,p0]
)}
op4[1p] {(sequential _ABORT_IDENT_)
on nodes (
node1[op4,p0]
)}
It runs 5 processes on 4 nodes.
##W IIS-DSEE-TFIP-00072 12:24:25(020) <Oracle_Enterprise_1> When checking operator: When binding output interface field "AMT_T" to field "AMT_T": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(021) <Oracle_Enterprise_1> When checking operator: When binding output interface field "AMT_B" to field "AMT_B": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(022) <Oracle_Enterprise_1> When checking operator: When binding output interface field "TRANSFER_PRICE_B" to field "TRANSFER_PRICE_B": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,5]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(023) <Oracle_Enterprise_1> When checking operator: When binding output interface field "STD_COST_G" to field "STD_COST_G": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,5]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(024) <Oracle_Enterprise_1> When checking operator: When binding output interface field "STD_COST_C" to field "STD_COST_C": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,5]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(025) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_ORDERED" to field "QTY_ORDERED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(026) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_CREDITED" to field "QTY_CREDITED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(027) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_INVOICED" to field "QTY_INVOICED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(028) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_COSTING" to field "QTY_COSTING": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00075 12:24:25(029) <Oracle_Enterprise_1> When checking operator: When binding output interface field "CONTRACT_FK" to field "CONTRACT_FK": Conversion from source type "string[max=246]" to result type "ustring[max=240]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00075 12:24:25(030) <Oracle_Enterprise_1> When checking operator: When binding output interface field "CSR_FK" to field "CSR_FK": Conversion from source type "string[max=290]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00072 12:24:25(031) <Oracle_Enterprise_1> When checking operator: When binding output interface field "LABOR_HOURS" to field "LABOR_HOURS": Implicit conversion from source type "decimal[38,10]" to result type "decimal[5,2]": Possible range/precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(032) <Oracle_Enterprise_1> When checking operator: When binding output interface field "TRAVEL_HOURS" to field "TRAVEL_HOURS": Implicit conversion from source type "decimal[38,10]" to result type "decimal[5,2]": Possible range/precision limitation.
##W IIS-DSEE-TFIP-00072 12:24:25(033) <Oracle_Enterprise_1> When checking operator: When binding output interface field "QTY_MATERIAL_USED" to field "QTY_MATERIAL_USED": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TFIP-00075 12:24:25(034) <Oracle_Enterprise_1> When checking operator: When binding output interface field "BOOK_CONVERSION_FK" to field "BOOK_CONVERSION_FK": Conversion from source type "string[max=138]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00075 12:24:25(035) <Oracle_Enterprise_1> When checking operator: When binding output interface field "BUDGET_CONVERSION_FK" to field "BUDGET_CONVERSION_FK": Conversion from source type "string[max=138]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00075 12:24:25(036) <Oracle_Enterprise_1> When checking operator: When binding output interface field "PY_BUDGET_CONVERSION_FK" to field "PY_BUDGET_CONVERSION_FK": Conversion from source type "string[max=138]" to result type "ustring[max=120]": Possible truncation of variable length string.
##W IIS-DSEE-TFIP-00072 12:24:25(037) <Oracle_Enterprise_1> When checking operator: When binding output interface field "ALLOC_AMOUNT" to field "ALLOC_AMOUNT": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,2]": Possible precision limitation.
##W IIS-DSEE-TDOR-00062 12:24:26(000) <Oracle_Enterprise_1,0> Column AMT_T floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(001) <Oracle_Enterprise_1,0> Column AMT_B floating point decimal is not fully supported; adjusting the scale.
##I IIS-DSEE-USBP-00001 12:24:26(000) <_EowGenerator,0> called postFinalRunLocally
##W IIS-DSEE-TDOR-00062 12:24:26(002) <Oracle_Enterprise_1,0> Column TRANSFER_PRICE_B floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(003) <Oracle_Enterprise_1,0> Column STD_COST_G floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(004) <Oracle_Enterprise_1,0> Column STD_COST_C floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(005) <Oracle_Enterprise_1,0> Column QTY_ORDERED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(006) <Oracle_Enterprise_1,0> Column QTY_CREDITED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(007) <Oracle_Enterprise_1,0> Column QTY_INVOICED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(008) <Oracle_Enterprise_1,0> Column QTY_COSTING floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(009) <Oracle_Enterprise_1,0> Column LABOR_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(010) <Oracle_Enterprise_1,0> Column TRAVEL_HOURS floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(011) <Oracle_Enterprise_1,0> Column QTY_MATERIAL_USED floating point decimal is not fully supported; adjusting the scale.
##W IIS-DSEE-TDOR-00062 12:24:26(012) <Oracle_Enterprise_1,0> Column ALLOC_AMOUNT floating point decimal is not fully supported; adjusting the scale.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 12:24:26(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 12:24:26(001) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFPM-00040 12:24:26(002) <_ABORT_IDENT_,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 12:24:32(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 12:24:32(001) <main_program> Startup time, 0:06; production run time, 0:01.
Thanks!
Attitude is everything....
-
just4geeks
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
Here is my configuration file. is that can be a problem:
{
node "node1"
{
fastname "lxdscon.beckman.com"
pools ""
resource disk "/dstage1/Server/Datasets" {pools ""}
resource scratchdisk "/dstage1/Server/Scratch" {pools ""}
}
node "node2"
{
fastname "lxdscon.beckman.com"
pools ""
resource disk "/dstage1/Server/Datasets" {pools ""}
resource scratchdisk "/dstage1/Server/Scratch" {pools ""}
}
node "node3"
{
fastname "lxdscon.beckman.com"
pools ""
resource disk "/dstage1/Server/Datasets" {pools ""}
resource scratchdisk "/dstage1/Server/Scratch" {pools ""}
}
node "node4"
{
fastname "lxdscon.beckman.com"
pools ""
resource disk "/dstage1/Server/Datasets" {pools ""}
resource scratchdisk "/dstage1/Server/Scratch" {pools ""}
}
}
Thanks!
{
node "node1"
{
fastname "lxdscon.beckman.com"
pools ""
resource disk "/dstage1/Server/Datasets" {pools ""}
resource scratchdisk "/dstage1/Server/Scratch" {pools ""}
}
node "node2"
{
fastname "lxdscon.beckman.com"
pools ""
resource disk "/dstage1/Server/Datasets" {pools ""}
resource scratchdisk "/dstage1/Server/Scratch" {pools ""}
}
node "node3"
{
fastname "lxdscon.beckman.com"
pools ""
resource disk "/dstage1/Server/Datasets" {pools ""}
resource scratchdisk "/dstage1/Server/Scratch" {pools ""}
}
node "node4"
{
fastname "lxdscon.beckman.com"
pools ""
resource disk "/dstage1/Server/Datasets" {pools ""}
resource scratchdisk "/dstage1/Server/Scratch" {pools ""}
}
}
Thanks!
Attitude is everything....
-
just4geeks
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
Here are my Environment variable settings:
Environment variable settings:
_=/usr/bin/nohup
APT_COMPILEOPT=-O -fPIC -Wno-deprecated -c
APT_COMPILER=g++
APT_CONFIG_FILE=/opt/IBM/InformationServer/Server/Configurations/default.apt
APT_DISABLE_COMBINATION=1
APT_DUMP_SCORE=1
APT_ERROR_CONFIGURATION=severity, !vseverity, !jobid, moduleid, errorIndex, timestamp, !ipaddr, !nodeplayer, !nodename, opid, message
APT_LINKER=g++
APT_LINKOPT=-shared -Wl,-Bsymbolic,--allow-shlib-undefined
APT_MONITOR_MINTIME=10
APT_OPERATOR_REGISTRY_PATH=/dstage1/Projects/dsdev/buildop
APT_ORCHHOME=/opt/IBM/InformationServer/Server/PXEngine
ASBHOME=/opt/IBM/InformationServer/ASBNode
BELL=^G
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_OPERATOR_BUILDOP_DIR=buildop
DS_OPERATOR_WRAPPED_DIR=wrapped
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
DS_USERNO=-20648
DSHOME=/opt/IBM/InformationServer/Server/DSEngine
DSIPC_OPEN_TIMEOUT=30
FLAVOR=-1
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/dsadm
HOSTNAME=lxdscon.beckman.com
INPUTRC=/etc/inputrc
KDEDIR=/usr
LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8
LC_COLLATE=en_US.UTF-8
LC_CTYPE=en_US.UTF-8
LC_MESSAGES=en_US.UTF-8
LC_MONETARY=en_US.UTF-8
LC_NUMERIC=en_US.UTF-8
LC_TIME=en_US.UTF-8
LD_LIBRARY_PATH=/dstage1/Projects/dsdev/RT_BP932.O:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSParallel:/opt/IBM/InformationServer/Server/PXEngine/user_lib:/opt/IBM/InformationServer/Server/PXEngine/lib:/dstage1/Projects/dsdev/buildop:/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSEngine/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/dstage1/oracle/product/10.2.0/client_1/lib:.:/usr/lib:/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LIBPATH=/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSEngine/lib:/dstage1/oracle/product/10.2.0/client_1/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:
LOGNAME=dsadm
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL=/var/spool/mail/tsingh
NLS_DATE_FORMAT=DD-MON-RR
NLS_LANG=American_America.UTF8
NLS_NUMERIC_CHARACTERS=.,
NLS_SORT=binary
ODBCINI=/opt/IBM/InformationServer/Server/DSEngine/.odbc.ini
OLDPWD=/opt/IBM/InformationServer/Server/DSEngine
ORACLE_HOME=/dstage1/oracle/product/10.2.0/client_1
ORACLE_SID=$env
OSH_STDOUT_MSG=1
PATH=/dstage1/Projects/dsdev/wrapped:/dstage1/Projects/dsdev/buildop:/dstage1/Projects/dsdev/RT_BP932.O:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSParallel:/opt/IBM/InformationServer/Server/PXEngine/user_osh_wrappers:/opt/IBM/InformationServer/Server/PXEngine/osh_wrappers:/opt/IBM/InformationServer/Server/PXEngine/bin:/home/tsingh/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/dstage1/oracle/product/10.2.0/client_1/bin:.
PIDTOK=14527
PWD=/opt/IBM/InformationServer/Server/DSEngine
PX_DBCONNECTHOME=/opt/IBM/InformationServer/Server/DSComponents
QTDIR=/usr/lib/qt-3.3
REMOTEHOST=mofultsingh01.global.bcecorp.net
SHELL=/bin/bash
SHLVL=5
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=
TNS_ADMIN=/dstage1/oracle/product/10.2.0/client_1/network/admin
UDTBIN=/opt/IBM/InformationServer/Server/DSEngine/ud41/bin
UDTHOME=/opt/IBM/InformationServer/Server/DSEngine/ud41
USER=dsadm
WHO=dsdev
please help!
I am trying to do different things while waiting for expert advice! So please excuse me if post is becoming too long but I am trying to provide as much details as I can.
Thanks!
Environment variable settings:
_=/usr/bin/nohup
APT_COMPILEOPT=-O -fPIC -Wno-deprecated -c
APT_COMPILER=g++
APT_CONFIG_FILE=/opt/IBM/InformationServer/Server/Configurations/default.apt
APT_DISABLE_COMBINATION=1
APT_DUMP_SCORE=1
APT_ERROR_CONFIGURATION=severity, !vseverity, !jobid, moduleid, errorIndex, timestamp, !ipaddr, !nodeplayer, !nodename, opid, message
APT_LINKER=g++
APT_LINKOPT=-shared -Wl,-Bsymbolic,--allow-shlib-undefined
APT_MONITOR_MINTIME=10
APT_OPERATOR_REGISTRY_PATH=/dstage1/Projects/dsdev/buildop
APT_ORCHHOME=/opt/IBM/InformationServer/Server/PXEngine
ASBHOME=/opt/IBM/InformationServer/ASBNode
BELL=^G
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_OPERATOR_BUILDOP_DIR=buildop
DS_OPERATOR_WRAPPED_DIR=wrapped
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
DS_USERNO=-20648
DSHOME=/opt/IBM/InformationServer/Server/DSEngine
DSIPC_OPEN_TIMEOUT=30
FLAVOR=-1
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/dsadm
HOSTNAME=lxdscon.beckman.com
INPUTRC=/etc/inputrc
KDEDIR=/usr
LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8
LC_COLLATE=en_US.UTF-8
LC_CTYPE=en_US.UTF-8
LC_MESSAGES=en_US.UTF-8
LC_MONETARY=en_US.UTF-8
LC_NUMERIC=en_US.UTF-8
LC_TIME=en_US.UTF-8
LD_LIBRARY_PATH=/dstage1/Projects/dsdev/RT_BP932.O:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSParallel:/opt/IBM/InformationServer/Server/PXEngine/user_lib:/opt/IBM/InformationServer/Server/PXEngine/lib:/dstage1/Projects/dsdev/buildop:/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSEngine/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/dstage1/oracle/product/10.2.0/client_1/lib:.:/usr/lib:/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LIBPATH=/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSEngine/lib:/dstage1/oracle/product/10.2.0/client_1/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:
LOGNAME=dsadm
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL=/var/spool/mail/tsingh
NLS_DATE_FORMAT=DD-MON-RR
NLS_LANG=American_America.UTF8
NLS_NUMERIC_CHARACTERS=.,
NLS_SORT=binary
ODBCINI=/opt/IBM/InformationServer/Server/DSEngine/.odbc.ini
OLDPWD=/opt/IBM/InformationServer/Server/DSEngine
ORACLE_HOME=/dstage1/oracle/product/10.2.0/client_1
ORACLE_SID=$env
OSH_STDOUT_MSG=1
PATH=/dstage1/Projects/dsdev/wrapped:/dstage1/Projects/dsdev/buildop:/dstage1/Projects/dsdev/RT_BP932.O:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSParallel:/opt/IBM/InformationServer/Server/PXEngine/user_osh_wrappers:/opt/IBM/InformationServer/Server/PXEngine/osh_wrappers:/opt/IBM/InformationServer/Server/PXEngine/bin:/home/tsingh/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/dstage1/oracle/product/10.2.0/client_1/bin:.
PIDTOK=14527
PWD=/opt/IBM/InformationServer/Server/DSEngine
PX_DBCONNECTHOME=/opt/IBM/InformationServer/Server/DSComponents
QTDIR=/usr/lib/qt-3.3
REMOTEHOST=mofultsingh01.global.bcecorp.net
SHELL=/bin/bash
SHLVL=5
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=
TNS_ADMIN=/dstage1/oracle/product/10.2.0/client_1/network/admin
UDTBIN=/opt/IBM/InformationServer/Server/DSEngine/ud41/bin
UDTHOME=/opt/IBM/InformationServer/Server/DSEngine/ud41
USER=dsadm
WHO=dsdev
please help!
I am trying to do different things while waiting for expert advice! So please excuse me if post is becoming too long but I am trying to provide as much details as I can.
Thanks!
Attitude is everything....
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Somewhere in your job design you have a VarChar or Char column with no precision (size, length) defined. You have to find it and fix it. It may or may not be in the Oracle Enterprise stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
just4geeks
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
Hi ,ray.wurlod wrote:Somewhere in your job design you have a VarChar or Char column with no precision (size, length) defined. You have to find it and fix it. It may or may not be in the Oracle Enterprise stage.
Thanks! I have double checked and all the char/varchar columns are defined with some positive value of length ( for example :varchar(20) )and nullable. but still have same errors but for now I would like to focus on other error because atleast I have workaround for this one.
Thanks,
Attitude is everything....
-
just4geeks
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
Thanks a lot!dspxlearn wrote:just4geeks,
Did you import the Oracle metadata from the table definitions or edited it manually?
The 'Only' reason for your case is that your datatypes from the source isn't matching with the metadata you have imported/edited.
As Ray said check them first.
I imported the metadata from tabel definitions. actually We have same job as server job which is running successfully since long time. But now we want to convert that job to parallel. Metadata and sql used in server jobs are identical with that of parallel job. however in server job we are using Oracle OCI stage , in parallel we are using oracle Enterprise stage. This is the only difference in job design.
Attitude is everything....
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
just4geeks
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
-
just4geeks
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
-
throbinson
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA