Friday, March 30, 2012

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

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)

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?

rsInvalidReportServerDatabase-Error after installing SP2

Hello all,
I have a W2003 Server machine running Sql Server 2000 SP4 and Reporting
Services with *now* installed SP2 (before SP1). After installing the service
pack, I get the following error (sry, its german):
"Die Version der Berichtsserver-Datenbank liegt in einem Format vor, das
nicht gÃ¼ltig ist oder nicht gelesen werden kann. Die gefundene Version ist
'C.0.6.51'; die erwartete Version ist 'C.0.6.54'. Aktualisieren Sie die
Version der Berichtsserver-Datenbank, und Ã¼berprÃ¼fen Sie die Zugriffsrechte,
um den Vorgang fortzusetzen. (rsInvalidReportServerDatabase)"
Can you give me please some advice, what I can do, to get the current
version of the database? I made backups from the report databases, but did
not manage to extract the key for encoding.
Thank you in advance.
Sandra GeislerI found a solution (well, I hope so). I just opened the stored
procedure GetDBVersion in the ReportServer database and exchanged the
last digit of the version number. I then restarted the ReportServer
service and it worked!! I tried to execute a report and it was
produced. If I am noticing some side effects, I will post them here.

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

We are using SQL server 2005 CTP and .Net 2005 beta 2.
the OS is Win xp and the reporting server is the local host.

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

Navigate to the database page. If there is a database configured, and you get this error, chances are you somehow chose to use an existing database. If you tried to upgrade from a previous RS deployment, this might occur. The May CTP will support upgrade from SQL 2000 RS to the May CTP version.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

|||we used the reporting service config tool to configure the service also we created new database to be used by the reporting service(both reportingservice & reportingservicetemp) ew had also configured the reporting service to use SA account, tried with windows security and also with the service crediantials. still we are getting the same error, when we try to deploy reporting project. we get the same error when we try to create a new data source from the report manager web application.

Thanks a lot for your help.
Thanks & regards

Jayan|||Hi Lukasz,
Thanks for your help, we deleted the earlier databases, then created new using the tool. still when we tried it gave the same error. then we restarted the service and everything worked fine.

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

the fix is:
1. In reporiting services configuration manager-> database setup, make sure you have the correct reporting database selected. In this case it will throw the same err when you try to initialize the reporting services.|||Hi,

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

XML Parsing Error: not well-formed
Location: http://moor-6ftylksqxm/reports/
Line Number 1, Column 2:<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %>
-^

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!sql

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

Thanks a lot for your help.
Thanks & regards

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

Thanks a lot for your help.
Thanks & regards

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

Thanks a lot for your help.
Thanks & regards

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!

rsInvalidPolicyDefinition - migration to another domain .....

Hi friends,

We have a problem with our RS2005 after migration into another domain.

The problem is that we have got duplicate access rights for the same AD usergroup.
When trying to remove or add a new AD group we get the error msg - "... role assignment is not valid. The role assignment is either empty or it specifies a user or group name that is already used in an existing role assignment for the current item. (rsInvalidPolicyDefinition)"

Books online gives no answers and neither does other serach engines .....

Anyone having a hint or solution .......

We have the same problem. Cannot remove some roles. I'm worried about if we need to make changes later, will we have to destroy the entire folder structure & re-create it in order to get rid of these roles/permissions?

rsInvalidPolicyDefinition - migration to another domain .....

Hi friends,

We have a problem with our RS2005 after migration into another domain.

Books online gives no answers and neither does other serach engines .....

Anyone having a hint or solution .......

rsInvalidPolicyDefinition

Greetings,
I am running SQL Server 2005 Reporting Services on a SQL Server 2000
(sp4) database and am running into an issue after a domain migration
that is preventing me from modifying any of the security settings on
the report server.
When attempting to Delete or Modify security settings on a folder i
receive the following message:
The "<All the users w/ access to the folder>" role assignment is not
valid. The role assignment is either empty or it specifies a user or
group name that is already used in an existing role assignment for the
current item. (rsInvalidPolicyDefinition) Get Online Help.
Has anyone seen this before or have suggestions as to where to start
troubleshooting it?
Thanks in advance,
Ben SullinsI've found a work around by clicking 'Revert to Parent secruty' on
these folders then going back in and modifying them. This only happens
on folders where the same user/group is listed 2x. Not sure how that
happened but I'm guessing it had to do w/ our domain migration...
sullins602 wrote:
> Greetings,
> I am running SQL Server 2005 Reporting Services on a SQL Server 2000
> (sp4) database and am running into an issue after a domain migration
> that is preventing me from modifying any of the security settings on
> the report server.
> When attempting to Delete or Modify security settings on a folder i
> receive the following message:
> The "<All the users w/ access to the folder>" role assignment is not
> valid. The role assignment is either empty or it specifies a user or
> group name that is already used in an existing role assignment for the
> current item. (rsInvalidPolicyDefinition) Get Online Help.
> Has anyone seen this before or have suggestions as to where to start
> troubleshooting it?
> Thanks in advance,
> Ben Sullins

