Hello,
we have a genesys reporting issue where data was lost due to a database error (in ICON logs) that stopped the solution from working correctly. Unfortunately this was not discovered for a few days before it started so once the database error was fixed, only the current days data was recovered then all ok moving forward from that point.
The data from the previous 3 days is still missing.
when raising this with support they advised we need the GIM backup covering the day of the fault, or just before then to restart ICON and it will process the missing days data. Unfortunately we dont have that GIM backup available.
i have checked ICON pq file which is just under 4 GB so suspect this contains the data for the 3 days of missing data. Support are telling me even if it does contain that data, without the GIM backup, it cannot be retrieved or recovered so is lost.
we also needed ICON to still have the data but that is also now purged (but it was present when we discovered the GIM DB backup does not cover the days it is needed for).
Is this true?
or can we do anything to recover the data? using the PQ file? Whilst the ICON data is purged, GIM retention is 180 days but think this is just FACT tables not anything else of use.
we are using latest versions of ICON and GIM apps v8.1/v8.5.
database is oracle.
