By Jeffrey McDaniel on Aug 20, 2013
How can you tell what version of the P6 Reporting Database you have installed? There are two main ways.
1- Query the ETL_PARAMETER table with the following:
select p_feature, p_1 from etl_parameter
where p_feature = 'db.star.version'
or p_feature = 'etl.source.version';
The output will be similar to:
DB.STAR.VERSION will give the major release that this STAR database was installed from. The ETL.SOURCE.VERSION will tell you which P6 version the ETL process is running with, this helps determine the mappings.
2- In the <star installation directory> there is a version.txt that will also give the version number. The version.txt was added in the last couple releases and is updated when fix packs are added.