Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Duplicate Entries viewing issues

web-app

I tried looking for "dupes" in the Issue Status or Type lookups and found none. I looked at the lookup up tables (I'm assumimg these are the ones ending in lut) and I only found one table that looks suspect, but I'm not sure.  The table is : issuestatetransitionlut

Here is the content of that table:

statusid otherstate statetype tstamp
2 1 0 000000000000089B
3 1 0 000000000000089C
3 2 0 000000000000089D
4 3 0 00000000000013CA
4 5 0 00000000000013CB
1 2 1 00000000000008A0
1 3 1 00000000000008A1
2 3 1 00000000000008A2
2 4 1 00000000000008A3
3 4 1 00000000000008A4
5 3 1 00000000000013C2
5 4 1 00000000000013C3

Please advise.  Anything else I can look at ?
Bruno989
· 1 		Bruno989
Wednesday, June 7, 2006, 8:46:32 PM
Replies (4)
helpful
0
not helpful

This table looks fine.

Please make sure you check:

  • issueprioritylut
  • issueresolutionlut
  • issuerisklevellut
  • issuestatuslut
  • issuetypelut

What has changed?
Saar Cohen
· 5000 		Saar Cohen
Wednesday, June 7, 2006, 10:53:49 PM
helpful
0
not helpful

I checked those tables and all seems fine.  The only remote thing I can see is that the image file in the "issuetypelut" table is used more than once.  Below are all the tables in question:

 

-----------------------------------------------------------------------
       issueprioritylut

rowid   seq     priorityid      prioritydesc    imagepath       tstamp
1       1       1       Low     images/Priority_Trivial.gif     0000000000001094
2       2       2       Medium  images/Priority_Minor.gif       0000000000001095
3       3       3       High    images/Priority_Major.gif       0000000000001096
4       4       4       Show Stopper    images/Priority_ShowStopper.gif 0000000000000890

-----------------------------------------------------------------------
       issueresolutionlut

resid   seq     isfinal resdesc tstamp
1       1       0       Unresolved      00000000000008A9
2       2       1       Won't Fix       00000000000008AA
3       3       1       Duplicate       00000000000008AB
4       4       0       Cannot Reproduce        00000000000008AC
5       5       1       Complete        00000000000008AD
6       6       0       Cancelled       00000000000012B2


-----------------------------------------------------------------------
       issuerisklevellut

rowid   seq     riskid  riskdesc        imagepath       tstamp
1       1       1       No Risk         00000000000008B0
2       2       2       Low             00000000000008B1
3       3       3       Medium          00000000000008B2
4       4       4       High            00000000000008B3

 

-----------------------------------------------------------------------
       issuestatuslut

statusid        seq     isfinal statusdesc      statustype      tstamp
1       1       0       Unassigned      0       00000000000013C4
2       2       0       Assigned        1       00000000000013C5
3       3       0       In Progress     0       00000000000013C6
4       4       1       Closed  0       00000000000013C9
5       5       0       Reopened        0       00000000000013C8

 

-----------------------------------------------------------------------
*       issuetypelut

rowid   seq     typeid  typedesc        imagepath       tstamp
1       1       1       Bug     images/TypeBug.jpg     00000000000010C0
2       2       2       Enhancement     images/TypeEnhancement.jpg     000000000000109C
3       3       3       Emergency       images/TypeNewFeature.jpg      000000000000109B
4       5       4       Issues  images/TypeTask.jpg    000000000000109D
5       4       5       Internal        images/TypeTask.jpg    000000000000109E
6       6       5       Investigation   images/TypeTask.jpg    00000000000019F7

----------------------------------------------------------------------
Bruno989
· 1 		Bruno989
Thursday, June 8, 2006, 2:04:37 PM
helpful
0
not helpful

Your issue type lookup contains duplicate typeid (5). Change it.
Mark Wing
· 9108 		Mark Wing
Thursday, June 8, 2006, 2:13:53 PM
helpful
0
not helpful

That worked.  Thank You
Bruno989
· 1 		Bruno989
Thursday, June 8, 2006, 4:55:32 PM