Sunday, February 26, 2012

Error (rsInternalError) after installation

I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003
64bit SP1 Enterprise Edition.
Reporting Services Configuration Manager indicate that everything is ok,
green checks except Encryption Keys and Execution Account.
Reporting Services databases, ReportServer and ReportServerTempDB, is not
"installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in
the same domain.
I get following error:
http://localhost/reportserver:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.
Event Viewer:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2006-02-24
Time: 10:11:35
User: N/A
Computer: PRD128ASAL
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2006-02-24 10:11:35
Event time (UTC): 2006-02-24 09:00:25
Event ID: ac7dc3e0abc2412aab9566d56f81859e
Event sequence: 12
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL
Server\MSSQL.1\Reporting Services\ReportServer\
Machine name: XXXXXXXXXX
Process information:
Process ID: 1900
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://localhost/reportserver
Request path: /reportserver
User host address: 127.0.0.1
User: DOMAIN\USERID
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at
Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
at
Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object
sender, EventArgs e)
at
System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
Custom event details:
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Reporting Services LogFiles:
w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed.
Exception thrown: System.NullReferenceException: Object reference not set to
an instance of an object.
at
Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing. -->
System.NullReferenceException: Object reference not set to an instance of an
object.
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed.
Exception thrown: System.NullReferenceException: Object reference not set to
an instance of an object.
at
Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running
Requests DB : System.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at
Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
unused)
Thankful for solution or any idea!
Regards, JonasAfter hours of thinking, testing, googleing and head scratching I found a
workaround.
I tried to change the Reporting Services application pool identity to a
windows account. And it worked. This window account is a member of local
administrators. Haven't tried more restricted rights yet.
But documentation from Microsoft recommends to use Network Service as
application pool identity for Reporting Services.
I found this url interesting, http://support.microsoft.com/kb/896861/.
But I tried both workaround descibed whitout success.
Any idea? Anyone?
I really would like to use the Network Service account as recommended by
Microsoft.
Regards, Jonas
"JvG" wrote:
> I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003
> 64bit SP1 Enterprise Edition.
> Reporting Services Configuration Manager indicate that everything is ok,
> green checks except Encryption Keys and Execution Account.
> Reporting Services databases, ReportServer and ReportServerTempDB, is not
> "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in
> the same domain.
> I get following error:
> http://localhost/reportserver:
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> Object reference not set to an instance of an object.
> Event Viewer:
> Event Type: Warning
> Event Source: ASP.NET 2.0.50727.0
> Event Category: Web Event
> Event ID: 1309
> Date: 2006-02-24
> Time: 10:11:35
> User: N/A
> Computer: PRD128ASAL
> Description:
> Event code: 3005
> Event message: An unhandled exception has occurred.
> Event time: 2006-02-24 10:11:35
> Event time (UTC): 2006-02-24 09:00:25
> Event ID: ac7dc3e0abc2412aab9566d56f81859e
> Event sequence: 12
> Event occurrence: 7
> Event detail code: 0
> Application information:
> Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
> Trust level: RosettaSrv
> Application Virtual Path: /ReportServer
> Application Path: C:\Program Files\Microsoft SQL
> Server\MSSQL.1\Reporting Services\ReportServer\
> Machine name: XXXXXXXXXX
> Process information:
> Process ID: 1900
> Process name: w3wp.exe
> Account name: NT AUTHORITY\NETWORK SERVICE
> Exception information:
> Exception type: NullReferenceException
> Exception message: Object reference not set to an instance of an object.
> Request information:
> Request URL: http://localhost/reportserver
> Request path: /reportserver
> User host address: 127.0.0.1
> User: DOMAIN\USERID
> Is authenticated: True
> Authentication Type: Negotiate
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Thread information:
> Thread ID: 1
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Is impersonating: True
> Stack trace: at
> Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object
> sender, EventArgs e)
> at
> System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
>
> Custom event details:
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Reporting Services LogFiles:
> w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed.
> Exception thrown: System.NullReferenceException: Object reference not set to
> an instance of an object.
> at
> Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
> w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
> The report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
> The report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing. -->
> System.NullReferenceException: Object reference not set to an instance of an
> object.
> at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed.
> Exception thrown: System.NullReferenceException: Object reference not set to
> an instance of an object.
> at
> Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
> w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running
> Requests DB : System.NullReferenceException: Object reference not set to an
> instance of an object.
> at
> Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
> at
> Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
> unused)
> Thankful for solution or any idea!
> Regards, Jonas

No comments:

Post a Comment