RVR-POSTGRESQL-RDBMS-302

1. Issue Summary

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

2. Action 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 Rivery Schemas: In Rivery, 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 is supported by Rivery. Generally, Rivery 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 Rivery to reflect the current structure.

3. External References:

   • You can find more details on setting up PostgreSQL connections in Rivery's documentation: Rivery 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

If the issue persists or you need further assistance, please open a ticket with Rivery support.