Showing posts with label address. Show all posts
Showing posts with label address. Show all posts

Wednesday, March 7, 2012

Report Server Not Activated

I have a Report Server where I have had to change the IP address of the
server and to the remote database server. After the IP address change, I
started receiving the following message when I access the report manager.
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated)
I have tried running rsactivate with no success. I have also ran rsconfig
to ensure my database connection is valid as well as rskeymgmt to delete and
reinstall the keys.
********************* LOG File ********************************
Below is the error messages being displayed in the ReportServerWebApp log.
Any additional information on how to solve this problem would be greatly
appreciated.
********************* LOG File ********************************
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing MaxScheduleWait to
default value of '1' second(s) because it was not specified in Configuration
file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing RunningRequestsAge
to default value of '30' second(s) because it was not specified in
Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!ui!8a4!2/2/2005-12:17:02:: e ERROR: Unable to communicate with report
server. Please verify that the report server is operational.
w3wp!ui!8a4!2/2/2005-12:17:02:: e ERROR: HTTP status code --> 500
--Details--
CantCommunicateWithReportServerException: Unable to communicate with report
server. Please verify that the report server is operational.
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!8a4!2/2/2005-12:17:06:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
w3wp!ui!868!2/2/2005-12:17:27:: e ERROR: The report server installation is
not initialized. Check the documentation for more information. --> The report
server installation is not initialized. Check the documentation for more
information.
w3wp!ui!868!2/2/2005-12:17:27:: e ERROR: HTTP status code --> 200
--Details--
System.Web.Services.Protocols.SoapException: The report server installation
is not initialized. Check the documentation for more information. --> The
report server installation is not initialized. Check the documentation for
more information.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
Item)
at
Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item)
at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender,
EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!868!2/2/2005-12:17:27:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)I had this problem too. After increase RAM Memory it was solved.
"Jim W" wrote:
> I have a Report Server where I have had to change the IP address of the
> server and to the remote database server. After the IP address change, I
> started receiving the following message when I access the report manager.
> The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated)
> I have tried running rsactivate with no success. I have also ran rsconfig
> to ensure my database connection is valid as well as rskeymgmt to delete and
> reinstall the keys.
> ********************* LOG File ********************************
> Below is the error messages being displayed in the ReportServerWebApp log.
> Any additional information on how to solve this problem would be greatly
> appreciated.
> ********************* LOG File ********************************
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing MaxScheduleWait to
> default value of '1' second(s) because it was not specified in Configuration
> file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> DatabaseQueryTimeout to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing InstanceName to
> default value of 'MSSQLSERVER.1' because it was not specified in
> Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> ProcessRecycleOptions to default value of '0' because it was not specified
> in Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> RunningRequestsScavengerCycle to default value of '30' second(s) because it
> was not specified in Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> RunningRequestsDbCycle to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing RunningRequestsAge
> to default value of '30' second(s) because it was not specified in
> Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> CleanupCycleMinutes to default value of '10' minute(s) because it was not
> specified in Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> SecureConnectionLevel to default value of '1' because it was not specified
> in Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing DisplayErrorLink
> to 'True' as specified in Configuration file.
> w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was not
> specified in Configuration file.
> w3wp!ui!8a4!2/2/2005-12:17:02:: e ERROR: Unable to communicate with report
> server. Please verify that the report server is operational.
> w3wp!ui!8a4!2/2/2005-12:17:02:: e ERROR: HTTP status code --> 500
> --Details--
> CantCommunicateWithReportServerException: Unable to communicate with report
> server. Please verify that the report server is operational.
> at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!8a4!2/2/2005-12:17:06:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
> w3wp!ui!868!2/2/2005-12:17:27:: e ERROR: The report server installation is
> not initialized. Check the documentation for more information. --> The report
> server installation is not initialized. Check the documentation for more
> information.
> w3wp!ui!868!2/2/2005-12:17:27:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException: The report server installation
> is not initialized. Check the documentation for more information. --> The
> report server installation is not initialized. Check the documentation for
> more information.
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item)
> at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
> at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
> at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
> at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
> at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender,
> EventArgs e)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!868!2/2/2005-12:17:27:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
>|||I have also noticed the following error within the ReportServer log file:
w3wp!library!788!02/03/2005-10:20:04:: i INFO: Call to GetSystemPermissions
w3wp!crypto!788!02/03/2005-10:20:04:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!788!02/03/2005-10:20:04:: i INFO: Exporting public key
w3wp!crypto!788!02/03/2005-10:20:04:: w WARN: Web Service not activated
w3wp!crypto!788!02/03/2005-10:20:04:: i INFO: Client is not a local admin.
Not attempting activation.
w3wp!library!788!02/03/2005-10:20:04:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information.
Jim.
"Dev Main" wrote:
> I had this problem too. After increase RAM Memory it was solved.
> "Jim W" wrote:
> > I have a Report Server where I have had to change the IP address of the
> > server and to the remote database server. After the IP address change, I
> > started receiving the following message when I access the report manager.
> >
> > The report server installation is not initialized. Check the documentation
> > for more information. (rsReportServerNotActivated)
> >
> > I have tried running rsactivate with no success. I have also ran rsconfig
> > to ensure my database connection is valid as well as rskeymgmt to delete and
> > reinstall the keys.
> >
> > ********************* LOG File ********************************
> > Below is the error messages being displayed in the ReportServerWebApp log.
> > Any additional information on how to solve this problem would be greatly
> > appreciated.
> >
> > ********************* LOG File ********************************
> >
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> > MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing MaxScheduleWait to
> > default value of '1' second(s) because it was not specified in Configuration
> > file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> > DatabaseQueryTimeout to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing InstanceName to
> > default value of 'MSSQLSERVER.1' because it was not specified in
> > Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> > ProcessRecycleOptions to default value of '0' because it was not specified
> > in Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> > RunningRequestsScavengerCycle to default value of '30' second(s) because it
> > was not specified in Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> > RunningRequestsDbCycle to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing RunningRequestsAge
> > to default value of '30' second(s) because it was not specified in
> > Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> > CleanupCycleMinutes to default value of '10' minute(s) because it was not
> > specified in Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> > SecureConnectionLevel to default value of '1' because it was not specified
> > in Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing DisplayErrorLink
> > to 'True' as specified in Configuration file.
> > w3wp!library!8a4!2/2/2005-12:16:59:: i INFO: Initializing
> > WebServiceUseFileShareStorage to default value of 'False' because it was not
> > specified in Configuration file.
> > w3wp!ui!8a4!2/2/2005-12:17:02:: e ERROR: Unable to communicate with report
> > server. Please verify that the report server is operational.
> > w3wp!ui!8a4!2/2/2005-12:17:02:: e ERROR: HTTP status code --> 500
> > --Details--
> > CantCommunicateWithReportServerException: Unable to communicate with report
> > server. Please verify that the report server is operational.
> >
> > at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> >
> > at
> > Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> > methodname)
> >
> > at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> >
> > at
> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > level)
> >
> > at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > sender, EventArgs args)
> >
> > at System.EventHandler.Invoke(Object sender, EventArgs e)
> >
> > at System.Web.UI.Control.OnInit(EventArgs e)
> >
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> >
> > at System.Web.UI.Page.ProcessRequestMain()
> > w3wp!ui!8a4!2/2/2005-12:17:06:: e ERROR: Exception in ShowErrorPage:
> > System.Threading.ThreadAbortException: Thread was being aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)
> > w3wp!ui!868!2/2/2005-12:17:27:: e ERROR: The report server installation is
> > not initialized. Check the documentation for more information. --> The report
> > server installation is not initialized. Check the documentation for more
> > information.
> > w3wp!ui!868!2/2/2005-12:17:27:: e ERROR: HTTP status code --> 200
> > --Details--
> > System.Web.Services.Protocols.SoapException: The report server installation
> > is not initialized. Check the documentation for more information. --> The
> > report server installation is not initialized. Check the documentation for
> > more information.
> >
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
> >
> > at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> >
> > at
> > Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
> > Item)
> >
> > at
> > Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item)
> >
> > at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
> >
> > at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
> >
> > at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
> >
> > at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
> >
> > at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender,
> > EventArgs e)
> >
> > at System.EventHandler.Invoke(Object sender, EventArgs e)
> >
> > at System.Web.UI.Control.OnInit(EventArgs e)
> >
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> >
> > at System.Web.UI.Page.ProcessRequestMain()
> > w3wp!ui!868!2/2/2005-12:17:27:: e ERROR: Exception in ShowErrorPage:
> > System.Threading.ThreadAbortException: Thread was being aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)
> >
> >

Monday, February 20, 2012

Report Rendering (II)

Hi,

I have been using the following code, (thanks to Shyam), to display address fields. This works great when using preview in BIDS, but the address shows on one continious line when the report is redered in Reporting Services.

=First(Fields!Name.Value) & IIf(First(Fields!Address1.Value) <> "", Chr(10) & Chr(13) & First(Fields!Address1.Value), "") &
IIf(First(Fields!Address2.Value) <> "", Chr(10) & Chr(13) & First(Fields!Address2.Value), "") &
IIf(First(Fields!Address3.Value) <> "", Chr(10) & Chr(13) & First(Fields!Address3.Value), "") &
IIf(First(Fields!Town.Value) <> "", Chr(10) & Chr(13) & First(Fields!Town.Value), "") &
IIf(First(Fields!County.Value) <> "", Chr(10) & Chr(13) & First(Fields!County.Value), "") &
IIf(First(Fields!Post_Code.Value) <> "", Chr(10) & Chr(13) & First(Fields!Post_Code.Value),

Any one any ideas?

Thanks

Did you try vbCRLF instead of chr(10) & 13?

http://blogs.infinite-x.net/category/dynamics-crm/reporting/

cheers,

Andrew