Home » C++ ProgrammingRSS

SSRS WebService ==> (503)Service Unavailable

Hi team,

I need to call SSRS 2008 via a web service in java, 

the report manager and report server is availible under IE, I can see my different reports and all, deduction that is the service is AVAILABLE!!

but when i call it from my ws the response is (503)Service Unavailable ... what means? is there some parameter to do?

my SSRS is local installation.

many thaks for any help or suggestion to fix this.

thx

 

 

14 Answers Found

 

Answer 1

is there any solution ? any suggestion?

thx in advance

 

Answer 2

Was there any exception in server log when 503 error happened?
Have fun with Reporting Service
 

Answer 3

thx for reply,

from java I have this 

 

 

from FileLog I have not log for this, logic because 503 means that the service is unvailable !!! so can not connect and ask .

 

I think it is a parameter in rsreportserver.config wrong ?

<Configuration>
	<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA7DS2pqqbLk28QEno/rX1RwQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAJaNg42DdWUcgrPYov63LZMAAAAA
BIAAAKAAAAAQAAAAF/rAmC21sV52LMiqMEY/OggBAADdue3q7BY8ZrdLRkZOpxb0jlZYDdElPqkH
KX4b1r8AUAjtATMoMlNSi/5b6CVaNdcSz5dK6T3wxyOvwMIulwc7ratMB4uiIfwEs0nKtRtpQ/Or
MGcxWhbT88W4DYj+xA+r3UIo1ABYs1Wu/oTdqdH/I80CvSsatb+guX32FpM6zRE3kTe2gs5c+nDC
dnAzQjACy4KRYaz/n8cZLmRVsFhosSPCOhGbn3r7qyO3D+V3AJDQ/w5SBmxCNRfuJLTEmxK/17sM
vd3TQYRB5TBXJUgF9mtr76RlYzgRxpGfDwydz+3oWGt3TP1RsmGNJIGap0VZUFsePdZonrA1zOMN
M+pSUL8S4vviYyUUAAAAy74ysbRUEz6mskDLHxLrwf12Eqs=</Dsn>
	<ConnectionType>Default</ConnectionType>
	<LogonUser></LogonUser>
	<LogonDomain></LogonDomain>
	<LogonCred></LogonCred>
	<InstanceId>MSRS10.MSSQLSERVERS2008</InstanceId>
	<InstallationID>{ed88f4a5-7bcf-4070-bca5-7c6dc8351acc}</InstallationID>
	<Add Key="SecureConnectionLevel" Value="0"/>
	<Add Key="CleanupCycleMinutes" Value="10"/>
	<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
	<Add Key="MaxActiveReqForOneUser" Value="20"/>
	<Add Key="DatabaseQueryTimeout" Value="120"/>
	<Add Key="RunningRequestsScavengerCycle" Value="60"/>
	<Add Key="RunningRequestsDbCycle" Value="60"/>
	<Add Key="RunningRequestsAge" Value="30"/>
	<Add Key="MaxScheduleWait" Value="5"/>
	<Add Key="DisplayErrorLink" Value="true"/>
	<Add Key="WebServiceUseFileShareStorage" Value="false"/>
	<!-- <Add Key="ProcessTimeout" Value="150" /> -->
	<!-- <Add Key="ProcessTimeoutGcExtension" Value="30" /> -->
	<!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
	<!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
	<!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
	<Add Key="WatsonFlags" Value="0x0428"/>
	<Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException"/>
	<Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException"/>
	<URLReservations>
		<Application>
			<Name>ReportServerWebService</Name>
			<VirtualDirectory>ReportServer_MSSQLSERVERS2008_WS</VirtualDirectory>
			<URLs>
				<URL>
					<UrlString>http://+:80</UrlString>
					<AccountSid>S-1-5-21-4018316531-2800467355-3748784866-172718</AccountSid>
					<AccountName>DOMAIN\USER</AccountName>
				</URL>
			</URLs>
		</Application>
		<Application>
			<Name>ReportManager</Name>
			<VirtualDirectory>Reports_MSSQLSERVERS2008_MG</VirtualDirectory>
			<URLs>
				<URL>
					<UrlString>http://ST018692:80</UrlString>
					<AccountSid>S-1-5-21-4018316531-2800467355-3748784866-172718</AccountSid>
					<AccountName>DOMAIN\USER</AccountName>
