cancel
Showing results for 
Search instead for 
Did you mean: 

DTR url not working after fresh system installation

Former Member
0 Kudos

Dear All,

We have installed SAP NW 7.4 Portal server.

we are not able to access the DTR using url http://<hostname>:50000/dtr.

Software components like DI_CMS, DI_CBS and DI_DTR are available on your server.


Please suggest if any actions to be performed to resolve the error.


We are configuring local SLD.


Regards,



Accepted Solutions (0)

Answers (1)

Answers (1)

divyanshu_srivastava3
Active Contributor
0 Kudos

Please share screenshot and logs.

divyanshu_srivastava3
Active Contributor
0 Kudos

To be precise, give default trace and application logs.

Former Member
0 Kudos

Hi,

Please find the below error in the default trace file.

#2.#2014 07 23 14:23:41:630#+0530#Error#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#

com.sap.ASJ.web.000137#BC-CTS-DTR-SRV#sap.com/tc~dtr~enterpriseapp#C0000A097086006600000002000060D4#8260651000000004#sap.com/tc~dtr~enterpriseapp#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#Guest#0##3C3F3D4D124511E49C030000007E0C2B#3c3f3d4d124511e49c030000007e0c2b#3c3f3d4d124511e49c030000007e0c2b#0#Thread[HTTP Worker [@2011805398],5,Dedicated_Application_Thread]#Plain##

Cannot process an HTTP request to servlet [DTRServlet] in [dtr] web application.

[EXCEPTION]

javax.servlet.ServletException: WebdavServlet.init() failed : com.tssap.dtr.pvc.basics.cluster.TaskFailedException: Connection is invalid.

        at com.tssap.dtr.server.servlet.WebdavServlet.init(WebdavServlet.java:460)

        at javax.servlet.GenericServlet.init(GenericServlet.java:270)

        at com.sap.engine.services.servlets_jsp.server.application.WebComponents.getServlet(WebComponents.java:864)

        at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:376)

        at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:210)

        at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:441)

        at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:430)

        at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:81)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:278)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)

        at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)

        at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.SessionSizeFilter.process(SessionSizeFilter.java:26)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:57)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:43)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:475)

        at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)

        at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)

        at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)

        at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)

        at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)

Caused by: com.tssap.dtr.pvc.basics.cluster.TaskFailedException: Connection is invalid.

        at com.tssap.dtr.pvc.basics.cluster.ClusterExclusiveTaskRunner.start(ClusterExclusiveTaskRunner.java:54)

        at com.tssap.dtr.server.deltav.impl.Repository.initialize(Repository.java:644)

        at com.tssap.dtr.server.deltav.impl.Repository.initialize(Repository.java:614)

        at com.tssap.dtr.server.servlet.WebdavServlet.initializeDeltaV(WebdavServlet.java:545)

        at com.tssap.dtr.server.servlet.WebdavServlet.init(WebdavServlet.java:451)

        ... 39 more

Caused by: com.tssap.dtr.pvc.util.sql.SQLRuntimeException: Connection is invalid.

        at com.tssap.dtr.pvc.util.sql.GenericStatementProvider.prepareStatement(GenericStatementProvider.java:76)

        at com.tssap.dtr.pvc.util.sql.GenericStatementProvider._getPreparedStatement(GenericStatementProvider.java:63)

        at com.tssap.dtr.pvc.util.sql.GenericStatementProvider.getPreparedStatement(GenericStatementProvider.java:45)

        at com.tssap.dtr.pvc.basics.persistence.PersistentClass.getPreparedStatement(PersistentClass.java:148)

        at com.tssap.dtr.pvc.repository.TaggedValuePersistentClass.loadTaggedValue(TaggedValuePersistentClass.java:113)

        at com.tssap.dtr.pvc.repository.TaggedValueTransientClass.loadTaggedValue(TaggedValueTransientClass.java:51)

        at com.tssap.dtr.pvc.repository.RepositoryManager._checkDbInitialization(RepositoryManager.java:288)

        at com.tssap.dtr.pvc.repository.RepositoryManager.isDbInitialized(RepositoryManager.java:1128)

        at com.tssap.dtr.server.deltav.impl.Repository.initializeDeltaV(Repository.java:559)

        at com.tssap.dtr.server.deltav.impl.Repository$1.run(Repository.java:646)

        at com.tssap.dtr.pvc.basics.cluster.ClusterExclusiveTaskRunner.startTask(ClusterExclusiveTaskRunner.java:65)

        at com.tssap.dtr.pvc.basics.cluster.ClusterExclusiveTaskRunner.start(ClusterExclusiveTaskRunner.java:51)

        ... 43 more

