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.
To access the log files:
- Sign in to the CIC Administration Application:
http://<host>:<port>/p6rdb
- In the sidebar, select
Status. - Select the View Log link.
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. Provides the time it took for each step to run. This log is derived from the ETL_PROCESSMASTER, ETL_PROCESSINFO, and ETL_PROCESSEXCEPTION tables.
- <yyyymmdd>: The date of the STARETL process run.