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
oravijay
Messages: 43
Registered: March 2010
Member
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,

Regards
Vijay



[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
oravijay
Messages: 43
Registered: March 2010
Member
Hi All,,

I have created the error table with the sql


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

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
Regards,
Vijay


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


Current Time: Mon Jun 21 05:36:03 CDT 2021