The iTrac+ APP requires an update to the web service.
On the server that hosts the iTrac IIS web service:
That is all that is needed.
If you browse the iTrac local server you get a 503 error reported.
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:
“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
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.
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:
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.
“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:
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)
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.)
Copyright TRACTIVITY 2016. All Rights Reserved