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 - 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 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
>
>

rsErrorReadingNextDataRow

Hi,
I'm getting the below error with my reports.
Any help is appretiated much.
Thanks...
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot read the next data row for the data set DataSet1.
(rsErrorReadingNextDataRow) Get Online Help
A severe error occurred on the current command. The results, if any, should
be discarded.I am having this issue too. Did you resolve this?
"eralper" wrote:
> Hi,
> I'm getting the below error with my reports.
> Any help is appretiated much.
> Thanks...
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot read the next data row for the data set DataSet1.
> (rsErrorReadingNextDataRow) Get Online Help
> A severe error occurred on the current command. The results, if any, should
> be discarded.
>
>|||Hi,
I was using Linked Servers for the data source of the reports. And
dynamically changing the database server name and database name by passing
these values as parameters.
On some of the servers I was using "." to map the database server to itself.
I changed the passed value "." to database server name for the database
server name parameter.
This change worked.
http://www.kodyaz.com/ShowPost.aspx?PostID=52#52
Eralper
http://www.kodyaz.com
"Kmistic" wrote:
> I am having this issue too. Did you resolve this?
> "eralper" wrote:
> > Hi,
> >
> > I'm getting the below error with my reports.
> > Any help is appretiated much.
> > Thanks...
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot read the next data row for the data set DataSet1.
> > (rsErrorReadingNextDataRow) Get Online Help
> > A severe error occurred on the current command. The results, if any, should
> > be discarded.
> >
> >
> >|||Thanks for replying. i am not using linked servers i am actually getting
this error from reporting services.
"eralper" wrote:
> Hi,
> I was using Linked Servers for the data source of the reports. And
> dynamically changing the database server name and database name by passing
> these values as parameters.
> On some of the servers I was using "." to map the database server to itself.
> I changed the passed value "." to database server name for the database
> server name parameter.
> This change worked.
> http://www.kodyaz.com/ShowPost.aspx?PostID=52#52
> Eralper
> http://www.kodyaz.com
>
> "Kmistic" wrote:
> > I am having this issue too. Did you resolve this?
> >
> > "eralper" wrote:
> >
> > > Hi,
> > >
> > > I'm getting the below error with my reports.
> > > Any help is appretiated much.
> > > Thanks...
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > Cannot read the next data row for the data set DataSet1.
> > > (rsErrorReadingNextDataRow) Get Online Help
> > > A severe error occurred on the current command. The results, if any, should
> > > be discarded.
> > >
> > >
> > >|||I would like to mention that this error only happens when non-adminstrators
try to view the report. I have the dataset being generated by a stored
procedure that executes a dtspackage using xp_cmdshell. When i take the
xp_cmdshell command out of the stored procedure it works fine. I pass the
xp_cmdshell the dtsrun command using sa and its password. I don't understand
what else i might need to do to enable the none admins to work.
"Kmistic" wrote:
> Thanks for replying. i am not using linked servers i am actually getting
> this error from reporting services.
> "eralper" wrote:
> > Hi,
> >
> > I was using Linked Servers for the data source of the reports. And
> > dynamically changing the database server name and database name by passing
> > these values as parameters.
> >
> > On some of the servers I was using "." to map the database server to itself.
> > I changed the passed value "." to database server name for the database
> > server name parameter.
> >
> > This change worked.
> >
> > http://www.kodyaz.com/ShowPost.aspx?PostID=52#52
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> >
> > "Kmistic" wrote:
> >
> > > I am having this issue too. Did you resolve this?
> > >
> > > "eralper" wrote:
> > >
> > > > Hi,
> > > >
> > > > I'm getting the below error with my reports.
> > > > Any help is appretiated much.
> > > > Thanks...
> > > >
> > > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > > Online Help
> > > > Cannot read the next data row for the data set DataSet1.
> > > > (rsErrorReadingNextDataRow) Get Online Help
> > > > A severe error occurred on the current command. The results, if any, should
> > > > be discarded.
> > > >
> > > >
> > > >|||Hi,
I was successfully running the report from VS.Net but it was failing when I
deploy it onto the report server. Do you have a similar behavior?
"Kmistic" wrote:
> Thanks for replying. i am not using linked servers i am actually getting
> this error from reporting services.
> "eralper" wrote:
> > Hi,
> >
> > I was using Linked Servers for the data source of the reports. And
> > dynamically changing the database server name and database name by passing
> > these values as parameters.
> >
> > On some of the servers I was using "." to map the database server to itself.
> > I changed the passed value "." to database server name for the database
> > server name parameter.
> >
> > This change worked.
> >
> > http://www.kodyaz.com/ShowPost.aspx?PostID=52#52
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> >
> > "Kmistic" wrote:
> >
> > > I am having this issue too. Did you resolve this?
> > >
> > > "eralper" wrote:
> > >
> > > > Hi,
> > > >
> > > > I'm getting the below error with my reports.
> > > > Any help is appretiated much.
> > > > Thanks...
> > > >
> > > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > > Online Help
> > > > Cannot read the next data row for the data set DataSet1.
> > > > (rsErrorReadingNextDataRow) Get Online Help
> > > > A severe error occurred on the current command. The results, if any, should
> > > > be discarded.
> > > >
> > > >
> > > >|||hi
i am getting error msg in sqlservice report
cannot read the next data row for the data set dataset1 in sql reporting service
i need a solloution for this proble
From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||I am also getting this error intermittenly on some reports. It is text query not a stored procedure and sometimes it works for the same user. The database and table being queried have high activity. Could this be a colision or exclusive lock? Since it's intermittent it is hard to troubleshoot
From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.h
Posted via DevelopmentNow.com Group
http://www.developmentnow.comsql

