3 Replies Latest reply: Jul 30, 2013 3:30 AM by Mike-Matthews-Oracle RSS

    Deduplication results deleted (DELETE FROM S_DEDUP_RESULT)

    user3035423

      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