I have a big problem with Reporting Services, and I absolytely don't know what to do with it!!

To explain brefly, we developped a data extension for RS to add a provider for our iSeries (AS-400). In the data extension, we call the DAAB(Data Access Application block) that we customized also, to link with the .net provider of IBM. This setup is working fine with Report Designer, and also with Report Server. We are able to render all the reports we want.

But we recently found that there is a problem concerning the connection to the data source. This problem is happening every morning, and the only solution we found by this time was to restart IIS and the reporting services service. This is not very clean, and we want to know what is causing this...!

Here is the error RS returns when we render a report (when it doesn't work):

An exception has occurred in data source 'Cie'. Details: Microsoft.ReportingServices.ReportProcessing.Repor tProcessingException:

Échec de l'exécution de la requête pour le dataset « Cie ». -->
Invalid section name. The section 'dataConfiguration' does not exist in the requested configuration file 'C:/Program Files/Microsoft SQL Server/MSSQL/Reporting Services/ReportServer/web.config' or the file 'c:\windows\microsoft.net\framework\v1.1.4322\Conf ig\machine.config'. Make sure that the 'enterpriseLibrary.configurationSections' configuration section exists in one of the files and that the section 'dataConfiguration' is defined.

It says that the dataConfiguration.config file is wrong, or something like that, but we doubt it is, because when IIS is restarted, it works...

So, we think that there si probably a problem with a timout or something like that with the datasource, or maybe the daab is loosing its connection...maybe something to do with the pooling...who knows...

So here where we are...if someone could help us with that one, it would be very appreciated!!


:: Philippe Trottier ::