Questions? We’ve got answers!

Trouble Shooting

Contents

New iTrac+ APP crashes when password entered

The iTrac+ APP requires an update to the web service.

On the server that hosts the iTrac IIS web service:

  1. Browse to C:\Program Files (x86)\Tractivity\iTracWeb
  2. Rename the Bin folder to Old Bin
  3. Download this file. Unzip and save the Bin folder to C:\Program Files (x86)\Tractivity\iTracWeb (same location)
  4. IMPORTANT! – After the new Bin folder is saved you MUST:
    1.  Open the folder and right-click on the file(s). Check properties
    2. If Security has locked the file – Unlock it.

That is all that is needed.

iTrac stopped working after a Windows Update *

If you browse the iTrac local server you get a 503 error reported.

Click here for help from Microsoft

Cabinet Vision Link – Unable to access SOLID database *

The access to the SOLID database may be lost after a Cabinet Vision Restore operation.

The following steps will recreate the Tractivity SQL login credential:

  • Copy the text below into a notepad document

“C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE” -E -S “SERVER\Solid” -Q “USE CxMaterials_11 DROP USER [Tractivity_MSSQL_User]” -b

“C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE” -E -S “SERVER\Solid” -Q “USE CxMaterials_11 CREATE USER Tractivity_MSSQL_User FOR LOGIN Tractivity_MSSQL_User WITH DEFAULT_SCHEMA=[dbo]” -b

“C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE” -E -S “SERVER\SOLID” -Q “USE [CxMaterials_11] EXEC sp_addrolemember N’db_datareader’, N’Tractivity_MSSQL_User’” -b

“C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE” -E -S “SERVER\SOLID” -Q “USE [CxMaterials_11] GRANT UPDATE TO Tractivity_MSSQL_User” -b

  • Change the SERVER in the notepad text to the correct server name
  • Change the CxMaterials_11 in the notepad text to the correct SOLID catalog name
  • Run cmd as Administrator
  • Paste the notepad text into the cmd box and ENTER

Unable to connect to SQL Database: Database Does Not Exist or Access Denied *

  • Remote connection is not enabled for a SQL Server instance

To check remote connection is enabled or disabled, open SQL Server Management Studio -> Connect to SQL Server where it is installed using SQL Server Management Studio ->Go to SQL Server instance property and check Allow remote connection to this server.

Active-X error when attempting to register TracManager *

If .NET 3.5 (includes 2.0) is not turned on when the TracManager installation is run, the installer will not be able to register the licenselib.dll. This will cause an automation error when you attempt to register the software. And since the feature was not turned on when the program was installed, it will need to be manually registered after the feature has been turned on.

Remedy:

  1. Be sure DOT NET 3.5 is turned on (this will include 2.0). If necessary enable this feature:
  2. If that does not correct the problem :
    1. Run cmd as administrator
    2. change to C:\Windows\Microsoft.NET\Framework\v2.0.50727
    3. type:  regasm “C:\Program Files (x86)\Tractivity\TracManager 2014\licenselib.dll”
    4. (if the application is installed in a different path – use that path)
    5. This should produce a “Type registered successfully” message
    6. Now run the TracManager program again

Licenselib

QuickBooks – Side-by-side error *

When attempting to connect with QuickBooks you get this error:

Error:  Automation error The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail.

This error may occur after installing an update of either TracManager or QuickBooks. The error is occurring when TracManager accesses the Intuit QuickBooks dll that provide the QuickBooks 3rd party application API. The error originates with the QuickBooks component that is not able to locate the dependent assembly. Typically a Microsoft MFC file version.

The Event viewer may have this error:

To resolve this, download and install this: http://www.microsoft.com/en-us/download/details.aspx?id=26347

Be sure to download and install the x86 version even when on a 64 bit computer.

Also a generic description of this problem – read this article: Code Project Article for additional information.

iTrac – Password Mismatch *

“Password Mismatch” when entering the correct user and password

The iTrac IIS web service connects to the TracManager database to look up the user and password. If the IIS service iis not able to access the database then the password will always mismatch.

iTrac web service must have Application settings that configure the database connection string. Double check the settings. If an SQL database you will need:

  • DataSource – SERVER NAME and Instance for example:  SERVER01\SQLEXPRESS
  • UserID – typically: sa
  • Password – set to the database password
  • Catalog – typically Timeport but may be different
  • dbType – must be set to: SQL
  •  

If all of the above is correct: Verify that the data type in database table [pCPDC Users] password column is set to VarChar (not text)

TracManager won't launch after QuickBooks update

If after updating QuickBooks you are unable to launch TracManager, the remedy is to uninstall TracManager and reinstall.

Before you take action: Find out what TracManager release is being used in your company. This is important if there was a newer release posted and you want to avoid updating all your computers right now. From one of the computers that is running TracManager, log in as Administrator and create a Software Version Report. This is accomplished by choosing Administrate Menu and selecting the last menu item.  Look for TracManager and the version.

(Alternately, you may also use the latest release if you are willing to update all of your computers.)

  1. Tractivity installation file will be named as follows: “TMyyyy.r.m.exe” where the yyyy is the year, r is the major release and m is the minor release. For example “TM2023.1.6.exe”. Locate the file locally or if you do not have a local copy you may download the installation file from our support site:support.tractivity.com   (you will need your login and password. The login is the software serial number, and the password is your assigned CID.
  2. Uninstall the TracManager software using the Windows control panel
  3. Install the software by running the installation file. When prompted, choose “All Windows Users” (this means all users only of the computer you are installing on).
  4. Verify by launching TracManager