Problem Description:
1. most of the Jobs in "Executing" status(interface, package, procedure) not progressed any more keeing status in the specific part.
- Procedure (JYTHON "raise" Command )
- Interface (dropping Temp table => c$,i$ )
- normally stopping after recording Error in Operator.
2. When making Scenario.
java.sql.BatchUpdateException: ORA-00001: unique constraint (REPWRK.PK_EXP_TXT) violated
3. Some Interfaces, or procedures occurred the same error.
1 : 23000 : java.sql.BatchUpdateException: ORA-00001: unique constraint (REPWRK.PK_EXP_TXT) violated
1 : 23000 : java.sql.SQLException: ORA-00001: unique constraint (REPWRK.PK_EXP_TXT) violated
java.sql.BatchUpdateException: ORA-00001: unique constraint (REPWRK.PK_EXP_TXT) violated
Expected Cause of ..
I expected Error occurred because one column named "I_TXT" of the primary key cols of "snp_exp_txt" table using sequence number has been overflowed
From now on ..
I followed the doc "How To Determine Orphan Records From The ODI SNP_EXP_TXT Work Repository Table [ID 749487.1]", but not work well.
* Then executed delete logs like "purge log" command in operator. It Works. Problem is clear.
but Curious.
that is right thing to solve this problem?
if not, how?
if do, how can easily, what else?
I'm looking forward to your replying.
THANKS, IN ADVANCE.
jeonghyeon Cheon,
