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

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content