rsInvalidItemPath Error and Jump to URL Issues

I am having a navigation issue with jump to URLs in reports. When I have a report that supports drilldown if I click the drill down then click a Jump To URL to render the next report I get a second toolbar. If the drill down was never clicked the jump to works fine.

My workaround was to try and create a javascript url to reset the url for the top frame. However, the same url that was working before is now throwing an rsInvalidItemPath error. Any thoughts?

Here is my original Jump To URL expression that was causing the second toolbar to appear on drill down:

=Globals!ReportServerUrl + "?/Early Life/Early Life Technician Summary QA&pDate=" + Parameters!pDate.Value.ToString().Replace("&", "%26") + "&pArea=" + Fields!Measures_AreaUniqueName.Value.ToString().Replace("&", "%26") + "&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true"

Renders as:
http://ilschd-sitdev01/ReportServer?/Early%20Life/Early%20Life%20Technician%20Summary%20QA&pDate=%5BOrder%20Finalized%20Date%5D.%5BFiscal%5D.%5BMonth%5D.%5BDecember,%202005%5D&pArea=%5BArea%5D.%5BOffices%5D.%5BArea%5D.%26%5BChicago%20North%5D&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true

I changed the Jump to URL expression to the following to try and fix the toolbar issue:

=top.location.href='" + Globals!ReportServerUrl + "?/Early Life/Early Life Technician Summary QA&pDate=" + Parameters!pDate.Value.ToString().Replace("&", "%26") + "&pArea=" + Fields!Measures_AreaUniqueName.Value.ToString().Replace("&", "%26") + "&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true" + "'"

Renders as:
BLOCKED SCRIPTtop.location.href='http://ilschd-sitdev01/ReportServer?/Early%20Life/Early%20Life%20Technician%20Summary%20QA&pDate=%5BOrder%20Finalized%20Date%5D.%5BFiscal%5D.%5BMonth%5D.%5BDecember,%202005%5D&pArea=%5BArea%5D.%5BOffices%5D.%5BArea%5D.%26%5BChicago%20North%5D&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true'

This version of Jump to URL causing the rsInvalidPath Exception to be thrown.

Reporting Services Error

The path of the item "/Early Life/Early Life Technician Summary QA,[Chicago North]" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

SQL Server Reporting Services

Thanks in advance,
Adam

Did you get this problem fixed, Adam? I have a similar problem it sounds like where I have a record containing an "&" but SRS is trying to read it as two parameters instead of one, so I get the same 260 characters long error.|||

You can use POST instead of GET i.e. using a HTML form with hidden fields rather than building up a URL string. This should get you around the 260 character limit.

Check out this article for an example http://blogs.msdn.com/bryanke/articles/73153.aspx

rsInvalidItemPath Error and Jump to URL Issues

My workaround was to try and create a javascript url to reset the url for the top frame. However, the same url that was working before is now throwing an rsInvalidItemPath error. Any thoughts?

Here is my original Jump To URL expression that was causing the second toolbar to appear on drill down:

I changed the Jump to URL expression to the following to try and fix the toolbar issue:

This version of Jump to URL causing the rsInvalidPath Exception to be thrown.

Reporting Services Error

SQL Server Reporting Services

Thanks in advance,
Adam

You can use POST instead of GET i.e. using a HTML form with hidden fields rather than building up a URL string. This should get you around the 260 character limit.

Check out this article for an example http://blogs.msdn.com/bryanke/articles/73153.aspx

sql

rsInvalidDataSourceReference-Pls help

Hello Everybody:
I have installed SQL Reporting Services for the first time using SQL Login account. After creating a Shared Data Source, and creating the report I am trying to deploy the report to the server. In the project properties I have set the TargetServerURL to http://hostweb01/ReportServer
When I try to deploy the project I get a windows pop up asking for User Name and password. I enter the username and password but the window keeps popping up. I therefore load the report from http://hostweb01/Reports
When I try to run the report I get the error.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)
Can anyone guide me what could be wrong and what should I do to correct the problem. I have stuck on this problem for hours.

Thanks,

Kapil

For the first item, when you give it a user name and password, are you giving a Windows account known by IIS? What is the security setting on your /reportserver web site (use IIS Manager)?

If you deploy manually (through Report Manager), you will need to create a new data source item (with the correct connection string) on he server before you upload the report. Afterwards, you can go to the report properties page and link the report to the data source object.

|||

Hi rahil,

u need to point the report to the datasource to solve this issue.

The datasource is shared by different reports and u need to have dependent items pointed to the datasource.

I too struggle a lot over this issue and at last found the solution.

I am giving u step by step solution for this issue.

1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx)

2. Click on the Folder in which u have reports

3. U will be directed into contents tab where u will find Show Details at the right top corner

4. Click on Show Details

5. Check in the particular report and click the edit button corresponding to it

