Is there a way to clear the history of all the reports

[Former Member]

I would like to clear out the history of all the reports listed in InfoView because many of the links are broke because I was told to delete all the directories containing the pdf's in the Epic\EpicBI\Output folder. Can I truncate the tables in the database or where does InfoView maintain those links?

[aasavaribhave · Accepted solution]

If you want to delete all the scheduled instances for reports, it can use the code similar to the following:

IInfoObjects oInfoObjects = oInfoStore.query("select si_id from ci_infoobjects where si_instance=1 and si_name='<report name>'");
for(int i=0; i<oInfoObjects.size(); i++)
{
       IInfoObject oInfoObject = (IInfoObject)oInfoObjects.get(i);
       oInfoObject.deleteNow();
}
oInfoStore.commit(oInfObjects);

as a side note, do not try to alter the output file repository or the CMS database directly, it could create lot of issues\inconsistencies in your system and make it unusable.

Thanks

Aasavari

[Former Member · Accepted solution]

Is there a utility I can paste that code into. I'm new to Java and web programming.

Thanks,

Phil

[aasavaribhave · Accepted solution]

I am not sure if there is a utility available for this. You need to engage a java developer or do it yourself. Alternately if you logon to CMC as administrator, go to folders, right click all folders and select Limits. You can check the option( unchecked by default) on the top to delete all instances that exceeed some specific count ( configurable). If you set that number to say 5. For all reports only 5 latest instances will remain in repository and all other instances in excess of 5 will be deleted. Subsequently uncheck the option to stop deleting instances in the future.

[Former Member · Accepted solution]

I installed Eclipse to run the code and will work on that today.

I went ahead and changed the limits to 2 and restarted the TomCat server and the SIA. But I still see a large amount of history. I also see another limits setting on the individual report. I set that to 2 on one report and it still did not clear out the history. So maybe the code is the only way to fix this.

[aasavaribhave · Accepted solution]

setting limit should work. Try creating a new test report and schedule it a few times, see if the limit works now. What version of Enterprise you use? 3.1, 4.0 what's the SP level?