Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deduplication results deleted (DELETE FROM S_DEDUP_RESULT)

user3035423Jul 1 2013 — edited Jul 30 2013

Good afternoon experts,

We do have installed Siebel 8.1.1.10 and integrated with Oracle Enteprise Data Quality.

Currently we are working with OOTB rules as defined in OEDQ. In this phase of project we do have only 2 environments installed: DEV and TST.

On TST matching of both Accounts and Contacts is working fine.

On DEV only matching the contacts matching does work, Accounts not. When investigating log files, we can see that potential Account candidates are sent back to siebel, but after that weird things happen on Siebel side:

results are deleted from siebel.s_dedup_result table instead to be written (abstract from log file):

EAIFileAttachments    EAIFileAttachmentDebug    5    00000b1d51ca6a72:0    2013-07-01 10:32:48    Getting file reference manager Session Global by key 'FileReferenceManager'

XMLConversion    XMLCnvArgTracing    5    00000b1d51ca6a72:0    2013-07-01 10:32:48    XML conversion input tracing. Creating a dump file containing source XML document.

DumpFile    DumpFileOpen    3    00000b1d51ca6a72:0    2013-07-01 10:32:48    XML parser input

DumpFile    DumpFileClose    3    00000b1d51ca6a72:0    2013-07-01 10:32:48   

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (Data)  state=EAIXMLPRS_STATE_INITIAL  stack=0

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=1

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (1-5UFM)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (75)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=1

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (1-WJZ9)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (85)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=1

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (1-WK1V)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (85)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=1

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (1-WK14)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (85)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=1

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (1-WJZQ)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (85)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=1

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (1-WJYN)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (85)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=1

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    characters (1-WK2I)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (Account.Id)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    startEvent (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DQ.MatchScore)  state=EAIXMLPRS_STATE_PROPSET  stack=3

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (DuplicateRecord)  state=EAIXMLPRS_STATE_PROPSET  stack=2

XMLConversion    XMLCnvParserDebug    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    endElement (Data)  state=EAIXMLPRS_STATE_PROPSET  stack=1

ObjMgrBusServiceLog    InvokeMethod    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    Business Service 'XML Converter For DQ' invoke method 'XMLToPropSet' Execute Time: 0.007 seconds.

ObjMgrBusServiceLog    InvokeMethod    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    End: Business Service 'XML Converter For DQ' invoke method: 'XMLToPropSet' at 10f27168

ObjMgrBusServiceLog    Delete    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    Business Service 'XML Converter For DQ' (address: '10f27168')was unregsitered at model '108e87e8' for session ''

ObjMgrBusServiceLog    Delete    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    Business Service 'XML Converter For DQ' was deleted at 10f27168

ObjMgrSqlObjLog    WriteRecord    5    00000b1d51ca6a72:0    2013-07-01 10:32:48    Begin: WriteRecord for SqlObj 'DeDuplication Results (Account)' at 8273eae8

ObjMgrSqlLog    Detail    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    INSERT/UPDATE statement with ID: Unknown

DELETE FROM SIEBEL.S_DEDUP_RESULT

WHERE ROW_ID = :1

ObjMgrSqlLog    Detail    4    00000b1d51ca6a72:0    2013-07-01 10:32:48    Bind variable 1: 1-WK2T

I would approecaite any hint
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2013
Added on Jul 1 2013
#data, #data-quality, #master-data-management-mdm
3 comments
769 views