Accessing Log Files

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 of ETL runs:

  1. Sign in to Primavera Analytics Administration Application:

    http://<host>:<port>/p6rdb

  2. From theIcon_Home_menu_in_admin_app_home_page Home Icon_down menu, select a staretl<id> or a <Custom Name of a data source>.
  3. In the sidebar, select icon Status.
  4. In the Recently Running ETLs section, select the View Log link to access the log files created for each STARETL run.

    The following information is displayed in a log file:

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

Last Published Friday, July 5, 2024