Database error while running workflow

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

boppana81 in Arlington Heights, Illinois

87 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

87 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 (4) / No (3) Reply - Report abuse

wish in Honolulu, Hawaii

84 months ago

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

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

trivo in Hillsborough, New Jersey

50 months ago

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

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

Madhu in New York, New York

37 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

infok in Chennai, India

1 month ago

Even I am getting the same error:
Severity: ERROR
Timestamp: 7/11/2015 11:02:54 AM
Node: uslv-dapp-inf04
Thread: WRITER_1_*_1
Process ID: 38584
Message Code: WRT_8229
Message: Database errors occurred:

Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO F_PUBLICATION_STATUS_T
(ACTUALDATE,DISPLAYORDER,FPR_CYCLE_NUM_FORMULA,
FPR_CYCLE_SORT_NUM,FPR_CYCLE,FPR_CYCLE_NAME,ID,ISACTUALDATEEDITABLE,
ISCURRENTFPRCYCLEFORPUB,ISCURRENTSUBMISSIONCYCLEFORPUB,ISLOGICALLYDELETED,JOURNAL,JOURNAL_NAME,
MEETING,MEETING_NAME,NAME,PUBLICATION_ID,PUB_TITLE,REASON_FOR_CHANGE,RECORDTYPEID,
REVISEDTARGETDATE,ROUTE_PATTERN,SIEBELROWID,STAGE,STATUS,STATUS_NAME,SUBMISSION_CYCLE_NUM_FORMULA,
SUBMISSION_CYCLE,SUB_PUB_ID,TARGETDATE,TARGET,CREATE_BY,CREATE_TS)
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO F_PUBLICATION_STATUS_T(ACTUALDATE,DISPLAYORDER,FPR_CYCLE_NUM_FORMULA,FPR_CYCLE_SORT_NUM,FPR_CYCLE,FPR_CYCLE_NAME,ID,ISACTUALDATEEDITABLE,ISCURRENTFPRCYCLEFORPUB,ISCURRENTSUBMISSIONCYCLEFORPUB,ISLOGICALLYDELETED,JOURNAL,JOURNAL_NAME,MEETING,MEETING_NAME,NAME,PUBLICATION_ID,PUB_TITLE,REASON_FOR_CHANGE,RECORDTYPEID,REVISEDTARGETDATE,ROUTE_PATTERN,SIEBELROWID,STAGE,STATUS,STATUS_NAME,SUBMISSION_CYCLE_NUM_FORMULA,SUBMISSION_CYCLE,SUB_PUB_ID,TARGETDATE,TARGET,CREATE_BY,CREATE_TS) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Till yesterday it ran fine in bulk mode.... Now what is the problem???

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

infok in Chennai, India

1 month ago

select * from all_constraints
where table_name = 'F_PUBLICATION_STATUS_T'

Executed this query and found that there is no constraints on the table....
Then what will be the issue.. Kindly help me out on this!

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

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