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
Error Code: RVR-MYSQL-RDBMS-30202Likely 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
- Confirm the MySQL user can access
INFORMATION_SCHEMAand runSHOW COLUMNS FROM <table_name>for the tables involved. - Check table and column names for mixed case or special symbols.
- Review the MySQL logs for schema-access or permission errors.
- Confirm the connector driver is current and compatible with the server version.
04Official documentation
→Related errors
- RVR-POSTGRESQL-RDBMS-302: cannot retrieve column description (PostgreSQL)RVR-POSTGRESQL-RDBMS-302 means the connector could not retrieve column descriptions from PostgreSQL. Check read access to the system catalogs and re-run schema discovery after schema changes.
- RVR-ACTIVATE-200: failed to get metadata from the databaseRVR-ACTIVATE-200 means the platform could not retrieve metadata from the database, because the connection is invalid or the network is blocked. Verify the connection settings and the user's permission to read metadata.
- RVR-MSSQL-RDBMS-202: failed to get last synchronization version for tableRVR-MSSQL-RDBMS-202 means Data Integration could not get a table's last synchronization version through Change Tracking. Confirm Change Tracking is enabled for the database and table, then re-initialize the table if needed.
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