Thanks Chad. TMS tech support suggested the same fix and it has helped. I can now use and add to the thesaurus normally without it crashing (hooray!). I'm still getting the error messages though and seeing some other weirdness. Christine, they have given us a script to run against the thesaurus database. Our IT guy is going to run it as I'm not savvy enough to try but contact TMS support and they can send it to you or email me off-list. It seems to be a common problem
Margaret Bullock | TACOMA ART MUSEUM
Curator of Collections and Special Exhibitions
253.272.4258 x 3019
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of TMSUSERS automatic digest system
Sent: Monday, February 03, 2014 2:00 PM
To: [log in to unmask]
Subject: TMSUSERS Digest - 1 Feb 2014 to 3 Feb 2014 (#2014-9)
There are 2 messages totaling 1171 lines in this issue.
Topics of the day:
1. Problem with geography thesaurus (2)
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
----------------------------------------------------------------------
Date: Mon, 3 Feb 2014 07:54:35 -0600
From: Christine Droll <[log in to unmask]>
Subject: Re: Problem with geography thesaurus
Chad,
I, too, am experiencing this problem. I did as you suggested and made the change in the DB config, but it's still throwing the error.
I would like some help as to how to do the second step in going into the back end to fix the thesaurus entries.
Thank you.
Christine
Christine Droll
Collections Database Administrator
The Nelson-Atkins Museum of Art
4525 Oak Street
Kansas City, MO 64111-1873
T: 816-751-1333
F: 816-751-0499
[log in to unmask]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Saturday, February 01, 2014 9:24 AM
To: [log in to unmask]
Subject: Re: Problem with geography thesaurus
Margaret, This is the result of a collation problem, and won't manifest unless you add more then 26 terms to a node.
In DB Config check the Value under System>Pattern.Alphas.List. The value should be "ABCDEFGHIJKLMNOPQRSTUVWXYZ" instead of "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" (without the quotation marks).
Changing the Pattern.Alphas.List will prevent anymore errors from occurring, but you will need to go into the back end to fix the thesaurus entries which are throwing the error. Gallery Systems should be able to help with that, or you can contact me directly.
~Chad
On Fri, Jan 31, 2014 at 5:38 PM, Margaret Bullock <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Recently our geography thesaurus crashed while someone was adding a new term and ever since then we get the following error message whenever we open it
Key is not unique in collection
[Error: -2147024809<tel:2147024809>]
[FillNextLevel.frmMain]
and it also won't less us use at all the listings associated with the term it was on when it crashed. I've emailed TMS Tech Support but thought I would also check with the listserv to see if anyone had a similar problem.
Thanks
Margaret Bullock
Margaret Bullock | TACOMA ART MUSEUM
Curator of Collections and Special Exhibitions
253.272.4258 x 3019<tel:253.272.4258%20x%203019>
[cid:image001.jpg@01CF20B5.2E4FB9E0]<https://urldefense.proofpoint.com/v1/url?u=http://www.pauselifeplayart.org/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=cGjXQl9VgLMeYjvA%2FUXCNmBSfnJoSRtPg1xAK6A6JCU%3D%0A&s=3f33a31f91e096b51a6c1b21af07c3db6ad23dfb7fc56b2799e6539654f8cc1e>
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
------------------------------
Date: Mon, 3 Feb 2014 15:29:40 +0000
From: "Garton, Susan" <[log in to unmask]>
Subject: Re: Problem with geography thesaurus
For the record, we experienced this problem too. I did not add more than 26 terms anywhere, so I'm not sure what caused it. Changing the value of the System>Pattern.Alphas.List fixed the problem for now, and I plan to run the script to fix the thesaurus on the back end soon...
Sue Garton
Data Administrator
National Portrait Gallery
(202) 633-8554 / [log in to unmask]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Saturday, February 01, 2014 10:24 AM
To: [log in to unmask]
Subject: Re: Problem with geography thesaurus
Margaret, This is the result of a collation problem, and won't manifest unless you add more then 26 terms to a node.
In DB Config check the Value under System>Pattern.Alphas.List. The value should be "ABCDEFGHIJKLMNOPQRSTUVWXYZ" instead of "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" (without the quotation marks).
Changing the Pattern.Alphas.List will prevent anymore errors from occurring, but you will need to go into the back end to fix the thesaurus entries which are throwing the error. Gallery Systems should be able to help with that, or you can contact me directly.
~Chad
On Fri, Jan 31, 2014 at 5:38 PM, Margaret Bullock <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Recently our geography thesaurus crashed while someone was adding a new term and ever since then we get the following error message whenever we open it
Key is not unique in collection
[Error: -2147024809<tel:2147024809>]
[FillNextLevel.frmMain]
and it also won't less us use at all the listings associated with the term it was on when it crashed. I've emailed TMS Tech Support but thought I would also check with the listserv to see if anyone had a similar problem.
Thanks
Margaret Bullock
Margaret Bullock | TACOMA ART MUSEUM
Curator of Collections and Special Exhibitions
253.272.4258 x 3019<tel:253.272.4258%20x%203019>
[L_CampaignPauseLifePlayArt]<https://urldefense.proofpoint.com/v1/url?u=http://www.pauselifeplayart.org/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=cGjXQl9VgLMeYjvA%2FUXCNmBSfnJoSRtPg1xAK6A6JCU%3D%0A&s=3f33a31f91e096b51a6c1b21af07c3db6ad23dfb7fc56b2799e6539654f8cc1e>
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
------------------------------
End of TMSUSERS Digest - 1 Feb 2014 to 3 Feb 2014 (#2014-9)
***********************************************************
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|