Error Message: fixed queue overflow
Action:
While uploading a higher number of records to a REST Destination component within a Data Flow Task, the following error message is received.
Error Message:
“fixed queue overflow”.
Solution:
This error is related to the value established in the Data Flow Task parameter called DefaultBufferMaxRows. The defaulted value is 10,000. Because the data flow can connect to different services that have different batch processing and processing speeds, the value of the DefaultBufferMaxRows may need to be adjust lower or maybe even higher depending on the service that is being connected to in the data flow. When the DefaultBufferMaxRows is set too high, you may encounter this error by design as a timer is set that confines the processing time allowed for the buffered rows rather than allow the alternative which could be a package that runs for long periods of times to process the rows.
The solution if you receive this error is to try starting with a value of 1000 (rather than 10,000) and gradually decrement by 100 until the error message is no longer received.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Where can I find the documentation for the Message Queue Task Plus?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Message Queue Task Plus can be found at the following link. For many of the components you can find ...An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP".
Action: When executing an SSIS package containing an ODBC Destination, the following error message occurred. Error Message: An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP". ...Error Message: The process cannot access the file because it is being used by another process
Action: While attempting to generate the token, the following error message is encountered. Error Message: The process cannot access the file because it is being used by another process Solutions: You have to determine which application is keeping ...Error Message: Could not create a managed connection manager
Action: While using Oracle Destination, the following error message was encountered.: Error Message: 'Could not create a managed connection manager' Solution: Most probably the required Oracle ODAC package is not installed on the machine where it ...Error Message: The operation has timed out.
Action: When moving data into a SharePoint list using the SharePoint Destination component, the following error intermittently occurs. Error Message: The operation has timed out. Solution: Try increasing the timeout parameter in the Sharepoint ...