I have written a very simple report. It works in Crystal XI R2. I have loaded it out onto BOE. The report is accesed via a URL. It works fine in Crystal and fine on the web when created. Sometime later the URL breaks and when the report is accessed I get an error message "Unable to retrieve object" Error in file ... Table could not be found." Now when I select the preview button for the report in BOE I get the same message. If I schedule the report and run it and click on that instance the report runs successfully and I can view it. I can run and view it int Crystal too.
If I go back to Crystal and save it as a new instance in BOE it works again. Until the next time it breaks in a day or 1/2 a day.
Any ideas?