Dear All
while updating Filed into a table using ODBC stage am getting following error
ODBS_Enterprise_0:The runlOCALLY() OF THE OPERATOR FAILED
ODBS_Enterprise_0:Operator terminated abnormally.runlOCALLY() did not return Apt_status=ok
for this I changed envoironment variable in Adminstaror-------->paralle--->Apt_Disable_combinationoperaor=TRUE.
eventhough i changed this setting in admin, my job got aborted..
and i tried to do same disblimg combination opeartor in Stage--->Advanced tab also,But i did not find any that option over ther in that particular stage
my job design
dataset--->Transformer---->ODBC stage
suggest me in this regard.
ODBS_Enterprise_0:The runlOCALLY() OF THE OPERATOR FAILED
Moderators: chulett, rschirm, roy
Hi pandeesh
Thanks for your replay..these are other warnings coming befor fatal error
Data_Set_0: When checking operator: When binding output schema variable "outRec": When binding output interface field "ac" to field "ac": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
ODBC_Enterprise_5,0: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column "etr"
cannot be found or is not specified for query. (13865)
ODBC_Enterprise_5,0: : The runLocally() of the operator failed.
ODBC_Enterprise_5,0: Operator terminated abnormally: runLocally did not return APT_StatusOk
I am using this code in odbc stage to upadate progress table name CLIENT
which contain two fileds:
UPDATE
PUB.client
SET
sparechar3='ETR'
WHERE
acno = ORCHESTRATE.ac
table details
Progress table: client
Fields: client.acno, client.sparechar3
in that, i need to upadate in sparechar3
by comapare antoher table "acno ",
Thanks for your replay..these are other warnings coming befor fatal error
Data_Set_0: When checking operator: When binding output schema variable "outRec": When binding output interface field "ac" to field "ac": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
ODBC_Enterprise_5,0: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column "etr"
cannot be found or is not specified for query. (13865)
ODBC_Enterprise_5,0: : The runLocally() of the operator failed.
ODBC_Enterprise_5,0: Operator terminated abnormally: runLocally did not return APT_StatusOk
I am using this code in odbc stage to upadate progress table name CLIENT
which contain two fileds:
UPDATE
PUB.client
SET
sparechar3='ETR'
WHERE
acno = ORCHESTRATE.ac
table details
Progress table: client
Fields: client.acno, client.sparechar3
in that, i need to upadate in sparechar3
by comapare antoher table "acno ",
RANGA RAO