DB_CRA increasing size quickly - UCCX 7.0

Answered Question
Feb 8th, 2012
User Badges:

Hi All


I hope anyone can help me with this issue. After install a subscriber in telephony cluster (CUCM 7.1.3), db_cra increased it size quickly. I looked in logs for a clue but I have not  success. Before db size increased 2-4 MB per day, last day increase was 80 MB.

I will very grateful if you can help me with this issue.


Thanks

Correct Answer by Gajanan Pande about 5 years 5 months ago

Luis,


db_cra is the database used for storing historical call details. Obviously, if you add new CUCM subscriber node & the agent phones registered to that node starts making/receiving calls, it would add to existing db size. This is normal.


Pls let me know if I understood the query right.


GP.


Pls rate helpful posts !!

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
Gajanan Pande Thu, 02/09/2012 - 00:37
User Badges:
  • Cisco Employee,

Luis,


db_cra is the database used for storing historical call details. Obviously, if you add new CUCM subscriber node & the agent phones registered to that node starts making/receiving calls, it would add to existing db size. This is normal.


Pls let me know if I understood the query right.


GP.


Pls rate helpful posts !!

luis.romero@dcv.cl Fri, 02/10/2012 - 05:27
User Badges:

Thanks for your answer Gajanan, but I think you are wrong. In two days db, has increasing 8 %, in 7 days db will reach 2 GB that is maximum size. We installed subscriber but we did not add more agents. The only one change was register with first priority extensions in subscriber. We can wait for a increasing in db, but 100 MB per day is too much. Before, the increase was 2-4 MB per day. Calls volume per day are constant (250 calls per day aprox)


I hope somebody can help with this problem.


Rgds

Aaron Harrison Fri, 02/10/2012 - 05:45
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi Luis


What were you using to monitor the size of the DB?


Is it the database content size, the database file size, or the db transaction log that is increasing?


Aaron

luis.romero@dcv.cl Fri, 02/10/2012 - 05:53
User Badges:

Hi Aaron


I can see database size in PurgeProcess.log in C:\Program Files\wfavvid\log\Purge_Sch folder. Its show database size once per hour.


Actions

This Discussion

Related Content