12-05-2006 11:37 AM - edited 07-03-2021 01:19 PM
We are receiving error that BBSM transaction history is full and we do not know how to clear. Can anyone help?
12-05-2006 01:26 PM
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;
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;
Hope this helps!
Rob
12-07-2006 11:12 AM
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
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
12-07-2006 10:26 PM
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
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: