Qlik Replicate - Error | Insufficient System Memory on resource pool

[deepaksahirwar]

Dear Community,

Do anyone have solution for the error mentioned below.

Topic : Qlik Replicate

Source: SQL Server

Target: Snowflake

______________________________________________

ERROR LOG 1

Stream component 'st_1_SFDC_REPORTING_STAGE_LOGSTREAM' terminated

Cannot initialize subtask

Failed while preparing stream component 'st_1_SFDC_REPORTING_STAGE_LOGSTREAM'.

Failed to connect

RetCode: SQL_ERROR  SqlState: 08001 NativeError: 26 Message: [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server.

Error Log 2

RetCode: SQL_ERROR SqlState: 42000 NativeError: 701 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is insufficient system memory in resource pool 'internal' to run this query. Line: 1 Column: -1

I wish to understand whether the error is from source end or on target server. What could be it's solution.

Thank you in advanced.

Best Regards,

Deepak

[deepaksahirwar · Accepted solution]

Dear Community,

I have got the resolution for the query mentioned above. Would like to share it here

The error  indicates that there is insufficient system memory in resource pool ‘internal’ to run the query. This error is caused by the SQL Server running out of memory while executing the query .

Possible solutions to resolve this issue:

1 Increase the memory allocation: You can increase the memory allocation for the SQL Server to avoid this error. This can be done by increasing the memory limit for the resource pool ‘internal’ 1.

2 Optimize the query: You can optimize the query to reduce the amount of memory required to execute it. This can be done by reducing the number of rows returned by the query, or by optimizing the query execution plan 1.

3 Upgrade the hardware: If the above solutions do not work, you may need to upgrade the hardware to provide more memory to the SQL Server .

If any more solutions then please feel free to post.

Thanks,

Deepak

[Dana_Baldwin]

Hi @deepaksahirwar 

The errors reported do appear to be related to an issue on the source. Microsoft Support should be able to help.

Beyond that, please make sure you are using a supported driver and source SQL Server version for the version of Replicate you are using.

At these links, adjust the version at the top left of the screen.

Client version required: Prerequisites | Qlik Replicate Help

SQL Server version supported: Supported source endpoints #Supported source endpoints | Qlik Replicate Help

Hope this helps,

Dana

[deepaksahirwar]

Dear @Dana_Baldwin ,

Thank you

Best Regards,

Deepak

[SushilKumar]

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar