• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PB2017R3 and PB2019 with Oracle 12c issue and Crashes

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (5)

Resolved PB2017R3 and PB2019 with Oracle 12c issue and Crashes

  1. Issue
0
Votes
Undo
  1. Pierre DETE
    Pierre DETE
  2. PowerBuilder
  3. Friday, 28 February 2020 18:18 PM UTC

Hi All Pb users,

We start to change our old Oracle database 11gr2 32-bit by a new 12c 64-bit + 12c client 32-bit to work with Pb 2017R3 IDE which is 32-bit of course.

The data base is working fine and can be reach both with SQLPLUS and Oracle sql dev. 

PB IDE is getting the client 32-bit OCI.DLL version as we don't have error message on it.

But it crashes on first CONNECT pb instruction. Without error message.

In windows Application events I can see :

Faulting application name: PB170.EXE, version: 17.2.0.1880, time stamp: 0x5c4c4727
Faulting module name: KERNELBASE.dll, version: 10.0.18362.628, time stamp: 0x54734dee
Exception code: 0xc0000005

The Database Profiles painter Crashes too with all profiles : 090, 010 and ORA.

Same crashes with PB2019.

Any idea on what we have to check?

 

Thanks in advance.

 

Pierre

 

 

 

 

 

 

 

 

Migration from PB10 with PFC
HOW TO DISPLY SPECIAL CHARACHER SET
Responses (5)
Peter Thiem
Peter Thiem Accepted Answer Pending Moderation
  1. Friday, 3 December 2021 06:32 AM UTC
  2. PowerBuilder
  3. # 1

I had this problem today, with Powerbuilder 2021 (version 21.0.0.1288, or 12.0.0.01311), Citrix, Windows Server 2016, Oracle 19c and Oracle Instant Client 19.13.0.0.0. I had to downgrade to Oracle Instant Client 19.12.0.0.0 to avoid the problem.

Comment
There are no comments made yet.
Pierre DETE
Pierre DETE Accepted Answer Pending Moderation
  1. Monday, 2 March 2020 13:50 PM UTC
  2. PowerBuilder
  3. # 2

Hi,

Thank you for your help, this morning I installed build 1915 and Powerbuilder stopped to crash.
But I not very happy with my new dev environment.

Before I had PowerBuilder + Oracle 11gr2 32-bit that was all.

Now I have Powerbuilder + Oracle database 12c 64-bit + Orcale client 12c 32-bit and I have to set my Oracle path when I want to use the PB IDE or access to the database directly with sqlplus for example. It's very boring.

Plus, as we are now able to build a 64-bit version of our product, next year PB IDE 32-bit will be a major problem.

Is it plan to have a 64-bit Powerbuilder IDE ?

 

Best Regards,

 

Pierre

 

 

 

Comment
Michael Kramer
  1. Michael Kramer
  2. Tuesday, 3 March 2020 09:16 AM UTC
PB IDE is a 32-bit app. Hence, no requirement for 64-bit DB drivers for PB development.

Appeon is surveying feature requests from consumers these days. You may have received e-mail with link. In that survey you can indicate 64-bit development - and thereby you help Appeon focus effort where we the consumer see most value.
  1. Helpful
There are no comments made yet.
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Monday, 2 March 2020 06:07 AM UTC
  2. PowerBuilder
  3. # 3

Hi Pierre，

When we do the verification locally, we can use the DB Profile in both PB 2017 R3 and PB 2019 IDE to connect to Oracle 12c/18c successfully.

I want to add more suggestions besides using ORA Database Interface:

  1. Make sure the Oracle Client is 32-bit because PB IDE is 32-bit.
  2. Try to launch PB IDE via Run as administrator and see if it works.
  3. I suggest you use a clean machine to install PB IDE and Oracle Client 32-bit and see if the problem still exists.

 

Regards,

Ken

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 28 February 2020 21:37 PM UTC
  2. PowerBuilder
  3. # 4

Hi Pierre;

   FYI:  If you are using PB2017R3, then the build you should be on build 1915 for the latest MR (maintenance release) and thus latest Oracle DB support.

  Confirmed, you should use the  SQLCA.DBMS = "ORA" setting in your PB Apps for O12C/18C/19C


Regards ... Chris

Comment
There are no comments made yet.
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Friday, 28 February 2020 20:08 PM UTC
  2. PowerBuilder
  3. # 5

Hi Pierre,

For ORACLE 12c client you can only expect ORA driver to work.
O10 => Oracle 10 client, and
O90 => Oracle 9 client. See:

  • PowerBuilder Help
    • Connecting to Your Database
      • Working with Native Database Interfaces
        • Using Oracle
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.