Can't login into DCAE Dashboard

Credentials for DCAE Dashboard (su1234:fusion) are not working, because there is no entry in postgres db. Looking at dashboards logs we can see errors.

psql:/tmp/create_table.sql:1015: ERROR:  invalid value "U" for "Y"
DETAIL:  Value must be an integer.
INSERT 0 1
psql:/tmp/create_table.sql:1021: ERROR:  insert or update on table "fn_user_role" violates foreign key constraint "fk_fn_user__ref_172_fn_user"
DETAIL:  Key (user_id)=(1) is not present in table "fn_user".

The issue may be because of postgress container image change from: crunchydata/crunchy-postgres:centos7-10.11-4.2.1

to: crunchydata/crunchy-postgres:centos8-13.2-4.6.1

seems that syntax of: to_date function changed.

Proposed solution:

Update:

to_date('21-AUG-14','%d-%M-%Y')

according to (https://www.postgresqltutorial.com/postgresql-to_date/) to:

to_date('21-AUG-14','dd-MON-YY')