Red Gate forums :: View topic - Object reference not set to an instance of an object errors
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

Object reference not set to an instance of an object errors

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
david.duffett



Joined: 02 Jul 2010
Posts: 20

PostPosted: Fri Jul 02, 2010 12:17 pm    Post subject: Object reference not set to an instance of an object errors Reply with quote

I managed to commit quite a few objects to SVN, but on many I am getting an Object reference not set to an instance of an object exception.

Anyone else getting this?

Some system information:

- Using SQL Server 2008 R2
- Running local database committing to local Visual SVN repository

Happens on various types of objects (Schema, Stored Procs, Roles, Users) - didn't seem to happen on Tables, and didn't happen on ALL of the objects of those types (some were successfully committed).
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Fri Jul 02, 2010 6:05 pm    Post subject: Reply with quote

Thanks for letting us know.

Would you be able to to try synching your database schema to a blank database (newly created) using SQL Compare 8, just so we can narrow it down? It would be great for us to identify the troublesome object.

Kind regards,

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
luan_au



Joined: 05 Jul 2010
Posts: 2

PostPosted: Mon Jul 05, 2010 1:49 pm    Post subject: Reply with quote

I am not sure if it's related but I hit an error trying out SQL Source Control this morning. My steps were as follow,

1.Created svn folder (F1)
2.Link database DB1 to the svn folder
3.Successfuly committed DB1 to subversion
4.Unlinked DB1 from source control
5.Link DB2 (same as DB1 but with modifications) to svn folder F1
6.Go to Commit Changes tab (hoping to see differences)
...a lot of processing happens for a while but then the following error occured:

RedGate.SQLSourceControl.Engine.InvalidStateException: Can't find a file path for User name SunBrowser ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 298, offset:56 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1796, offset:370 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1795, offset:13 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2202, offset:28 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 219, offset:134 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 203, offset:11 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 217, offset:109 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 239, offset:28 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 244, offset:8 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2165, offset:204 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1764, offset:99 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1763, offset:52 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1229, offset:25 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1226, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2065, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1928, offset:117 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 203, offset:11 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 248, offset:137 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 724, offset:26 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2314, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1357, offset:120 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1359, offset:21 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1504, offset:13
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at #oEc.#i3l.GetFullPath(IDatabaseObject dbObject)
at RedGate.SQLSourceControl.Engine.ToRetrieveChangeSet.#paj(ScriptSynchronizationActions scriptActions, Differences differences)
at RedGate.SQLSourceControl.Engine.ToRetrieveChangeSet.#oaj(ICancellableOperationStatus status, WarningsAccepter accepter, ISourceControlUserCallBacks callBacks, FilesToUpgrade& filesToUpgrade)
at RedGate.SQLSourceControl.Engine.ToRetrieveChangeSet.#t.#TXd.#Xkz(ICancellableOperationStatus x)
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperation.#i5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(Action action)
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperation.Invoke()
at RedGate.SQLSourceControl.Engine.Cancellables.MultiStepCancellableOperation.#m1f(ICancellableOperationStatus status, IMultiStepCancellableOperation operation)
at #eEc.#jfd.#m1f(ICancellableOperationStatus status, #jfd operation)
at #oEc.#i7c.#t.#z2.#hOi()
at #oEc.#i7c.#bOi[TDiffType](ICancellableOperationStatus status, Func`1 innerBuild)
at #oEc.#i7c.#q1f(ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks, ScriptDatabaseInformation folderOptions)
at #oEc.#4Ec.#z7c(ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks)
at #oEc.#4Ec.#7Jc(ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks)
at #oEc.#4Ec.#t.#A2.#D7c(ICancellableOperationStatus status)
at #eEc.#iEc.#t.#u3.#k5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(Action action)
at #eEc.#iEc.Invoke()
at #JLc.#Qlg.Invoke()
at #JLc.#PLc.#t.#Jfb.#EJf()
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action toDo, Predicate`1 shouldReportPredicate, Boolean rethrow)
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token)
Back to top
View user's profile Send private message
luan_au



Joined: 05 Jul 2010
Posts: 2

PostPosted: Wed Jul 07, 2010 11:59 am    Post subject: Reply with quote

Silence is golden! Very Happy
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Wed Jul 07, 2010 12:05 pm    Post subject: Reply with quote

Apologies. This has been escalated to the project team. We'll try to give you a more meaningful response by the end of today.

Thanks for bearing with us.

David
Back to top
View user's profile Send private message Send e-mail
simon.jackson



Joined: 08 Jan 2009
Posts: 45

PostPosted: Thu Jul 08, 2010 8:39 am    Post subject: Reply with quote

luan_au,

Sorry for the delay in replying. Thanks for submitting the problem you had, both here and from within the product.

The problem you have seen occurs when the working copy of the database contains a statement such as

EXEC sp_addrolemember N'role_name', N'SunBrowser'
GO

But not the corresponding
CREATE USER SunBrowser

statement.

We are working on a fix for this issue (SOC-845). You should be able to carry on working if you SVN update (using tortoise, or any other SVN client) the Security\Users and Security\Schemas folders in your working base in order to make sure that the create user statement exists. I will PM you with the precise details for your case.
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