rsItemNotFound for Report Models

I have a Sharepoint integrated Reporting Services server. I have created Report models based on Data Sources. I then created Report Builder Reports to make some BI Charts and Graphs. They look great and work fine for a few days then all of a sudden I get a rsItemNotFound error saying it cannot find the Report Model which is clearly there.

An error has occurred during report processing. (rsProcessingAborted)

The item 'IT Reports/PWPDB_Prod_Model.smdl' cannot be found. (rsItemNotFound)

If I open the Report Model from Report Builder it loads the data fields, but also fails to run reports with the same error

If I try to regenerate the model from the library I get an error stating that the model needs to be a generated model.

The model specified must be a generated model.

(rsModelNotGenerated)

Even after rebooting all of the servers in the farm I get the same messages. I can regenerate a model from the data source and it doesn't work. I am seeing no errors in the logs of my app server at all regarding reporting services.

It looks as though I will have to de-integrate Reporting Services as it is not viable for a business critical application.

Please for th elove of Zeus tell me you were able to solve this?

I am getting the exact same error. I have tried everything under the sun to make this work. Any advice?

rsItemNotFound for Report Models

I have a Sharepoint integrated Reporting Services server. I have created Report models based on Data Sources. I then created Report Builder Reports to make some BI Charts and Graphs. They look great and work fine for a few days then all of a sudden I get a rsItemNotFound error saying it cannot find the Report Model which is clearly there.

An error has occurred during report processing. (rsProcessingAborted)

The item 'IT Reports/PWPDB_Prod_Model.smdl' cannot be found. (rsItemNotFound)

If I open the Report Model from Report Builder it loads the data fields, but also fails to run reports with the same error

If I try to regenerate the model from the library I get an error stating that the model needs to be a generated model.

The model specified must be a generated model.

(rsModelNotGenerated)

Even after rebooting all of the servers in the farm I get the same messages. I can regenerate a model from the data source and it doesn't work. I am seeing no errors in the logs of my app server at all regarding reporting services.

It looks as though I will have to de-integrate Reporting Services as it is not viable for a business critical application.

Please for th elove of Zeus tell me you were able to solve this?

I am getting the exact same error. I have tried everything under the sun to make this work. Any advice?

RS 2005 Testing - database connection issue

Hi,
From my own PC, I have created a report in Report Builder (RB) that has a
SQL server database as a data source, and when I go to run it (in either RB
or Report Manager), I get the following message: -
"Cannot create a connection to data source 'dataSource'.
(rsErrorOpeningConnection)
--
An error has occurred during report processing. (rsProcessingAborted)"
However, when I run the report in Report Builder directly on the test
server, the report is produced no probs!
Any ideas as to why this is happening?
Cheers
TrevorReport Builder is probable running with NT Auth. Do you have permissions to
the data source and model that may be different then when run on the local
machine?
Try to follow how the connections are working. Client machine RB -> Model
-> Data Source. Somewhere there looks like your client has no access to or
it does not exist.
--
| Thread-Topic: RS 2005 Testing - database connection issue
| thread-index: AcXEPOQcb4FfUXeUQNyO6UODzJAI5Q==| X-WBNR-Posting-Host: 195.44.12.109
| From: =?Utf-8?B?YXVsZHJlaWR5?= <auldreidy@.discussions.microsoft.com>
| Subject: RS 2005 Testing - database connection issue
| Date: Wed, 28 Sep 2005 07:57:05 -0700
| Lines: 19
| Message-ID: <5777EA31-DEBF-4071-91B3-D6CE0C7004B0@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53272
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
|
| From my own PC, I have created a report in Report Builder (RB) that has a
| SQL server database as a data source, and when I go to run it (in either
RB
| or Report Manager), I get the following message: -
|
| "Cannot create a connection to data source 'dataSource'.
| (rsErrorOpeningConnection)
| --
| An error has occurred during report processing. (rsProcessingAborted)"
|
| However, when I run the report in Report Builder directly on the test
| server, the report is produced no probs!
|
| Any ideas as to why this is happening?
|
| Cheers
| Trevor
|
|