Red Gate forums :: View topic - Error loading project
Return to www.red-gate.com RSS Feed Available

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

Error loading project

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jcooke



Joined: 27 Jan 2009
Posts: 5
Location: Richmond, VA

PostPosted: Tue Apr 21, 2009 8:05 pm    Post subject: Error loading project Reply with quote

I am getting an error while trying to load a generator project. It fails during 'Reading Permissions' with the follwoing error:
"The given key was not present in the dictionary".

I have been able to sucessfully load some other projects. This seems to be affecting about half of my current projects. It has been about a month since accessing the projects, but no changes have been made other than DB location.

I have tried to resolve the situation by performing the following steps:

1. I tried changing the database source by updating the .sqlgen project file. No change

2. I created a new project. Then I copied the <Tables> tag from the project file that was not working into the new project. Hoping that I would get the new project setup with the table changes associated to the existing project. This did not work either.

3. I have tried comparing a working project file with the non-working one using BeyondCompare2. I did not get through the whole file ( it's pretty big), but I was not able to see anything that seemed that it would cause this error.

Thanks

Jim Cooke
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Fri Apr 24, 2009 3:02 pm    Post subject: Reply with quote

Hi Jim,

While we can't really support hand-editing the project files outside of Data Generator, there are some circumstances where it could be useful, for instance if you have set up a project and have an identical copy of the same database and want to simply change the database name.

If the error happens while applying the project to the database schema, I don't think it would be possible to troubleshoot this unless we are sent the project file and the schema, and even then it may take some time to work out.

I would recommend creating new project files as this may be easier.
Back to top
View user's profile Send private message
jcooke



Joined: 27 Jan 2009
Posts: 5
Location: Richmond, VA

PostPosted: Fri Apr 24, 2009 3:30 pm    Post subject: Error loading project Reply with quote

Brian,

Thanks for getting back to me. I had editted the project file under some direction from the red-gate support team. This was done because I had a number of projects that were pointing to a database that was taken down to be rebuilt, and the projects would not load without a valid schema to connect with.

Can you give me any information on what the application is looking for when, during loading the project, it is reading permissions? That appears to be where it is failing.

Additionally, is there any logging so that I might be able to see more detailed debugging information. The message "The given key was not present in the dictionary" doesn't tell me what key it was looking for or in which dictionary. I don't know that I would be able to figure it out even if I had the additional information, but it just makes me feel better knowing that I have exhausted all possibilities.

Thanks again,

Jim Cooke
804-272-3800 x292
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Fri Apr 24, 2009 3:57 pm    Post subject: Reply with quote

Hi Jim,

I'm starting to suspect that the project file is not to blame. It sounds like a generic database registration error that you would get from a bunch of different Red Gate products when the schema can't be understood by the software.

What sort of account are you connecting to the database with? Does it have a dbo role?
Back to top
View user's profile Send private message
jcooke



Joined: 27 Jan 2009
Posts: 5
Location: Richmond, VA

PostPosted: Fri Apr 24, 2009 9:07 pm    Post subject: Error loading project Reply with quote

Brian,

My SQL Server account does have the dbo role. I am almost certain it is in the project file. Here is why I think that:
1. I tried changing to another database schema that I have loaded to previously with Data Generator.
2. I tried installing the software on another machine and copying over the project file.
3. Not all of my projects are failing. Some work just as they did before.

I will start rebuilding my projects, but hopefully, you can point me in a another direction on Monday.


Jim
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Mon Apr 27, 2009 11:12 am    Post subject: Reply with quote

Hi Jim,

Best suggestion I have at the moment is to try installing our SQL Compare demo and see if comparing the database to itself fails with the same error. If it does, the projects may not work regardless of whether or not you start from scratch because both programs use the same underlying schema engine and I suspect that there is some bit of metadata that it doesn't understand.
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