DSXchange

hi ,


i had a job with a sequential file and a oracle stage .when i connected to one instance it worked fine.i was able to load data into the table.


i had the same job but connected to different instance of oracle . now i am i am getting an error say

The runLocally() of the operator failed.
Operator terminated abnormally: runLocally did not return APT_StatusOk.

but one thing is i am import matadata form that instance.

please help me out.

Do you have appropriate table privileges in the new instance?

i do have all the privilages required

Your error Message is not complete, Provide more info. Because this message is common.

Oracle_Enterprise_2,1: Unable to insert a record into the table.
racle_Enterprise_2,1: Records inserted: 0
Records used for update: 0
Records rejected: 0
Total records: 0.

Oracle_Enterprise_2,1: The runLocally() of the operator failed.
Oracle_Enterprise_2,1: Operator terminated abnormally: runLocally did not return APT_StatusOk

racle_Enterprise_2,0: Array execute failed for insert:
insert is: INSERT
INTO
incntv
(SELLING_SRC_CD, INCNTV_LVL_NBR, MODEL_YEAR, INCNTV_CD, INCNTV_LVL_DESC, LOAD_ID, LOAD_TIMSTM)
VALUES
( :SELLING_SRC_CD, :INCNTV_LVL_NBR, :MODEL_YEAR, :INCNTV_CD, :INCNTV_LVL_DESC, :LOAD_ID, :LOAD_TIMSTM)
sqlcode is: -1843
esql complaint: ORA-01843: not a valid month
.

See this is because of bad data or date , "esql complaint: ORA-01843: not a valid month "
Do date validation before inserting or correct the source data.

I agree this must be due to a invalid date, verify the date before inserting. Which genrally should be followed to avoid any issues in live environment.
Check the format of date u are inserting the data in?

I think you need to check structure of table in both databae instances. It might be VARCHAR2 in one and DATE in another. Also execute this SQL on the SQL prompt: select sysdate from dual;
Verify that the database date format is same for both the instances.

Hope it helps......