1. Sim Joo Pee
  2. PowerServer
  3. Wednesday, 18 October 2023 04:20 AM UTC

HI Sir,

 

  I am using PB/PS2022 Build 1900. We encountered below error when our application is exec a stored procedure.

SQLCA.sqlcode: -1
 SQLCA.sqlDBcode: -2
 SQLCA.sqlErrText: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

 

It looks like a timeout issue to me, but i am not sure. Can anyone enlighten me?

My appplication json has below setting

   "Transaction": {
        "Timeout": 0,
        "TransactionException": true
      },
      "Session": {
        "Timeout": 86400
      },
      "Request": {
        "Timeout": 3600
      },
      "RunMode": 0
    }

 "Connections": {
    "Default": {
      "dtk": {
        "ConnectionType": "SqlServer",
        "Database": "dtk",
        "Host": "Pvv",
        "Port": 1433,
        "UserID": null,
        "Password": null,
        "EnablePooling": true,
        "MinPoolSize": 0,
        "MaxPoolSize": 100,
        "ConnectionLifetime": 0,
        "ConnectionTimeout": 15,
        "CommandTimeout": 30,
        "SecurityOptions": "encrypt=False",
        "OtherOptions": null,
        "DynamicConnection": true
      },

Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 18 October 2023 14:32 PM UTC
  2. PowerServer
  3. # 1

Hi Sim,

 

If the stored procedure is taking too long to complete you might want to consider increasing your Command Timeout value. Please see here: https://docs.appeon.com/ps2022/Configure_timeout_settings.html

 

Regards,
Francisco

Comment
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.