User profile for Nir_Kornfled – Support

Activity overview Badges (0) Posts (0) Comments (2)

Comments

OK. Found it! [image] I hope... A database with a table function and a non-english comment in it will raise the error, making SQLCompare fail to compare it with any other database or image. Example - The following function created to an empty database will fail SQLCompare: create function dbo.udfTest() returns @Res table (a1 int) as begin -- אא return end Same function exactly with english remark works fine! create function dbo.udfTest() returns @Res table (a1 int) as begin -- aa return end This happens with the latest version 3.1.9.12 and did not in earlier versions! :evil: Following is the callstack when simply trying to display the changes on this function: ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at RedGate.SQL.Shared.ExecutionBlock.ᐁ(String , Boolean , Boolean ) at RedGate.SQL.Shared.ExecutionBlock.AddBatch(String batch) at RedGate.SQLCompare.Engine.Work.ᐁ(IBlockWriter , Function , Options ) at RedGate.SQLCompare.Engine.Work.BuildFromDifferences(Differences differences, Difference onlyDifferenceToInclude, Options options, Boolean runOnTwo) at ᐉ.ᐄ() at ᐉ.ᐁ(Difference ) at ᐏ.ᐂ(Difference ) at ᐏ.ᐁ(Difference ) at ᐅ.ᐁ(Object , EventArgs ) at RedGate.SQL.Grids.GridControl.OnGridCellSelected(GridCellSelectedEventArgs e) at RedGate.SQL.Grids.GridControl.set_SelectedCell(SelectedCell value) at ᐅ.ᐁ(Difference , Int32 ) at ᐅ.ᐁ(Differences ) at ᐏ.ᐑ() at ᐏ.ᐎ() at ᐏ.ᐁ(Object , ItemClickEventArgs ) at DevExpress.XtraBars.BarManager.OnClickItem(BarItem item, BarItemLink link) at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link) at DevExpress.XtraBars.BarButtonItem.OnClick(BarItemLink link) at DevExpress.XtraBars.BarItem.OnClickCore(BarItemLink link) at DevExpress.XtraBars.BarItemLink.OnLinkClick() at DevExpress.XtraBars.BarItemLink.OnLinkAction(BarLinkAction action, Object actionArgs) at DevExpress.XtraBars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs) at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.ClickLink(BarItemLink link) at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link) at DevExpress.XtraBars.Controls.CustomLinksControl.OnMouseUp(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) I need a quick fix - my release is delayed because I was stupid to update SQLCompare before it. [image] Red-Gate people - please respond. Thank you. / comments

OK. Found it! I hope... A database with a table function and a non-english comment in it will raise the error, making SQLCompare fail to compare it with any other database or image. Example - Th...

0 votes

Hello, I've read the thread but nothing seems to solve the error on my database. I get this error while trying to compare a specific database to a snapshot or to another database. Trying to compare a snapshow of the database results to the same error. I'm using SQLCompare 3.1.9.12 Is there a way to see where the error occurs in SQLCompare? I'm currently stuck and can not make a release! Please hurry. / comments

Hello, I've read the thread but nothing seems to solve the error on my database. I get this error while trying to compare a specific database to a snapshot or to another database. Trying to compare...

0 votes

Total activity: 3
Last activity: February 06, 2025 09:23
Member since: February 06, 2025 09:22

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 1