rsDataSourceNotFound error in SSRS 2005

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occurred during report processing. (rsProcessingAborted)

The data source 'xxx' cannot be found. (rsDataSourceNotFound)

This error occurs irrespective of electing to re-deploy or not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

How do I get around this error?

Pl let me know if anyone has encountered this error?

rsDataSourceNotFound error in SSRS 2005

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occurred during report processing. (rsProcessingAborted)

The data source 'xxx' cannot be found. (rsDataSourceNotFound)

This error occurs irrespective of electing to re-deploy or not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

How do I get around this error?

Pl let me know if anyone has encountered this error?

RSConfigTool.exe unhandled exception after patching SP2

After patching SQL2005 SP2, an unhandled exception occurred in RSConfigTool.exe.

The error message:

Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

Not found.

Is this a known issue? Thanks.

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Management.ManagementException: Not found
at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.PropertyData.RefreshPropertyInfo()
at System.Management.PropertyDataCollection.get_Item(String propertyName)
at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName)
at System.Management.ManagementBaseObject.get_Item(String propertyName)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.get_IsSharePointIntegrated()
at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
at ReportServicesConfigUI.ConfigurationManager.tsbConnect_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
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
-
RSConfigTool
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/binn/RSConfigTool.exe
-
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
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
-
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
-
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
-
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.ServiceProcess
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
-
System.DirectoryServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.DirectoryServices/2.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.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
-
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
-
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
-
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.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
-

************** 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:

<configuration>
<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.

Bobby,

Could you, please, check, what version has this dll:

%Program Files%\Microsoft SQL Server\90\Shared\ReportingServicesWMI.dll

?

For SP2 it should be 2005.90.3042.0.

I would also recommend to take a look at this file: ReportingServices.mof or ReportingServicesXPSP2UP.mof, in the same location (you should find only one if them, depending on your OS). See if you find in your mof file a class called MSReportServer_Instance and a property of this class called IsSharePointIntegrated.

Mihaela

|||

Hi Mihaela,

ReportingServicesWMI.DLL version: 2005.090.3042.00

C:\Program Files\Microsoft SQL Server\90\Shared>findstr -i MSReportServer_Instance *.mof
ReportingServicesXPSP2up.mof://* Class: MSReportServer_Instance (lives in v9)
ReportingServicesXPSP2up.mof:class MSReportServer_Instance

Directory of C:\Program Files\Microsoft SQL Server\90\Shared

11/22/2006 10:00 PM 17,447 ReportingServicesXPSP2up.mof
10/14/2005 01:41 AM 23,138 sqlmgmproviderxpsp2up.mof
2 File(s) 40,585 bytes

OS version is Microsoft Windows [Version 5.2.3790]

|||

Bobby,

It seems that you have the right version of ReportingServicesWMI.dll.

First I would suggest to restart the WMI service and after this try to connect again using the config tool and see what is happening. The WMI service "long name" is Windows Management Instrumentation.

If this is still not working, I would suggest to restart your Reporting Services service and try to connect again using the config tool.

I would also suggest to take a look in the log files located here:

%Program Files%\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles

You should look for a file whose name starts with ReportServerService or ReportServerService_main.

I would suggest to sort the files by Date Modified descending and, after you try to connect using the config tool and you see the exception, take a look at the newest log file for the Windows service and see what was logged there.

Mihaela

|||

Hi Mihaela,

After rebooting the box, RSConfigTool.exe is working...

Not sure why it didn't work before.

Thanks for your help.

Bobby Fu

RS: An unexpected error

I receive the message when I usehttp://mytest/reports (ReportManager):

The underlying connection was closed: An unexpected error occurred on a
receive.

Contents of log:

<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__06_16_2005_09_35_28.log</Path>
<SystemName>mytest</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!1e70!6/16/2005-09:35:28:: i INFO: Reporting Web Server started
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing ConnectionType
to '0' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing IsEventService
to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutilities!1e70!6/16/2005-09:35:28:: i INFO: Running on 2
physical processors, 4 logical processors
w3wp!resourceutilities!1e70!6/16/2005-09:35:28:: i INFO: Reporting Services
starting SKU: Enterprise
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Running Requests
Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Running Requests DB timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Memory stats update timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1e70!06/16/2005-09:35:34:: i INFO: Call to GetSystemPermissions
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Exporting public key
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Performing sku validation
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Importing existing encryption
key
w3wp!webserver!16a4!6/16/2005-09:35:48:: i INFO: Reporting Web Server stopped

In what a problem?

P.S. Windows 2003 Standart, MS SQL 2000 SP4, RS SP 2

I am getting the same exact error. Why is there no response to this?