TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Bethany Bannister-Andrews <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Thu, 20 Nov 2014 01:58:14 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (1888 bytes) , text/html (5 kB)
Does anyone else get this error? It happens when I'm attempting to change a user's security group in Database Configuration, and quite randomly. For example, today I changed one department for User A (successfully) and for the next department, I got this error (and for all subsequent attempted changes). It will look like it changed successfully, but if you exit DB Config and then go back in, the departments with the error will be back to their original value. Sometimes it goes away when I reboot my computer, but more often than not, it doesn't fix it and I have to ask a coworker to make the changes for me.

String or binary data would be truncated.
The statement has been terminated.

SQL:
INSERT INTO [DorisDuke]..UserSecurity (UserID, SecurityGroupID, DepartmentID) VALUES (158, 7, 16)
[Error: -2147217833]
[DBInsertWrapper.CSystemInfo]

Source:
GSUtilities.CSystemInfo.DBExecuteThrowErr
GSUtilities.CSystemInfo.ExecuteInsert

Thanks for any suggestions!
Bethany

Bethany Bannister-Andrews
Collections Technician, Shangri La
Doris Duke Foundation for Islamic Art
4055 Papu Circle
Honolulu, HI 96816
(808) 792-5505
www.shangrilahawaii.org<http://www.shangrilahawaii.org/>

Follow Shangri La:
Website: www.shangrilahawaii.org<http://www.shangrilahawaii.org/>
Twitter: @ShangriLaHi<https://twitter.com/shangrilahi>
Instagram: @ShangriLaHawaii<http://instagram.com/shangrilahawaii>
Tumblr: @ShangriLaHawaii<http://shangrilahawaii.tumblr.com/>
Facebook: Shangri La, Doris Duke Foundation for Islamic Art<https://www.facebook.com/pages/Shangri-La-Doris-Duke-Foundation-for-Islamic-Art/202214289815530?ref=br_tf>
Blog: The Door to Shangri La<http://blog.shangrilahawaii.org/wordpress/>


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.


ATOM RSS1 RSS2