Hi All,
Whenever I delete a table in the DW I get the below error.
An error occurred while saving the project in the database.
The given key was not present in the dictionary.
Dear HP,
Thank you for your reply. Actually I encountered this error in Jet Data Manager. I simulated the error and found that the error occurred due to the reference to an existing field as the parameter in one of the transformation which used to come to me as prompt before deleting the table.
Therefore I first deleted the parametric reference fields before deleting the whole table,as droping the table without deleting the parametric field created a circular reference as JDM kept looking for the parametric field while loading itself and hence the error is what I concluded.
Hi Franco -
Jet Essentials caches certain information about the design of your data source when Excel is opened. If that information is changed, the cache needs to be refreshed.
You'll want to exit out of Excel, restart Excel, and then reload your report.
