The given key was not present in the dictionary

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

The given key was not present in the dictionary

Postby ChrisGodfree » Thu Nov 01, 2012 11:34 am

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
ChrisGodfree
 
Posts: 7
Joined: Thu May 10, 2012 9:02 am

Postby Brian Donahue » Fri Nov 02, 2012 2:19 pm

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.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby ChrisGodfree » Thu Nov 08, 2012 9:35 am

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).
ChrisGodfree
 
Posts: 7
Joined: Thu May 10, 2012 9:02 am

Postby Brian Donahue » Thu Nov 08, 2012 10:19 am

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.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests