CSV Troubleshooting and Technical Information

Last reviewed: 08/19/2008
Article ID: R11176

The information in this article applies to:

Summary

This article contains extensive troubleshooting and technical information for STI Server and the Tabs3 and PracticeMaster CSV software.

Windows and nOVELL

Because separate versions of STI Server are available for Windows and Novell platforms, the following icons will be used where appropriate:

 

Indicates the information only applies to Windows.

 

Indicates the information only applies to Novell.


Please select your server's operating system. This will dynamically filter the troubleshooting information throughout this article. Selecting Both will display troubleshooting information for both Windows and Novell platforms.

                 

Contents

Error Messages

"The server 'STI_SERVER@[computer name]' can't be found."

The Tabs3/PracticeMaster CSV software requires direct communication with STI Server in order to function. The following steps may be used to determine the source of the problem.

"The server connection limit has been exceeded."

STI Server is available in levels of 8, 16, 32, 64, 128, 256, 512, or 1024 connections. The term "connection" refers to the communication or link to the STI Server that is established for each application a user is running. For example, suppose a firm has 8 users. All 8 users have PracticeMaster running at the same time (i.e., 8 connections), 4 of the same users also have Tabs3 running (i.e., 4 more connections), and 1 of the users also has APS and TAS running (i.e., 2 more connections). This results in 14 combined Tabs3 and PracticeMaster client server version software applications (i.e., connections) running at the same time on the network.

Note: STI Server requires four connections for overhead purposes. These connections are reserved by STI Server and cannot be used by other users. For additional information, see Overhead Connections in Chapter 1 of the STI Server manual.

When the maximum number of connections has been reached, the above message will be displayed. You will be prevented from starting the Tabs3/PracticeMaster software until additional connections are made available. This can be accomplished in several ways:

"The STI Server Service service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

This is a Windows message that is displayed if a service is unable to start. In the case of STI Server Service, this message occurs if STI Server is already running. Because STI Server can be run as either a normal Windows application (i.e., by double-clicking CTSRVR.EXE) or as a Windows service, it is possible to have STI Server already running as a Windows application before attempting to manually start the STI Server Service. [Note: The Windows application mode of STI Server is also known as the Desktop Interactive Program (Fig. 2).]

If STI Server is already running as a Windows application, it is not necessary to start the STI Server Service. Likewise, if the STI Server Service is already running, it is not necessary to run STI Server as a Windows application. To avoid this message and start the STI Server Service, you must shut down the Windows application mode of STI Server before starting the STI Server Service. (Note: STI Server functions identically regardless of whether it is run as a Windows application or as a Windows service.)

"The system cannot find the path specified."

This is a Windows message that is displayed if the system cannot locate the CTSRVR.EXE executable file required to start the STI Server Service. This usually occurs if the service was installed from a mapped drive instead of the actual directory in which STI Server is installed. The following procedure may be used to determine the executable path defined by the STI Server Service.

  • To determine the executable path of the STI Server Service
    1. From the Windows Control Panel, select Administrative Tools
    2. Double-click Services.
    3. Right-click the STI Server Service from the list of services, and select Properties.
    4. In the STI Server Service Properties window, select the General tab.
    5. The Path to executable field (Fig. 4) will list the executable path of the STI Server Service.

Fig. 4, STI Server Service Properties window

The executable path defined by the STI Server Service must match the actual path of your Tabs3/PracticeMaster program directory, and cannot include a mapped drive. For example, if your Tabs3/PracticeMaster program directory is "C:\STI" and "K:\" is mapped to "C:\STI"; then the executable path must be "C:\STI\CTSRVR.EXE", not "K:\CTSRVR.EXE".

To resolve this error, you must use the CTNTINST.EXE command-line program to first uninstall, then reinstall the STI Server Service from the correct directory location. Information on how to use the CTNTINST.EXE command-line program is available in the STI Server manual.

"The Database Server may not have been shutdown properly the last time it was used. An improper shutdown can lead to FCRP_ERRs on file opens for non-transaction files (unless the COMPATIBILITY WTHRU_UPDFLG option and WRITETHRU filemode are used). To properly shutdown the Database Server, select the 'Shutdown' option from the server's Control menu."

This is a Windows message that is displayed when starting STI Server. This message is displayed if STI Server was not shut down properly (i.e., due to power loss, hardware failure, etc.). Although only displayed when starting STI Server as a Windows application, it does not matter how STI Server was being run at the time it was shut down improperly (i.e., as a Windows application or as a Windows service). [Note: The Windows application mode of STI Server is also known as the Desktop Interactive Program (Fig. 2).]

If you are able to start STI Server, then this error will be resolved. However, it is important to determine why STI Server was not shut down properly so that it does not become a recurring problem.

"Warning: STSRVR.CFG not found."

This file is required by the Tabs3/PracticeMaster software to communicate with STI Server. If this file is missing, it can be created by reinstalling the STI Server software.

"The STI Server must be at least version 8.27.159"
"The STI Server must be at least version 8.27.143"
"The STI Server must be at least version 8.27.124"

Version 14.3 Tabs3 and PracticeMaster Client Server Version software cannot be used with STI Server version 6. The most recent versions of Tabs3 and PracticeMaster Client Server Version software (with a release date of 04/10/2008 or greater) require STI Server version 8.27.159. The methods listed here may be used to determine what version of STI Server you are currently using. If you receive this message, you must install the most recent STI Server CD that was shipped to you.

 
"The Port number for the Tabs3 Accelerator is invalid.  Match the IP Address or Hostname specified for the STI Director Service."
"The IP Address or Hostname for the PracticeMaster Accelerator does not match the IP Address or Hostname specified for the STI Director Service."

The computer address of the STI Director Service, which is configured using the STDirector Control Panel applet, does not match the computer address of the specified Accelerator. If the Accelerator and the STI Director Service are both being run from the same server, these addresses should match. Verify that the IP Address or Hostname for the specified Accelerator is correct, and click OK to continue. If this is incorrect, click Cancel and correct the address for the Accelerator.

 
The General Ledger software contains an invalid GLS Data Path for one or more GLS Clients. As a result, the software is running without Client/Server functionality. Once the GLS Data Path has been manually fixed, you will need to run the CSCONV14.EXE program to convert the data. Detailed information regarding how to resolve the invalid GLS Data Paths can be found in Knowledge Base Article R11176 at www.support.Tabs3.com.
CSV Version 14.3 software requires that the GLS Data Path for all defined GLS clients be relative paths AND be located in a folder under the current working directory. This is required in order for HotBackup to back up data for all GLS clients. Start GLS and run a Data File Integrity Check. There will be one or more Error 25's or Error 28's reported, thus indicating which GLS client has an invalid path. You must address these invalid paths by editing the GLS Data Path, which may require moving the GLS client data. KB Article R11191, How to Move GLS Clients, includes step-by-step procedures regarding how to move GLS client data. Alternatively, if the GLS Client is no longer used, the GLS client can be deleted; however, you will want to make sure that this is the desired course of action. Invalid GLS Data Paths must be addressed before you will be able to use the Client Server version of the software. Once you have addressed the invalid path, rerun the CSCONV14.EXE program from the server (located in the Tabs3 program directory).
 
Note: As an alternative, if the CSCONV14.EXE program was previously run, you can determine which GLS client(s) have invalid GLS Data Paths by viewing the contents of the CSCONV14.LOG file instead of running a Data File Integrity Check.
"Unable to copy director file to windows directory" message appears at the end of an update.
This message indicates that during the install either the STI Director Service has restarted or STDirect.exe is being held open. To resolve the issue, the user needs to manually shut down the STI Director Service in the Control Panel, and then confirm that STDirect.exe is not running in the Task Manager via the Processes tab. Once this has been done, copy the STDirect.exe file found in the program directory into the Windows directory, and choose Yes to overwrite the file when prompted. You can then restart the STI Director Service in the Control Panel, and begin working in the software again.
Unable to lock the Task File
This message indicates that the STI Director Service is unable to lock the Task File.

Cause:  This error occurs if the Client Server Data Directory path is incorrect or the STI Director Service has insufficient rights to the Client Server Data Directory.

