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.