When running the Verify database function, it will always give a message that the table cannot be found. After this, you are then asked to look for the database, in your case using either adagio.ssi or srglob.psv (in the company data directory). At this point, the process will either say that the report is up to date, indicate that another file needs to be updated (same steps as before, just repeat) or an error will occur because proper files cannot be found. If in fact an error occurs, it will be because a required system file cannot be found.
You only need to run 'Verify database' if you want to point the report to a different company database. Is this what you want to do?
Perhaps your SalesAnalysis table is missing or unreadable? Report tables are stored in a folder called 'qrasp', and it typically will be found on the root of the same drive where Adagio programs are installed - this is likely on the i drive, based on your posting.
In the i:\qrasp directory, you should find a table file qrtsrw68.qrw and if not, this is a problem. If it is there, then you should have seen it when using 'adagio.ssi' as the database selector and listing 'All' tables. I suspect that the table is there, based on the wording of your message and also that the report continues to work.
The fact that this is a Linux server adds a layer of complexity.
No, sorry but Crystal Reports 8.5 on it's own doesn't have the automation processes for this to happen automatically.
_________________________
Regards,
Softrak Tech Support