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