Hello,
Yes, we have experienced this same issue at NGA.  We are using TMS 2012 SP2.
We get a message like this:
There is already an object named '#GARNERH_h-garner_ValidateCrates_939' in the database.

SQL:
CREATE TABLE [#GARNERH_h-garner_ValidateCrates_939]
(
    ComponentID INT PRIMARY KEY
    ,LocationID INT
    ,CrateID INT
)
[Error: -2147217900]
[frmObjLocation.InitCratesTempTable]

Source:
GSUtilities.CSystemInfo.DBExecuteThrowErr

If you figure out what the issue is, let us know!  We will do the same.
Elizabeth

Elizabeth Concha, Collection Information Systems Assistant
National Gallery of Art
phone 202-842-6939
email: [log in to unmask]



From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Eddy Almonte
Sent: Thursday, January 14, 2016 4:41 PM
To: [log in to unmask]
Subject: Deactivating Location Moves

Hello fellow TMS’ers,

Has anyone had trouble lately with deactivating the current location move of an object under location history? We used to be able to deactivate any location move of an object (even the current location), but now we can only deactivate anything except the current location. The weird thing is, sometimes deactivating the current location move works successfully, but most of the time we get an error message.

I’m curious to know if this happens to anyone else…

Thanks in advance!
Eddy


Eddy Almonte
Assistant Registrar
Colección Patricia Phelps de Cisneros
2 East 78th street
New York, NY 10075
www.coleccioncisneros.org<http://www.coleccioncisneros.org><http://www.coleccioncisneros.org/>


Statement of Confidentiality

THE INFORMATION CONTAINED IN THIS E-MAIL IS INTENDED FOR THE EXCLUSIVE USE OF THE ADDRESSEE AND MAY CONTAIN CONFIDENTIAL OR PRIVILEGED INFORMATION. IF YOU ARE NOT THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT ANY FORM OF DISSEMINATION OF THIS COMMUNICATION IS STRICTLY PROHIBITED. IF THIS E-MAIL WAS SENT TO YOU IN ERROR, PLEASE IMMEDIATELY NOTIFY US BY PHONE.
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.