Re: Unable to get the login page for portal server
mic...@integraware.com.br
i had the same problem. I installed the Storage Procedure for JTA(SQLServerJTA.zip - dll more scripts .isql) on the server, but do not resolved. I´m still receiving the message Error 503: Failed to load target servlet on the client browser, but now my SystemOut.log shows me the follow message:
[15/01/07 20:40:24:453 BRST] f5e7297 ApplicationMg A WSVR0200I: Iniciando o aplicativo wps_facade
[15/01/07 20:40:24:469 BRST] f5e7297 WebContainer A SRVE0169I: Carregando Módulo da Web: WebSphere Portal Server 5.0 Facade.
[15/01/07 20:40:24:500 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0 Facade] [/wsrp] [Servlet.LOG]: JSP 1.2 Processor: init
[15/01/07 20:40:24:531 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0 Facade] [/wsrp] [Servlet.LOG]: SimpleFileServlet: init
[15/01/07 20:40:24:547 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0 Facade] [/wsrp] [Servlet.LOG]: com_ibm_wps_AdminServlet: init
[15/01/07 20:40:24:609 BRST] f5e7297 ApplicationMg A WSVR0221I: Aplicativo iniciado: wps_facade
[15/01/07 20:40:24:609 BRST] f5e7297 ApplicationMg A WSVR0200I: Iniciando o aplicativo wps
[15/01/07 20:40:29:688 BRST] f5e7297 WSServerImpl W WSWS1015W: Servlet para servlet-link WSRPRegistrationService não localizado. O componente de porta WSRPRegistrationService será ignorado.
[15/01/07 20:40:33:422 BRST] f5e7297 WebContainer A SRVE0169I: Carregando Módulo da Web: WebSphere Portal Server 5.0.
[15/01/07 20:40:33:453 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: JSP 1.2 Processor: init
[15/01/07 20:40:33:469 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: SimpleFileServlet: init
[15/01/07 20:40:33:531 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: TranscodingUtilities: init
[15/01/07 20:40:33:703 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: portal: init
[15/01/07 20:40:34:000 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: Loading services...
[15/01/07 20:40:34:016 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: ... from file:/D:/IBM/PortalServer/shared/app/config/services.properties
[15/01/07 20:40:34:109 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: PmiService [com.ibm.wps.services.pmi.PmiServiceImpl] initializing...
[15/01/07 20:40:34:141 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: PmiService [com.ibm.wps.services.pmi.PmiServiceImpl] done.
[15/01/07 20:40:34:172 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: PlatformService [com.ibm.wps.services.platform.PlatformServiceImpl] initializing...
[15/01/07 20:40:34:172 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: PlatformService [com.ibm.wps.services.platform.PlatformServiceImpl] done.
[15/01/07 20:40:34:312 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: ConfigService [com.ibm.wps.services.config.ConfigServiceImpl] initializing...
[15/01/07 20:40:34:328 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: ConfigService [com.ibm.wps.services.config.ConfigServiceImpl] done.
[15/01/07 20:40:34:328 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: ProductService [com.ibm.wps.services.product.ProductServiceImpl] initializing...
[15/01/07 20:40:34:344 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: ProductService [com.ibm.wps.services.product.ProductServiceImpl] done.
[15/01/07 20:40:34:344 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: BundleService [com.ibm.wps.services.bundle.BundleServiceImpl] initializing...
[15/01/07 20:40:34:344 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: BundleService [com.ibm.wps.services.bundle.BundleServiceImpl] done.
[15/01/07 20:40:34:359 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: LocalizerService [com.ibm.wps.services.localizer.LocalizerServiceImpl] initializing...
[15/01/07 20:40:34:375 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: LocalizerService [com.ibm.wps.services.localizer.LocalizerServiceImpl] done.
[15/01/07 20:40:34:391 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: NamingService [com.ibm.wps.services.naming.NamingServiceImpl] initializing...
[15/01/07 20:40:34:406 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: NamingService [com.ibm.wps.services.naming.NamingServiceImpl] done.
[15/01/07 20:40:34:422 BRST] f5e7297 WebGroup I SRVE0180I: [WebSphere Portal Server 5.0] [/wps] [Servlet.LOG]: ServiceManager: DataStoreService [com.ibm.wps.services.datastore.DataStoreServiceImpl] initializing...
[15/01/07 20:40:35:266 BRST] f5e7297 FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/wps50DS, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a {0} from the DataSource.
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:244)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:171)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:193)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:592)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:529)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1226)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1032)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1712)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:674)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:456)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:215)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:190)
at com.ibm.wps.services.datastore.DataStoreServiceImpl.getConnectionInternal(DataStoreServiceImpl.java:342)
at com.ibm.wps.services.datastore.DataStoreServiceImpl.init(DataStoreServiceImpl.java:152)
at com.ibm.wps.services.Service.init(Service.java:108)
at com.ibm.wps.services.Service.init(Service.java:84)
at com.ibm.wps.services.ServiceManager.init(ServiceManager.java:277)
at com.ibm.wps.services.ServiceManager.init(ServiceManager.java:118)
at com.ibm.wps.engine.Servlet.init(Servlet.java:180)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletInstance.java:82)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147)
at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113)
at com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:189)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:876)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:224)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(WebAppServletManager.java:542)
at com.ibm.ws.webcontainer.webapp.WebApp.loadServletManager(WebApp.java:1272)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp.java:277)
at com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(WebGroup.java:412)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup.java:219)
at com.ibm.ws.webcontainer.WebContainer.addWebApplication(WebContainer.java:1026)
at com.ibm.ws.runtime.component.WebContainerImpl.install(WebContainerImpl.java:136)
at com.ibm.ws.runtime.component.WebContainerImpl.start(WebContainerImpl.java:356)
at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:415)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:808)
at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:351)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:578)
at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:268)
at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:246)
at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:543)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:418)
at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:134)
at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:543)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:418)
at com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:183)
at com.ibm.ws.runtime.WsServer.start(WsServer.java:128)
at com.ibm.ws.runtime.WsServer.main(WsServer.java:225)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:94)
---- Begin backtrace for nested exception
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Failed to initialize DTC. Check if DTC service is running.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
And my SystemErr.log shows me the follow message:
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Failed to initialize DTC. Check if DTC service is running.
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.base.BaseStatement.commonExecute(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.open(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbcx.base.BaseXAConnection.<init>(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.websphere.jdbcx.base.BaseXADataSource.getXAConnection(Unknown Source)
[15/01/07 20:40:44:984 BRST] f5e7297 SystemErr R at com.ibm.ejs.cm.pool.JTAConnectionFactory.createConnection(JTAConnectionFactory.java:40)
[15/01/07 20:40:45:000 BRST] f5e7297 SystemErr R at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:1280)
[15/01/07 20:40:45:000 BRST] f5e7297 SystemErr R at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:1176)
[15/01/07 20:40:45:000 BRST] f5e7297 SystemErr R at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:1102)
[15/01/07 20:40:45:000 BRST] f5e7297 SystemErr R at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:960)
[15/01/07 20:40:45:000 BRST] f5e7297 SystemErr R at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:893)
[15/01/07 20:40:45:000 BRST] f5
I checked for the service DTC on SQLServer and the service is running.
Can you tell me, how can I solve this problem ?
thanks a lot.
Kaga
it is present in the zip file of the JDBC driver and has a readme also, which clearly defines (in a cookbook style) as to what command requires execution on the server end for these procedures to be installed. These procedures are installed in master schema of SQL Server so that they are available to the client connecting to any other schema of SQL Server.
It has nothing to do specifically with the portal server, if you would take some other better JDBC driver for SQL Server (Type 4) then you would not need to install any component on the server.
Hope this helps,
Kapil.