As Didi mentioned, we are looking for errors in the below files/dir.
Do you mind to take a look and share the error message?

/var/log/ovirt-engine/setup/*
/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log
/var/log/messages



Didi, Eli, can you please have a look?



Looking at the logs Marcos shared with me I see:

2018-03-21 15:02:30,373-0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.executeRaw:863 execute-result: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '
-u', 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'], rc=1
2018-03-21 15:02:30,374-0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:921 execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u'
, 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'] stdout:
Creating schema engine_20180321150206@localhost:5432/engine_20180321150206
Creating fresh schema
Creating tables...
Creating functions...

2018-03-21 15:02:30,374-0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:926 execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u'
, 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'] stderr:
psql:/usr/share/ovirt-engine/dbscripts/create_functions.sql:1095: ERROR:  must be owner of function uuid_generate_v1
FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions.sql

2018-03-21 15:02:30,374-0400 ERROR otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema schema._misc:428 schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions
.sql
2018-03-21 15:02:30,375-0400 DEBUG otopi.context context._executeMethod:143 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/otopi/context.py", line 133, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", line 430, in _misc
    raise RuntimeError(_('Engine schema refresh failed'))
RuntimeError: Engine schema refresh failed
2018-03-21 15:02:30,376-0400 ERROR otopi.context context._executeMethod:152 Failed to execute stage 'Misc configuration': Engine schema refresh failed
2018-03-21 15:02:30,377-0400 DEBUG otopi.transaction transaction.abort:119 aborting 'DWH Engine database Transaction'
2018-03-21 15:02:30,377-0400 DEBUG otopi.transaction transaction.abort:119 aborting 'Database Transaction'


 A few lines above in the log I see:

********* QUERY **********
CREATE OR REPLACE FUNCTION uuid_generate_v1()
RETURNS uuid STABLE
AS $PROCEDURE$
DECLARE
    v_val BIGINT;
    v_4_1_part CHAR(4);
    v_4_2_part CHAR(4);
    v_4_3_part CHAR(4);
    v_8_part CHAR(8);
    v_12_part CHAR(12);
    v_4_part_max INT;
BEGIN
    PERFORM setseed(random());

    -- The only part we should use modulo is the 4 digit part, all the
    -- rest are really big numbers (i.e 16^8 - 1 and 16^12 - 1)
    -- The use of round(random() * 1000 is for getting a different id
    -- for DC/Cluster in different installations
    v_4_part_max = 65535;-- this is 16^4 -1

    v_val := nextval('uuid_sequence');
    v_4_1_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0');
    v_4_2_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0');
    v_4_3_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0');

    -- generate this part using the clock timestamp
    v_8_part := lpad(to_hex(cast(FLOOR(EXTRACT(EPOCH FROM clock_timestamp())) as bigint)), 8 , '0');

    v_12_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 12, '0');

    RETURN v_8_part || v_4_1_part || v_4_2_part || v_4_3_part || v_12_part;
END;$PROCEDURE$
LANGUAGE plpgsql;
**************************

The log is OVESETUP_CORE/generatedByVersion=str:'4.2.1.7'