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 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.