I added a new table to a Cache database in a specific schema.  When I launched Crystal I already had  historical connection to the appropriate data source, and the newly added table would not display.  I tried refreshing the connection and verifying the database and still the new table would not show up.  I knew I needed to delete all the current / favorite / historical connections but the option was greyed out in the database expert.  I found out that the historical data source connections are stored locally on the workstation as XML files in the following directory: C:\[DocumentsAndSettings][Users]\<username>\My Documents\History.  I deleted these files and re-launched Crystal wherein I was able to re-create the connections and the table finally showed up.

Happy Reporting

*Update 08/11/2020

One reason I write about issues I deal with is to help others experiencing the same problem. However I will admit that these also serve as a personal knowledgebase (deduct altruism points). I was working with one of my report developers today and we started seeing some strange behavior. While in design view for a report that had already established connections to a data source, we attempted to add a table and none of the SQL Views would should under the schema we were traversing. We verified the database, logged off and back on the server, finally restarting the workstation. When the report was reopened we started receiving errors “Failed to retrieve data from the database” followed with “connection reset by peer (due to timeout or reboot).” Now this only happened when my developer tried authenticating on his workstation. I was successfully able to establish a connection on my computer. Last thought was that there must be something wrong with the data source. I remembered this post and followed the directions. After deleting the cached connection, my developer was able to re-authenticate and view all of the schema information successfully. I hope this information is valuable to others.

As always, Happy Reporting!