P6 Reporting Database versioning

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 3.1

etl.source.version 83

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. 

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Provide new information on P6 Analytics and Reporting Database.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today