1. Arcady Abramov
  2. PowerServer
  3. Wednesday, 3 May 2023 11:32 AM UTC

Hello, Team

When I convert my fully running desktop app to PowerServer I get an unclear error.

I am running in the local dev environment with SAP SQL Anywhere DB's, located locally and available.

At some point, for an unexplained reason (not happens in desktop version) I get this error on a transaction:

"Transaction is timeout. Transaction ID: B74ED707-51A6-4730-8C4D-E8DA4F25A9CB-4" 

The exception occur seemingly at random without any DB operation which is waiting for anything.

Could it be that power server has a problem with .post function?  

 

This is the extract from the power server log

There are no timestamps and not stack traces, so it is completely unclear which transaction fails, which times out and which (for what ever reason) is trying to use "SqlServer" as a database type

 

//------------------------------------------------------------------------------------------------

warn: PowerServer[0]

      The cache name was not found by the name of application, Application will connect database by PB transaction.applcation name: sales_channel_dev_cloud, transaction name:

fail: PowerServer.Api.ServerApiController[0]

      'PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api)' get result (

      {

        "IsSuccess": false,

        "RequestId": null,

        "AppName": "sales_channel_dev_cloud",

        "NameSpace": "Sales_channel_dev_cloud",

        "ErrorCode": 0,

        "ErrorMessage": "No data provider of database type `SqlServer' is found, you need to add a data provider before using the database"

      }).

fail: PowerServer.Api.ServerApiController[0]

      'PowerServer.Api.ServerApiController.SelectWithParmAsync (PowerServer.Api)' get result (

      {

        "IsSuccess": false,

        "RequestId": null,

        "AppName": "sales_channel_dev_cloud",

        "NameSpace": "Sales_channel_dev_cloud",

        "ErrorCode": 0,

        "ErrorMessage": "Transaction is timeout. Transaction ID: B74ED707-51A6-4730-8C4D-E8DA4F25A9CB-4"

      }).

//------------------------------------------------------------------------------------------------

 

Thank you

Arcady

Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Friday, 5 May 2023 03:44 AM UTC
  2. PowerServer
  3. # 1

Hi Arcady,

For the transaction timeout issue, you can refer to this KB:

https://www.appeon.com/developers/get-help/knowledgebase/transaction-timeout

Regards, Logan

Comment
There are no comments made yet.
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 3 May 2023 14:31 PM UTC
  2. PowerServer
  3. # 2

Hi Arcady,

Did you successfully configure the DB Cache mappings in the PS Project?

 

Regards,
Francisco

Comment
  1. Arcady Abramov
  2. Thursday, 4 May 2023 05:04 AM UTC
Hello, Francisco

How can I know if my configuration was successful or optimal?

Is there a way to test it?
  1. Helpful
  1. Francisco Martinez @Appeon
  2. Thursday, 4 May 2023 14:16 PM UTC
The "Test connection" button in the DB configuration page will test the connection parameters and verify that they work. I suggest you share with us the Advanced tab of the DB Configuration page.

Regards - Francisco
  1. Helpful
  1. Logan Liu @Appeon
  2. Friday, 5 May 2023 03:48 AM UTC
Hi Arcady,

Please notice the supported database connection options: https://docs.appeon.com/ps2022/Supported_database_connection_options.html

If some code in your application is using a transaction not configured in any cache, you can refer to this doc:

https://docs.appeon.com/ps2022/Making_database_connections_from_the_app_client.html

Regards, Logan

  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.