</URL> </URLs> </Application> </URLReservations> <Authentication> <AuthenticationTypes> <RSWindowsBasic/> </AuthenticationTypes> <EnableAuthPersistence>True</EnableAuthPersistence> </Authentication> <Service> <IsSchedulingService>True</IsSchedulingService> <IsNotificationService>True</IsNotificationService> <IsEventService>True</IsEventService> <PollingInterval>10</PollingInterval> <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage> <MemorySafetyMargin>80</MemorySafetyMargin> <MemoryThreshold>90</MemoryThreshold> <RecycleTime>720</RecycleTime> <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime> <MaxQueueThreads>0</MaxQueueThreads> <UrlRoot> </UrlRoot> <UnattendedExecutionAccount> <UserName>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA7DS2pqqbLk28QEno/rX1RwQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAPihX0mNB/kK7IKB1pk6dTQAAAAA BIAAAKAAAAAQAAAAEwmPGY/ZLL9GRiKN4y6NKRgAAABABhyovXGKIzRTlijhlxB9uAZbJ3PE+5AU AAAAc1nfi8j7oPbakoyrNzmWPQUAnYU=</UserName> <Password>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA7DS2pqqbLk28QEno/rX1RwQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAACrcQGIXYWluGdbobetjCVIAAAAA BIAAAKAAAAAQAAAAm7ZWKZlRFsCqIkRBTjerURAAAAABW8oge5KC/XGipwSqHOwnFAAAAEQFrm3C 4+gAj0BxQeMoo7C4uD4Q </Password> <Domain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA7DS2pqqbLk28QEno/rX1RwQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGwwW2CTsqoTYc9fvsPxda8AAAAA BIAAAKAAAAAQAAAAFXAWWruw/Km+XijXF4oUqhgAAABsocUi6MDcVmCZLM6JdfTOx01fJ8i5RZIU AAAAwB6eyJCZHhlpnYmzBtN58HWGdzw=</Domain> </UnattendedExecutionAccount> <PolicyLevel>rssrvpolicy.config</PolicyLevel> <IsWebServiceEnabled>True</IsWebServiceEnabled> <IsReportManagerEnabled>True</IsReportManagerEnabled> <FileShareStorageLocation> <Path> </Path> </FileShareStorageLocation> </Service> <UI> <ReportServerUrl> </ReportServerUrl> <PageCountMode>Estimate</PageCountMode> </UI> <Extensions> <Delivery> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <FileShareConfiguration> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> </FileShareConfiguration> </Configuration> </Extension> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer>BCNVMSB009</SMTPServer> <SMTPServerPort>25</SMTPServerPort> <SMTPAccountName> </SMTPAccountName> <SMTPConnectionTimeout> </SMTPConnectionTimeout> <SMTPServerPickupDirectory> </SMTPServerPickupDirectory> <SMTPUseSSL> </SMTPUseSSL> <SendUsing>2</SendUsing> <SMTPAuthenticate> </SMTPAuthenticate> <From></From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats> </PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>True</SendEmailToUserAlias> <DefaultHostName>BCNVMSB009m</DefaultHostName> <PermittedHosts> </PermittedHosts> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <DocumentLibraryConfiguration> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> </DocumentLibraryConfiguration> </Configuration> </Extension> <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/> </Delivery> <DeliveryUI> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider"> <DefaultDeliveryExtension>True</DefaultDeliveryExtension> <Configuration> <RSEmailDPConfiguration> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/> </DeliveryUI> <Render> <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/> <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/> <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/> <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/> <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/> <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/> <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/> <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/> <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/> <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering"/> </Render> <Data> <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/> <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/> <Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <!-- <Extension Name="SSIS" Type="Microsoft.SqlServer.Dts.DtsClient.DtsConnection,Microsoft.SqlServer.Dts.DtsClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/> --> </Data> <SemanticQuery> <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>False</EnableMathOpCasting> </Configuration> </Extension> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>True</EnableMathOpCasting> <DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters> <EnableUnistr>False</EnableUnistr> <DisableTSTruncation>False</DisableTSTruncation> </Configuration> </Extension> <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>True</EnableMathOpCasting> <ReplaceFunctionName>oREPLACE</ReplaceFunctionName> </Configuration> </Extension> <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling"/> </SemanticQuery> <ModelGeneration> <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/> <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/> <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling"/> </ModelGeneration> <Security> <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/> </Security> <Authentication> <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/> </Authentication> <EventProcessing> <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary"> <Event> <Type>ReportHistorySnapshotCreated</Type> </Event> </Extension> <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary"> <Event> <Type>TimedSubscription</Type> </Event> </Extension> <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary"> <Event> <Type>SnapshotUpdated</Type> </Event> </Extension> </EventProcessing> </Extensions> </Configuration>

 

 

Answer 4

This is config file not server log. Please refer to http://msdn.microsoft.com/en-us/library/ms156500.aspx for server log.
 

Answer 5

Thx for reply

I know what is the server log

but I said there is no log for this error .

when my web service call  the server this one return 503 which means that the server is shutdown or KO, which is not truth, because I can see my reports in the browser !!

 

Thx

 

 

Answer 6

some log, I cannot see anywhere 503 !! or Service Unvailable or something like this

 

before the java call  :

</Header>rshost!rshost!12e4!07/01/2010-17:31:56:: i INFO: CLR runtime is initialized.

rshost!rshost!12e4!07/01/2010-17:31:57:: i INFO: Derived memory configuration based on physical memory as 2052648 KB

appdomainmanager!DefaultDomain!e58!07/01/2010-17:31:57:: i INFO: Entered managed ServiceMain in DefaultDomain.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing AuthenticationTypes to '8'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.

configmanager!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Using report server internal url http://localhost:80/ReportServer_MSSQLSERVERS2008_WS.

configmanager!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Using report server external url http://ST018692:80/ReportServer_MSSQLSERVERS2008_WS.

configmanager!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Using url root http://ST018692:80/ReportServer_MSSQLSERVERS2008_WS.

appdomainmanager!DefaultDomain!e38!07/01/2010-17:32:15:: i INFO: Appdomain:2 WindowsService_0 started.

resourceutilities!WindowsService_0!e38!07/01/2010-17:32:16:: i INFO: Reporting Services starting SKU: Developer

resourceutilities!WindowsService_0!e38!07/01/2010-17:32:16:: i INFO: Evaluation copy: 0 days left

resourceutilities!WindowsService_0!e38!07/01/2010-17:32:16:: i INFO: Running on 1 physical processors, 2 logical processors

rshost!rshost!1608!07/01/2010-17:32:16:: i INFO: Registered url=http://+:80/ReportServer_MSSQLSERVERS2008_WS/, vdir=/ReportServer_MSSQLSERVERS2008_WS, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVERS2008\Reporting Services\ReportServer.

rshost!rshost!1608!07/01/2010-17:32:16:: i INFO: Currently registered url http://+:80/ReportServer_MSSQLSERVERS2008_WS/ on endpoint 2

rshost!rshost!16e8!07/01/2010-17:32:16:: i INFO: Registered url=http://ST018692:80/Reports_MSSQLSERVERS2008_MG/, vdir=/Reports_MSSQLSERVERS2008_MG, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVERS2008\Reporting Services\ReportManager.

rshost!rshost!16e8!07/01/2010-17:32:16:: i INFO: Currently registered url http://ST018692:80/Reports_MSSQLSERVERS2008_MG/ on endpoint 3

rshost!rshost!854!07/01/2010-17:32:16:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer_MSSQLSERVERS2008_WS/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVERS2008\Reporting Services\ReportServer\ReportBuilder.

rshost!rshost!e38!07/01/2010-17:32:16:: i INFO: Derived memory configuration based on physical memory as 2052648 KB

rpcserver!DefaultDomain!16e8!07/01/2010-17:32:16:: i INFO: Process monitoring started.

servicecontroller!DefaultDomain!854!07/01/2010-17:32:16:: i INFO: Total Physical memory: 2101911552

library!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Catalog SQL Server Edition = Enterprise

crypto!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Initializing crypto as user: DOMAIN\USER

crypto!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Exporting public key

crypto!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Performing sku validation

crypto!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Importing existing encryption key

dbpolling!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: EventPolling polling service started

dbpolling!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: NotificationPolling polling service started

dbpolling!WindowsService_0!1608!07/01/2010-17:32:16:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.

dbpolling!WindowsService_0!7e4!07/01/2010-17:32:16:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.

dbpolling!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: SchedulePolling polling service started

dbpolling!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: UpgradePolling polling service started

dbpolling!WindowsService_0!3c8!07/01/2010-17:32:16:: i INFO: PollingMaintenance: Polling started

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 30463 seconds.  Cycle: 86400 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: SQM timer timer enabled: Next Event: 34063 seconds.  Cycle: 86400 seconds

rpcserver!DefaultDomain!1310!07/01/2010-17:32:17:: i INFO: RPC Server started.

servicecontroller!DefaultDomain!1310!07/01/2010-17:32:17:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10.MSSQLSERVERS2008'

appdomainmanager!WindowsService_0!1310!07/01/2010-17:32:17:: i INFO: Appdomain:2 WindowsService_0 initialized.

library!DefaultDomain!e58!07/01/2010-17:32:18:: i INFO: Catalog SQL Server Edition = Enterprise

resourceutilities!DefaultDomain!e58!07/01/2010-17:32:18:: i INFO: Reporting Services starting SKU: Developer

resourceutilities!DefaultDomain!e58!07/01/2010-17:32:18:: i INFO: Evaluation copy: 0 days left

after java call :

 

</Header>rshost!rshost!12e4!07/01/2010-17:31:56:: i INFO: CLR runtime is initialized.

rshost!rshost!12e4!07/01/2010-17:31:57:: i INFO: Derived memory configuration based on physical memory as 2052648 KB

appdomainmanager!DefaultDomain!e58!07/01/2010-17:31:57:: i INFO: Entered managed ServiceMain in DefaultDomain.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing AuthenticationTypes to '8'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.

library!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.

configmanager!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Using report server internal url http://localhost:80/ReportServer_MSSQLSERVERS2008_WS.

configmanager!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Using report server external url http://ST018692:80/ReportServer_MSSQLSERVERS2008_WS.

configmanager!DefaultDomain!e38!07/01/2010-17:31:58:: i INFO: Using url root http://ST018692:80/ReportServer_MSSQLSERVERS2008_WS.

appdomainmanager!DefaultDomain!e38!07/01/2010-17:32:15:: i INFO: Appdomain:2 WindowsService_0 started.

resourceutilities!WindowsService_0!e38!07/01/2010-17:32:16:: i INFO: Reporting Services starting SKU: Developer

resourceutilities!WindowsService_0!e38!07/01/2010-17:32:16:: i INFO: Evaluation copy: 0 days left

resourceutilities!WindowsService_0!e38!07/01/2010-17:32:16:: i INFO: Running on 1 physical processors, 2 logical processors

rshost!rshost!1608!07/01/2010-17:32:16:: i INFO: Registered url=http://+:80/ReportServer_MSSQLSERVERS2008_WS/, vdir=/ReportServer_MSSQLSERVERS2008_WS, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVERS2008\Reporting Services\ReportServer.

rshost!rshost!1608!07/01/2010-17:32:16:: i INFO: Currently registered url http://+:80/ReportServer_MSSQLSERVERS2008_WS/ on endpoint 2

rshost!rshost!16e8!07/01/2010-17:32:16:: i INFO: Registered url=http://ST018692:80/Reports_MSSQLSERVERS2008_MG/, vdir=/Reports_MSSQLSERVERS2008_MG, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVERS2008\Reporting Services\ReportManager.

rshost!rshost!16e8!07/01/2010-17:32:16:: i INFO: Currently registered url http://ST018692:80/Reports_MSSQLSERVERS2008_MG/ on endpoint 3

rshost!rshost!854!07/01/2010-17:32:16:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer_MSSQLSERVERS2008_WS/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVERS2008\Reporting Services\ReportServer\ReportBuilder.

rshost!rshost!e38!07/01/2010-17:32:16:: i INFO: Derived memory configuration based on physical memory as 2052648 KB

rpcserver!DefaultDomain!16e8!07/01/2010-17:32:16:: i INFO: Process monitoring started.

servicecontroller!DefaultDomain!854!07/01/2010-17:32:16:: i INFO: Total Physical memory: 2101911552

library!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Catalog SQL Server Edition = Enterprise

crypto!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Initializing crypto as user: BCNDOMAIN\Z.HAMROUNE

crypto!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Exporting public key

crypto!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Performing sku validation

crypto!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Importing existing encryption key

dbpolling!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: EventPolling polling service started

dbpolling!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: NotificationPolling polling service started

dbpolling!WindowsService_0!1608!07/01/2010-17:32:16:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.

dbpolling!WindowsService_0!7e4!07/01/2010-17:32:16:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.

dbpolling!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: SchedulePolling polling service started

