October 28, 2013 at 2:11 pm
This report is actually a rather simple report
with 2 parameters.
2 query dataset
1 query dataset returns the values for one of the params and the other is a static list.
the second dataset is generated by:
Select h.YRQ, h.SID, h.College, h.CollegeLevelCredits, h.Name, h.Email, h.DegreeTitle, h.BirthDate, h.Addr, h.City, h.State, h.Zip, h.DayPhone, h.EveningPhone,
h.PriorEdLevel, h.prevColAttended1, h.PrevColAttended2, h.StudentIntent, h.LastUpdate, h.CourseId, h.CourseTitle, h.ColCR, h.ColGPA,
h.MathScore, h.MathLevel, h.MathPlacement, h.MathTestName, h.ReadingScore, h.ReadingLevel, h.ReadingPlacement, h.ReadingTestName, h.WritingScore,
h.WritingLevel, h.WritingPlacement, h.WritingTestName
from DashboardData.dbo.AHC_CollegeReadiness h
where h.runtype = @ReadinessType and h.yrq = @YRQ
This data is staged daily, from a production to the Report and then statically pulled to the report in ssrs.
In SSMS this runs very quickly, in fact instantly. in the SSRS Report, the smallest dataset comes back, slowly, and the report is ok... the other two options fail each time.
I've researched and looked online for a solution, but have been unsuccessful in locating.
Here is the error says: Unhandled exception has occured in your application. If you click Continue. the application will ignore this error and attempt to continue. If you click Quit the application will close immediately.
Not enough Storage is available to process this command.
servers have plenty of memory and disk space.
Thoughts on things to look for, to help solve this problem?
below is the JIT error incase you can decipher anything in there that may be useful.
R
JIT ERROR:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ComponentModel.Win32Exception: Not enough storage is available to process this command
at System.Drawing.BufferedGraphicsContext.CreateCompatibleDIB(IntPtr hdc, IntPtr hpal, Int32 ulWidth, Int32 ulHeight, IntPtr& ppvBits)
at System.Drawing.BufferedGraphicsContext.CreateBuffer(IntPtr src, Int32 offsetX, Int32 offsetY, Int32 width, Int32 height)
at System.Drawing.BufferedGraphicsContext.AllocBuffer(Graphics targetGraphics, IntPtr targetDC, Rectangle targetRectangle)
at System.Drawing.BufferedGraphicsContext.AllocBufferInTempManager(Graphics targetGraphics, IntPtr targetDC, Rectangle targetRectangle)
at System.Drawing.BufferedGraphicsContext.Allocate(IntPtr targetDC, Rectangle targetRectangle)
at System.Windows.Forms.Control.WmPaint(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5472 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
MSReportBuilder
Assembly Version: 10.50.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/MSReportBuilder.exe
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5476 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5468 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Deployment
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
----------------------------------------
Microsoft.ReportingServices.Designer.Controls
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.Designer.Controls.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5476 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5456 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
Microsoft.ReportingServices.ReportDesign.Common
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.ReportDesign.Common.DLL
----------------------------------------
Microsoft.ReportingServices.QueryDesigners
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.QueryDesigners.DLL
----------------------------------------
PresentationCore
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.5453 built by: Win7SP1GDR
CodeBase: file:///C:/Windows/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
WindowsBase
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.5453 built by: Win7SP1GDR
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Microsoft.ReportingServices.Diagnostics
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.Diagnostics.DLL
----------------------------------------
Microsoft.ReportingServices.RsClient
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.RsClient.DLL
----------------------------------------
vratzdam
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
wkpmywmo
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
-gd-ekdk
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
3m5wmmy6
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5468 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
Microsoft.DataWarehouse
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.DataWarehouse.DLL
----------------------------------------
Microsoft.Data.ConnectionUI.Dialog
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.Data.ConnectionUI.Dialog.DLL
----------------------------------------
Microsoft.ReportingServices.ComponentLibrary.Controls
Assembly Version: 10.0.0.0
Win32 Version: 10.50.3721.0 ((KJ_PCU_Main).120518-1225 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.ComponentLibrary.Controls.DLL
----------------------------------------
PresentationFramework
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.5453 built by: Win7SP1GDR
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/PresentationFramework/3.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
Microsoft.ReportingServices.ReportDesign.Forms
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.ReportDesign.Forms.DLL
----------------------------------------
WindowsFormsIntegration
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4902 built by: NetFXw7
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsFormsIntegration/3.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
----------------------------------------
PresentationFramework.Aero
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4902 built by: NetFXw7
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/PresentationFramework.Aero/3.0.0.0__31bf3856ad364e35/PresentationFramework.Aero.dll
----------------------------------------
Microsoft.ReportingServices.ReportPreview
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.ReportPreview.DLL
----------------------------------------
Microsoft.ReportingServices.RichText
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.RichText.DLL
----------------------------------------
Microsoft.ReportingServices.RPLObjectModel
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.RPLObjectModel.DLL
----------------------------------------
Microsoft.ReportingServices.ProcessingCore
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.ProcessingCore.DLL
----------------------------------------
System.Web.Services
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
xnfn9num
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.ReportingServices.Interfaces
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.Interfaces.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
MDXQueryGenerator
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/MDXQueryGenerator.DLL
----------------------------------------
Microsoft.Data.ConnectionUI
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.Data.ConnectionUI.DLL
----------------------------------------
System.Data.OracleClient
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data.OracleClient/2.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
----------------------------------------
Microsoft.ReportingServices.DataExtensions
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.DataExtensions.DLL
----------------------------------------
Microsoft.AnalysisServices.AdomdClientUI
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.AnalysisServices.AdomdClientUI.DLL
----------------------------------------
Microsoft.AnalysisServices.AdomdClient
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1539 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/10.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
----------------------------------------
Microsoft.ReportingServices.QueryDesigners.SharePoint
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.QueryDesigners.SharePoint.DLL
----------------------------------------
Microsoft.ReportingServices.QueryDesigners.SapBw
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.QueryDesigners.SapBw.DLL
----------------------------------------
Microsoft.ReportingServices.DataExtensions.XmlaClient
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.DataExtensions.XmlaClient.DLL
----------------------------------------
Microsoft.ReportingServices.QueryDesigners.Essbase
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.QueryDesigners.Essbase.DLL
----------------------------------------
lksmcswd
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.ReportingServices.SPBProcessing
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.SPBProcessing.DLL
----------------------------------------
Microsoft.ReportingServices.ImageRendering
Assembly Version: 10.0.0.0
Win32 Version: 10.50.4000.0 ((KJ_PCU_Main).120628-0827 )
CodeBase: file:///C:/Users/RichN/AppData/Local/Apps/2.0/MRQWQ2EP.Y0T/1Y28PJPL.DLY/repo..tion_c3bce3770c238a49_000a.0032_9a08cf0b892e413c/Microsoft.ReportingServices.ImageRendering.DLL
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
October 29, 2013 at 11:08 am
thoughts on step or details I could add that will help to help me diagnose this issue?
October 30, 2013 at 4:35 pm
It's been a while but I may have seen this and it was when I was using multi-valued parameters and queries to pull the available parameter values. It turned out there was actual crap being returned by the parameter queries. Don't know why it manifested this way though.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply