search cancel

"SQL parse error: Column ebr_serial_num not found in table Call_Req (subquery 1.0 SELECTION) at . ebr_serial_num" And SDM starts working slowly


Article ID: 127982


Updated On:


CA Service Management - Service Desk Manager ServiceDesk CA Service Desk Manager


Service Desk Manager works slowly and experience performance issues. The following  appears in the logs:

bpvirtdb_srvr  11332 ERROR        sqltrans.c            2156 Column ebr_serial_num not found in table Call_Req (subquery 1.0 SELECTION)
bpvirtdb_srvr  11332 ERROR        vdbsql.c              4619 SQL parse error: Column ebr_serial_num not found in table Call_Req (subquery 1.0 SELECTION) at . ebr_serial_num
bpvirtdb_srvr  11332 SIGNIFICANT  vdbsql.c              4620 SELECT Call_Req.open_date,,min(Attached_SLA.time_to_violation) AS mintime,min(target_time.target_time) AS mintgt,Call_Req.ref_num,Call_Req.last_mod_dt,Call_Req.summary,Call_Req.zsua,Call_Req.ebr_serial_num FROM Call_Req WHERE Call_Req.type = 'R' AND Call_Req.ref_num = '5975019'  OUTER_JOIN Call_Req.persid = Attached_SLA._mapped_cr ; Call_Req.persid = target


Service Desk Manager (SDM) 17.2 and 17.3


Defect with 14.1

This issue was addressed via T52Y539 (USRD2793) in SDM 14.1.02.
For SDM 17.3, the issue was addressed in the RU9 patch update.


Please note the above RU updates that will address the issue.  17.2 RU2 and higher, as well as 17.3 RU9 and higher.
If you are experiencing this behavior please open a case in support informing you about this article, and attaching to the case the following information to assist in our investigation:

Enable the following trace/processes in your environment:
pdm_trace bpvirtdb_srvr on
pdm_trace bpvirtdb_srvr size 100000
pdm_trace bpvirtdb_srvr watch sqltrans.c 2156
pdm_trace bpvirtdb_srvr attach domsrvr
pdm_trace domsrvr size 100000

Traces should be written automatically due to the watch setting.
Monitor the environment for at least one day. As soon as the slow-process starts please write down the time so that we can be more assertive in our analysis of traces.

To turn off trace, including attached processes, run:
pdm_trace bpvirtdb_srvr off

Collect pdm_trace for domsrvr and bpvirtdb_srvr and stdlog files and attach to the case open in the stand.