Database error while running workflow

Get new comments by email
You can cancel email alerts at anytime.
Comments (5)

boppana81 in Arlington Heights, Illinois

76 months ago

Hi
Iam running a seesion.Iam unable to run Workflow.When i run Debug it shows me the data loaded into target. It shows me the following Error message in Session log
WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-26002: Table TGT.T_SG_21 has index defined upon it.

Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO t_SG_21(Primarykey,EMPLOYEE_ID,FIRST_NAME,LAST_NAME ,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMIS SI ON_PCT,DEPARTMENT_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO t_SG_21(Primarykey,EMPLOYEE_ID,FIRST_NAME,LAST_NAME ,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMIS SI ON_PCT,DEPARTMENT_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
WRITER_1_*_1> Fri Jun 13 15:39:44 2008
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> WRT_8325 Final rollback executed for the target [t_SG_22, t_SG_21] at end of load
WRITER_1_*_1> Fri Jun 13 15:39:44 2008
WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [t_SG_21]]
WRITER_1_*_1> WRT_8168 End loading table [t_SG_22] at: Fri Jun 13 15:39:44 2008
WRITER_1_*_1> WRT_8168 End loading table [t_SG_21] at: Fri Jun 13 15:39:44 2008
WRITER_1_*_1> WRT_8035 Load complete time: Fri Jun 13 15:39:44 2008

- Was this comment helpful? Yes (2) / No Reply - Report abuse

HEMANTA BISHI in Bombay, India

75 months ago

I think,it's kind of constraint violation.Primary key will be violating duplicates to enter. So it fires the error.
correct me if i am wrong.

- Was this comment helpful? Yes (3) / No (1) Reply - Report abuse

wish in Honolulu, Hawaii

73 months ago

Try to load it normal rather than Bulk. U can see this option in Targets.

- Was this comment helpful? Yes (28) / No (13) Reply - Report abuse

trivo in Hillsborough, New Jersey

39 months ago

Yes.. Even I had same problem.. The change to normal from bulk worked. thanks..

- Was this comment helpful? Yes (11) / No (4) Reply - Report abuse

Madhu in New York, New York

26 months ago

wish in Honolulu, Hawaii said: Try to load it normal rather than Bulk. U can see this option in Targets.

Thanks for your commnets. It really helpe me out!!

- Was this comment helpful? Yes (1) / No (1) Reply - Report abuse

» Sign in or create an account to comment on this topic.