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

Resolved PBCATxxx tables creation and errors when disabled

  1. Issue
0
Votes
Undo
  1. Hugo Moors
    Hugo Moors
  2. PowerBuilder
  3. Tuesday, 3 October 2023 13:14 PM UTC

(edit Use Extended Attributes OFF, see print screen)

Hello,

Our DBA doesn't want those tables in the databases and my applications don't use them.

So I have the option Use Extended Attributes OFF, Read Only ON

pb.ini in AppData\Local\Appeon\PowerBuilder 22.0 and C:\Program Files (x86)\Appeon\PowerBuilder 22.0

Both contain:

[Database]
NoCatalog=1
ReadOnly=1

I'm only using database interface MSOLEDBSQL SQL Server.

Now the problems:

When I click Test Connection on the Preview tab of the Database Profile the pbcat tables are created or when using a read-only login I get an error

(and then Connection successful tongue-out) 

When opening the datawindow Data Source, for each table in the select I get an error (the datawindows have no mention of the pbcat tables when I export the source code)

I have this behavior in both PB 2022: GA #1892 and 2022 R2: GA #2819 and on multiple machines. I use the normal PowerBuilder installer.

If it's something I'm doing wrong in the settings I'd like to know but I've sort of started to live with it, when opening a data source I click escape a few times to skip those errors and I only use Test Connection with a read only login. But still if it can be fixed that would be good cool

 

  1. Bug
  2. Database
  3. Database Painter
  4. Database Profile
  5. PowerBuilder
  6. PowerBuilder (Appeon)
  7. Database Provider
Datawindows (reports) to be used in C# VS2022 site
Rich Text component, and pbcrt.dll, TX v15, TX v28
Responses (3)
Hugo Moors
Hugo Moors Accepted Answer Pending Moderation
  1. Tuesday, 3 October 2023 15:22 PM UTC
  2. PowerBuilder
  3. # 1

I've created bug reports for this

I saw that in 2022 I had already created a bug for the Test Connection error that was reproduced and accepted but nothing seems to have been done with it.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 3 October 2023 14:29 PM UTC
  2. PowerBuilder
  3. # 2

Hi Miguel;

  You are correct .. the 1st person to log into a new DB using the PB IDE must have DBA Create authority in order for the creation of the PBCATxxxx tables to be successful. After that, PB Developers with normal DB accounts should be OK and should not get these messages.

Regards ... Chris

Comment
Hugo Moors
  1. Hugo Moors
  2. Tuesday, 3 October 2023 14:35 PM UTC
But I don't want them in the database, I don't need them and our DBA doesn't want them.

  1. Helpful
Hugo Moors
  1. Hugo Moors
  2. Tuesday, 3 October 2023 15:00 PM UTC
I meant to say "Use Extended Attributes OFF" (I edited my question)

I don't want those tables but PB keeps looking for them and even creating (or trying to) them when I click Test Connection (imho Test Connection should only be doing that, not trying to create stuff)
  1. Helpful 1
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 3 October 2023 13:24 PM UTC
  2. PowerBuilder
  3. # 3

I seem to remember to have read somewhere that this would only happen if you logon for the first time, but not sure.

Maybe someone else knows.

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 3 October 2023 13:38 PM UTC
there seem to be some problems with these tables. For example: https://community.appeon.com/index.php/qna/q-a/catalog-tables-could-not-be-created

Maybe you should report it as a bug if no one gives you a response here.
  1. Helpful 1
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.