Determining your Database Version

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting >

Determining your Database Version

Affected Software/Reports/DLL(s): EQuIS Professional

 

Affected Software Version: N/A

 

Symptoms: If you receive a database where there is no associated EQuIS version, use the instructions below to determine your database version.

 

Cause/Details: N/A

 

Resolution/Workaround: This information is included in the ST_MODULE.VERSION_NUMBER field. Please see the following steps to determine database version or email an export of your ST_MODULE table to support@earthsoft.com for further assistance:

 

1.Open ST_MODULE and filter for MODULE_TYPE=db.

2.Locate the schema component of interest in the NAME category.

3.Note the VERSION_NUMBER field, which is in the following format:
[YYDDD when the schema file was last modified].[YYDDD when the schema file was compiled]
where YYDDD represents the two-digit year and three-digit day of year. The second number set is typically within one to two days of a version release.

4.For example, the VERSION_NUMBER for Professional is 16036.16096, which converts to February 5th, 2016 and April 6th, 2016.

5.Compare the modified date in VERSION_NUMBER dates from ST_MODULE to the Release Notes release dates.