BusinessObjects Board

Delete script for Inbox reports has wiped everything

server administration XI Server Discussion
#1

I used the Java script created by Business objects, which did the cleanup for individual users, i changed the query to clean all inboxes.

I used the following query.

SELECT * FROM CI_INFOOBJECTS WHERE SI_NAME like ‘R0%-%’ and SI_KIND = ‘Webi’ and SI_OWNERID= ‘1830’ ";

Now in CMS i do not have any of the reports (R01 - R09) showing in the my Backups folders, reports folders and inboxes and schedules.

I have looked in the server and i can see alot of .wid files in the
D:<Boinstall dir>\Data<servername>storage\docs*.

Whats the best plan to put things right.

Any help will be appreciated.

Ajay

Ajayp007 (BOB member since 2009-05-23)

#2

I have correctted the problem.

I have found the correct WID files and imported them in by the
WEBI Rich client.

Just had to rename the files back to before and setup the schedules.

I will get some kind of backups in place.

MYSQL, File structure and SQL DB backup.

Ajay

Ajayp007 (BOB member since 2009-05-23)

#3

Now that everything is restored.

A question would be,
can someone tell me what the correct query would be just to delete
the inbox records and not everything else in the CMS application.

I think i was just using the incorrect Property value in the query.

Any guidance would be appreciated.

Ajay

Ajayp007 (BOB member since 2009-05-23)

#4

Here is a tool that I wrote can help you

Sheshachala5 :india: (BOB member since 2004-01-09)

#5

Thanks for the feedback, I fixed this a few months ago.
I managed to get a script to run on the server as a scheduled job, this way every night the inboxes are cleaned up therfore giving the users new reports on a daily basis.

It was a jsp script which I ran using a Windows File Script, then used a bat file to schedule the script.

If I can find my script then I will place it on the site.

Ajay

Ajayp007 (BOB member since 2009-05-23)