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