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.




Old, duplicate value shown in custom-field dropdown

web-app

We have created a drop-down Severity custom field for one of our projects, with a database holding the values for the drop-down. Something like this:

SeverityName | SeverityDescription | SeveritySortOrder

0                     None                                   0

1                     System Crash or Data Loss  1

2                     Major Functionality Bug        2

...

Our problem is that the second item in the drop-down shows a repeated value. It should read "System Crash or Data Loss" but it actually reads "System Crash or Data Loss System Crash or Data Loss." (Might the full-stop be significant?)

We've checked the column of the database table that provides the description, and have tried editing it. When, for example we changed this particular value it to "System Crash", the drop-down item read "System Crash System Crash or Data Loss." i.e. the "System Crash or Data Loss." didn't dissapear. It is only this item in the table that appears this way. The value in this column did at one point read "System Crash or Data Loss." but then we removed the fullstop later.

I wondered whether an old value was being cached somehow, so I tried stopping and restarting the Gemini website. I also tried clearing out the ASPState database. Nothing works.

Any ideas what's causing this.
Sam Jack
· 1 		Sam Jack
Friday, August 11, 2006, 3:50:12 PM
Replies (10)
helpful
0
not helpful

Can you please post the definition of the custom field as it is on the screen?

Also, check that you do not have duplicate IDs in the lookup.
Mark Wing
· 9108 		Mark Wing
Friday, August 11, 2006, 3:56:06 PM
helpful
0
not helpful

Is there any way of uploading a screenshot?
Sam Jack
· 1 		Sam Jack
Friday, August 11, 2006, 3:58:03 PM
helpful
0
not helpful

I've checked that there are no duplicate values.

I have the following settings in the custom field:

Field Name: Severity

Is Active: Yes

Type: Dropdown Listbox

Screen order 1

Screen label Severity

Lookup table name: psslSeverity

Key Name: SeverityName

Description : SeverityDescription

Sort Name: SeveritySortOrder

All the Is Visible Options ticked.

All other options left blank.
Sam Jack
· 1 		Sam Jack
Friday, August 11, 2006, 4:35:00 PM
helpful
0
not helpful

Thanks for this. When do you see the duplicate text?

When viewing the issue? or when actually selecting from the combo?
Mark Wing
· 9108 		Mark Wing
Friday, August 11, 2006, 6:38:47 PM
helpful
0
not helpful

I see duplicate text in both cases. Also if I add the custom field to the main issue grid, I see the same thing.

 I've configured an almost identical custom field in a different project, and I get the same problem there as well.
Sam Jack
· 1 		Sam Jack
Friday, August 11, 2006, 6:43:35 PM
helpful
0
not helpful

Is it possible for you to create a new Gemini database?

If so point the web app to the new database and create a new look up with 2 fields, say a and b with the values of 1 a, 2 b, 3 c.

Does it work as expected?

 
Mark Wing
· 9108 		Mark Wing
Friday, August 11, 2006, 6:49:00 PM
helpful
0
not helpful

We have in fact already tried this: we created a new installation of 2.0.5 with a fresh database on a different server, and created the same table as I described above for the custom field. Everything works fine in this case.
Sam Jack
· 1 		Sam Jack
Monday, August 14, 2006, 10:32:27 AM
helpful
0
not helpful

Yes, but try using the existing installation against a new database.

From checking the code we think the problem must be duplicate ID, could you please double check again?
Mark Wing
· 9108 		Mark Wing
Monday, August 14, 2006, 10:45:30 AM
helpful
0
not helpful

I've managed to fix the problem now: somehow a newline character had got entered into the database cell of the erroneous value, and the duplicate value was hiding after that (Enterprise Manager by default obviously only showing the one line of text). Simply by deleting all text to the right of the value I wanted, I cleared the error.

Sorry to bother you!
Sam Jack
· 1 		Sam Jack
Monday, August 14, 2006, 12:01:45 PM
helpful
0
not helpful

No worries, thanks for the update.
Mark Wing
· 9108 		Mark Wing
Monday, August 14, 2006, 12:06:34 PM