Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to pull data from SQL server?

Hello,

  Since today morning,I'm getting the following error whenI try to extract data from sql server.

Microsoft OLE DB Provider for SQL Server, ErrorMsg: Could not allocate space for object 'dbo.SORT temporary run storage:  ' because the 'PRIMARY' filegroup is full. Create space by getting rid of  unneeded files, 

4 Replies
Anonymous
Not applicable
Author

Any suggestions?

Gysbert_Wassenaar

The tempdb database on your sql server installation ran out of space. Ask your database administrator to resolve this issue. This is not a qlikview problem, but a sql server problem.


talk is cheap, supply exceeds demand
flipside
Partner - Specialist II
Partner - Specialist II

It sounds like you have run out of the allocated space for your database. Do you manage this database yourself or do you have a SQL DBA to sort it out?  The database needs shrinking to create more disk space or redundant database objects could be backed up and removed or an extra/larger disk added to the server.

flipside

Anonymous
Not applicable
Author

Thank you guys !!!!