Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Megha_More
Partner - Creator
Partner - Creator

Error occured while doing full load

Hello team,

We faced following error while moving data from SQL to postgres .

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 'default' to run this query. Line: 1 Column: -1

What will be the reason behind this.

 

Thanks,

megha

Labels (2)
4 Replies
Steve_Nguyen
Support
Support

@Megha_More 

The error could be many think.

1. what is the Replicate server memory size

2. what was the exact query that was running that cause the memory usage.

3. how many table are on that task

4. does the tables in the task have LOBS

5. have you test on smaller table to check if the issue exist with small table ?

 

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Heinvandenheuvel
Specialist II
Specialist II

- This is 99.99% sure to be a SQLserver issue where things like Replicate Server memory are irrelevant. Involved your source DBA! 

- This is likely to be a VIRTUAL memory issue, not physical, or it could be 'total confusion - as suggested by the 'line 1, column -1'.   Check out https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/701-error-large-batch...  - it mentions  DBCC MEMORYSTATUS

- Did it ever work?

- Is there a TABLE associated with the error ? If there is no immediate name on the message use the THREAD NUMBER from the line with the error, to look back (NotePad++ 'find all in current document') to see what happend prior, and how long ago.

- How quickly does the error come up - right after starting the task? After hours of running, Gigabytes transferred?

- Does it come up right after a particular table is started, or deep into a particular table? For clarity you may want to run the task configured to SINGLE load stream.

- Assuming it is triggered by a specific table, what is special about it? LOBS? Computed / linked columns? Maybe drop some suspect columns from the replication request. Are you using filters or passthru queries?

- Activate logging for SOURCE UNLOAD level TRACE to see the queries used. Execute those in SMSS studio and hopefully get more complete messages?

Good luck,

Hein.

 

 

Barb_Fill21
Support
Support

HI @Megha_More 

I would also show this error to the SQL Server DBA. I agree with @Heinvandenheuvel  that this is probably a Sql Server issue.   I recommend as well to answer @Heinvandenheuvel 's question to give us more information about the issue. 

 

Thanks

Barb

Megha_More
Partner - Creator
Partner - Creator
Author

Hi Team,

Thanks for the responses. Error resolved after doing full load again by cross checking all the connections.

 

Thanks,

Megha.