A failure might occur when you attempt to register an Oracle, a PostgreSQL, or an Amazon Redshift table to metadata. The following error messages are generated:

This issue can occur when you use any of the following methods to register the table:

• SAS^® Management Console 9.4M6
• SAS^® Data Integration Studio 4.904
• the METALIB procedure

This issue manifests in any table which meets both of the following conditions:

• A primary key definition is present in two columns of the parent table.
• Two or more foreign keys are associated with this primary key in the parent table.

For example, this issue impacts the metadata registration of the Common Data Model CI_CAMP_GRP_PAGE table. 

In this particular case, the parent table CI_CAMP_GRP_PAGE has a primary key  that is associated with the two columns CAMPAIGN_GROUP_SK and PAGE_NM.  

A foreign-key reference is defined in each of these three child tables:

• CI_CAMP_GRP_PAGE_CHAR_UDF
• CI_CAMP_GRP_PAGE_DATE_UDF
• CI_CAMP_GRP_PAGE_NUM_UDF

The problem affects Rev. 940_20w21 and requires a fix for environments that use Oracle, PostgreSQL, or Amazon Redshift.

To obtain a fix for Oracle, see SAS Note 65900, "Registering an Oracle table to the metadata might fail and generate an error."

To obtain a fix for PostgreSQL or Amazon Redshift, contact SAS Technical Support

Operating System and Release Information

A fix for this issue for Base SAS 9.4_M6 is available at:

A fix for this issue for SAS/ACCESS Interface to PostgreSQL 9.4_M6 is available at: