Red Gate forums :: View topic - The given key was not present in the dictionary
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

The given key was not present in the dictionary

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ChrisGodfree



Joined: 10 May 2012
Posts: 7

PostPosted: Thu Nov 01, 2012 11:34 am    Post subject: The given key was not present in the dictionary Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6589

PostPosted: Fri Nov 02, 2012 2:19 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
ChrisGodfree



Joined: 10 May 2012
Posts: 7

PostPosted: Thu Nov 08, 2012 9:35 am    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6589

PostPosted: Thu Nov 08, 2012 10:19 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group