ITS Service Status Report

Data Refresh Delay — Resolved

U-M Data Warehouse Procurement tables refresh running late.

Services Affected: Enterprise Data Service

Start Time: 01/18/2021 6:54 am

Data Refreshed: 01/24/2021 10:17 pm

Issue Symptoms: Outdated

1/25/2021 12:21 pm:  Our ETL process has finished successfully at 1/24/2021 10:17 pm last night.  Thank you for your patience.

01/18/21 11:00 am: Grants are issued on the Procurement tables. Users have access to the tables with the latest data from (01/17/2021). We will let the regular process run on Sunday for the history load.

01/18/21 10:10 am: Our ETL process hung again when trying to load a history table "WRHS_LUM_ACTV_HIST". All other procurement tables have the latest data. We are going to run the grant script and have users access the data except for this table.

01/18/21 9:12 am: This session is still running long.  Oracle DBAs are monitoring.  It should complete around 11:00 am.  Thank you for your patience

01/18/21 8:25 am: There was a long running session.  The session was aborted and restarted.  It should complete around 9:00 am.  Thank you for your patience

01/18/21 7:15AM:

The refresh of the Procurement (PR) tables in the Financials data set is taking longer than expected.

Other tables (General Ledger, Asset Management, etc.) in the Financials data set are available. 

Users may receive an Oracle error message stating the table or view does not exist when trying to access the Procurement tables in the Financials data set. M-Reports will return the message "No Data Available" when trying to access the Procurement tables in the Financials data set.

Business intelligence applications, such as Tableau, BusinessObjects, M-Reports, and unit reporting applications, may fail to refresh or may contain outdated data. Users may receive errors, see outdated information, or be unable to view the data in the U-M Data Warehouse until this issue is resolved.

Who is Impacted? Users of the Procurement (PR) tables in the U-M Data Warehouse Financials data set.

Next Update: We expect the refresh to run on its regular schedule day Sunday Jan 24 night and all tables to be refreshed

Technical Details

Service Type: Production

Comments:

1/25/2020, ystevens, the DW PR dataset refreshed successfully last Sunday 1/24/2021.

Report Additional Impacts

Contact the ITS Service Center for more information or to report additional impacts.