.WID file size too big even when data was purged

building reports webintelligence
1

Hello,

I am trying to save some disk space by purging all WebI reports stored as .WID files in a shared file server.

It did work for most of them, however, for some reports, even when I purged the data (I am WebI Rich Client); the .WID file is still about 16 MB.

Do you have any idea why I am not able to reduce the .WID file size?

Thanks!
Alicia

arevello :canada: (BOB member since 2012-06-21)

2

Hi

how may queries do you have in your report?
which purge option did you use?
there are 3 purge options

check whether you have purged all the queries.

Thanks

osrootofos :us: (BOB member since 2012-02-10)

3

Thank you for your answer!

I’ve found the problem: The ODBC for those particular reports did not exist on the server (those were old reports), so even when I did Purge from WebI Rich Client and the data was removed from the form of the report, it was not completely removed from the .WID file.

I solved it by doing a Refresh; after that I’ve got the error ‘Database Error WIS 10901’ and then I’ve saved the report and the size of the .WID file was reduced from several MB to just some KB.

Thanks again,
Alicia

arevello :canada: (BOB member since 2012-06-21)

4

Hi

Please check these links:
solution for your database error

http://www.forumtopics.org/busobj/viewtopic.php?t=183217&view=next&sid=712015a37699581fb22db171550c2768

you can find many other links just search.

Thanks

osrootofos :us: (BOB member since 2012-02-10)