Solution:  The following is a list of ways to troubleshoot:

  • Incorrect Client Server Data Directory: Make sure the Client Server Data Directory is valid from the server's point of view. If it is a new install, use the following steps to copy and run HBQ. If it is an existing dataset that has already been working, then use the following steps to edit the DataDirectory registry key.
  • New Installs - Copy and Run HBQ

    1. On the server where the STI software is installed, insert the STI Server CD.
    2. Close out of the installation window if it automatically runs.
    3. Open My Computer.
    4. Right-click the CD drive and select Explore.
    5. Double-click the Server folder.
    6. Right-click HBQ.EXE and select Copy.
    7. Paste HBQ.EXE into the program directory.
    8. Double-click HBQ.EXE in the program directory to run the program.
    9. Type "Y" and press Enter to run HBQ.EXE, as shown below.

    Existing Installs - Edit DataDirectory Registry Key

    1. On the server where the STI software is installed.
      1. Click start, and then select Run.
      2. Type REGEDIT into the field.
      3. Click OK.
    2. Verify that the Data ID in the Registry matches the Data ID in System Configuration.
      1. Open System Configuration.
      2. Select Utilities | Change Data ID from the System Configuration menu bar.
      3. Write down the Data ID found here.
      4. Back in the registry editor, expand HKEY_LOCAL_MACHINE.
      5. Expand Software.
      6. Expand STI.
      7. Expand HotBackupV14.
      8. Select the key that matches the Data ID written down in step c.
    3. Verify that the DataDirectory String has the correct value. If it does not, edit the value to have the correct Client Server Data Directory path. Also verify that your ExeDirectory String has the correct value. These path's both need to be valid from the server's point of view.
    4. CAUTION: Editing the Windows registry is typically not recommended because of potential problems that can occur when not done properly. Tabs3 and PracticeMaster is not responsible for edits made to the registry. Any registry changes should be made by your network administrator or a qualified professional. (Tabs3 Support personnel do not have the necessary training to help you with Windows registry changes.)

      WARNING: The following disclaimer is used by Microsoft regarding editing of the registry: "Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk."

      IMPORTANT: Microsoft recommends making a back up copy of the registry files before editing the registry. Refer to Microsoft documentation for details on how to back up the registry.


  • Insufficient Rights: Make sure the STI Director Service is logging on with an account that has sufficient rights to the Client Server Data Directory. We have had instances where the Local System Account permissions have been limited, which prevents the STI Director Service from locking the task file.
  • To view the log on account the STI Director Service is using, use the following steps:

    1. From the Windows Control Panel, select Administrative Tools.
    2. Double-click Services.
    3. Right-click the STI Director Service from the list of services and select Properties.
    4. Select the Log On tab. Here it will indicate what log on account the STI Director Service is using.

    Note: The STI Director Service and the STI Server Service must use the same log on account; otherwise, the services cannot communicate with each other correctly.

Unable to modify CTSRVR.CFG
This error occurs because the Web installer is unable to modify the new CTSRVR.CFG file. There are several known causes for this error, and the solution varies depending on the cause and whether or not the Windows or Novell CSV version is being used.

Cause:  A former Novell CSV user switches to a Windows CSV system, is on the current server, and then attempts to run the Web Update.

Solution:  Delete the CTSRVR.NLM file in the program directory and rerun the Web update.

Cause:  A Novell CSV user's CTSRVR.CFG file is modified with the result that the local directory line has been deleted or commented out from the CTSRVR.CFG file;
   ...OR...
A Novell CSV user's CTSRVR.CFG file is missing as a result of the file having been deleted, renamed or moved. This scenario may be followed by an "Error (12) occurred while attempting to open the xxxxxxx file" error message indicating reindexing files is needed.

Solution:  Stop the STI Server. Edit the CTSRVR.CFG file with a text editor by adding the local directory line with the correct location. Restart the server. Restart Tabs3; an error 53 may be displayed. Make a temporary backup. Reindex the file listed in the error 53 message (or reindex all files). Restart PracticeMaster; an error 53 may be displayed. Reindex the file listed in the error message (or reindex all files).

Status Log (CTSTATUS.FCS)

While STI Server is operational, status information is appended to CTSTATUS.FCS. This includes information regarding when STI Server was started, whether any errors occurred, and whether STI Server was shut down properly. The CTSTATUS.FCS file is located in the Tabs3/PracticeMaster program directory, and is viewable via a text editor such as Notepad. Viewing the contents of this file can be very helpful in troubleshooting STI Server, especially if any errors are listed.

