The given key was not present in the dictionary

ChrisGodfree

I have suddenly started to get the error message "The given key was not present in the dictionary" when opening existing .sqlgen projects. I have looked at the log files but they don't show any error messages. Also, I can create a new project using the same databases and that works fine as does SQL Compare.

Searching this forum has suggested database permissions but nothing has changed (to my knowledge) and without knowing where the error lies it is proving difficult to investigate - any ideas??

Edit - sorry put in wrong forum, this is SQL Data Generator 1

Brian Donahue

Hello Chris,

I suspect that there are some empty elements in the project file. They could have been caused by some schema changes. I will send debugging instructions and hopefully we can work out what is missing in the project file.

ChrisGodfree

For anyone who faces this in the future, Brian was spot on - columns which were used in our project had been dropped from the source tables. Debugging will help to identify the problem columns but as the project won't open you will need to manually edit the .sqlgen (I simply removed the whole table definition).

Brian Donahue

I have logged a bug with the development team - it would be better if SDG continued past this so you can load up the project and fix the problem.