1. David Vasconcelos
  2. PowerServer 2020 or older (Obsolete)
  3. Friday, 26 April 2019 22:10 PM UTC

Powerserver 2017, PowerBuilder 2017 R3, Sybase ASE 16.

Works fine in Client server, but when running in WEB, after the close of the query, AEM still shows transaction opened, eventually it times out and we get the transaction time error.  Any ideas why this could be happening.

(Note:  We do have other cursors that work fine in both Client Server and Powerserver)

 

//Sample
ls_sql =" SELECT COLA, COLB,COLC " + &
" FROM TABELA, TABLEB" + &
" WHERE ( TABLEA.COLA = " + string(id_case ) + " ) "
 
DECLARE case_part_cursor DYNAMIC CURSOR FOR SQLSA;
PREPARE SQLSA FROM :ls_SQL USING SQLCA;
OPEN DYNAMIC case_part_cursor;

ll_count = 1
If SQLCA.SQLCODE = GUO_CON.II_SQL_SUCCESS Then
 Do While SQLCA.SQLCODE = 0
     FETCH case_part_cursor INTO
         :il_COL1[ll_count],
               :is_COL2[ll_count],
             :is_COL3[ll_count];

        If SQLCA.SqlCode <> 0 Then EXIT
     ll_count++
    Loop
END If


CLOSE case_part_cursor;

 

 

Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Monday, 29 April 2019 02:35 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

HI David,

I did not reproduce the issue via executing the cursor with your sample code. I tested it against PB 2017 R3 & PowerServer 2017 build 1858 & ASE 15. The issue must be caused by that there is update operation that is not committed. Please try to create a simple PB case to execute the cursor only and see if there is still the issue.

Regards,
ZhaoKai

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.