data providers not working following SITS upgrade...
Reports worked fine prior to recent SITS upgrade (from 8.1.0 to 8.2.0), BO XI rel3 on ORACLE 10g. now NO reports are refreshing successfully. When I take some example SQL from a report and run it in TOAD, EVERY report mentions the SAME view as having an error in it. (view "SITSBI.INS_STU_V" has errors).
But , I've since realised that ALL views in our LIVE production database that contain some data are 'red-crossed' as containing errors.
Surely that this means I need to do some kind of mass data refresh type thing post SITS Upgrade? What is the procedure in this situation? (My boss is away and unavailable.)
If you open a Universe up in BO XI Designer structure is refreshed OK, but if u2018Check Integrityu2019 is run, I'm getting 57 divergences, 2133 Parse Object errors and 41 parse Join errors..