Occasional error when using SSIS as report data source

• lmacdonald

  Hall of Fame

  Points: 3763

  More actions

  September 11, 2014 at 10:34 am

  #296092

  About once a month, our SSRS stops responding. I have to kill the process and start it again before I can browse the reporting server. I regularly see an error in the logs after SSRS connects to a SSIS data source, and often this is about the same time the reporting server stop responding. The server is 2008R2(RTM) - no service packs, running on Windows NT Enterprise 6.1 (SP1). Not every log shows an error when connecting to the SSIS data source, like I said it will go fine for about a month, and not every error kills the reporting service. Has anyone experienced an issue with SSIS data sources like this? Thanks!

  INFO: A wrapper has been created for the connection to the SSIS data source.

  webserver!ReportServer_0-8!4a14!09/11/2014-10:33:20:: i INFO: Processed report. Report='/Report/Name', Stream=''

  httpruntime!ReportServer_0-8!5b2c!09/11/2014-10:33:28:: e ERROR: RsWorkerRequest::EndOfRequest: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

  at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.EndOfRequest(Int32 fConnectionClosed, Int32 fExecuting)

  at ReportingServicesHttpRuntime.RsWorkerRequest.EndOfRequest(Boolean discontinuePipeline)

  INFO: A wrapper has been created for the connection to the SSIS data source.

  extensionfactory!ReportServer_0-2!590c!09/11/2014-11:26:24:: e ERROR: Exception caught instantiating TERADATA report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c' or one of its dependencies. The system cannot find the file specified.

  File name: 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c'

  at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)