1. Rajkumar K S
  2. PowerBuilder
  3. Wednesday, 6 March 2024 11:19 AM UTC

Hi Team,

Good day!

We have a powerclient application successfully running in PB R2 version in all the clients. Recently we have migrated to PB R3 runtime : 2.2.0.3289  and few clients getting the error " "Not enogh memory to execute the program" Error code R0108. This issue is generated only after the R3 migration.

Adding few more findings.

We have one more powerclient application migrated  PB R2 to PB R3 in test environment and few machines got the same memory not enough error. For that confirmation, we have revert back to PB R2 build and it's working fine with the same code and same machine. So this is confirmed that something happened in PB R3 migration. For this critical issue we were not able to go for a production build. Could you please help in fixing this issue.  

Note:- Kindly treat this issue will be critical

I am attaching the screenshot for your reference.

Thank you

Rajkumar

Csquare info solutions ltd.

Attachments (3)
Accepted Answer
Rajkumar K S Accepted Answer Pending Moderation
  1. Tuesday, 2 April 2024 02:11 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Team,

Appeon team given the issue fixed dll and it's working now in PB R3.

 

Thank you

Rajkumar K S

Comment
  1. Armeen Mazda @Appeon
  2. Tuesday, 2 April 2024 17:47 PM UTC
Fantastic news, thanks for updating!
  1. Helpful
There are no comments made yet.
Rajkumar K S Accepted Answer Pending Moderation
  1. Friday, 15 March 2024 16:03 PM UTC
  2. PowerBuilder
  3. # 1

Hi Chris,

For your better understanding

For the DBMS you stated being Sybase 11 and the Client being used is ASE (ie: SQLCA.DBMS = "ASE")

this is the setting we have used to connect the DB. 

SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=*****;UID=DBA;PWD=<******>'". 

 

Note: This issue only getting after PB R3 migration and we have reverted back to PB R2 then it's working fine. 

 

Regards

Rajkumar K S

Comment
  1. Sivaprakash BKR
  2. Saturday, 16 March 2024 07:56 AM UTC
Rajkumar,

Is that a 32 bit appl or 64 bit? If 32 bit, can you try converting to 64 bit, as a temporary workaround?

What amount of RAM is there in machines where you found this issue? Is the other machine have more RAM?

Do you have a dddw and do filter on that ? Go through this thread https://community.appeon.com/index.php/qna/q-a/memory-leak-issues-datawindowchild



  1. Helpful
  1. Rajkumar K S
  2. Sunday, 17 March 2024 05:10 AM UTC
Hi Sivaprakash,

Thank you for raising this bug.. We also having the same dropdown child filter functionality. After the filter around 2 lak records in the dropdown child and it's working fine PB R2 32 bit application. Issue is only getting PB R3 migration..



Regards

Rajkumar
  1. Helpful
  1. Sivaprakash BKR
  2. Monday, 18 March 2024 05:36 AM UTC
Rajkumar,

I'vent raised any bugs with Appeon Support. I'm not sure whether the OP of that thread has raised a bug issue with the support. If none as done, you could initiate.
  1. Helpful
There are no comments made yet.
Rajkumar K S Accepted Answer Pending Moderation
  1. Friday, 15 March 2024 15:24 PM UTC
  2. PowerBuilder
  3. # 2

Hi Chris,

Thank you for your reply. Please find the details

  • Does this issue happen in the PB IDE development environment? No 
  • What O/S version & build are the Clients using? Windows 10 Pro, Version 22H, OS Build 19045.4046
  • What DBMS version & build are the Clients using? DBMS Version : Sybase 11
  • What DB Client is your App using to connect to the DBMS? Sybase ASE
  • How & where is the PB App EXE deployed to (ie: local PC, VM, Citriix, etc)? Powerclient and Local PC Exe
  • Do the clients use something like RDP to access your  PB App? No
  • Another other unique environmental considerations? No

 

Thanks and Regards

Rajkumar K S

Attachments (1)
Comment
  1. Chris Pollach @Appeon
  2. Friday, 15 March 2024 15:42 PM UTC
Hi Rajkumar ;

For the DBMS you stated being Sybase 11 and the Client being used is ASE (ie: SQLCA.DBMS = "ASE").

Note that for that old deprecated ASE v11 DBMS the "ASE" DB client is *not* recommended by Sybase / SAP for use with that version.

Instead, you would need to use the old SYC DB client (ie: SQLCA.DBMS = "SYC"). HTH

Regards .. Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 13 March 2024 15:17 PM UTC
  2. PowerBuilder
  3. # 3

Hi Rajkumar;

  Since you mentioned that "only a few clients" are getting this error .. I am wondering what is unique about their environment that differs from the many clients that are not getting this error?

  Also, can you tell us ...

  • Does this issue happen in the PB IDE development environment?
  • What O/S version & build are the Clients using?
  • What DBMS version & build are the Clients using?
  • What DB Client is your App using to connect to the DBMS?
  • How & where is the PB App EXE deployed to (ie: local PC, VM, Citriix, etc)?
  • Do the clients use something like RDP to access your  PB App?
  • Another other unique environmental considerations?

Many thanks in advance!

Regards ... Chris

Comment
There are no comments made yet.
Niyas Akayil Accepted Answer Pending Moderation
  1. Wednesday, 13 March 2024 10:51 AM UTC
  2. PowerBuilder
  3. # 4

hi team,

  after updating to Powerbuilder 2022 R3 i am also getting this error, Application termination error(R01018),Not enough Memory, can Anyone please comment on this issue, this is become more complicated 

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 6 March 2024 13:31 PM UTC
  2. PowerBuilder
  3. # 5

Appeon says this can be caused by a Fill with too large of a number. I imagine Space could have the same issue.

https://docs.appeon.com/pb2022r3/troubleshooting_guide/tr_066.html

What is the line of code mentioned in the error message?

Comment
  1. Rajkumar K S
  2. Tuesday, 12 March 2024 15:15 PM UTC
Hi Smith,



It retrieved below 2 lak records, but this same code is working in PB R2 with same machine. issue is only after PB R3 migration..



Regards

Raj.
  1. Helpful
  1. Roland Smith
  2. Wednesday, 13 March 2024 19:32 PM UTC
What is a lak?
  1. Helpful 1
  1. Miguel Leeuwe
  2. Sunday, 17 March 2024 10:28 AM UTC
it's a 100,000 according to google
  1. Helpful
There are no comments made yet.
Arnd Schmidt Accepted Answer Pending Moderation
  1. Wednesday, 6 March 2024 13:19 PM UTC
  2. PowerBuilder
  3. # 6

Hi Rajkumar,

what happens in the reported line of code (function)?!

regards

Arnd

 

Comment
  1. Rajkumar K S
  2. Wednesday, 6 March 2024 13:59 PM UTC
Hi Arnd,



Please find the below error lines

We have one dropdown child datawindow and after the retrieval, we are clearing the dropdown child.

DataWindowChild dwc_item_list

dw_2.GetChild("c_item_code", dwc_item_list)



dwc_item_list.setfilter("")

dwc_item_list.filter()



Note:- In the previous version PB R2 this code works fine without any issues.



Regards

Rajkumar
  1. Helpful
  1. Arnd Schmidt
  2. Wednesday, 6 March 2024 14:49 PM UTC
Eventually you really retrieved a lot of data and the memory is full.

Also I would check the returncode of GetChild().

Which one is line 40?













  1. Helpful 1
  1. Arnd Schmidt
  2. Saturday, 16 March 2024 14:47 PM UTC
  1. Helpful 1
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.