Error in Reporting
Hi TFS Users,
I am working on TFS with the following versions installed..
TFS -- RTM Version
SQL -- SQL Server 2005 Evaluation Version
Team System -- RTM Version
When i try to executes Reports (TeamProject -->Reports-->Builds) from Team Explorer i am getting the following message..[There are some builds configured and executed for this Team Project]
Reporting Services Error
- An internal error occurred on the report server. See the error log for more details. (rsInternalError)Get Online Help
- For more information about this error navigate to the report server on the local server machine, or enable remote errors
SQL Server Reporting Services
In the event viewer the message is as below
Event Type:Information
Event Source:ASP.NET 2.0.50727.0
Event Category:Web Event
Event ID:1314
Date:4/24/2006
Time:5:19:37 PM
User:N/A
Computer:BLRKCECD
Description:
Event code: 4010
Event message: An unhandled security exception has occurred.
Event time: 4/24/2006 5:19:37 PM
Event time (UTC): 4/24/2006 11:49:37 AM
Event ID: 02322568d1614950a0d627e62a2246d4
Event sequence: 6
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/ReportServer-1-127903529420849718
Trust level: Full
Application Virtual Path: /ReportServer
Application Path: D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\
Machine name: BLRKCECD
Process information:
Process ID: 3272
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Request information:
Request URL: http://blrkcecd/ReportServer/Pages/ReportViewer.aspx?/TeamProject3/Builds&rs:Command=Render
Request path: /ReportServer/Pages/ReportViewer.aspx
User host address: 132.186.90.252
User: IN002\IC003717t
Is authenticated: True
Authentication Type: NTLM
Thread account name: NT AUTHORITY\NETWORK SERVICE
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Can any one help me out what is the problem..
Thanks a ton in advance..
Regards
Ravikanth
[6972 byte] By [
chittark] at [2008-2-22]
What account is being used by the datasources?
you can check this by going to the report manager( http://<AT>/reports) and clicking on the datasources.
Thanks,
Othmane
Hi Othmane,
I didn't understand what <AT> means...
I logged in using the TFS set up account. In the start programs, i opened Microsoft SQL Server 2005 and SQL Server 2005 Management studio. I connected to the Reporting services and i got the list of team projects under "Home " Directory. From one of the team projects, i selected build. It shown me the Data Sources, History,Subscriptions. when i double click the Data sources it showed "TfsReportDS" and "TFSOlapReportDS"...and in the properties they are configures as shared resources...
So among this how can we know which datasource is being used..
Please do reply
Regards
Ravikanth
By AT, i meant your application tier computer name. Could you try navigating to http://blrkcecd/Reports and then clicking on the datasources. Once you do that you will see the credentials used to execute the report.
The TFSOlapReportDS is used to connect to the Analysis Services database(the OLAP cube) to get most of the data displayed within the report.
The TFSReportDS is used to get the information that is shown on top of the report from the relational warehouse(last processed time, last warehouse update).
Also could you try running an iisreset from a cmd window just in case this solves the issue.
Let me know,
Othmane
Hi othmane,
A white blank screen is coming when i try to navigate using http://blrkcecd/Reports .
I tried using http://blrkcecd/ReportingServer, i got list of Team projects and data sources. The XML file after clicking "TFSOlapReportDS" is as follows
<Extension>OLEDB-MD</Extension>
<ConnectString>Data source=BLRKCECD;initial catalog=TFSWarehouse</ConnectString>
<UseOriginalConnectString>False</UseOriginalConnectString>
<OriginalConnectStringExpressionBased>False</OriginalConnectStringExpressionBased>
<CredentialRetrieval>Store</CredentialRetrieval>
<WindowsCredentials>True</WindowsCredentials>
<ImpersonateUser>False</ImpersonateUser>
<UserName>domain\Name</UserName>
</DataSourceDefinition>
and the XML file for "The TFSReportDS" is
<Extension>SQL</Extension>
<ConnectString>Data source=BLRKCECD;initial catalog=TFSWarehouse</ConnectString>
<UseOriginalConnectString>False</UseOriginalConnectString>
<OriginalConnectStringExpressionBased>False</OriginalConnectStringExpressionBased>
<CredentialRetrieval>Store</CredentialRetrieval>
<WindowsCredentials>True</WindowsCredentials>
<ImpersonateUser>False</ImpersonateUser>
<UserName>Domain\Name</UserName>
</DataSourceDefinition>
In both the datasources the User name is the name i configured for reporting sevices.
I tried log in with both the TFS Set up A/c and the Reporting Services A/c for accessing reports, but same "Registry" error.
IISReset also didn't help...
Thanks in advance
Regards
Ravikanth
I suspect that something was not installed/configured properly during Reporting Services set up, could you run the Reporting Services Configuration utility for any red flags. Also it does help sometimes to look at the reporting services log files at C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles
Thanks,
Othmane
Othmane,
Do i need to install any service pack for SQL Server 2005 Evaluation Version ? Some where i read that i need to install Service Pack1 which will fix some errors in Reporting services ..
Regards
Ravikanth
It is always recommended to install the latest updates and SPs. I am still trying to figure out the reason why you are seeing the issue above. Feel free to install the latest SP to see if it fixes the issue but could you run the steps in my latest post above and let me know about the outcome of running the Reporting Services Configuration.
Thanks,
Othmane
Hi Othmane,
I run the steps you mentioned in your earlier posts..
1. There are no red flags in the Report server configuration
2. The following is the dump of Reporting server i found in log file (D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles)
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>India Standard Time</TimeZone>
<Path>D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__04_27_2006_09_04_29.log</Path>
<SystemName>BLRKCECD</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!1!4/27/2006-09:04:30:: i INFO: Reporting Web Server started
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!4/27/2006-09:04:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!4/27/2006-09:04:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!4/27/2006-09:04:30:: i INFO: Evaluation copy: 166 days left
w3wp!runningjobs!1!4/27/2006-09:04:30:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!4/27/2006-09:04:30:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!4/27/2006-09:04:30:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!4/27/2006-09:04:30:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!5!4/27/2006-09:04:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!5!4/27/2006-09:04:41:: e ERROR: Error rending control: System.Security.SecurityException: Requested registry access is not allowed.
at System.ThrowHelper.ThrowSecurityException(ExceptionResource resource)
at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
at System.Security.Cryptography.Utils.get_FipsAlgorithmPolicy()
at System.Security.Cryptography.RijndaelManaged..ctor()
at System.Web.Configuration.MachineKeySection.ConfigureEncryptionObject()
at System.Web.Configuration.MachineKeySection.EnsureConfig()
at System.Web.Configuration.MachineKeySection.GetEncodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32& length)
at System.Web.UI.ObjectStateFormatter.Serialize(Object stateGraph)
at System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Serialize(Object state)
at System.Web.UI.Util.SerializeWithAssert(IStateFormatter formatter, Object stateGraph)
at System.Web.UI.HiddenFieldPageStatePersister.Save()
at System.Web.UI.Page.SavePageStateToPersistenceMedium(Object state)
at System.Web.UI.Page.SaveAllState()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
The Zone of the assembly that failed was:
MyComputer
w3wp!library!5!4/27/2006-09:04:41:: Unhandled exception was caught: System.Security.SecurityException: Requested registry access is not allowed.
at System.ThrowHelper.ThrowSecurityException(ExceptionResource resource)
at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
at System.Security.Cryptography.Utils.get_FipsAlgorithmPolicy()
at System.Security.Cryptography.RijndaelManaged..ctor()
at System.Web.Configuration.MachineKeySection.ConfigureEncryptionObject()
at System.Web.Configuration.MachineKeySection.EnsureConfig()
at System.Web.Configuration.MachineKeySection.GetEncodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32& length)
at System.Web.UI.ObjectStateFormatter.Serialize(Object stateGraph)
at System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Serialize(Object state)
at System.Web.UI.Util.SerializeWithAssert(IStateFormatter formatter, Object stateGraph)
at System.Web.UI.HiddenFieldPageStatePersister.Save()
at System.Web.UI.Page.SavePageStateToPersistenceMedium(Object state)
at System.Web.UI.Page.SaveAllState()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
The Zone of the assembly that failed was:
MyComputer
w3wp!library!5!4/27/2006-09:04:41:: 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.Security.SecurityException: Requested registry access is not allowed.
at System.ThrowHelper.ThrowSecurityException(ExceptionResource resource)
at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
at System.Security.Cryptography.Utils.get_FipsAlgorithmPolicy()
at System.Security.Cryptography.RijndaelManaged..ctor()
at System.Web.Configuration.MachineKeySection.ConfigureEncryptionObject()
at System.Web.Configuration.MachineKeySection.EnsureConfig()
at System.Web.Configuration.MachineKeySection.GetEncodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32& length)
at System.Web.UI.ObjectStateFormatter.Serialize(Object stateGraph)
at System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Serialize(Object state)
at System.Web.UI.Util.SerializeWithAssert(IStateFormatter formatter, Object stateGraph)
at System.Web.UI.HiddenFieldPageStatePersister.Save()
at System.Web.UI.Page.SavePageStateToPersistenceMedium(Object state)
at System.Web.UI.Page.SaveAllState()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
The Zone of the assembly that failed was:
MyComputer
End of inner exception stack trace
w3wp!library!5!4/27/2006-09:04:43:: i INFO: Exception dumped to: D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
Thanks in advance,
Regards
Ravikanth
Hi Ravikanth,
After looking into this further, it seems that the account used to run SQL Reporting Services under does not have the appropriate permissions to access a registry key.
Did you encounter any errors during setup? Is this a Single or Dual TFS server install?
My recommendation to you is to reinstall Reporting Services. If it is a single server install, then just reinstall SQL Server Reporting Services; the SQL install will configure Reporting Services. However if it is a dual install, you would need to uninstall TFS first and reinstall it after Reporting services is reinstalled since TFS handles the configuration of Reporting Services.
Thanks,
Othmane
Othmane,
What is the Reporting Services Configuration utility? Is that just the RS setup?
Thanks,
-Joey
You can find this utility under Program files->Microsoft SQL Server 2005->Configuration Tools, on your application tier: " Reporting Services Configuration Manager"
Thanks,
Othmane
Hi Othmane,
After re installing SQl Server, the problem got solved. Now reports are working fine. I have couple of questions...
1. Is there any way i can set the Data ware house refreshing rate.
2. My counter part in U.S while trying to access TFS remotely, is getting "TF31002" error. Should i need to install Proxy that comes along with TFS installation media ?
Thanks and Regards
Ravikanth
Hi Othmane, After re installing SQl Server, the problem got solved. Now reports are working fine. I have couple of questions...
1. Is there any way i can set the Data ware house refreshing rate.
2. My counter part in U.S while trying to access TFS remotely, is getting "TF31002" error. Should i need to install Proxy that comes along with TFS installation media ?
Thanks and Regards
Ravikanth
