Diagnostic Tool
From ICISWiki
This is the TDM for Version 5.3
Contents |
Introduction
The ICIS Diagnostics Tool is an application that tests the different components of your ICIS installation to determine the cause of error situations. This is useful in troubleshooting when your ICIS application is not functioning properly.
It is so simple to use! Just choose the tests you want to execute and click on the "Run tests" button.
The ICIS Diagnostics Tool was developed using Visual Basic 6.
Configuration Test
If you choose to execute the Configuration Test, the application will show you the result similar to the following:
-------------------------------------
System Configuration
-------------------------------------
Operating System: MSWinXP Workstation Ver.5.1 Service Pack 2 (Build 2600)
ICIS ODBC settings:
Central GMS: Microsoft Access Driver (*.mdb) (OK)
Local GMS: Microsoft Access Driver (*.mdb) (OK)
Central DMS: Microsoft Access Driver (*.mdb) (OK)
Local DMS: Microsoft Access Driver (*.mdb) (OK)
ICIS module versions:
icis32.dll: Thursday, February 10, 2005 10:46:11 AM (5.0.0.0)
Browse.exe: Friday, May 20, 2005 11:13:52 AM (Unknown)
GMSSrch.exe: Thursday, August 04, 2005 4:07:27 PM (5.2.0.0)
SetGen.exe: Tuesday, July 26, 2005 3:35:47 PM (5.1.0.3)
InTrack.exe: Friday, July 29, 2005 3:27:00 PM (5.2.0.0)
DMSWRBK.XLA: Wednesday, February 02, 2005 11:06:52 AM (Unknown)
Database Test
If you choose to execute the Database Test, the application will show you the result similar to the following:
------------------------------------- Database Structure ------------------------------------- Central GMS table: ATRIBUTS (771780 records) table: BIBREFS (257 records) table: CHANGES (230089 records) table: GEOREF (4219 records) table: GERMPLSM (1935810 records) table: INSTLN (72 records) ...
ICIS DLL Test
If you choose to execute the DLL Test, the application will show you the result similar to the following:
------------------------------------- DLL Functions ------------------------------------- GMS_openDatabase2 (OK) DMS_openDatabase (OK)
Error Codes
Reference of error codes and the recommended action to fix the error situation.
error-0001: Invalid ODBC DSN
Summary:
The indicated ODBC DSN supplied in the ICIS.INI file is invalid.
Action:
Navigate to "Control Panel". Then click on "Administrative Tools". Click on "Data Sources". Check if the DSN exist in the ODBC Data Sources Panel. [Show Me]
error-0002: ODBC Connection failed for ODBC DSN
Summary:
The connection credentials (username, password, location) supplied for the DSN is incorrect.
Action:
Supply with the correct connection credentials. This may vary for each type of Data Source. Check your Data Provider documentation.
error-0003: Module is not compatible
Summary:
An ICIS module is not compatible to the ICIS application installed.
Action:
Download the module with the proper version compatible to the installed ICIS application.
error-0004: Invalid database structure.
Summary:
The ICIS database is not compatible to the ICIS application installed.
Action:
Download the scripts that will fix the ICIS database from https://cropforge.org
error-0005: User Access Error: Missing USERS record
Summary:
Username and Password credentials from the ICIS.INI are checked against the USERS table. The credentials were not found.
Action:
The ICIS.INI UID and PWD entries is not found in the USERS table. Modify the UID and PWD to correspond to the valid USERS record.
error-0006: User Access Error: Missing INSTLN record
Summary:
Username and Password credentials from the ICIS.INI are checked against the INSTLN table. The credentials were not found.
Action:
The value of the table field USERS.INSTALID does not correspond to the INSTLN table records. Modify the value of the table field USER.INSTALID to a valid INSTLN table record.
error-0007: DB table not found.
Summary:
An ICIS database table is missing.
Action:
Download the scripts that will fix the ICIS database from https://cropforge.org
error-0008: DB table column not found.
Summary:
A column from an ICIS database table is missing.
Action:
Download the scripts that will fix the ICIS database from https://cropforge.org
error-0009: DB index not found.
Summary:
An index from an ICIS database table is missing.
Action:
Download the scripts that will fix the ICIS database from https://cropforge.org
error-0010: DB table column not set as REQUIRED.
Summary:
A column from an ICIS database table is not defined properly.
Action:
Download the scripts that will fix the ICIS database from https://cropforge.org
error-0100: Internal function failed to execute. [procedure name]
Summary:
There is a bug in the ICIS diagnostics application.
Action:
Report to cropforge.org
