Article Details
Id:10214
Product:finPOWER Connect
Type:FIX
Version:1.06.00
Opened:05/06/2012
Closed:22/06/2012
Released:01/08/2012
Job: J009756

Permission Explorer; may error when setting permissions

The Tools, User Security, Permissions, Permissions Explorer may fail with the following error:

Failed to save Permission.

Failed to add new record in UpdateQueryBuilder.

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

This occurs when setting the following Permission keys because they are longer than 50 characters.

Report.Account Status.DisbursementPayoutReconciliation
Report.Account Status.AccountCorrespondenceExceptionList

The database has been updated to increase the column "PermissionKey" to 100 characters in the "RolePermission" table.