on 08-30-2013 10:51 AM
Hi all,
i just installed an application server Java (7.30 SPS09 with Sybase ASE) and everything works fine except for the DTR.
When i try to connect to http://ipaddress:50000/dtr/ i receive a 500 internal server error (Error: Application error occurred during the request processing.)
This is the application_00.3.log content
------------------------------------------------------------------------------------------------
#2.0 #2013 08 30 11:41:18:542#+0200#Fatal#/Applications/DTR/Lifecycle#
com.sap.DI.dtr.090009#BC-CTS-DTR-SRV#sap.com/tc~dtr~enterpriseapp#C000C0A8014000A00000000D000013BC#9145650000000004#sap.com/tc~dtr~enterpriseapp#com.tssap.dtr.server.servlet.WebdavServlet#Guest#0##C23D7F34115711E3C1F40000008B8D32#c23d7f34115711e3c1f40000008b8d32#c23d7f34115711e3c1f40000008b8d32#0#Thread[HTTP Worker [@1751870372],5,Dedicated_Application_Thread]#Plain#com.tssap.dtr.server.deltav.resources.log_messages#
Initialisation of DTR application failed. Please refer to SAP note 774339 for more details on how to analyze the error condition.#
------------------------------------------------------------------------------------------------
And this is the defaultTrace_00.2.trc content
------------------------------------------------------------------------------------------------
#2.0 #2013 08 30 11:41:18:546#+0200#Error#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#
com.sap.ASJ.web.000137#BC-CTS-DTR-SRV#sap.com/tc~dtr~enterpriseapp#C000C0A8014000A000000010000013BC#9145650000000004#sap.com/tc~dtr~enterpriseapp#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#Guest#0##C23D7F34115711E3C1F40000008B8D32#c23d7f34115711e3c1f40000008b8d32#c23d7f34115711e3c1f40000008b8d32#0#Thread[HTTP Worker [@1751870372],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: C000C0A8014000A00000000E000013BC#
#2.0 #2013 08 30 11:41:18:547#+0200#Error#com.sap.engine.services.servlets_jsp.ISE500#
com.sap.ASJ.web.000500#BC-CTS-DTR-SRV#sap.com/tc~dtr~enterpriseapp#C000C0A8014000A000000011000013BC#9145650000000004#sap.com/tc~dtr~enterpriseapp#com.sap.engine.services.servlets_jsp.ISE500#Guest#0##C23D7F34115711E3C1F40000008B8D32#c23d7f34115711e3c1f40000008b8d32#c23d7f34115711e3c1f40000008b8d32#0#Thread[HTTP Worker [@1751870372],5,Dedicated_Application_Thread]#Plain##
500 Internal Server Error is returned for HTTP request [http://192.168.1.64: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 [-2094142884].
[EXCEPTION]
javax.servlet.ServletException: WebdavServlet.init() failed : com.tssap.dtr.pvc.basics.cluster.TaskFailedException: Commit of the transaction not possible because the status is: no_transaction
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: Commit of the transaction not possible because the status is: no_transaction
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.repository.InitializationException: Commit of the transaction not possible because the status is: no_transaction
at com.tssap.dtr.server.deltav.impl.Repository.createViews(Repository.java:1316)
at com.tssap.dtr.server.deltav.impl.Repository.initializeDeltaV(Repository.java:561)
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.tssap.dtr.pvc.basics.transaction.MarkedRollbackException: Commit of the transaction not possible because the status is: no_transaction
at com.tssap.dtr.pvc.basics.transaction.Transaction.handleCommitForMarkedRollback(Transaction.java:456)
at com.tssap.dtr.pvc.basics.transaction.Transaction.commit(Transaction.java:286)
at com.tssap.dtr.server.deltav.impl.Repository.createViews(Repository.java:1306)
... 47 more
Caused by: com.sap.sql.exception.OpenSQLException: OpenSql Sybase: Transaction not committed because an exception set @@transtate to 3
OpenSQLExceptionCategories: []
at com.sap.sql.exception.SQLExceptionFactory.createOpenSQLException(SQLExceptionFactory.java:167)
at com.sap.sql.exception.SQLExceptionFactory.wrapChainedSQLException(SQLExceptionFactory.java:72)
at com.sap.sql.jdbc.direct.DirectPooledConnection.processSQLExceptionJava6(DirectPooledConnection.java:1000)
at com.sap.sql.jdbc.direct.DirectPooledConnection.processSQLException(DirectPooledConnection.java:926)
at com.sap.sql.jdbc.direct.DirectConnection.commit(DirectConnection.java:436)
at com.sap.sql.jdbc.common.CommonConnectionImpl.commit(CommonConnectionImpl.java:442)
at com.sap.engine.services.dbpool.spi.LocalTXManagedConnectionImpl.clientCommit(LocalTXManagedConnectionImpl.java:504)
at com.sap.engine.services.dbpool.cci.ConnectionHandle.commit(ConnectionHandle.java:239)
at com.tssap.dtr.pvc.basics.transaction.SharedConnection.commit(SharedConnection.java:189)
at com.tssap.dtr.pvc.basics.transaction.Transaction.commit(Transaction.java:281)
... 48 more
Caused by: java.sql.SQLException: OpenSql Sybase: Transaction not committed because an exception set @@transtate to 3
at com.sap.sql.jdbc.syb.SybConnection.commit(SybConnection.java:51)
at com.sap.sql.jdbc.direct.DirectConnection.commit(DirectConnection.java:428)
... 53 more
------------------------------------------------------------------------------------------------
Searching for SAP note doesnt help me.
I found something interesting related to internal server error but nothing specific to "Commit of the transaction not possible because the status is: no_transaction" error.
Any idea?
Regards.
Hello Manera,
please doublecheck the Product Availabibilty Matrix whether the DB you are using is listed among the supported DBs.
Direct link to the "SAP NetWeaver 7.3 Planning Product Availability Matrix (Planning PAM) with all EHPs": https://websmp203.sap-ag.de/~sapidb/011000358700000207512010E
Best Regards,
Ervin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Maurizio,
I found an issue another customer faced and the solution was to apply the latest fix for the DTR.
That customer used the very same DB i.e. ASE 15.7 and face the very same problem you did (however he was on 731 SP5 we have a chance that the latest fix helps).
http://service.sap.com/patches
Browse our Download Catalog
SAP NetWeaver and complementary products
SAP NetWeaver
SAP NETWEAVER 7.3
Entry by Component
Development Infrastructure
DI DESIGN TIME REPOSITORY 7.30
# OS independent
DIDTR09P_1-10007968.SCA
Please let me know whether the fix improved on the behaviour.
Thank you and Best Regards,
Ervin
HI Ervin,
The same problem also occurred in my case, problem solved by appling the same DTR patch
Thanks
Youwang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.