RVR-POSTGRESQL-RDBMS-302

Issue summary

• The error code RVR-POSTGRESQL-RDBMS-302 indicates a failure in retrieving the column description for a PostgreSQL data connector in Data Integration. This error is often linked to issues with how you manage or access metadata or schema information during the connection setup or data extraction process.

Action steps

To resolve the error, follow these steps:

• Verify Connection Configuration: Ensure that the connection to the PostgreSQL database is properly configured. This includes checking credentials, network accessibility, and any specifics regarding PostgreSQL access levels.
• Check Permissions: Verify that the database user has adequate permissions to access the necessary metadata views. This often includes read access to system catalogs such as information_schema.columns.
• Update Data Integration Schemas: In Data Integration, ensure that the schema mapping for your PostgreSQL source is up-to-date. You can do this by re-running the schema discovery or auto-mapping function.
• Review PostgreSQL Version Compatibility: Ensure that the PostgreSQL version in use Data Integration supports by Data Integration. Generally, Data Integration supports all standard-supported versions of PostgreSQL.
• Troubleshoot Schema Changes: If there have been recent changes in the database schema, re-synchronize the metadata in Data Integration to reflect the current structure.

External references

• You can find more details on setting up PostgreSQL connections in Data Integration documentation: Data Integration PostgreSQL Connection
• For details on PostgreSQL's system catalogs which store information about database objects, you can refer to the PostgreSQL official documentation: PostgreSQL System Catalogs

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.