• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PB Hangs when open Data Source from Datawindow painter

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

Resolved PB Hangs when open Data Source from Datawindow painter

  1. How-to
0
Votes
Undo
  1. EMILIO GARCIA ANDRES
    EMILIO GARCIA ANDRES
  2. PowerBuilder
  3. Friday, 10 September 2021 11:35 AM UTC

Hi all.

I am working with PB2019R2.

I have a problem when I try to open the datasource from the datawindow painter. The hourglass stays indefinitely. This happens to me when I use a database connection using Oracle 10g or Oracle 9i. However if I use an ODBC connection that points to my Oracle DB, the datasource opens perfectly.

Has something similar happened to someone?

Thank you very much in advance.

Best regards.

-EGA-

Mailmerge with OLE
reset / start over in dropdowndatawindow (dddw)
Responses (5)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 13 September 2021 14:47 PM UTC
  2. PowerBuilder
  3. # 1

Hi Emilio,

If your database is a 12c database, you should not be using the 10g profile but the "ORA Oracle" profile:

See if that makes a difference.

regards

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Monday, 13 September 2021 14:51 PM UTC
Added to this: I don't think it's a good idea to connect as SYSDBA. You should be using a user with sufficient rights for what you are doing, but SYSDBA is limited for 'normal' stuff. Use the user of you main Schema and give him/her DBA rights if necessary.

  1. Helpful
There are no comments made yet.
EMILIO GARCIA ANDRES
EMILIO GARCIA ANDRES Accepted Answer Pending Moderation
  1. Monday, 13 September 2021 07:07 AM UTC
  2. PowerBuilder
  3. # 2

Hi Chris.

1. The version is: 

select * from v$version where banner like 'Oracle%' --> Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

2. The settings is:

 

Thank you.

Regards.

-EGA-

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 13 September 2021 15:47 PM UTC
Ahhh ... that is your problem - you seem to be using the Oracle 10G driver. This will *not* work with O12C and higher. You *must* use the Oracle (ORA) driver in both your App's and DB Profile(s).
  1. Helpful
There are no comments made yet.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Friday, 10 September 2021 14:49 PM UTC
  2. PowerBuilder
  3. # 3

Hi

This is a known problem with Oracle and the DW data painter and existed in PB10 upwards to my knowledge. It will come back eventually and if you look you will see quiries being processed in the Oracle database. The performance of the queries is very slow due to some issues witht he Oracle optimiser.

Sorry there is not a lot you can do but wait, on our system this can be upto a minute, much longer than my patience!

 

Cheers

David

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 10 September 2021 13:57 PM UTC
  2. PowerBuilder
  3. # 4

When a database connection 'hangs' it 99.99% of the time means it can't find the server - you have something not configured correctly in your database connection. 

are you using TNS names? are you using Instant client?

 

if you wait it out, it should provide an error?

since you didn't mention an error, how are you getting out of waiting? Are you killing the process?

Comment
EMILIO GARCIA ANDRES
  1. EMILIO GARCIA ANDRES
  2. Monday, 13 September 2021 07:11 AM UTC
Hi Mike.



I'm using TNS Names. It does not provide any error. I have to kill the prrocess.



Thanks.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 10 September 2021 13:44 PM UTC
  2. PowerBuilder
  3. # 5

Hi Emilio;

  Can you tell us ...

  1. What version & build of the Oracle DB Server are you using?
  2. What settings are you using in the 10G or 9i DB profiles?

Regards ... Chris

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.