I have a SSRS 2008 R2 Tablix with two date parameters (StartDate and EndDate). The report generates fine no matter the date range. With a small date range selected (say 1 week) the column/row drilldowns work perfectly. But when I select a wider date range (say a month) and drill into one of the columns I get the following error: An internal error occurred on the report server. See the error log for more details. (rsInternalError) I took a look at the ExecutionLog and the Status showed as rsSuccess for this execution. I then looked in the Error Log and found: library!ReportServer_0-18!1ba8!09/10/2010-06:22:23:: i INFO: RenderFromSession('/ExigoReports/SalesByStateWarehouse') library!ReportServer_0-18!1ba8!09/10/2010-06:22:24:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Invalid offset for item. ReferenceID: fffffffffffffbdc, Offset: -1060, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.; library!ReportServer_0-18!1ba8!09/10/2010-06:22:30:: i INFO: Exception InternalCatalogException dumped to: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles flags= ReferencedMemory, AllThreads, SendToWatson library!ReportServer_0-18!1ba8!09/10/2010-06:22:30:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. webserver!ReportServer_0-18!1ba8!09/10/2010-06:22:30:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. library!WindowsService_10!8f4!09/10/2010-06:27:25:: i INFO: Call to CleanBatch() library!WindowsService_10!8f4!09/10/2010-06:27:25:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 12 chunks, 0 running jobs, 0 persisted streams, 31 segments, 31 segment mappings, 0 edit sessions. library!WindowsService_10!8f4!09/10/2010-06:27:25:: i INFO: Call to CleanBatch() ends A SQL Dumper error log was also produced: (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 5476 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0053DBC8 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters: (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 5476 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0053DBC8 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL> (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000 (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL> (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL> (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL> (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used (1C30:1F6C) 09/10/10 06:22:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used (1C30:1F6C) 09/10/10 06:22:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used (1C30:1F6C) 09/10/10 06:22:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\SQLDmpr0006.mdmp (1C30:1F6C) 09/10/10 06:22:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' (1C30:1F6C) 09/10/10 06:22:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0' (1C30:1F6C) 09/10/10 06:22:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0' (1C30:1F6C) 09/10/10 06:22:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' (1C30:1F6C) 09/10/10 06:22:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1' (1C30:1F6C) 09/10/10 06:22:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1' (1C30:1F6C) 09/10/10 06:22:30, ACTION, ReportingServicesService.exe, Watson Invoke: No I loked all over and could not find a post that contaild any info on a "Invalid offset for item. ReferenceID: fffffffffffffbdc, Offset: -1060" error messages. Anyone see this before? Thanx, //Jose

Try the links below, u should get ur answer there or let me know. http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/aeb53869-9c8f-4a5c-9f1b-aa3507a2b9e0/ http://social.technet.microsoft.com/Forums/en-US/Forefrontclientreporting/thread/f090548c-6ebe-4b05-8003-f560263bbefd HTH

@HTH, I took a look at those links in my research prior to posting my question. Neither helped, thanks though. Is there something else I can try? //Jose

add an <appSettings> section in the web.config in ReportServer and give a clear directive. <appSettings> <clear /> </appSettings> That clears the inherited values for appSettings and ReportServer is good to go. This change enabled both the root ReportManager to work as well as the ReportServer viewer control. http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/a22799e1a354ea79/9aca125282998795 Hope This Helps Thanks

Sorry, I should have stated that I not only read but tried the solutions in the links. After I added that piece of code to the ReportServer web.config file, I restarted IIS and SSRS to no avail. I'm still getting an error on drilldown. //Jose

Hi, Try to apply the latest hot fix to see if it helps. Download cu2 from http://support.microsoft.com/kb/2120979/ and then install it. thanks, Jerry

Hi Jerry, Thanks for the link. I was able to apply the 416150 StreamInsightClient hotfix and the 416149 StreamInsight hotfix. I am still receiving the error on column group expand :( Is there anything else we can try? Here is the latest log results (the offset changed address): <Header> <Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1540 )</Product> <Locale>English (United States)</Locale> <TimeZone>Eastern Daylight Time</TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__09_15_2010_00_01_53.log</Path> <SystemName>GL-SERVER-A2</SystemName> <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName> <OSVersion>6.0.6002</OSVersion> <ProcessID>1188</ProcessID> <Virtualization>None</Virtualization> </Header> library!WindowsService_1!788!09/15/2010-00:01:53:: i INFO: Call to CleanBatch() library!WindowsService_1!788!09/15/2010-00:01:53:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions. library!WindowsService_1!788!09/15/2010-00:01:53:: i INFO: Call to CleanBatch() ends library!ReportServer_0-1!16e8!09/15/2010-00:03:08:: i INFO: RenderFromSession('|yk4j3vbrccxfzhbg5fwrvny4|@|/ExigoReports/Genewize/SalesByStateWarehouse|') library!ReportServer_0-1!16e8!09/15/2010-00:03:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Invalid offset for item. ReferenceID: fffffffffffffd52, Offset: -686, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.; library!ReportServer_0-1!16e8!09/15/2010-00:03:12:: i INFO: Exception InternalCatalogException dumped to: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles flags= ReferencedMemory, AllThreads, SendToWatson library!ReportServer_0-1!16e8!09/15/2010-00:03:12:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. webserver!ReportServer_0-1!16e8!09/15/2010-00:03:12:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. library!ReportServer_0-1!16e8!09/15/2010-00:03:23:: Call to DeleteItemAction(|yk4j3vbrccxfzhbg5fwrvny4|@|/ExigoReports/Genewize/SalesByStateWarehouse|). //Jose

Hello togehter, are there any solutions for this error? I got the same error when i use the drilldown of a SSRS-Matrix: Invalid offset for item. RefenceID: ffffffffffffff15, Offset: -235 Thank you

Hello, Has anyone found a solution to this issue? There isn't much data online about it. Thanks, Chris