RVR-SF-RDBMS-314

1. Issue Summary

   • The error "Failed to create table literal" with Error Code RVR-SF-RDBMS-314 in a Rivery RDBMS data connector typically signifies a problem with creating a table in the database. This could be due to several reasons such as SQL syntax errors, use of reserved keywords, issues with table or column naming conventions, unsupported data types, or existing permissions issues.
   • Based on the Rivery documentation and typical causes, the likely root of the issue can be traced to an aspect of SQL syntax or naming conventions that the Rivery platform is enforcing at the creation of a new table.

2. Action Steps:

   • Check SQL Syntax and Constraints:
     • Verify the SQL query used to create the table for valid syntax and ensure no reserved keywords are used as identifiers. Enclose any reserved words in double quotes as identifiers to differentiate them from reserved keywords.
   • Naming Conventions:
     • Ensure the table name and column names do not contain special characters or uppercase/lowercase mix, as these may not be supported.
     • Check for reserved keywords in your table names or column names and ensure they are appropriately quoted if needed.
   • Permissions and Access:
     • Confirm the user under which the Rivery operation is being executed has the necessary permissions for creating tables and modifying schema in the target database.
   • Data Types and Configuration:
     • Verify that the data types in your table creation command align with the Rivery-compatible data types.
     • Ensure that any configuration settings in the River's schema are correctly defining the data structure and do not conflict with existing database constraints.

3. External References:

   • For further guidance, consult the Rivery Documentation regarding specific database connectors, supported data types, and their configurations.
   • Additionally, review documentation from your specific database provider for handling common SQL syntax and reservation handling, such as Snowflake or SQL Server.

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