One of the biggest problem with BTS 4.5.1.v14 is db mismatch between EMS and CA. Most of time the sync command on EMS CLI does not solve this issue.
Here is the prosedure to solve this issue :
1- Log into Active EMS with btsadmin and run audit database type=full
This command will give output related with errored db.
Let's say the problem is related with EXT2SUBSCRIBER table.
...................
..........
...
Auditing table EXT2SUBSCRIBER on [CA146,FSPTC235]
.............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
DATABASE MISMATCH FOUND IN EXT2SUBSCRIBER WHERE CTXG_ID='MUTI-CTXGRP' and EXT='6002'
EMS DATABASE: SUB_ID=xxx_MERKEZ
CA146 SHARED MEMORY: SUB_ID=xxx-1073-1-23 ....................................................................................................
DATABASE MISMATCH FOUND IN EXT2SUBSCRIBER WHERE CTXG_ID='xxxx' and EXT='1057'
EMS DATABASE: SUB_ID=xxxx-1058
CA146 SHARED MEMORY: SUB_ID=xxxxx-BAH-3
DATABASE MISMATCH FOUND IN EXT2SUBSCRIBER WHERE CTXG_ID='xxxxx' and EXT='1058'
EMS DATABASE: SUB_ID=xxxx-1057
CA146 SHARED MEMORY: SUB_ID=xxxxxx-ALANDUZU
NO DATABASE ENTRY FOUND IN EXT2SUBSCRIBER WHERE CTXG_ID='xxxx-CTXGRP' and EXT='71003' ON CA146 ...............................
NO DATABASE ENTRY FOUND IN EXT2SUBSCRIBER WHERE CTXG_ID='xxxx-CTXGRP' and EXT='3401' ON CA146
THE ROW COUNT OF THE EMS DATABASE AND CA146 ARE NOT THE SAME EMS database has 1232 rows
CA146 shared memory has 1230 rows
2- Exit btsadmin CLI and login with root to Active EMS. Then run following command .
bts_audit -ems EMS1 -ca CA1 -platforms CA146,FSPTC235 -tables EXT2SUBSCRIBER
3- This will command will generate two files under /opt/ems/report/
cd /opt/ems/report/
ls -l | grep *.sql
Audit_CA146_root.sql
Audit_EM01_root.sql
4- Export Audit_CA146_root.sql to path /opt/OptiCall/CA146/bin on Active CA.
sftp root@CA01
cd /opt/OptiCall/CA146/bin
put *CA*.sql
exit
5- Login Active CA with root and run following command.
ssh root@CA01
cd /opt/OptiCall/CA146/bin
./dbm_sql.CA146 data catalog - dorep < Audit_CA146_root.sql
6- Login Active EMS with oracle user and run following command.
su - oracle
sqlplus opticall/opticall
*copy and paste the content of Audit_EM01_root.sql line by line
commit
quit
Then go to step 1 and verify there is no mismatch value on ext2subsciber table.
