1. Jon Tzeng
  2. PowerServer
  3. Friday, 1 March 2024 17:23 PM UTC

Hello,

We have PowerServer 2022 R3 application and Oracle 19 database and we get error when executing a simple statement. Here is what we find on the powerserver.log  Could you help to identify what the issue is?  Thanks

-----------------------------------------------------------------------------------------------

2024-02-29 14:25:35,488 ERROR PowerServer.Api.ServerApiController.? [?] - MESSAGE: DynamicOpenCursor(80000484-0000-ed00-b63f-84710c7967bb)(2024-02-29 08:25:35.4888526): get result (
{
"IsSuccess": false,
"AppName": "ABC",
"NameSpace": "ABC",
"Type": "DynamicOpenCursor",
"SessionId": "61C208C9-A3F3-4DAE-855E-A95A912948BA",
"TransactionId": "B4260CCB-E844-4E61-915B-239654774448-2",
"TransactionName": "sqlca",
"SqlStatement": "SELECT COUNT(*) INTO :li_count FROM \"AIM00\".\"T_TABL\" WHERE \"SCH00\".\"T_TABLE\".\"SAK_NO\" = 12345",
"Content": {
"ResultSets": []
},
"ErrorCode": -1,
"ErrorMessage": "TTCExecuteSql:ReceiveExecuteResponse - Unexpected Packet received."
}).

Jon Tzeng Accepted Answer Pending Moderation
  1. Monday, 4 March 2024 12:00 PM UTC
  2. PowerServer
  3. # 1

We find out this issue is happening when the select count(*) result is greater than 1. 

Comment
  1. Armeen Mazda @Appeon
  2. Monday, 4 March 2024 14:39 PM UTC
Thanks for sharing this info!
  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.