none
Timesheet Periods Missing from Reporting Database RRS feed

  • Question

  • I have an issue where multiple timesheet periods are missing from the reporting database. I can access the time periods from the UI, and we can also access the data from an OLAP cube; however, they are missing from the reporting DB. I have also recently ran a successful DB sync by restoring the ECFs. Has anyone seen this? What did you do to fix it?

    Thanks,

    Chris

    Tuesday, January 9, 2018 9:39 PM

All replies

  • Data is missing or the whole views are missing? Which version you're using? There's a bug in 2016 that sometimes built-in views are missing. Please check this site link

    HTH


    IN
    Thanks, Kashif

    Thursday, January 11, 2018 6:26 AM
  • We are on 2013 version 15.0.4571.1502. It appears that the data is missing rather than the view as it is not all of the data missing, but only certain timesheet periods. From year 2017, Timesheets 1-33 are there (missing 34-39), 40-46 are there (missing 47-51), and 52 is present. Performing a query of the database returns no data for the missing timesheet periods while querying the MPS_TimesheetLine_UserView table. 

    Thanks,

    Chris




    Thursday, January 11, 2018 1:48 PM