We ran out of space on our server causing some reports to disappear. We decided to do a restore from our last backup of the file system and database. After this was done, we realized our server backup wasn’t done on the day we requested (when we stop BO services and do the database backup). We have narrowed down a time with an existing backup that may work for us, and are proceeding with trying to restore again, but wanted to post our troubles out here to see if any help can be given for our current situation.
When we try to refresh a report in infoview we get the following error:
“An internal error occured while calling the ‘processDPCommands’ API. (Error: WIS 30270)”
and
"Connection or SQL sentence error: (DA0005): [Exception: CS, It is not an RSS file] A connection required to refresh this document is unavailable. (DA0004): [] The following data providers have not been successfully refreshed:
0: (CS) :It is not an RSS file An internal error occurred while calling the ‘processDPCommands’ API. (Error: WIS 30270) BOException caught:RESULT=80004005;WHAT=RefreshBatch failed"
Any help on this situation is greatly appreciated!
The CMS, which was probably the only thing properly backed up, is more “current” than the items in your IFRS. Whenever a backup of the CMS and File Store does not occur simultaneously you’re going to run into problems. Your best bet is as you stated (trying to determine when a good backup of both occurred simultaneously) and then move forward. The bad news is that you may still wind up with reports you “see” hanging off the folders, but when you try to execute they fail. What this means is that the CMS has a record (a pointer) to some .wid item in the IFRS, however, the item is not there. You may want to comb through all of your folders and reports executing them all one at a time to see which ones do work or not, noting the ones that fail. Once you note the failed reports you’ll have to delete them from the folder list, and either rebuild by hand or perhaps you’ve got an old BIAR archive that you can pull them back in from. You are experiencing the inherent risk associated with operating BO and not having a surefire way of backing up all of the data properly. High on my wish list is that BO would at least store the entire report definition (folder entry and .wid info) at the database level and let the OFRS stuff go to disk (as it does now). Losing OFRS info is not as gut wrenching as losing the IFRS stuff, and having it stored in the database would at least help in the backup/restore process. (off my soap box now).
(BOB member since 2006-09-12)