• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Parse Error in Oracle - PowerBuilder Catalog Table related

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

Resolved Parse Error in Oracle - PowerBuilder Catalog Table related

  1. Issue
0
Votes
Undo
  1. Dennis Huynh
    Dennis Huynh
  2. PowerBuilder
  3. Friday, 18 October 2019 21:43 PM UTC

Hi,

Please help ... DBA informed the following error.  We just recently upgraded Oracle to 12c.  The owner for PowerBuilder Catalog tables was not SYSTEM and some how the SQL was generated with SYSTEM.

WARNING: too many parse errors, count=100 SQL hash=0x384a3478

PARSE ERROR: ospid=6063, error=942 for statement:

SELECT PBD_FHGT,PBD_FWGT,PBD_FITL,PBD_FUNL,PBD_FCHR,PBD_FPTC,PBD_FFCE,PBH_FHGT,PBH_FWGT,PBH_FITL,PBH_FUNL,PBH_FCHR,PBH_FPTC,PBH_FFCE,PBL_FHGT,PBL_FWGT,PBL_FITL,PBL_FUNL,PBL_FCHR,PBL_FPTC,PBL_FFCE,PBT_CMNT  FROM SYSTEM.PBCATTBL   WHERE PBT_OWNR = :1 AND PBT_TNAM = :2

Warm regards and Thanks,

Dennis

 

Re: For MailMerge feature
qr printing
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 7 December 2021 19:31 PM UTC
  2. PowerBuilder
  3. # 1

Hi Dennis;

   If you created the PBCATxxx tables via an SQL script - this could be your problem. Normally you would let the PB IDE create these tables by allowing your DBA (with their account) run the IDE and then open the DB Painter on a new DB. This only needs to be done once, then all other developers can login to the DB OK and use the PBCATxxx tables. The PB IDE should have properly created the PBCATxxx tables as per the latest PB release.

Regards ... Chris

Comment
There are no comments made yet.
Dennis Huynh
Dennis Huynh Accepted Answer Pending Moderation
  1. Tuesday, 22 October 2019 16:45 PM UTC
  2. PowerBuilder
  3. # 2

Michael - Thanks for your input on how to turn off the Extended Attributes feature.  I might have to go to that route if the new build does not solve the problem.

Warm Regards,

Dennis

Comment
There are no comments made yet.
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Saturday, 19 October 2019 00:10 AM UTC
  2. PowerBuilder
  3. # 3

Try to change your Database Profile settings in PowerBuilder IDE.

If you use the O10 driver in PowerBuilder =>

  • Tab page = System
  • Field = PowerBuilder Catalog Table Owner
  • Enter value =

Alternative to disable use of PBCATXXX tables completely =>

  • Painter = Database
  • Database Preferences (Menu > Design > Options...)
  • Tab page = General
  • Group = Painter Options
  • Uncheck [-] Use Extended Attributes

HTH /MIchael

 

Comment
SAMIR DRIF
  1. SAMIR DRIF
  2. Tuesday, 7 December 2021 18:44 PM UTC
Hi Michael



I drop the five tables of PBCATxxx from my database but i have the same message of Dennis

WARNING: too many parse errors, count=100 SQL hash=0x384a3478



PARSE ERROR: ospid=6063, error=942 for statement:



SELECT PBD_FHGT,PBD_FWGT,PBD_FITL,PBD_FUNL,PBD_FCHR,PBD_FPTC,PBD_FFCE,PBH_FHGT,PBH_FWGT,PBH_FITL,PBH_FUNL,PBH_FCHR,PBH_FPTC,PBH_FFCE,PBL_FHGT,PBL_FWGT,PBL_FITL,PBL_FUNL,PBL_FCHR,PBL_FPTC,PBL_FFCE,PBT_CMNT FROM SYSTEM.PBCATTBL WHERE PBT_OWNR = :1 AND PBT_TNAM = :2



How i can disable these logs error



Best regards



  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.