test
- How-to
-
Kacie Chen @ appeon
- InfoMaker
- Tuesday, 8 June 2021 02:03 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: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
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.