Every time you run the STARETL process, Primavera Data Warehouse creates extensive log files that provide information about the installation and daily operations details of each step of the process. Inspect the log files after each run of the STARETL process to determine if any issues exist.
The following log files are created after each STARETL run:
- <yyyymmdd>ProcessId.log: Contains the details of the SQL commands run to perform the database refresh updates.
- <yyyymmdd>ProcessId.html: Contains results of the processes run to create the users, tables, and transfer of data. This log file provides the time it took for each step to run. It is derived from the ETL_PROCESSMASTER, ETL_PROCESSINFO, and ETL_PROCESSEXCEPTION tables.
Note: <yyyymmdd> represents the date the STARETL process run.
Using Primavera Analytics Web Administration Application
To access the log files from the Primavera Analytics Web Administration Application:
- Sign in to Primavera Analytics Web Administration Application.
- In left pane, select Status.
- Select the Log tab.
Using the STARETL Process Server
To access the log files on the STARETL process server, go to <PDW Install Folder>\star\etl_homes\staretl<id>\log
If a problem occurs with Primavera Data Warehouse and the log files do not provide sufficient information, see Primavera Data Warehouse Troubleshooting.