-
Bug
-
Resolution: Done
-
Highest
-
Honolulu Release
-
None
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')