COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Connection, Viewer, Scheduler => Topic started by: bi4u2 on 24 Jul 2012 01:54:30 PM

Title: Report Fails to Run - 'Insufficient Disk Space'
Post by: bi4u2 on 24 Jul 2012 01:54:30 PM
Has anyone seen this one? Client is running 10.1.1 on SQL Server and a very complex crosstab report will not run. We get this error after the reports goes for about 45 minutes.

RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0115 Inappropriate SQL request. UDA-SQL-0564 [Microsoft SQL Server Native Client 10.0]Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (SQLSTATE=42000, SQLERRORCODE=1101)
Title: Re: Report Fails to Run - 'Insufficient Disk Space'
Post by: Raghavendra Tare on 10 Dec 2015 03:09:54 AM
I am getting the same error while running a scheduled report in production server.
Please suggest a solution if you had resolved the issue you faced.