Red Gate forums :: View topic - DP error - A problem Occurred whilst loading your project
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

DP error - A problem Occurred whilst loading your project

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Thu Mar 01, 2012 7:10 pm    Post subject: DP error - A problem Occurred whilst loading your project Reply with quote

CURRENT VERSION: 2.70.1.6 (Just downloaded and installed yesterday)

After installing the latest update to DT I get the following error when trying to load the last project I worked on. Everything between the lines is the text of the error message. The error message consist of a single circular icon with a white letter X on a red background and consists of a "OK" button only.

------------------------------------------------------------
A Problem occurred whilst loading your project:

Value cannot be null.
Parameter name: key
---------------------------------------------------------------


In addition to not being able to load this project DT is unable to find any of the prior projects I worked on. The most recent DT project is not the only project, just the most recent. Is there some issue when you update DT from 2.X to 2.Y???
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Mar 05, 2012 4:18 pm    Post subject: Reply with quote

Thanks for your post.

I wasn't aware that upgrading would break the old project files, so I'm sorry this is happening.

Are you able to recreate the project in the new version? Has this happened to all your existing projects?
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Fri Apr 13, 2012 6:25 pm    Post subject: Re: Reply with quote

Chris Auckland wrote:
Thanks for your post.

I wasn't aware that upgrading would break the old project files, so I'm sorry this is happening.

Are you able to recreate the project in the new version? Has this happened to all your existing projects?


Chris,

I haven't had time to do this yet because the process is very lengthy. That is the time it takes to set up the Dependency Tracker project I had is rather long due to the number of objects involved.

You see my database has 2,136 USER Tables, 716 Stored Procedures and 285 UDF's. That means it takes any Red-Gate product that searches thru DB Objects like Dependency tracker or SQL Prompt which is even slower because of this, a long time to complete a task and hand control of the app back to the user. When using Dependency tracker it takes a while to create a project and so it really stinks when you find out after the fact that anything you did in a prior verison is not just unusable in the current version but is gone period.

I hope the next DT upgrade takes into account some option for iusers to not loose the stuff they did on the prior version. This kind of bug can be very discouraging to a user when it comes time to upgrade.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue Apr 17, 2012 1:23 pm    Post subject: Reply with quote

Thanks for your reply.

Since I last posted to this thread, I've seen a similar issue with SQL Compare, which is the engine SQL Dependency tracker uses to read the schema.

It seems to happen if you have an unexpected null value for some extended properties. The older SQL Compare engine didn't seem to be so fussy.

Can you run the following query and see if anything is returned:

Code:
SELECT major_id, minor_id, t.name AS [Table Name], c.name AS [Column Name], value AS [Extended Property]
FROM sys.extended_properties AS ep
INNER JOIN sys.tables AS t ON ep.major_id = t.object_id
INNER JOIN sys.columns AS c ON ep.major_id = c.object_id AND ep.minor_id = c.column_id
WHERE value IS null;
GO

_________________
Chris
Back to top
View user's profile Send private message Send e-mail
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Tue Apr 17, 2012 7:01 pm    Post subject: Reply with quote

Chris,

I tried the query out and got 0 rows back.

Thanks
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