cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
558
Views
0
Helpful
3
Replies

Clear BBSM Transaction History

jmrobfogel
Level 1
Level 1

We are receiving error that BBSM transaction history is full and we do not know how to clear. Can anyone help?

3 Replies 3

Rob Huffman
Hall of Fame
Hall of Fame

Hi Jacob,

Transaction History Reports

The Transaction History report shows the details of BBSM transactions. For auditing purposes, these transactions are never deleted from the BBSM database. If you want to export this data or truncate part of it, use standard SQL commands. For the database schema, refer to the Cisco BBSM 5.2 SDK Developer Guide.

From this good doc;

http://www.cisco.com/en/US/products/sw/netmgtsw/ps533/products_user_guide_chapter09186a0080192294.html#1039049

Cisco BBSM 5.2 SDK Developer Guide

http://www.cisco.com/en/US/products/sw/netmgtsw/ps533/products_user_guide_book09186a008019e125.html

Here is a great post from Stephen @ Cisco that outlines how to deal with this;

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Wireless%20-%20Mobility&topic=Security%20and%20Network%20Management&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.1dd96995/0#selected_message

Hope this helps!

Rob

stschmidt
Level 1
Level 1

Purge both the transaction history and debugging tables. This can be

done via SQL commands. MSDE has a 2GB limit per database. If you want to save this data in a test file, use the following:

Bcp "use atdial select * from transaction_history" queryout

-T -c

The above will export the table to a tab delimited text file. It will be

very large and notepad will not be able to open this file. You will need

to use excel, access or some other text editor that can handle large

files.

The next step is to purge the two tables. These will be the largest

tables especially if you have been using debug. Transaction_history is

written to constantly and needs to be purged on occasion.

From the command prompt

OSQL -d atdial -E

> delete transaction_history

> delete debugging

> go

Thank you for this . I just want to confirm if this will require a reboot of the system after done, or if there are any other issues I should consider before doing this. Will service be interrupted? Also, do I need to make a back up the logs if we do not need them? Any particular reason to do this? Finally, about how often should we do this as a regular maitenance procedure. Thanks so much

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: