Red Gate forums :: View topic - Error: Have no proxy for engine object
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

Error: Have no proxy for engine object

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



Joined: 04 Dec 2013
Posts: 7

PostPosted: Tue Mar 25, 2014 4:48 pm    Post subject: Error: Have no proxy for engine object Reply with quote

Hi all,

we just tried to use SQL Dependency Tracker 2 on a SQL Server 2012 database. For the object which we chose (a stored procedure in our case) we changed the options to "Add objects that the selected objects use (All levels)" as well.

When adding the procedure to our project, only the procedure itself has been added and no dependencies at all. Instead we received 116 error messages, which read "Have no proxy for engine object #..."

The feature list / requirements provide different information regarding the supported versions of SQL Server. The requirements state, that SQL Server 2012 IS supported (http://documentation.red-gate.com/display/SDT2/Requirements), whereas the feature list doesn't mention it (http://www.red-gate.com/products/sql-development/sql-dependency-tracker/features).

Has anybody else experienced this problems? If so, what is the solution to get the dependency diagrams working for SQL Server 2012 (it seems to work fine for SQL Server 2008 databases though)?

Thanks and kind regards,
Jens
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 922
Location: Red Gate Software

PostPosted: Wed Mar 26, 2014 5:54 pm    Post subject: Reply with quote

Hi, thank you for your forum post.

Does this stored procedure have dependencies to or from a linked server or external data source?

Is the option to "Resolve all external references" configured?

To resolve all unresolved external references:
1.On the toolbar, click Resolve All External References.
A progress message box is displayed. If you select the Close message box on completion check box, SQL Dependency Tracker closes this message box automatically next time you resolve external references. Alternatively, you can set your project options to close all message boxes when operations are complete.
2.If necessary, click OK to close the message box.

To resolve unresolved external references for selected objects:
1.Select the objects.
2.Right-click a selected object, click Add to Project, and then click Resolve External References.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
jela



Joined: 04 Dec 2013
Posts: 7

PostPosted: Fri Mar 28, 2014 9:19 am    Post subject: Reply with quote

Hi,

thank you for your reply.

I just checked again - no, the procedure does not have dependencies to linked servers or external data sources.

I also followed your instructions to make sure, I didn't have other options checked, than suggested by you. In "Project options" > "Diagram" every single option is checked. I still ran into the same problems as described in my previous post. For the procedure (as this is the only object, which gets added) the toolbar entry "Resolve All External References" is not available. Also right clicking the object in either the diagram or the "Objects in Project" list didn't provide me with an option "Add to Project" to resolve external references.

As far as I remember, Dependency Tracker worked for me before the latest update. I'm not 100% sure though, as I didn't pay attention what server versions I was connecting to before the update. As mentioned before, the problem only seems to occur on SQL Server 2012.

Thanks and kind regards,
Jens
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