SSRS Report Error

Hi, 

I got the below error while running Print general report. The same error is coming while running customer report also. I generated full CIL and synchronization, but error still exist.

TempDB table field cannot be empty for RecId 5637148326.
(S)\Classes\xInfo\add
(S)\Classes\Info\add - line 101
(S)\Classes\Global\error - line 3
(S)\Classes\SrsReportProviderQueryBuilder\initializePreProcessedDetails - line 36
(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 26
(S)\Jobs\

 

Please see the detail error from event viewer.


An error has occurred during report processing. (rsProcessingAborted)

An error has occurred during report processing. (rsProcessingAborted)

Microsoft.Reporting.WinForms.ReportServerException
at Microsoft.Reporting.WinForms.SoapReportExecutionService.ServerUrlRequest(AbortState abortState, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.SoapReportExecutionService.Render(AbortState abortState, String reportPath, String executionId, String historyId, String format, XmlNodeList deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

Query execution failed for dataset 'LedgerJournalDS'. (rsErrorExecutingCommand)

Microsoft.Reporting.WinForms.ReportServerException


An exception occurred in the query metadata execution. The exception is TempDB table field cannot be empty for RecId 5637145329.
(S)\Classes\xInfo\add
(S)\Classes\Info\add - line 101
(S)\Classes\Global\error - line 3
(S)\Classes\SrsReportProviderQueryBuilder\initializePreProcessedDetails - line 36
(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 26
(S)\Jobs\
.

Microsoft.Reporting.WinForms.ReportServerException


TempDB table field cannot be empty for RecId 5637145329.
(S)\Classes\xInfo\add
(S)\Classes\Info\add - line 101
(S)\Classes\Global\error - line 3
(S)\Classes\SrsReportProviderQueryBuilder\initializePreProcessedDetails - line 36
(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 26
(S)\Jobs\


Microsoft.Reporting.WinForms.ReportServerException


TempDB table field cannot be empty for RecId 5637145329.
(S)\Classes\xInfo\add
(S)\Classes\Info\add - line 101
(S)\Classes\Global\error - line 3
(S)\Classes\SrsReportProviderQueryBuilder\initializePreProcessedDetails - line 36
(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 26
(S)\Jobs\


Microsoft.Reporting.WinForms.ReportServerException

Related
Recommended