Some more details on the issue:
We received our updated universes from the third-party source that designed them. Their connection for the database has a different name than our connection, so we have to open the universe in Designer, then edit the parameters to change the data source from their name to the name that we use. We then export the universe into the production domain. Designer saves the changes to the universe, then prompts us to inform us that we will be overwriting the existing universe with the same name. We click OK and the save completes.
Beyond this point, we can access the universe and generate new reports against it, but all previously saved reports will not refresh when we attempt to do so. The error that we receive indicates that the data source that uses our named connection is not available.
We are unable to edit the report to force an update of the reference to the "old" universe to point to the "new" universe because the "Unable to connect to data source" dialog box blocks us from accessing the universe pick list.
Any suggestions?
Thank you,
Wes Downs
Database Developer
Synovus Financial Corp.