Caused by: com.sap.engine.services.dbpool.exceptions.BaseSQLException: Connection is invalid.

        at com.sap.engine.services.dbpool.cci.ConnectionHandle.checkIfInvalid(ConnectionHandle.java:652)

        at com.sap.engine.services.dbpool.cci.ConnectionHandle.checkIfValid(ConnectionHandle.java:639)

        at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:113)

        at com.tssap.dtr.pvc.basics.transaction.SharedConnection.prepareStatement(SharedConnection.java:131)

        at com.tssap.dtr.pvc.util.sql.GenericStatementProvider.prepareStatement(GenericStatementProvider.java:74)

        ... 54 more

#

#2.#2014 07 23 14:23:41:630#+0530#Error#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#

com.sap.ASJ.web.000137#BC-CTS-DTR-SRV#sap.com/tc~dtr~enterpriseapp#C0000A097086006600000004000060D4#8260651000000004#sap.com/tc~dtr~enterpriseapp#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#Guest#0##3C3F3D4D124511E49C030000007E0C2B#3c3f3d4d124511e49c030000007e0c2b#3c3f3d4d124511e49c030000007e0c2b#0#Thread[HTTP Worker [@2011805398],5,Dedicated_Application_Thread]#Plain##

Cannot process an HTTP request to servlet [DTRServlet] in [dtr] web application.

For more details on the problem please check traces searching by logId: C0000A097086006600000002000060D4#

#2.#2014 07 23 14:23:41:631#+0530#Error#com.sap.engine.services.servlets_jsp.ISE500#

com.sap.ASJ.web.000500#BC-CTS-DTR-SRV#sap.com/tc~dtr~enterpriseapp#C0000A097086006600000005000060D4#8260651000000004#sap.com/tc~dtr~enterpriseapp#com.sap.engine.services.servlets_jsp.ISE500#Guest#0##3C3F3D4D124511E49C030000007E0C2B#3c3f3d4d124511e49c030000007e0c2b#3c3f3d4d124511e49c030000007e0c2b#0#Thread[HTTP Worker [@2011805398],5,Dedicated_Application_Thread]#Plain##

500 Internal Server Error is returned for HTTP request [http://10.9.465.174:50000/dtr/]:

  component [DTRServlet],

  web module [dtr],

  application [sap.com/tc~dtr~enterpriseapp],

  DC name [sap.com/tc~dtr~enterpriseapp],

  CSN component[BC-CTS-DTR-SRV],

  problem categorization [com.sap.ASJ.web.000137],

  internal categorization [275707664].

[EXCEPTION]

javax.servlet.ServletException: WebdavServlet.init() failed : com.tssap.dtr.pvc.basics.cluster.TaskFailedException: Connection is invalid.

        at com.tssap.dtr.server.servlet.WebdavServlet.init(WebdavServlet.java:460)

        at javax.servlet.GenericServlet.init(GenericServlet.java:270)

        at com.sap.engine.services.servlets_jsp.server.application.WebComponents.getServlet(WebComponents.java:864)

        at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:376)

        at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:210)

        at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:441)

        at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:430)

        at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:81)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:278)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)

        at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)

        at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.SessionSizeFilter.process(SessionSizeFilter.java:26)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:57)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:43)

        at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

        at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

        at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:475)

        at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)

        at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)

        at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)

        at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)

        at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)

