finding deleted report in CMS database

I vaguely remember that if a report object is being deleted from Infoview, it is not gone permanently, but being flagged as deleted. And I can still find it by querying the CMS database. Is that correct?

I have a situation here that I do not need to recover the report, but I just need to prove if the report has ever existed before or not.

Unfortunately, it is in our Dev environment and we did not turn on auditing.

By the way, it is BOE XI R2.

Any help will be very much appreciated.


substring :us: (BOB member since 2004-01-16)

Hi there

I think the document is deleted logically and physically. Within legacy BO version it was working like that but within XI there are no way to restore one document …

Don’t you have any BIAR backup file?

Unfortunately, we do not have the bandwidth to backup Dev as often as we like (unlike Production). Besides, we never have such issue before until now. We are suspecting the developer was lying about her work. She claimed that someone had deleted her report. We think she has never started the development. We usually can trust our developers, except this person.

Anyway, there is no way I can find out without auditing or backup, is that correct?

Thanks!


substring :us: (BOB member since 2004-01-16)

Correct …

My understanding was that in XI-R2 there were two-passes…

(1) Instantly, instance record is removed from the CMS database.
(2) Eventually, when the CMS has some “idle time” the physical folder and instance objects are removed from the FRS Input and Output.

I seem to remember that in “high-use” environments there was a problem with the FRS filling-up with “deleted” objects and instances because the CMS never had enough “idle time” to do the physical clean-up.

I don’t know if that was ever fixed in an XI-R2 service pack, or with the XI-3.0/3.1 releases.

You might still have the “ghost” instances in your FRS…


MJRBIM :canada: (BOB member since 2007-03-23)