This discussion is archived
2 Replies Latest reply: Jun 25, 2012 1:50 AM by mroshaw76 RSS

Staging Database Connect Error - Siebel OEDQ-CDS

mroshaw76 Explorer
Currently Being Moderated
Hi!

I've installed and configured OEDQ 9 with the Siebel 8.2.2 connector.

When I invoke Batch DeDupe, I always get this error in the Siebel 'Data Quality' component error log:

GenericLog     GenericError     1     000002af4fd31660:a0     2012-06-10 10:29:33     Object manager error: ([0] Data Quality vendor-specific error: An error occurred when calling function 'sdq_set_dedup_candidates ()' in connector 'EDQ': "(-1013) Set dedup candidates problem." Detailed error message: Error setting dedup candidates: could not connect to database "oracle:oedq@oedq9-vm/oedq" (code 234,351)(SBL-APS-00118) (0x650076))GenericLog     GenericError     1     000002af4fd31660:0     2012-06-10 10:29:33     ( (0) err=2818155 sys=6619254) SBL-OMS-00107: Object manager error: ([0] Data Quality vendor-specific error: An error occurred when calling function 'sdq_set_dedup_candidates ()' in connector 'EDQ': "(-1013) Set dedup candidates problem." Detailed error message: Error setting dedup candidates: could not connect to database "oracle:oedq@oedq9-vm/oedq" (code 234,351)(SBL-APS-00118) (0x650076))

I have an Oracle database running on host oedq9-vm, called OEDQ, and a schema called OEDQ with the staging tables within it. I've set up the Batch Data Staging Area in Director and I've set the dnd.properties settings appropriately (under the #Database Setup section).

Any idea what I'm missing?

I haven't found anywhere in the Siebel configuration where the username and password needs to be set for the staging database. I'm guessing that's the problem but there's nothing in the OEDQ-CDS installation guide stating to set these values anywhere.

Any help, much appreciated!

Regards,

mroshaw

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points