Home » Developer & Programmer » Data Integration » Error table is not working in OWB ? (centos linux ,oracle 11gr2 owb )
Error table is not working in OWB ? [message #485782] Thu, 09 December 2010 21:45 Go to next message
Messages: 43
Registered: March 2010
javascript: insertTag(document.post_form.msg_body, '', ' Embarassed ');

Dear Oracle Experts,

I new to oracle OWB.
Platform Oracle 11gr2 in centos linux

i have created a new mapping which transfers the data between two schemas.when I deploy i didnt face any errors and when i run the mapping it shows log

ORA-00001 unique constraint (RAHS2MIG1.PK_OBJECT) VOILATED.

IS it possible to record this message in Error table? Please if any one know how to record the error in error table.

I can only able to edit dml error table name box in property inspector but i cannot able to edit error table name.

Thanks in Advance,


[Updated on: Thu, 09 December 2010 21:46]

Report message to a moderator

Re: Error table is not working in OWB ? [message #485783 is a reply to message #485782] Thu, 09 December 2010 21:54 Go to previous message
Messages: 43
Registered: March 2010
Hi All,,

I have created the error table with the sql

SQL> connect rahs2mig1/rahs2mig1
dbms_errlog.create_error_log('migrationinfo','ERROR$_MIG') ;

PL/SQL procedure successfully completed.

I have created the table ERROR$_MIG for the target schema object migrationinfo.After clicking the start option in the mapping.
ORA-00001 unique constraint (RAHS2MIG1.PK_OBJECT) VOILATED. error shows only in the log.
No errors record in the ERROR$_MIG table.
Please advise.

Thanks in Advance

Previous Topic: Error while deploying mapping within control center
Next Topic: Datawarehousing
Goto Forum:

Current Time: Thu Sep 16 20:27:07 CDT 2021