Resolving Database Errors In The Audit Trail When Using IPv6 addresses

On Firefox 9 and other browsers where IPv6 addresses are passed to FocusOPEN, the audit trail can break due to SQL Server database field length truncation errors, causing FocusOPEN to cease to function. This problem is resolved as of version 3.4.2 (scheduled for release in January 2012). To fix this in previous editions, run the following SQL update scripts to change the length of fields where the IP address is stored:

ALTER TABLE AuditUserHistory ALTER COLUMN IpAddress VARCHAR(50)
GO
 
ALTER TABLE AuditAssetHistory ALTER COLUMN IpAddress VARCHAR(50)
GO
 
ALTER TABLE AuditAssetSearch ALTER COLUMN IpAddress VARCHAR(50)
GO
 
ALTER TABLE IpAddress ALTER COLUMN IpAddressValue VARCHAR(50)
GO
 
troubleshooting/ipv6-audit-trail-errors/start.txt · Last modified: 2012/01/10 08:07 by admin