1. Shawn Davis
  2. PowerServer
  3. Tuesday, 21 March 2023 22:25 PM UTC

I've been getting behavior where my app some time stops responding. When I look in the server Application event log I'm seeing these in pairs. Not sure if they are actually related to my issue but wondering if anyone can shed some like on how to debug them or what they mean.

Category: PowerServer
EventId: 0
SpanId: 3ca5b593f70a4ced
TraceId: 9d81a781ff406f01c50764e3e81c5ab8
ParentId: 0000000000000000
RequestId: 40000077-0000-f100-b63f-84710c7967bb
RequestPath: /api/ServerApi/CommitAndCreateTransaction
ActionId: 51038dd0-f961-4494-9f2d-ca0efba444a0
ActionName: PowerServer.Api.ServerApiController.CommitAndCreateTransaction (PowerServer.Api)

Failed to commit because there is no available database connection or transaction at   ..MoveNext()
--- End of stack trace from previous location ---
at   ..MoveNext()
--- End of stack trace from previous location ---
at   ..MoveNext()

 

Category: PowerServer.Api.ServerApiController
EventId: 0
SpanId: 3ca5b593f70a4ced
TraceId: 9d81a781ff406f01c50764e3e81c5ab8
ParentId: 0000000000000000
RequestId: 40000077-0000-f100-b63f-84710c7967bb
RequestPath: /api/ServerApi/CommitAndCreateTransaction
ActionId: 51038dd0-f961-4494-9f2d-ca0efba444a0
ActionName: PowerServer.Api.ServerApiController.CommitAndCreateTransaction (PowerServer.Api)

'PowerServer.Api.ServerApiController.CommitAndCreateTransaction (PowerServer.Api)' get result (
{
"IsSuccess": false,
"RequestId": null,
"AppName": "LongbowCMSv2",
"NameSpace": "LongbowCMSv2",
"ErrorCode": 0,
"ErrorMessage": "Failed to commit because there is no available database connection or transaction"
}).

 

Thanks!

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 21 March 2023 23:43 PM UTC
  2. PowerServer
  3. # 1

Hi Shawn;

  I have been dealing with a customer who has had the odd "similar" issue like yours. Engineering seems to think that it might be related to networking issues. However, the best route IMHO would be to open a Support Ticket for this issue to delve deeper into these errors.

   Out of interest sake ...

  1. What DBMS & version are you using?
  2. What O/S are you using?
  3. How is PS being deployed & running through?

Regards ... Chris 

Comment
  1. Logan Liu @Appeon
  2. Wednesday, 22 March 2023 03:48 AM UTC
Hi Shawn,

If the transaction has been timeout or not exists before "commit" in PowerScript, you may see this error.

There is a KB about "Transaction does not exist" for your reference: https://www.appeon.com/developers/get-help/knowledgebase/transaction-does-not-exist

You can debug the PowerServer project to see whether the SQLCA.SQLCODE is already -1 before "commit".

Please submit a support ticket as Chris suggested if still not solved.

Regards, Logan
  1. Helpful 2
  1. Shawn Davis
  2. Thursday, 6 April 2023 15:35 PM UTC
Support ticket costs money, right?
  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 6 April 2023 16:14 PM UTC
Hi Shawn ... no, it's free! ;-)

FYI: https://www.appeon.com/standardsupport

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.