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
Follow Shangri La:
Website: www.shangrilahawaii.org
Twitter:
@ShangriLaHi
Instagram:
@ShangriLaHawaii
Tumblr:
@ShangriLaHawaii
Facebook:
Shangri La, Doris Duke Foundation for Islamic Art
Blog:
The Door to Shangri La
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.