CFS and Finance Data Warehouse Outage Scheduled

CFS and Finance Data Warehouse will be unavailable from 5:00 p.m. on Friday, August 24th through 9:00 a.m. on Sunday, August 26th.  The Chancellor’s Office is moving CFS production database from Solaris to Linux and both systems must be offline to complete the project. This move will not affect any other services (e.g. FTS and SJSU Email) you typically access through the my.sjsu.edu application portal.

On Sunday morning, CFS data will be as of Friday, Aug. 24th 2:00 a.m.  Finance Data Warehouse will be refreshed as follows:

Monday, August 27, 2018 – available by 8:00 a.m. with data current as of Sunday, August 26 at 6:00 p.m.
Tuesday, August 28, 2018 – available by 10:00 a.m. with data current as of Tuesday morning at 2:00 a.m.
Wednesday, August 29, 2018 – available by 8:00 a.m. with data current as of Wednesday morning at 2:00 a.m.

Daily Finance Data Warehouse refreshes will return to normal starting Wednesday with our standard 8:00 a.m. availability and reflect data from 2:00 a.m. that morning.

For more information about the outage, updates or changes to the schedule, visit the my.sjsu.edu application portal. Please forward this message to any staff or faculty you feel should be notified.

Resolved – Finance Data Warehouse Issue

Earlier today, users reported totals in the Actuals column being doubled than what was actually posted. We discovered the problem only occurs for users who run their Data Warehouse reports using the Department Tree and Dept Level fields.

If you run reports using the Department Tree Level, please make sure you select SJ_Dept_Primary in the Dept Tree Level field to obtain accurate results.  This issue does not affect users who do not use the Dept Tree and Dept Level fields.

For more information regarding setting up Finance Data Warehouse reports, please refer to Finance Tutorials.

If you have any questions, please contact Finance Support at financeconnect@sjsu.edu .

1:  Dept Tree Name field in Manage My Budget as of Period report

Finance Data Warehouse Dept Tree Name

 

2:  Dept Tree field in Financial Summary Between Periods reportFinance Data Warehouse Dept Tree