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
},