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 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