CompuTools Teleplex Blog

Many of our customers use Microsoft SQL Server, and recently, we have been using Microsoft SQL Server 2005 Express at sites where the advanced features of the full product are not required.  The Express edition is great for IVR systems, small call centers, and for small web sites, but it also has some limitations including (1) it will never use more than 1GB of memory, and (2) the maximum database size is 4GB.  (The maximum database size was increased to 10GB in SQL Server Express 2008 R2.)

Generally speaking, these limitations have no effect on us because the main thing that we do is save call detail and agent activity data.  (The database isn’t used for processing millions of online orders, so we don’t need petabyte databases with hyper-performance.)  However, the question “What happens if the database fills up?” sometimes arises,  and the related question “How big is my database now?”

The answer to the first question is:

1. Teleplex will keep running, and will write the data to a text file (provided that the disk isn’t actually full), and
2. You will start getting supervisory Alerts, along with error messages like this: 

The portion shown in yellow is from SQL Server, and the “NativeError” is the actual SQL Server error code.

The answer to the second question can be found by one of the following methods:
 

1. In Microsoft SQL Server Management Studio (“SSMS”) right-click on the database in question to reveal its properties.  On the “General” property page you can see the “Size” and the “Space Available”.  The Size is the allocated size on disk, which is not necessarily how much space is actually in use inside the database.  Space Available indicates the amount of free space within the allocated space, not within the maximum space allowed.  Therefore, these numbers do not necessarily show whether you have hit the 4GB limit or not because the allocated size might show 4GB, but there might actually be unused space within that 4GB.  (Of course, you are probably reading this article because you are running out of space.)Furthermore, SSMS seems to display the sum of sizes of the “.MDF” (Master Data File) and “.LDF” (transaction log) files (which is confusing), so the magic number you are really looking for is a total Size of around 5GB.
    
2. Look directly at the size of “.MDF” file.  With a default installation, data files will be in “C:\Program Files\Micrsoft SQL Server\MSSQL.1\MSSQL\Data”.  If the “.MDF” file is around 4GB, you are probably near the limit.

Note that in the SSMS Database Properties “Files” page, you can also see under the “Autogrowth” column how the database is configured to grow.  The default settings allows a database to grow automatically to an unlimited size (although the Express server, as mentioned, has a maximum limit of 4GB).  You may want to confirm that someone didn’t actually limit the size.  (If so, you can change the configuration by clicking on the button in the Autogrowth column.)
 

When the database appears to be full, you should do the following:

• Check the obvious: Are you actually almost out of disk space?  If so, delete some unnecessary files.  You can probably quickly free up some disk space by deleting the contents of the Teleplex “Logs” subdirectory, deleting Internet Explorer temporary files, and by deleting files in any of your “temp” directories.
• If you still have plenty of disk space, check the database size as described above.  If you are nearing your configured limit, increase the limit.
• If, however, you have reached the 4GB limit of SQL Server Express, you have no choice but to delete some old data (or upgrade to the full version of SQL Server).  You easily delete old data from the “Manage Database” screen in Teleplex, and probably the best place to start is with the Call Log, which will get you back to a normal running state in short order.

Of course you should always do the following anway:

• Make regular backups.
• Monitor your disk space.
• Delete old data.
• If you are low on disk space, use SMSS to shrink the database (or use the DBCC SHRINKDATABASE command).  You might also want to consider moving the database to a larger drive or partition.

What do the error messages “Unable to accept call in the current state” and “Unable to answer call in the current state” mean?

There are three computers involved:  The PSTN-side switch (i.e., the telephone company), the CPU on the Dialogic ISDN board inside the Teleplex server, and the CPU running Teleplex.

A simplified typical inbound call flow is shown below.

The tricky part, and the source of the error occurs in the middle column.  Suppose, for example, that the caller hangs up sometime during steps (3) or (4).  (This really means, because everything is so fast, that the caller dialed the number and immediately hung up-even before the first ring.)  The board knows that the caller wants to disconnect, and may have even informed the Dialogic driver.  However, Teleplex is still waiting, in parallel, for the Accept function to return.  So when the Accept message arrives at the board from the application in Step (5), the board says “No silly!!  Unable to accept call in the current state”.  (Sorry.  How was I to know?)

On the Teleplex-side, the function to Accept the call returns an error code, and Teleplex displays an error message.

You can ignore these “error” messages, which are not really errors at all.

Finally, we changed Teleplex from Version 3.51.0.8 so it will display an informational rather than an error for this case.

Teleplex CallBrowser installation is straightforward, but can be tedious if you are installing it on a large number of machines in a call center.

To simplify this, you can pass a number of default settings to use in CallBrowser’s login profiles via Setup.exe’s command line.  Possible parameters are:

• SERVER=teleplex_server.  Sets the default Teleplex server name or IP address.
• EXTENSION=extension_number.  Sets the extension number to use.
• PROTOCOL=protocol_name.  Sets the RPC (Remote Procedure Call) protocol to use, This is typically “ncacn_ip_tcp”, indicating TCP/IP protocol.
• ENDPOINT=endpoint.  This is a protocol-specific parameter. For “ncacn_ip_tcp”, you typically set the endpoint to “7100”, which is a TCP/IP port.
• FTPPROFILENAME=profile_name.  Call Centers typically set up the ACDs and Dialer campaigns agents can login to in single data file, so the possibilities don’t need to be set on every machine.  This parameter sets the name of the file containing those profiles.
• FTPPROFILESERVER=ftp_server.  If you are loading login profiles from an FTP server this specifies
  the name or IP address of the FTP server.

The best way to use these command lines settings is to create a batch file in a shared directory, and run Setup.exe from the batch file.  The batch file might contain a line something like this (the line is split below for readability):

Setup SERVER=Teleplex1

EXTENSION=Site.%1

PROTOCOL=ncacn_ip_tcp

ENDPOINT=7100 FTPPROFILENAME=Profiles.dat

FTPPROFILESERVER=ftpserver

Notice the “%1”. This is a parameter to the batch file itself, and should be set to the extension number. If the batch file name is, for example, “go.bat”, you would install CallBrowser for the machine at extension “2703” with the following command:

        \\share\go 2703

You can then quickly finish the installation simply by pressing Enter several times.