Command line "Object reference not set ..." error?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Command line "Object reference not set ..." error?

Postby freecell1 » Tue Mar 13, 2012 8:26 pm

I have a build script that loops through a set of databases and executes a command line sqlcompare on each one (identical arguments). On one of the databases I get an error at the end of the comparison:

Unexpected error: Object reference not set to an instance of an object.
[15:11:57]: [Exec] Object reference not set to an instance of an object.
(stack trace follows)

This is running in TeamCity via MSBuild. If I run from a command line myself it works. Can anyone suggest possible causes or ways to troubleshoot?
Posts: 21
Joined: Tue Mar 13, 2012 8:21 pm

Postby Chris Auckland » Fri Mar 16, 2012 10:54 am

Thanks for your post.

Could you try turning on the command line logging? It might give a better idea where the problem is:

Alias: /log
Default: None

Sets a minumum log level

Log files collect information about the application while you are using it. These files are useful to us if you have encountered a problem. By default, logging is disabled and no log files are stored.

Value Alias Description
None n Disables logging.
Error e Reports serious and fatal errors. For example, an error message might report a failed operation.
Warning w Reports warning and error messages. For example, a warning message might report a handled exception, or a problem which does not prevent you from using the application.
Verbose v Reports all messages in the log file.

The logs are normally created in '%USERPROFILE%\\AppData\\Local\\Red Gate\\Logs\\SQL Compare'
Chris Auckland
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby freecell1 » Fri Mar 16, 2012 5:03 pm

I've figured it out. It had to do with having UNSAFE c# CLR assemblies on the server. In that scenario the user must be in the sql admins group for the comparison to work, it seems. THat's why it worked when I ran it but not when the build system did.

We actually ended up revisiting usage of CLR functions and we going to stop making new ones, and also exclude them from sql source control. The actual C# project code is already in svn anyway.

Thanks for the suggestion.

Posts: 21
Joined: Tue Mar 13, 2012 8:21 pm

Return to SQL Compare 10

Who is online

Users browsing this forum: franckdumps and 2 guests