Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

balrajprabhu
Contributor II

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
balrajprabhu
Contributor II

Re: Unable to pull data from SQL server?

Any suggestions?

MVP & Luminary
MVP & Luminary

Re: Unable to pull data from SQL server?

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
Valued Contributor II

Re: Unable to pull data from SQL server?

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

balrajprabhu
Contributor II

Re: Unable to pull data from SQL server?

Thank you guys !!!!