Boomi · Data Integration: MySQL

RVR-MYSQL-RDBMS-302: cannot retrieve column descriptions (MySQL)

Short answer

RVR-MYSQL-RDBMS-302 means the connector could not retrieve column descriptions from MySQL. Check the user's access to INFORMATION_SCHEMA and look for unsupported table or column names.

VerifiedLast verified

01Error text

Boomi error
Error Code: RVR-MYSQL-RDBMS-302

02Likely causes

  • The MySQL user lacks permission to read the schema.
  • Table or column names mix uppercase and lowercase or contain special symbols, which Data Integration does not support.

03How to fix it

  1. Confirm the MySQL user can access INFORMATION_SCHEMA and run SHOW COLUMNS FROM <table_name> for the tables involved.
  2. Check table and column names for mixed case or special symbols.
  3. Review the MySQL logs for schema-access or permission errors.
  4. Confirm the connector driver is current and compatible with the server version.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Boomi work:Open Boomi jobsBoomi rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.