View data error in oracle enterprise stage
Posted: Thu Feb 21, 2008 2:19 pm
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!
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!