ERROR: Duplicate primary/unique key detected in join

Moderator: NorbertKrupa

Post Reply
User avatar
janice
Intermediate
Intermediate
Posts: 51
Joined: Wed May 30, 2012 1:14 pm

ERROR: Duplicate primary/unique key detected in join

Post by janice » Wed May 30, 2012 1:21 pm

Hi there,

We're getting the following error during a Cognos cube build from our new Vertica database:
  • Wed 30 May 2012 07:59:12 AM 2 000001B1 RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
    Wed 30 May 2012 07:59:12 AM 2 000001B1 UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
    Wed 30 May 2012 07:59:12 AM 2 000001B1 UDA-SQL-0107 A general exception has occurred during the operation "open result".
    Wed 30 May 2012 07:59:12 AM 2 000001B1 ERROR: Duplicate primary/unique key detected in join (cognos_wh.cust_billing_line_item x cust_wh.region_dim) using previous join and region_dim_DBD_123_rep_node0001 (PATH ID: 5); value 20192;
We have primary keys on the tables so there can't be duplicates. Does any know if this error is from Cognos or Vertica?

Thanks for your help,
Janice
Everyday is an adventure!

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: ERROR: Duplicate primary/unique key detected in join

Post by id10t » Wed May 30, 2012 2:38 pm


User avatar
janice
Intermediate
Intermediate
Posts: 51
Joined: Wed May 30, 2012 1:14 pm

Re: ERROR: Duplicate primary/unique key detected in join

Post by janice » Thu May 31, 2012 2:55 am

Thanks, sKwa! Sorry, I should have done a search before posting. The link did help explain my dilemma.
Everyday is an adventure!

Post Reply

Return to “Cognos”