cancel
Showing results for 
Search instead for 
Did you mean: 

DTR - Internal server error - no_transaction

former_member117942
Participant
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

ErvinSzolke
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Manera,

please doublecheck the Product Availabibilty Matrix whether the DB you are using is listed among the supported DBs.

http://service.sap.com/pam

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

former_member117942
Participant
0 Kudos

Hello Ervin,

my OS version is 2008 R2 and DB is ASE 15.7

I checked with PAM and other link you provide to me and i can say the combination is fully supported.

Thanks.

Regards.

ErvinSzolke
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

former_member117942
Participant
0 Kudos

Hi Ervin,

thanks for your help, the solution solved my problem!

The SAP note 1801864 is not yet released, probably the reason why i was not able to find it using the search tool.

Thanks again.

Regards.

ErvinSzolke
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

I am glad to hear that the problem is solved.

Indeed the note is in processing at the moment, but it says only the same what I did to apply the latest fixes for DTR.

Regards,

Ervin

ErvinSzolke
Product and Topic Expert
Product and Topic Expert
0 Kudos

update: I asked the note author to release the note. He is OOO now, so once he is back I assume he will release the note, but as mentioned there is no additional information in it, only that the latest fix solves the problem.

ErvinSzolke
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

I also received the information about DTR and Sybase which also fits to this topic:

1650822 -- Sybase platform is supported by DTR

Regards,

Ervin    

Answers (1)

Answers (1)

Former Member
0 Kudos

HI Ervin,

The same problem also occurred in my case, problem solved by appling the same DTR patch

Thanks

Youwang

ErvinSzolke
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hey Youwang,

I am glad to hear it! 😉

Best Regards and have a good development!

Ervin