Admin authentication to the Filr :8443 tool fails after upgrade to 4.0

  • 7024088
  • 23-Aug-2019
  • 28-Aug-2019

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:
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
provide the password for the postgres user and hit ENTER.  The following will be returned:
psql (10.6)
Type "help" for help.
filr=#
Issue these two commands:
ALTER TABLE ss_emailitem ALTER COLUMN recipients TYPE text;
\q