Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

BTS10200- DB mismatch between EMS and CA

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.

Version history
Revision #:
1 of 1
Last update:
‎05-03-2010 05:15 AM
Updated by:
 
Labels (1)