INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Call sweet issues

Call sweet issues

(OP)
Hello all,
We have an Avaya phone system with Datel Call Sweet. We have had a persistent issue in which Call Sweet will simply stop tracking calls in the middle of the day. We have determined it is likely due to the 4GB limit per database on the SQL Server 2005 engine it is running on as I see the following errors all throughout the event viewer:

CODE -->

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. 

CODE -->

Could not allocate space for object 'dbo.ErrorLog'.'PK_ErrorLog' in database 'SWEET_LOGGING' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. 

Before you suggest that we migrate to a new SQL Server engine, I should say that we attempted to migrate to 2008R2 with a 10GB limit, but it did not appear to track any new calls so we rolled back. Also, we intend to migrate to a new phone system shortly anyway. Ideally within a few months we will not be using this system anymore.

Ideally what I need is this: some way to reduce the overall database size so that Call Sweet actually becomes usable. Is there a setting somewhere I can use to change the number of days worth of data that it retains? Thank you

RE: Call sweet issues

So to make a long story short: the problem is neither the Avaya nor the Datel Call Sweet, it is a MS SQL limitation.
This limitation has always been there so the decision to go the cheap way pays off now, but you can cleanup the database with a SQL query.
I advise to go to this this forum and get your answer there from the SQL guru's.

RE: Call sweet issues

(OP)
It is, but if I can just configure Call Sweet to not retain as much information, the MS SQL limitation would not be an issue.
If I could just tell Callsweet to retain one or two less days of data, that may solve our problem.

RE: Call sweet issues

I'm with intrigrant, I read that error code on a spice site and seems to be SQL indeed.

________________________________________

Add me to LinkedIN


=----(((((((((()----=
www.curlycord.com
Toronto, CAN

RE: Call sweet issues

Quote (Freight-Brain)

We have an Avaya phone system

which Avaya system?
saying Avaya without specifying system is like saying BMW without specifying Motorcycle, Car or Messerschmitt!


Do things on the cheap & it will cost you dear

RE: Call sweet issues

(OP)
Thank you but once again, I'm simply trying to find a way to tell the Call Sweet to not attempt to write and/or retain as much data to the database so that it does not fill up. This in of itself should not have anything to do with Avaya or the database engine.

RE: Call sweet issues

Contact the manufacturer.

________________________________________

Add me to LinkedIN


=----(((((((((()----=
www.curlycord.com
Toronto, CAN

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close