6. Go to the properties tab and click on it

7. U will find a menu on left hand side, click on Data Sources link

8. There u will find radio button selected for A share data source(by default) and a browse button.

9. Click on the browse button u will find the tree structure of the datasource and the reports folder.

10. select the datasource in the datasource folder and select OK.

by this way u will be able to point the report to the datasource.

Regards,

Vamsi Krishna Korasiga

rsInvalidDataSourceReference-Pls help

Thanks,

Kapil

For the first item, when you give it a user name and password, are you giving a Windows account known by IIS? What is the security setting on your /reportserver web site (use IIS Manager)?

|||

Hi rahil,

u need to point the report to the datasource to solve this issue.

The datasource is shared by different reports and u need to have dependent items pointed to the datasource.

I too struggle a lot over this issue and at last found the solution.

I am giving u step by step solution for this issue.

1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx)

2. Click on the Folder in which u have reports

3. U will be directed into contents tab where u will find Show Details at the right top corner

4. Click on Show Details

5. Check in the particular report and click the edit button corresponding to it

6. Go to the properties tab and click on it

7. U will find a menu on left hand side, click on Data Sources link

8. There u will find radio button selected for A share data source(by default) and a browse button.

9. Click on the browse button u will find the tree structure of the datasource and the reports folder.

10. select the datasource in the datasource folder and select OK.

by this way u will be able to point the report to the datasource.

Regards,

Vamsi Krishna Korasiga

rsinvaliddataSourceReference problem

Hi,
I have some rdl files to be deployed using RS 2005. I have 3 folders viz., ReportFolder1, ReportFolder2 and System Files.
ReportFolder1 - contains soem reports
ReportFolder2 - contains some other types of reports
System Files - Contains the shared Data source
All the above folders are present in a main folder called ReportMain
In all my rdl files I have given the value of DataSourceReference element as 'ReportMain/System Files/MyDatabase'.
Still when the reports are deployed and i try to view any report, I get the following error:
The report server cannot process the report. The data source connection information has been deleted.(rsInvalidDataSourceReference).

Why do I get this error still? Can anyoen help?
Thanks.

Hi SandyJ,

This is because ur not pointing the reports to the required data source

I am giving u step by step solution for this issue.

1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx)

2. Click on the Folder in which u have reports

3. U will be directed into contents tab where u will find Show Details at the right top corner

4. Click on Show Details

5. Check in the particular report and click the edit button corresponding to it

6. Go to the properties tab and click on it

7. U will find a menu on left hand side, click on Data Sources link

8. There u will find radio button selected for A share data source(by default) and a browse button.

9. Click on the browse button u will find the tree structure of the datasource and the reports folder.

10. select the datasource in the datasource folder and select OK.

by this way u will be able to point the report to the datasource.

Regards,

Vamsi Krishna Korasiga

rsinvaliddataSourceReference problem

Why do I get this error still? Can anyoen help?
Thanks.

Hi SandyJ,

This is because ur not pointing the reports to the required data source

I am giving u step by step solution for this issue.

1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx)

2. Click on the Folder in which u have reports

3. U will be directed into contents tab where u will find Show Details at the right top corner

4. Click on Show Details

5. Check in the particular report and click the edit button corresponding to it

6. Go to the properties tab and click on it

7. U will find a menu on left hand side, click on Data Sources link

8. There u will find radio button selected for A share data source(by default) and a browse button.

9. Click on the browse button u will find the tree structure of the datasource and the reports folder.

10. select the datasource in the datasource folder and select OK.

by this way u will be able to point the report to the datasource.

Regards,

Vamsi Krishna Korasiga

rsInvalidDataSourceReference Error

Hi,

I have published the data source and the report on the report server programmatically. When i open the report either using URL redirection (programmatically) or from the Report Manager screen, the following error message is displayed.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

If I change the report properties manually using Report Manager screen and bind the data source to the report, it works fine.

Is there any solution to bind it programmatically ?

Thanks in advance.It sounds like the RDL is not set correctly to point to where the datasource is being deployed. You can either change the RDL or call SetItemDatasources (RS 2005) or SetReportDatasources (RS 2000) to set the data source to point to the shared data source.|||Thanks, I also had got a solution last week, though was work-around, was still useful.|||

I am having the same problem.

Would you give me the work around to the problem.

|||

Hi All,

I also got this error today for the very first time and I was wondering how it is created.

I have been using RS for nearly 2 years and never seen this message before. When I go into Report->Data Sources it tells me "The shared Data Source Reference is no longer valid" and all I need to do is to reconnect the data source.

Also, if I delete a report and redeploy it then it will also connect to the data source correctly even though it is the same data source....but if I redeploy a report without deleting it the message is issued.

This seems like a really strange one...I would like to know if anyone knows how this happens...I have two other report projects which are functioning just fine and after I reconnect the data source all is fine... ?

Thanks In Advance

Peter

sql

rsInvalidDataSourceReference Error

Hi,