Caused by: com.tssap.dtr.pvc.basics.cluster.TaskFailedException: Connection is invalid.

        at com.tssap.dtr.pvc.basics.cluster.ClusterExclusiveTaskRunner.start(ClusterExclusiveTaskRunner.java:54)

        at com.tssap.dtr.server.deltav.impl.Repository.initialize(Repository.java:644)

        at com.tssap.dtr.server.deltav.impl.Repository.initialize(Repository.java:614)

        at com.tssap.dtr.server.servlet.WebdavServlet.initializeDeltaV(WebdavServlet.java:545)

        at com.tssap.dtr.server.servlet.WebdavServlet.init(WebdavServlet.java:451)

        ... 39 more

Caused by: com.tssap.dtr.pvc.util.sql.SQLRuntimeException: Connection is invalid.

        at com.tssap.dtr.pvc.util.sql.GenericStatementProvider.prepareStatement(GenericStatementProvider.java:76)

        at com.tssap.dtr.pvc.util.sql.GenericStatementProvider._getPreparedStatement(GenericStatementProvider.java:63)

        at com.tssap.dtr.pvc.util.sql.GenericStatementProvider.getPreparedStatement(GenericStatementProvider.java:45)

        at com.tssap.dtr.pvc.basics.persistence.PersistentClass.getPreparedStatement(PersistentClass.java:148)

        at com.tssap.dtr.pvc.repository.TaggedValuePersistentClass.loadTaggedValue(TaggedValuePersistentClass.java:113)

        at com.tssap.dtr.pvc.repository.TaggedValueTransientClass.loadTaggedValue(TaggedValueTransientClass.java:51)

        at com.tssap.dtr.pvc.repository.RepositoryManager._checkDbInitialization(RepositoryManager.java:288)

        at com.tssap.dtr.pvc.repository.RepositoryManager.isDbInitialized(RepositoryManager.java:1128)

        at com.tssap.dtr.server.deltav.impl.Repository.initializeDeltaV(Repository.java:559)

        at com.tssap.dtr.server.deltav.impl.Repository$1.run(Repository.java:646)

        at com.tssap.dtr.pvc.basics.cluster.ClusterExclusiveTaskRunner.startTask(ClusterExclusiveTaskRunner.java:65)

        at com.tssap.dtr.pvc.basics.cluster.ClusterExclusiveTaskRunner.start(ClusterExclusiveTaskRunner.java:51)

        ... 43 more

Caused by: com.sap.engine.services.dbpool.exceptions.BaseSQLException: Connection is invalid.

        at com.sap.engine.services.dbpool.cci.ConnectionHandle.checkIfInvalid(ConnectionHandle.java:652)

        at com.sap.engine.services.dbpool.cci.ConnectionHandle.checkIfValid(ConnectionHandle.java:639)

        at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:113)

        at com.tssap.dtr.pvc.basics.transaction.SharedConnection.prepareStatement(SharedConnection.java:131)

        at com.tssap.dtr.pvc.util.sql.GenericStatementProvider.prepareStatement(GenericStatementProvider.java:74)

        ... 54 more

divyanshu_srivastava3
Active Contributor
Former Member
0 Kudos

Hi Divyanshu,

Already checked the note did the configuration,still the issue persists.

AtulKumarJain
Active Contributor
0 Kudos

Hi ,

Please check below thread

http://scn.sap.com/thread/1765650

BR

Atul

divyanshu_srivastava3
Active Contributor
0 Kudos

Try with latest patch for DTR components.

Sriram2009
Active Contributor
0 Kudos

Hi

Could you refer the SAP Note 2038879 & 1541295


BR

SS

divyanshu_srivastava3
Active Contributor
0 Kudos

Did you made changes to Local and global as well in config tool ?

Make changes to local.