1. James Wong
  2. PowerBuilder
  3. Friday, 4 June 2021 00:57 AM UTC

Hi

In our experience, we never deployed pb system tables such as dbo.pbcattbl with our application developed by PB before.

But our customer found some DB error messages through MS SQL Profiler:

SQL:BatchStarting 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 dbo.pbcattbl where pbt_tnam = 'csm_card' and pbt_ownr = 'dbo'        
SQL:StmtStarting 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 dbo.pbcattbl where pbt_tnam = 'csm_card' and pbt_ownr = 'dbo' 652 1 0 0
Exception Invalid object name 'dbo.pbcattbl'. 1 16
User Error Message Invalid object name 'dbo.pbcattbl'. 1 16    

Here are my questions:

1. Those select command triggered by PB DLLs?

2. Any impact for our application without those pb system tables? As we never use them in our application logic.

Thx!

 

James

mike S Accepted Answer Pending Moderation
  1. Friday, 4 June 2021 03:47 AM UTC
  2. PowerBuilder
  3. # 1

any chance your customer creates custom reports via infomaker?

do you do any creates of datawindow using SyntaxFromSQL ?

Comment
  1. Chris Pollach @Appeon
  2. Friday, 4 June 2021 15:34 PM UTC
Hi James;

Mike has two good questions, as these are the only two things that require the PBCATxxx tables to be copied from DEV into PROD environments. Otherwise, the information in the PBCATxxx tables has already been compiled into the DW Objects - and thus, not used in the App;s EXE(s).

Regards ... Chris
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.