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
How can I know if my configuration was successful or optimal?
Is there a way to test it?
Regards - Francisco
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