Environment
Micro Focus Filr 4.x
Situation
After upgrading from 3.x to 4.0 within a Small Deployment, the admin
authentication to the Filr Management Console (port 8443 tool) fails.
The /vastorage/mysql-backup/final-dump.psql file contains this error:
The /vastorage/mysql-backup/final-dump.psql file contains this error:
ERROR: value too long for type character varying(255)
Resolution
Issue the following commands within a terminal session (putty or otherwise) while logged in as root:
Syntax:psql <Database Name> <User Name>Example:psql filr postgres
Issue these two commands:provide the password for the postgres user and hit ENTER. The following will be returned:psql (10.6)
Type "help" for help.
filr=#
ALTER TABLE ss_emailitem ALTER COLUMN recipients TYPE text;
\q