Problems Starting STI Server

On a Windows server, STI Server may be started manually from a Command Prompt window, from the Services Applet, or via the Desktop Interactive Program (Fig. 2). [Note: STI Server can only be started from a Command Prompt window or from the Services Applet if it has already been installed as a Windows service (i.e., as the STI Server Service).] On a Novell server, STI Server may be started manually using NetWare's LOAD command.

STI Server Service

If the STI Server Service fails to start, it returns a service-specific error. The following is an example of the output from a failed startup when starting the STI Server Service from a Command Prompt window.

	C:\STI> ctntinst -start STI Server Service
	Starting the FairCom Server service...
	STI Server Service start unsuccessful:
	Current State: STOPPED
	Win32 Exit: 1066
	Service Exit: 2
	Checkpoint: 0x0
	WaitHint: 0x0

The service-specific error is displayed as the Service Exit code. The following table provides information regarding service-specific error codes.

Error
Code

Cause

Resolution

0

STI Server is already running as a Windows application (i.e., the Desktop Interactive Program).

Shut down the Desktop Interactive Program, and start the service again.

2

The required CTSRVR.CFG file located in the Tabs3/PracticeMaster directory is invalid, usually due to editing it via a word processor instead of a text editor.

Rename the existing CTSRVR.CFG file, and reinstall the STI Server software to create a new CTSRVR.CFG file (see note below).

6

STI Server has not been activated.

Run the FairCom Server Activation Utility to activate STI Server.

Error Code 2 Note: If you purchased STI Server with a connection limit of 256 or more, you will need to modify the new CTSRVR.CFG file to reflect the connection limit.

Desktop Interactive Program

If an error occurs when attempting to start STI Server via the Desktop Interactive Program (i.e., by double-clicking the CTSRVR.EXE file), the following message will be displayed.

The "Server Operation Now Stopped" message is displayed for one of the following reasons.

If the STI Server Service is currently running, it must be stopped before attempting to start STI Server via the Desktop Interactive Program. Information on stopping STI Server Service is available in the STI Server manual. (Note: If the STI Server Service is already running, it is not necessary to run the Desktop Interactive Program. STI Server functions the same regardless of whether it is run as a Windows service or as a Windows application.)

If the required CTSRVR.CFG file is invalid, rename it and reinstall the STI Server software to create a new CTSRVR.CFG file. (Note: If you purchased STI Server with a connection limit of 256 or more, you will need to modify the new CTSRVR.CFG file to reflect the connection limit.)

Novell NLM (Network Loadable Module)

On a Novell server, STI Server is run as a NLM (Network Loadable Module). If STI Server is not running, it may have been stopped via NetWare's UNLOAD command; or the LOAD command in the server's AUTOEXEC.NCF file may be incorrect. STI Server may be started manually using NetWare's LOAD command, but you will also want to verify the contents of the AUTOEXEC.NCF file to ensure STI Server is started automatically each time the server is started.

If the LOAD command in the server's AUTOEXEC.NCF file is incorrect, STI Server will not be started when the server is started. Before modifying the AUTOEXEC.NCF file, first verify that STI Server can be started manually using the above procedure. Once you have confirmed the correct LOAD command to start STI Server manually, edit the same LOAD command in the AUTOEXEC.NCF file. The next time the Novell server is restarted, STI Server will be running.

Technical Information

This section provides information on common situations that occur with STI Server and Tabs3/PracticeMaster CSV software.

Determining Connection Information

Connection information is shown in the Help | About window (Fig. 1) of all Tabs3/PracticeMaster CSV software. The relevant fields in this window include Current Connections, Maximum Connections, and Activation Limit. The Maximum Connections represents the user-configurable number of connections allowed by STI Server. The Activation Limit represents the number of connections you purchased with STI Server (i.e., 8, 16, 32, 64, 128, 256, 512, or 1024). Detailed connection information is available here.

Increasing Your Connection Limit

STI Server is available in levels of 8, 16, 32, 64, 128, 256, 512, or 1024 connections. This connection limit may be increased at any time by contacting our Sales Department at (402) 419-2200. After receiving a new STI Server CD with the higher connection limit, simply follow the procedure listed here to upgrade STI Server to the higher connection limit.