dbpolling!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: UpgradePolling polling service started

dbpolling!WindowsService_0!3c8!07/01/2010-17:32:16:: i INFO: PollingMaintenance: Polling started

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 30463 seconds.  Cycle: 86400 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds

runningjobs!WindowsService_0!1310!07/01/2010-17:32:16:: i INFO: SQM timer timer enabled: Next Event: 34063 seconds.  Cycle: 86400 seconds

rpcserver!DefaultDomain!1310!07/01/2010-17:32:17:: i INFO: RPC Server started.

servicecontroller!DefaultDomain!1310!07/01/2010-17:32:17:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10.MSSQLSERVERS2008'

appdomainmanager!WindowsService_0!1310!07/01/2010-17:32:17:: i INFO: Appdomain:2 WindowsService_0 initialized.

library!DefaultDomain!e58!07/01/2010-17:32:18:: i INFO: Catalog SQL Server Edition = Enterprise

resourceutilities!DefaultDomain!e58!07/01/2010-17:32:18:: i INFO: Reporting Services starting SKU: Developer

resourceutilities!DefaultDomain!e58!07/01/2010-17:32:18:: i INFO: Evaluation copy: 0 days left

 

NO CHANGE

but I have this Error :

{http://xml.apache.org/axis/}HttpErrorCode:503

(503)Service Unavailable

 

Thx

 

 

 

 

 

Answer 7

Have you checked your code if you're refering to correct server url? I'm sorry that I missed some of your words.

Mostly user would met 503 when RS is unloading app domain, which is definitely not your case per server log. So I guess your code are refering to wrong server url.

 

Answer 8

Right !!

When i have generated stubs(proxy)

the object ReportExecutionServiceLocator is generated from the url1 = http://srv1/reportserver/execution.asmx

when i execute urlExec=http://srv2/..../asmx 

may this is an error ??

srv1 and srv2 are ssrs  2008 normally it is not a problem right ?

 

ReportExecutionServiceLocator exLoc = new ReportExecutionServiceLocator();

		ReportExecutionServiceSoap rs 

			= exLoc.getReportExecutionServiceSoap(

					new java.net.URL(urlExec)

				);

may be it source of problem I will try to change it to srv1 to srv2 !!

 

 

Answer 9

Unfortunaly, still does not work !!

 

 

Answer 10

I'm not a Java developer. In .NET, URL should be http://<Server Name>/reportserver/reportexecution2005.asmx?wsdl. Should it be the same both .net and Java?
Have fun with Reporting Service
 

Answer 11

thx for reply,

the wsdl is the same

http://<Server Name>/reportserver/reportexecution2005.asmx?wsdl

when you generate the client (stub) you will create a several objects (class) espacially

ReportExecutionServiceLocator 

if you are some curious you can see in this object the chaine http://<Server Name>/reportserver/reportexecution2005.asmx

in many places.

when you want to execute you will do it like

 

ReportExecutionServiceLocator exLoc = new ReportExecutionServiceLocator();

		ReportExecutionServiceSoap rs 

			= exLoc.getReportExecutionServiceSoap(

					new java.net.URL(urlExec)

				);

so the

urlExec =http://<Server Name>2/reportserver/reportexecution2005.asmx
this is precision only,
my problem is more hard to me beacause it is not linked to java but i still think, it paramatrage to fix !!
thx for any help.

 

Answer 12

Hi userBIDS,

First, the Web Services URL you should use is
http://<server>/ReportServer_MSSQLSERVERS2008_WS/reportexecution2005.asmx

For error 503, as you mentioned, it is service unavailable. Generally, it is caused by the an framework error. We can check if any error from System Logs(using Event Viewer).

However, in this case, it is a little confused. Is the Java application throw 503 error or the Reporting Services?
When 503 error occurs, and we still be able to view reports, it should mean the error is thrown from Java application.

In addition, the configuration file looks fine. There is no error in the Reporting Services logs.

Thanks,
Jin Chen

 

Answer 13

thx U are right. SSRS works fine

the problem is the java app, it is a curious problem because I have a class GenareteReport which have a method GenerateReportAsFile(...)

when I create a main method inside of this class i can get the file and works fine , but if I call  the same method from another class,  an error 503 occurs from java application !!

 

i tried lot of combinason whithout instantiation, static, final way ...it still KO.

 

many thx

 

 

Answer 14

any suggest ?

thx in advance

 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter