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

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

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

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:

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

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