Determining Your Version of STI Server

Before determining what version of STI Server you are using, it is important to note that there are currently only two versions of STI Server available:

One method to determine the version of STI Server you are currently using is via the Desktop Interactive Program (i.e., the Windows GUI for STI Server) (Fig. 2). This program can be run by double-clicking the CTSRVR.EXE file in the program directory. (Note: If STI Server is running as a Windows service, it must be stopped in order to use the Desktop Interactive Program.) The version of STI Server will be displayed in the title bar of the Desktop Interactive Program.

Fig. 2, Desktop Interactive Program window

For Windows and Novell servers, the following method can also be used to determine the version of STI Server you are currently using. On Windows servers, this method does not require the STI Server Service to be stopped, and can also be used regardless of how you normally run STI Server (i.e., as a Windows service or using the Desktop Interactive Program).

  1. In the program directory, open the CTSTATUS.FCS file in a text editor such as Notepad.
  2. Locate the line that contains the phrase "Server Is Operational". If this line appears multiple times, the last one listed will be the most current one. [Note: You can use Notepad's Find feature (Ctrl+F) to facilitate this step.]
  3. The version of STI Server will be indicated by a line similar to the following:
    - User#  00011  c-tree(R)  v8.27.159  Server Is Operational         -SN 33213321

Moving to a New Server

Detailed instructions for moving STI Server and the Tabs3/PracticeMaster CSV software to a new server are available in KB Article R11227, "Moving CSV Software from One Computer to Another."

Note: Separate versions of STI Server are available for Windows and Novell platforms. If the server's operating system will be changing from Novell to Windows or vice versa, a different version of the STI Server is required. Please contact our Sales Department at (402) 423-1440 to receive a new version of the STI Server software for your server's operating system.

Alternative Names for the STI Server Service

When installing STI Server as a Windows service, we strongly recommend naming it the "STI Server Service" for troubleshooting purposes. For example, installing STI Server as a Windows service can be done using the following command, where "STI Server Service" is the name given to the service:

	ctntinst  -install  STI Server Service

However, it is possible to simply enter  ctntinst -install  without providing a name, in which case an alternative name is given to the Windows service. The name given varies depending on which version of STI Server was being used at the time it was first installed:

If STI Server is installed as a service and you are unable to locate the "STI Server Service," it is possible that it was installed with an alternative name. Additional information on installing STI Server as a Windows service is available in the STI Server manual.

Faircom Activation Utility

The FairCom Server Activation Utility (Fig. 3) is used to activate STI Server once it is installed. STI Server must be activated in order for it to run. This utility is provided with the STI Server software, and the FairCom Server Serial Number and Activation Key required for activation are included with your STI Server purchase.

Fig. 3, FairCom Server Activation Utility window

During the STI Server installation, the FairCom Server Activation Utility is run automatically, prompting you for your FairCom Server Serial Number and Activation Key. (Note: The FairCom Server Serial Number is not the same as your Tabs3/PracticeMaster serial number.) If you choose not to activate STI Server during the installation, or if you need to enter a new FairCom Server Serial Number and Activation Key to upgrade your connection limit, the utility can be run by executing one of the following files:

This file is located in the Tabs3/PracticeMaster program directory.

Note: If you are installing STI Server over an existing STI Server installation, you will not be prompted for a FairCom Server Serial Number and Activation Key.

FairCom Serial Number and Activation Key

The FairCom Serial Number and Activation Key are printed on a label included with the STI Server purchase invoice, and on the STI Server CD case. This label will appear similar to the following.

	STI Server - Windows Version
	Serial #:     123456
	Key:          ABCDE.ABCDE.ABCDE-ABCDE.ABCDE.ABCDE
	Connections:  256

Note: The FairCom Server Serial Number is not the same as your Tabs3/PracticeMaster serial number.

References


© 1999-2008 Software Technology, Inc.   All rights reserved. Terms of Use
The maker of Tabs3 and PracticeMaster
e-Mail Suggestions for the Knowledge Base to: kb@Tabs3.com
Technical Support via e-mail is not available.
Knowledge Base:   http://support.Tabs3.com
Web Site:   http://www.Tabs3.com