What database are you using? Are you using the same database with both Citrix servers? Perhaps the problem is the new Citrix servers network connection.

Hi Lawrence,

Can you provide us with more info?

- What version of DB are you using?

- What bitness are you using (32/64 bits) for your DB connection?

- How are you connecting to the DB (ie: ODBC, Native Driver, etc...)?

- Are some very specific reports that are having the problem? or is this happening with any DW?

Regards,

We are using Sybase 16, and both 2008 and 2016 Servers are pointing to same Sybase 16 database Service.

I did execute same Store PRocedure from 2016 server thru ISQL, but the result sets are coming really quick. I do understand in Datawindow we have sorting as well as grouping. But how it is working in 2008 and not in 2016 server.

Thanks.

- What version of DB are you using? Sybase 16

- What bitness are you using (32/64 bits) for your DB connection? we tried in both 32 bit and 64 bit.

- How are you connecting to the DB (ie: ODBC, Native Driver, etc...)? Native driver

- Are some very specific reports that are having the problem? or is this happening with any DW?

Happening all DW which are all having Storage setup as Rows to Disk.

Hi Lawrence;

  Have you tried adding this to your PB.ini ...

[DataStore Behavior]

UseHwnd=no

Regards ... Chris

Note: For production create your own PB.ini & deploy with your EXE's.

I tried with [DataStore Behavior] in PB.ini, it looks much better than earlier. But I am not sure whether the result has any change. I am going to test it today and compare the result set and let you all know.

Thanks so much for your help on this.

you mentioned that the problem only occurs on datawindows with Rows to Disk set on.

can you set that off to make sure that is actually the problem?  

If it is, either turn OFF rows to disk for your processing (do you really need that on? memory is cheap these days); or find out why the disk is so slow. 

If you must use the rows to disk then find out why your disk is so slow.  I assume that this is a completely new machine you are running it on?  So, could it be that the this is a virtual machine setup by your network admin with limited (slow) disk I/O?   Or put in a SSD drive and have the rows to disk save to that drive.  Also, maybe there is some security setting in windows or citrix server that makes writing to a temporary file slow?

Since the change that caused the problem was going to a newer version of Citrix, it is probably because the new server isn't configured correctly.

Rolland Smith,

Thanks for your response, I already asked Citrix team to take a look at the server/citrix configuration. Citrix team and Network admin were confirmed that everything looks correct on their end. I did remove Rows to disk option and eventhough it is slow. I am still trying with PowerBuilder 12.6 build, last week I tried with PowerBuilder 2019 but no luck.
Please let us know whether we have solution for this issue.

Thanks

Team,

I did run our application in both 2016 server as well as 2008 server. And monitored thru Wireshark and Procmonitor on both servers. In 2008 server, the ReadFile and WriteFile operations are going faster and finally it took 15 seconds to pull data to Front End screen. But in 2016 server also ReadFile and WriteFile operations are going faster upto some level  and getting stuck in some place for nearly 3 minutes. I donot have any clue why it is getting hung on that place. We verified Memory, and CPU utilization, everything looking good on 2016 server.

Do you guys come across these kind of scenarios?

Thanks.