Questions? Feedback?powered byOlark live chat software

Standard Support

Bug 1103

syntaxfromsql taking a long time in Oracle 12c compared to Oracle 11g 08 November, 2018

Regin Ravindran
10 May, 2018
Product: PowerBuilder Category: DataWindow
Version: 2017 Publishing: Public
Status: Scheduling Priority: P2
Classification: Sybase (legacy) bug Resolution:
Mark Lee 08 November, 2018
Hi Regin,

We are sorry to inform you that this bug is not fixed yet.
We suggest that you upgrade to PB 2017 R3 1858 and try it out.
This version is more stable than PB 2017 R2 and fixed many bugs and includes many new features.
https://www.appeon.com/support/documents/appeon_online_help/pb2017r3/whats_new/index.html
 
Of course, we will continue to follow up this issue and will update you when there is any progress.

Regards,
Mark Lee
Regin Ravindran 08 November, 2018
Can I get a status on this pls?
Has it been fixed and do we need to upgrade PB to resolve this?
Mark Lee 11 May, 2018
Hi Regin,

Thanks for reporting this problem! 
We will escalate this problem to our development team for further analysis. 
We will need some time to figure it out, and we will get back to you if any progress we would make.

 Based on our initial analysis, this might be related to the features added in Oracle 12c itself and we’d suggest to use O10 Oracle 10 or ODBC to connect to Oracle 12c database to work it around.

Regards,
Mark Lee
Govinda Lopez 10 May, 2018
Hi Regin,

I will transfer it to our Engineering team for further analysis. We will keep you posted of the results here.


Regards,
Regin Ravindran 10 May, 2018
Issue:
We are having an issue when a datawindow is being built dynamically in our production database which is on Oracle 12c. The select statement used to build the datawindow is a join of a view and 2 tables. 
The user is seeing some time lapse when trying to open the window(that is when the dynamic datawindow is built using syntaxfromsql). 
This application when run against a database that is on Oracle 11g creates the datawindow fast and displays it immediately. Pls let me know if there is any setting that can be changed in Oracle or PowerBuilder to make this faster.
Pls let me know if you need any additional information.
OS:
Windows Server 2008 R2 
Platform:
64-bit 
Database Type:
Oracle 
Database Version:
12c