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.
unable to insert data into a table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
.
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
.
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......
Verify that the database date format is same for both the instances.
Hope it helps......
Assume everything I say or do is positive