Is there any solution to bind it programmatically ?

I am having the same problem.

Would you give me the work around to the problem.

|||

Hi All,

I also got this error today for the very first time and I was wondering how it is created.

Thanks In Advance

Peter

rsInvalidDataSourceReference Error

Hi,

Is there any solution to bind it programmatically ?

I am having the same problem.

Would you give me the work around to the problem.

|||

Hi All,

I also got this error today for the very first time and I was wondering how it is created.

Thanks In Advance

Peter

rsInvalidDataSourceReference Error

Hi,

Is there any solution to bind it programmatically ?

I am having the same problem.

Would you give me the work around to the problem.

|||

Hi All,

I also got this error today for the very first time and I was wondering how it is created.

Thanks In Advance

Peter

rsInvalidDataSourceReference

I am getting the following error:

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

All i did is created the datasource in the same location where my report files .rdl files are. instead of datasource folder on the report server.

everything works fine from my project vs2005, but if i run the report via localhost/reports, it gives the above error:

please help, i created this method since i have 5 different sites on the same server, all of the sites has reports with same datasource name many of them are common for that reason.

Thank you very much for the informartion.

Try this:

Open up Report Manager, and drill down to open your report. Click on the Properties tab, then select 'Data Sources' from the left pane. Click the Browse button next to 'Select a shared data source'. From here, navigate to the folder where your report is, and select the data source that is in there (since this is where you deployed to). Click OK, then Apply your changes.

Hope this helps.

Jarret

|||Wow.. Jarret Thank you very much. you gave me two tips since yesterday. thks....|||

Hi,

I am using a rss script to deploy reports and data sources. All my datasources lie in the shared location "Data Sources". With the script the data source and reports are deployed but the it gives the same error as posted by cplusplus1.

Here is the rss script to deploy report and data source that I used. Please help.

'To deploy Data Source

Public Sub CreateDataSource(ByVal name As String, ByVal extension As String, ByVal connectionString As String)
'Define the data source definition.
Dim definition As New DataSourceDefinition()
definition.Extension = extension
definition.ConnectString = connectionString
definition.Enabled = True
definition.EnabledSpecified = True
definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
definition.WindowsCredentials = True
definition.Prompt = Nothing
definition.ImpersonateUserSpecified = True
Try
rs.CreateDataSource(name, dataSourcePath, overWriteExistingDataSource, definition, Nothing)
Console.WriteLine("Data source {0} created successfully", name)

Catch e As Exception
Console.WriteLine(e.Message)
End Try

End Sub

' TO DEPLOY Report

Public Sub PublishReport(ByVal reportName As String)
Try
Dim stream As FileStream = File.OpenRead(filePath + reportName + ".rdl")
definition = New [Byte](stream.Length) {}
stream.Read(definition, 0, CInt(stream.Length))
stream.Close()

Catch e As IOException
Console.WriteLine(e.Message)
End Try

Try
warnings = rs.CreateReport(reportName, parentPath, False, definition, Nothing)

Dim dataSources() As DataSource = rs.GetItemDataSources(parentPath + "/" + reportName)

Dim ds As DataSource
For Each ds In dataSources
If (ds.Item.GetType() Is Type.GetType("InvalidDataSourceReference")) Then
Dim NewDS As DataSource = New DataSource()
Dim dsRef As DataSourceReference = New DataSourceReference()

dsRef.Reference = dataSourcePath + "/" + dataSourceName
NewDS.Item = dsRef
NewDS.Name = ds.Name
Dim NewDataSources() As DataSource = New DataSource() {NewDS}

rs.SetItemDataSources(parentPath + "/" + reportName, NewDataSources)
End If
Next

If Not (warnings Is Nothing) Then
Dim warning As Warning
For Each warning In warnings
Console.WriteLine(warning.Message)
Next warning
Else
Console.WriteLine("Report: {0} published successfully with no warnings", reportName)
End If
Catch e As Exception
Console.WriteLine(e.Message)
End Try
End Sub

rsInvalidDataSourceReference

I am getting the following error:

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

All i did is created the datasource in the same location where my report files .rdl files are. instead of datasource folder on the report server.

everything works fine from my project vs2005, but if i run the report via localhost/reports, it gives the above error:

please help, i created this method since i have 5 different sites on the same server, all of the sites has reports with same datasource name many of them are common for that reason.

Thank you very much for the informartion.

Try this:

Hope this helps.

Jarret

|||Wow.. Jarret Thank you very much. you gave me two tips since yesterday. thks....|||

Hi,

Here is the rss script to deploy report and data source that I used. Please help.

'To deploy Data Source

Catch e As Exception
Console.WriteLine(e.Message)
End Try

End Sub

' TO DEPLOY Report

Catch e As IOException
Console.WriteLine(e.Message)
End Try

Try
warnings = rs.CreateReport(reportName, parentPath, False, definition, Nothing)

Dim dataSources() As DataSource = rs.GetItemDataSources(parentPath + "/" + reportName)

dsRef.Reference = dataSourcePath + "/" + dataSourceName
NewDS.Item = dsRef
NewDS.Name = ds.Name
Dim NewDataSources() As DataSource = New DataSource() {NewDS}

rs.SetItemDataSources(parentPath + "/" + reportName, NewDataSources)
End If
Next

sql

rsInternalError Reporting Server error !

Salam,

I get this error, if any one can help me

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get For more information about this error navigate to the report server on the local server machine, or enable remote errors

But I could solve the problem by restarting the IIS , so each time this message appear I restart the IIS and the ReportServer's will work but after some time the problem again will appear . I think the problem with cache in IIS because the session still opened and not closed so how I can solve this

Hi,

Try to set up the "Recycle worker process (in minutes)" to shorter frequency in the report server application pool.

Also, you will be able to find detaild information about the service health in the log files at "Microsoft SQL Server\MSSQL.n\Reporting Services\LogFiles" folder.

Regards,

Janos

|||

Thanks,

I set up the "Recycle worker process (in minutes)" to 60 minutes and I will see .

and this is the log file for today

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Jerusalem Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__07_04_2007_12_56_21.log</Path>
<SystemName>PAYROLL</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2, v.4035</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!webserver!1!04/07/2007-12:56:21:: i INFO: Reporting Web Server started
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!04/07/2007-12:56:22:: i INFO: Reporting Services starting SKU: Developer
w3wp!resourceutilities!1!04/07/2007-12:56:22:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!07/04/2007-12:56:24:: Call to GetPermissionsAction(/).
w3wp!library!1!07/04/2007-12:56:24:: i INFO: Catalog SQL Server Edition = Developer
w3wp!library!1!07/04/2007-12:56:24:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!5!07/04/2007-12:56:24:: Call to GetSystemPermissionsAction().
w3wp!library!7!07/04/2007-12:56:24:: Call to ListChildrenAction(/, False).
w3wp!library!6!07/04/2007-12:56:24:: Call to GetSystemPropertiesAction().
w3wp!library!7!07/04/2007-12:56:39:: Call to GetPermissionsAction(/Payroll).
w3wp!library!7!07/04/2007-12:56:39:: Call to GetPropertiesAction(/Payroll, PathBased).
w3wp!library!7!07/04/2007-12:56:39:: Call to GetSystemPermissionsAction().
w3wp!library!6!07/04/2007-12:56:39:: Call to ListChildrenAction(/Payroll, False).
w3wp!library!6!07/04/2007-12:56:39:: Call to GetSystemPropertiesAction().
w3wp!library!7!07/04/2007-12:56:44:: Call to GetPermissionsAction(/Payroll/Company).
w3wp!library!7!07/04/2007-12:56:44:: Call to GetPropertiesAction(/Payroll/Company, PathBased).
w3wp!library!7!07/04/2007-12:56:44:: Call to GetSystemPermissionsAction().
w3wp!library!7!07/04/2007-12:56:44:: Call to ListChildrenAction(/Payroll/Company, False).
w3wp!library!6!07/04/2007-12:56:44:: Call to GetSystemPropertiesAction().
w3wp!library!5!07/04/2007-12:56:46:: Call to GetPermissionsAction(/Payroll/Company/ASU-HR).
w3wp!library!7!07/04/2007-12:56:46:: Call to GetSystemPermissionsAction().
w3wp!library!7!07/04/2007-12:56:48:: Call to GetDataSourceContentsAction(/Payroll/Company/ASU-HR).
w3wp!library!5!07/04/2007-12:56:48:: Call to GetPropertiesAction(/Payroll/Company/ASU-HR, PathBased).
w3wp!library!6!07/04/2007-12:56:48:: Call to ListChildrenAction(/, False).
w3wp!library!6!07/04/2007-12:56:48:: Call to ListChildrenAction(/Payroll, False).
w3wp!library!6!07/04/2007-12:56:49:: Call to ListChildrenAction(/Payroll/Company, False).
w3wp!library!7!07/04/2007-12:56:49:: Call to ListChildrenAction(/, False).
w3wp!library!7!07/04/2007-12:56:49:: Call to ListChildrenAction(/Payroll, False).
w3wp!library!7!07/04/2007-12:56:49:: Call to ListChildrenAction(/Payroll/Company, False).
w3wp!library!5!07/04/2007-12:56:49:: Call to GetSystemPropertiesAction().
w3wp!library!7!07/04/2007-12:59:05:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeInsuranceCard).
w3wp!library!7!07/04/2007-12:59:05:: i INFO: Call to RenderFirst( '/Payroll/Company/rpt_EmployeeInsuranceCard' )
w3wp!library!7!07/04/2007-12:59:09:: Using folder C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!webserver!7!07/04/2007-12:59:10:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeInsuranceCard', Stream=''
w3wp!library!5!07/04/2007-12:59:11:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeInsuranceCard).
w3wp!library!5!07/04/2007-12:59:11:: i INFO: Call to RenderNext( '/Payroll/Company/rpt_EmployeeInsuranceCard' )
w3wp!cache!5!07/04/2007-12:59:11:: i INFO: Session live: /Payroll/Company/rpt_EmployeeInsuranceCard
w3wp!webserver!5!07/04/2007-12:59:11:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeInsuranceCard', Stream=''
w3wp!library!6!07/04/2007-12:59:19:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeInsuranceCard).
w3wp!library!6!07/04/2007-12:59:19:: i INFO: Call to RenderNext( '/Payroll/Company/rpt_EmployeeInsuranceCard' )
w3wp!cache!6!07/04/2007-12:59:19:: i INFO: Session live: /Payroll/Company/rpt_EmployeeInsuranceCard
w3wp!webserver!6!07/04/2007-12:59:22:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeInsuranceCard', Stream=''
w3wp!library!6!07/04/2007-13:04:10:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeTranspotationCard).
w3wp!library!6!07/04/2007-13:04:10:: i INFO: Call to RenderFirst( '/Payroll/Company/rpt_EmployeeTranspotationCard' )
w3wp!webserver!6!07/04/2007-13:04:11:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeTranspotationCard', Stream=''
w3wp!library!7!07/04/2007-13:04:17:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeTranspotationCard).
w3wp!library!7!07/04/2007-13:04:17:: i INFO: Call to RenderNext( '/Payroll/Company/rpt_EmployeeTranspotationCard' )
w3wp!cache!7!07/04/2007-13:04:17:: i INFO: Session live: /Payroll/Company/rpt_EmployeeTranspotationCard
w3wp!webserver!7!07/04/2007-13:04:17:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeTranspotationCard', Stream=''
w3wp!library!6!7/4/2007-13:06:22:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams

|||

again the problem still exist even after I set up the Recycle worker process to 60 m .

what I can do to solve this problem.

|||Well, you must check the log files for more details to this error. Please check all log files in the directory I specified before. (just the today's file

)|||

which log files there is a lot of todays files .

|||Try to check the ReportServerService_main.log, ReportServerWebApp.log.

rsInternalError on Reporting Services

hello,
i have created a webform to call the reports in the report
server. When i click submit in the webform, it will redirect to the
selected report.
This works fine for the first few times. However, after sometime
i would be getting the following error :
"An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were
in use and max pool size was reached. "
Once this happen, i could not even open my local report server
in the browser.
Could some one please help me......... it's urgent.. thanks
...
--
Message posted via http://www.sqlmonster.comtry setting the timeout to infinite,
rs.Timeout = -1

rsInternalError General network error for new report

Running RS2000 on Windows 2003
I published a new report today (copied from an existing report, used same
data source calling different stored procedure, changed parameters, etc.).
It worked fine when run locally.
However, when published and run within Report Manager I get the following
error -
Reporting Services Error
----
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
General network error. Check your network documentation.
I'm not sure I've seen this error before. I've had errors before but they
usually occurred because I forgot to give adequate permissions to the stored
procedure or something like that.
I've search around but haven't figured out how to troubleshoot this problem.
I have looked at the trace logs but I'm still learning how to read them.
Here is what appear to be the relevant portion found in them -
In ReportServer__08_17_2007_06_42_51.log
w3wp!library!1058!08/17/2007-10:54:06:: i INFO: Call to RenderFirst(
'/Development/Ref Des Term Count' )
w3wp!library!1058!08/17/2007-10:54:07:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: A severe error occurred on
the current command. The results, if any, should be discarded.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.ChunkStorage.WriteNewSnapshotToDB(String
effectiveParams, Int32 paramsHash, DateTime createdDate, String description,
Guid snapshotDataID, Boolean isPermanentSnapshot)
at
Microsoft.ReportingServices.Library.ReportSnapshot.WriteNewSnapshotToDB(String effectiveParams, Int32 paramsHash, DateTime createdDate, String description)
at
Microsoft.ReportingServices.Library.RSService.AllocateNewSnapshot(Boolean
isPermanentSnapshot, String effectiveParams, Int32 paramsHash, DateTime
createdDate, String description)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
-- End of inner exception stack trace --
w3wp!library!1058!08/17/2007-10:54:07:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!1058!08/17/2007-10:54:08:: 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.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: A severe error occurred on
the current command. The results, if any, should be discarded.
In ReportServerService__main_08_17_2007_05_10_24.log
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__main_08_17_2007_05_10_24.log</Path>
<SystemName>IW-SQL</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!servicecontroller!11dc!8/17/2007-05:10:24:: i INFO:
Recycling the service from default domain
ReportingServicesService!servicecontroller!11dc!8/17/2007-05:10:27:: i INFO:
New app domain started
Other existing reports seem to be working with no problem.
Any help troubleshooting this would be greatly appreciated.
KevinWell I've found a solution. Instead of copying an existing report I just
started from scratch. I built a new one from the ground up and it worked
fine.
Apparently there was something in the report I made from the copy that it
didn't like. I thought I went through it pretty thoroughly to make sure
nothing referred to fields, parameters, etc. that didn't apply but I guess I
missed something.
For future reference I would appreciate any recommendations for catching
problems when copying a report. Maybe copying isn't recommended? It usually
seems to save time (except in this case!).
Kevin|||Rats!!! I thought I had it fixed. My report and stored procedure both have
just one parameter. I just made a simple report (data is listed in a table)
and set a default value for the report parameter and it worked.
Thinking that it was fixed, I removed the default and re-published. Now
when I select a value from the list in the prompt and run the report I get
the error.
So, is the problem something to do with my prompt? Any ideas on
troubleshooting would be appreciated. The prompt is just a simple query from
one table -
SELECT DISTINCT r.item AS PromptValue
,r.item AS PromptLabel
FROM dbname.dbo.tablename r
WHERE r.item <> ''
ORDER BY r.item
The stored procedure queries the same table and is as follows -
CREATE PROCEDURE rpt_Ref_DesTermCount
(
@.StockCode VARCHAR(30) = '%'
)
AS
SELECT r.item
,r.ref_des
,r.TermCount
FROM dbname.dbo.tablename r
WHERE r.item LIKE @.StockCode
ORDER BY r.ref_des
GO
Thanks in advance,
Kevin

