Topic
  • 4 replies
  • Latest Post - ‏2014-03-25T09:04:56Z by CQAdmin
raj_kgdr
raj_kgdr
63 Posts

Pinned topic records with same id

‏2014-03-25T03:52:10Z |

Friends, May be something new to me, but wanted to get this cleared from the experts please.

I ran a query today filtering with the id. I furnished the id details as - 4246 and surprisingly I found 2 records with the same id. 

1) Is this possible?

2) How did this happen?

3) Any way to stop this to happen in future?

 

Thanks

  • DonaldN
    DonaldN
    287 Posts

    Re: records with same id

    ‏2014-03-25T04:24:23Z  

    Are you sure they are two record from the same database with the same ID? This can't happen because the primary key in the table should prevent this from happening. Do you have a screen shot showing what's going on?

  • raj_kgdr
    raj_kgdr
    63 Posts

    Re: records with same id

    ‏2014-03-25T04:57:04Z  
    • DonaldN
    • ‏2014-03-25T04:24:23Z

    Are you sure they are two record from the same database with the same ID? This can't happen because the primary key in the table should prevent this from happening. Do you have a screen shot showing what's going on?

    yeah indeed. Attached is the screen shot.

    Attachments

  • DonaldN
    DonaldN
    287 Posts

    Re: records with same id

    ‏2014-03-25T06:19:52Z  
    • raj_kgdr
    • ‏2014-03-25T04:57:04Z

    yeah indeed. Attached is the screen shot.

    It does look very strange. Someone needs to take a closer look into the database and see if there is indeed data corruption. In this case, you should contact IBM Rational Support for further investigation.

  • CQAdmin
    CQAdmin
    103 Posts

    Re: records with same id

    ‏2014-03-25T09:04:56Z  

    This looks to be a customized field. ClearQuest ID itself is always unique. Request you to check the code which is assigning value to this field. And further, check where you have placed that code.

    Thanks.