Skip to main content
Feedback

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 Data Integration 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 Data Integration platform. Data Integration 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.

  2. Verify Data Types and Casting:

    • If your query involves complex data types or XML fields, ensure they are properly cast to string types. Data Integration supports XML but requires casting using syntax like CAST(SomeField AS NVARCHAR(MAX)).

  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. 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 Data Integration.

  5. Consult Data Integration Documentation and Examples:

    • Reference detailed examples in the Data Integration documentation for setting up custom queries. This can often illuminate potential pitfalls in writing these queries correctly.

3. External References

  • Data Integration Documentation on Custom Queries (navigate to the relevant database section for specific instructions or limitations).
  • 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 Data Integration support.

On this Page