HomeSybaseSybase Error – Sufficient memory cannot be found for the LOAD. Increasing the Load_Memory_MB or decreasing the BLOCK FACTOR or BLOCK SIZE will allow the LOAD to proceed. %1

Sybase Error – Sufficient memory cannot be found for the LOAD. Increasing the Load_Memory_MB or decreasing the BLOCK FACTOR or BLOCK SIZE will allow the LOAD to proceed. %1

In this blog post, you’ll learn more about the Sybase Error Sufficient memory cannot be found for the LOAD. Increasing the Load_Memory_MB or decreasing the BLOCK FACTOR or BLOCK SIZE will allow the LOAD to proceed. %1 and the reason for receiving this error

Sybase SQL Error Message

Sufficient memory cannot be found for the LOAD. Increasing the Load_Memory_MB or decreasing the BLOCK FACTOR or BLOCK SIZE will allow the LOAD to proceed. %1

Reason for this Error

When the user explicitly sets Load_Memory_MB, the LOAD process applies various heuristics for load parameters in an attempt to find a combination such that the memory required is not more than what the user specified. For a fixed width LOAD, BLOCK FACTOR indicates the minimal number of rows that must be read into memory for each read. The default BLOCK FACTOR is 10,000. Decreasing the BLOCK FACTOR will make the LOAD’s internal memory requirements smaller. For a variable length input LOAD, BLOCK SIZE represents the size in bytes in which input data should be read. The default BLOCK SIZE is 500,000 bytes. Decreasing the BLOCK SIZE for a variable width input load will reduce LOAD’s memory requirements. Alternatively, the Load_Memory_MB option setting could be raised.

Leave a Reply

You May Also Like

In this blog post, you’ll learn more about the Sybase Error No plan. HTML_PLAN function is not supported for this...
In this blog post, you’ll learn more about the Sybase Error Division by zero and the reason for receiving this...
In this blog post, you’ll learn more about the Sybase Error Incorrect or missing encryption key and the reason for...