• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PB2019 R2 and PostgreSQL: Error Table xx has no columns;

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

Resolved PB2019 R2 and PostgreSQL: Error Table xx has no columns;

  1. Issue
0
Votes
Undo
  1. Johann Lessmann
    Johann Lessmann
  2. PowerBuilder
  3. Tuesday, 18 August 2020 14:09 PM UTC
We switched to PowerBuilder PB2019 R2 Build 2353 and today was the first time I had to change a datawindow.... :-)
 
When I open a DW in the DW-Painter all is ok and I can see data in the "Preview"-Section...
 
But if I want to change the datasource I get the following error:
 
"Table "xx" has no columns; possible invalid table format. Please check to see if the active DB Profile is correct.  Do you want to continue in graphic mode?"
 
Any idea ?
 
Johann
 
 
How can i send a PDF file to whatsapp using powerb...
Window scrolling
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 18 August 2020 17:48 PM UTC
  2. PowerBuilder
  3. # 1

Hi Johann;

   This is typically caused by a table access restriction setting in the DBMS itself. Are you using the same User & system table settings in the new PB DB profile vs the previous version over your DBMS? If the settings are the same, then is the DBMS instance you are connecting to the same in 2019R2 vs previous PB version?

Regards ... Chris

Comment
There are no comments made yet.
Johann Lessmann
Johann Lessmann Accepted Answer Pending Moderation
  1. Thursday, 20 August 2020 08:30 AM UTC
  2. PowerBuilder
  3. # 2

Hi Chris,

the PB2019-Installation writes a new pbodb190.ini and there are some differences for the PostgreSQL db in it. I changed it back to the old settings and now it works again...

Thank you!

Johann

 

 

 

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 1 September 2020 19:22 PM UTC
Hi Johann .. thank you for the feedback - most appreciated!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 20 August 2020 15:03 PM UTC
  2. PowerBuilder
  3. # 3

Hi Johann;

  I never needed to change the INI file. I just make sure that my User ID has DBO authority and then specify the DBO name n the DB Profile's "System" tab page, as follows:

Comment
Johann Lessmann
  1. Johann Lessmann
  2. Tuesday, 25 August 2020 07:33 AM UTC
Hi Chris,

for our PostgresDB the "Extended Attributes" are "Disabled"....

But the new pbodb190.ini changed the property "PBTableOwner" from 'No' to "Yes"



  1. Helpful
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.