RVR-RDBMS-310

1. Issue Summary

The error "Failed to get Custom Query mapping" with Error Code: RVR-RDBMS-310 indicates an issue when attempting to execute a custom query within Rivery's RDBMS data connector. This usually arises from incorrect or unsupported query syntax or mapping issues in the query context.

2. Action Steps

To resolve this error, consider the following steps:

1. Check the Query Syntax:

   • Ensure your custom query is using proper SQL syntax and is supported by the Rivery platform. Rivery only supports single SELECT statements for custom queries and does not allow SQL scripts with multiple statements or non-selective actions like INSERT or UPDATE【4:1†Rivery Documentation 202408 (2).pdf】.

2. Verify Data Types and Casting:

   • If your query involves complex data types or XML fields, ensure they are properly cast to string types. Rivery supports XML but requires casting using syntax like CAST(SomeField AS NVARCHAR(MAX))【4:1†Rivery Documentation 202408 (2).pdf】.

3. Check Mapping and Auto-Mapping:

   • Use the auto-mapping feature to ensure all necessary fields are correctly mapped. Misaligned fields can cause mapping errors; thus, verify that your fields in the source table are correctly matched to the expected types and names in the destination【4:0†Rivery Documentation 202408 (2).pdf】.

4. Database Specific Considerations:

   • Specific databases can have nuanced requirements or limitations. Ensure that any database-specific functions or features used within your query are compatible with Rivery.

5. Consult Rivery Documentation and Examples:

   • Reference detailed examples in the Rivery documentation for setting up custom queries. This can often illuminate potential pitfalls in writing these queries correctly【4:4†Rivery Documentation 202408 (2).pdf】.

3. External References

• Rivery Documentation on Custom Queries (navigate to the relevant database section for specific instructions or limitations)【4:1†Rivery Documentation 202408 (2).pdf】.
• For additional information on SQL features and compatibility, always refer to the official documentation of the RDBMS you are using.

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