Installation of JBoss ON fails with the message "ERROR: Hash/Modulo distribution column does not refer to hash/modulo distribution column in referenced table." when postgres-XL is used as a database
Issue
-
JBoss ON installation fails with the error:
ERROR [org.rhq.core.db.setup.DBSetup] {DBSetup.fata-sql-exception}Failed to create table [RHQ_CONFIG_PROP_DEF] [SQL=[CREATE TABLE RHQ_CONFIG_PROP_DEF (ID INTEGER NOT NULL PRIMARY KEY, NAME CHARACTER VARYING(255), DISPLAY_NAME CHARACTER VARYING(100), DESCRIPTION CHARACTER VARYING(1000), MIN_ENTRIES INTEGER, MAX_ENTRIES INTEGER, DEFAULT_VALUE CHARACTER VARYING(2000), REQUIRED BOOLEAN, READONLY BOOLEAN, SUMMARY BOOLEAN, ACTIVATION_POLICY CHARACTER VARYING(20), GROUP_ID INTEGER REFERENCES RHQ_CONFIG_PROP_GRP_DEF, ORDER_INDEX INTEGER, VERSION CHARACTER VARYING(50), PARENT_MAP_DEFINITION_ID INTEGER REFERENCES RHQ_CONFIG_PROP_DEF, PARENT_LIST_DEFINITION_ID INTEGER REFERENCES RHQ_CONFIG_PROP_DEF, SIMPLE_TYPE CHARACTER VARYING(20), ALLOW_CUSTOM_ENUM_VALUE BOOLEAN, DTYPE CHARACTER VARYING(10) NOT NULL, CONFIG_DEF_ID INTEGER REFERENCES RHQ_CONFIG_DEF, UNITS SMALLINT, DYNAMIC_TYPE CHARACTER VARYING(20), DYNAMIC_KEY CHARACTER VARYING(128))]; ErrorCode=[0]; SQLState=[42601]; Message=[ERROR: Hash/Modulo distribution column does not refer to hash/modulo distribution column in referenced table.]; Type=[org.rhq.core.db.ExtendedSQLException]]: org.rhq.core.db.ExtendedSQLException: ERROR: Hash/Modulo distribution column does not refer to hash/modulo distribution column in referenced table.
-
Installation of JBoss ON fails with the message "ERROR: Hash/Modulo distribution column does not refer to hash/modulo distribution column in referenced table." when postgres-XL is used as a database
Environment
- Red Hat JBoss Operations Network (ON) 3.3
- Postgres-XL 9.5
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.