rsInternalError (RSClientCOnnection.GetProperties)

Hello,

We are converting from 2000 to 2005 and are getting the following error when attempting to run any RS reports. Any help would be greatly appreciated.

************** Exception Text **************

Microsoft.SqlServer.ReportingServices2005.ReportServiceDetailsException:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) >

Microsoft.SqlServer.ReportingServices2005.ReportServiceMoreInformationException:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

End of inner exception stack trace

Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetProperties(String

Item, Property[] Properties)

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.PermissionsCacheItem.get_ItemProperties()

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.EvaluateNode(XPathNavigator

navigator, PermissionsCacheItem cache)

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.Evaluate(String

xmlExpression, INodeInformation source)

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.Visible(INodeInformation

source)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItemBase.UpdateMenuCommandStatus(MenuCommand

menuCommand)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DefaultMenuHandler.UpdateMenuCommandsStatus(MenuCommand

menuCommand)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DefaultMenuHandler.GetMenuItems(ArrayList

items)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DefaultMenuHandler.GetMenuItems()

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.ShowContextMenu(Point

windowPos)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WmContextMenu(Message&

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message&

System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies ************** mscorlib

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

AppIDPackage

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL

System

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

Microsoft.SqlServer.SqlTools.VSIntegration

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL

Microsoft.VisualStudio.Shell.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase:

file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll

Microsoft.VisualStudio.OLE.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase:

file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll

System.Windows.Forms

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

Microsoft.SqlServer.SqlTDiagM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll

Microsoft.DataWarehouse.SQM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL

Microsoft.SqlServer.Instapi

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll

ObjectExplorer

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL

ConnectionDlg

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL

SqlWorkbench.Interfaces

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL

Microsoft.SqlServer.CustomControls

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll

Accessibility

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

SqlMgmt

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL

Microsoft.SqlServer.RegSvrEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll

EnvDTE

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll

Microsoft.NetEnterpriseServers.ExceptionMessageBox

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

Microsoft.SqlServer.ConnectionInfo

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll

Microsoft.SqlServer.Management.UI.RSClient

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UI.RSClient.DLL

System.Xml

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.SqlServer.SmoEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SmoEnum.dll

System.Management

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll

System.Web.Services

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll

System.Configuration

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

zhphbr91

Assembly Version: 9.0.242.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

Microsoft.SqlServer.Management.UI.RSUserInterface

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UI.RSUserInterface.DLL

Microsoft.SqlServer.SqlEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll

Microsoft.ReportViewer.WinForms

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.42

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll

Microsoft.SqlServer.Smo

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll

Microsoft.SqlServer.Management.UI.RSWrapper

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UI.RSWrapper.DLL

************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging enabled.

For example:

<system.windows.forms jitDebugging="true" /> </configuration>

When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.

Not quite sure if this will help, but I do not what this method Is. Basically its a method on the Data Extension to retrieve the properties of the command object, within the Report Designer.

Do you know which Data extension the report is using (SQL Server, Oracle or maybe a Custom data extension?)

|||

We are using SQL Server.

It appears that we may have solved this issue by reinstalling RS SP1. I'm unsure why we were receiving this error though but it is gone now.

Thanks for your help.

Dan

rsInternalError - Urgent please

Hi
I am getting an error like An internal error occurred on the report
server.(rsInternalError) The timeout period elapsed prior to obtaining a
connection from the pool. This may have occurred because all pooled
connections were in use max pool size was reached
Could anyone please solve this problem.
Help is strongly appreciated.
Thanks & Best Regards
MukeshThis link might help,
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=290788
daw
"mukesh" wrote:
> Hi
> I am getting an error like An internal error occurred on the report
> server.(rsInternalError) The timeout period elapsed prior to obtaining a
> connection from the pool. This may have occurred because all pooled
> connections were in use max pool size was reached
> Could anyone please solve this problem.
> Help is strongly appreciated.
> Thanks & Best Regards
> Mukesh
>
>sql

rsInternalError

I have reporting services installed on my xp laptop and haven't used it for a
while. Now when I try to run a report I get the following error message.
@.AwaitingFirstExecution is not a parameter for procedure CreateSession
Anybody seen this before? I can't find any information about this.
Thanks
MGSounds like the report is calling a stored procedure called "CreateSession".
Is that a datasource of your report? If not, make sure you have enough
permission to run the report.
Ed
"Mardy" wrote:
> I have reporting services installed on my xp laptop and haven't used it for a
> while. Now when I try to run a report I get the following error message.
> @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> Anybody seen this before? I can't find any information about this.
> Thanks
> MG|||Thanks Ed but no it's not using a stored procedure. Actually all the reports
that I try to run return this same message. All work fine when I run from
visual studio. I've tested and reloaded the data sources but no success.
"Ed" wrote:
> Sounds like the report is calling a stored procedure called "CreateSession".
> Is that a datasource of your report? If not, make sure you have enough
> permission to run the report.
> Ed
> "Mardy" wrote:
> > I have reporting services installed on my xp laptop and haven't used it for a
> > while. Now when I try to run a report I get the following error message.
> > @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> >
> > Anybody seen this before? I can't find any information about this.
> >
> > Thanks
> > MG|||Not sure if it is related. We were getting the rsinternalerror as well.
After working with Microsoft, they determined that the error had to do with
the AMD processor on our server. Are you using an AMD processor?
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:B555F393-D1B1-421B-9DE8-9686F305FE06@.microsoft.com...
>I have reporting services installed on my xp laptop and haven't used it for
>a
> while. Now when I try to run a report I get the following error message.
> @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> Anybody seen this before? I can't find any information about this.
> Thanks
> MG|||Thanks Chris
I have reporting services loaded on a Dell Inspiron with an Intel Pentium M
processor.
"Chris" wrote:
> Not sure if it is related. We were getting the rsinternalerror as well.
> After working with Microsoft, they determined that the error had to do with
> the AMD processor on our server. Are you using an AMD processor?
>
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:B555F393-D1B1-421B-9DE8-9686F305FE06@.microsoft.com...
> >I have reporting services installed on my xp laptop and haven't used it for
> >a
> > while. Now when I try to run a report I get the following error message.
> > @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> >
> > Anybody seen this before? I can't find any information about this.
> >
> > Thanks
> > MG
>
>

rsInternalError

I get this error message while deploying report:
An internal error occurred on the report server.
See the error log for more details. (rsInternalError)
Invalid text, ntext, or image pointer value
0xFDFF7F5F000000000303000001000200.
The statement has been terminated.
This happens to all reports I am trying to deploy either through VS.NET or
froom rds file
How do I resolve it?
Thanks,
-StanHI,
Did you ever resolve this issue? I'm getting the same message. Just
started during my last attempt to deploy.
thanks
"Stan" wrote:
> I get this error message while deploying report:
> An internal error occurred on the report server.
> See the error log for more details. (rsInternalError)
> Invalid text, ntext, or image pointer value
> 0xFDFF7F5F000000000303000001000200.
> The statement has been terminated.
> This happens to all reports I am trying to deploy either through VS.NET or
> froom rds file
> How do I resolve it?
>
> Thanks,
> -Stan
>
>

Friday, March 30, 2012

rsItemNotFound for Report Models

rsItemNotFound for Report Models

rsInvalidReportServerDatabase-Error after installing SP2

rsInvalidReportServerDatabase

rsInvalidReportServerDatabase

rsInvalidReportServerDatabase

rsInvalidReportServerDatabase

rsInvalidPolicyDefinition - migration to another domain .....

rsInvalidPolicyDefinition - migration to another domain .....

rsInvalidPolicyDefinition

rsInvalidItemPath Error and Jump to URL Issues

Reporting Services Error

rsInvalidItemPath Error and Jump to URL Issues

Reporting Services Error

rsInvalidDataSourceReference-Pls help

rsInvalidDataSourceReference-Pls help

rsinvaliddataSourceReference problem

rsinvaliddataSourceReference problem

rsInvalidDataSourceReference Error

rsInvalidDataSourceReference Error

rsInvalidDataSourceReference Error

rsInvalidDataSourceReference Error

rsInvalidDataSourceReference

rsInvalidDataSourceReference

rsInternalError Reporting Server error !

rsInternalError on Reporting Services

rsInternalError General network error for new report

rsInternalError (RSClientCOnnection.GetProperties)

rsInternalError - Urgent please

rsInternalError

rsInternalError

RS and HTTPS

Blog Archive

About Me