RVR-MSSQL-RDBMS-302

1. Issue Summary

   • The error RVR-MSSQL-RDBMS-302 indicates a failure to fetch data from an MSSQL database due to a package size that is too large. When fetching data from MSSQL, the default package size can exceed limits imposed by your database or network configurations. This is a common issue when transferring a large amount of data in a single query or transaction.

2. Action Steps:

   • Adjust Package Size:
     • Change the default package size setting in MSSQL server settings. This can often be adjusted using the SQL Server Management Studio (SSMS) or a similar tool. Look for network packet size settings.
   • Batch Query Results:
     • Consider breaking your queries into smaller batches by implementing pagination or processing the data in chunks. This can be achieved by using techniques such as skipping over a certain number of rows and fetching a set batch size of data in each iteration.
   • Service Configuration:
     • You might need to check and adjust settings related to the Maximum Transfer Unit (MTU) or configure network components to handle larger packet sizes, particularly if you're fetching over a network that is sensitive to packet sizing.
   • Consult SQL Server Logs:
     • Review the SQL Server error logs to identify if there are more specific indicators of where or how the package size exceeds the configurations. This may lead to further solutions related to network, firewall settings, or the SQL server configuration itself.

3 External References:

• MSSQL Connector Documentation: Rivery MSSQL Documentation
• General SQL Server Management: Microsoft SQL Server documentation

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