Article Details
| Id: | 14041 |
| Product: | finPOWER Connect |
| Type: | FIX |
| Version: | 3.00.02 |
| Opened: | 25/08/2016 |
| Closed: | 26/08/2016 |
| Released: | 07/10/2016 |
| Job: | J017946 |
ISAudit, ISAuditLog and ISLock tables; now correctly truncates columns
The ISAudit, ISAuditLog and ISLock tables may fail to insert records if the Windows User Name is longer than 50 characters.
WARNING: This issue prevents a database from being opened.
The following tables and columns now restrict the length of data inserted into the column.
- ISAudit
- WindowsUser - 50 characters.
- MachineName - 50 characters.
- IPAddress - 48 characters.
- ISAuditLog
- WindowsUser - 50 characters.
- MachineName - 50 characters.
- IPAddress - 48 characters.
- ISLock
- WindowsUser - 50 characters.
- MachineName - 50 characters.
Note, the WindowsUser column's length will be updated in the next finPOWER Connect database upgrade.