When doing a Schema Compare and then a File | Print Preview, I get the following error:
System.ApplicationException
Unable to get root pair of schemas
Stack Trace:
at Quest.Compare.General.UI.CNSPrintReport.FillReport(CNSPrintEventArgs args)
at Quest.Compare.General.UI.SchemaCompareBase.SchemaCompareBasePanel.Print()
at Quest.Compare.Schema.DB2.Schema.Wrapper.DB2SchemaCompareForm.DoPrint(Boolean prompt)
at Quest.Toad.Gui.MainForm.printButton_ItemClick(Object sender, ItemClickEventArgs e)
at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link)
at DevExpress.XtraBars.BarBaseButtonItem.OnClick(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.BarItemLink.OnLinkActionCore(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 System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Issue occurs when tables in the schema compare has a primary key and other tables, not in schema compare, has a foreign key that is dependent on this primary key.
For an example:
CREATE SCHEMA "C1";
CREATE SCHEMA "C2";
CREATE SCHEMA "C3";
CREATE TABLE "C1"."T1" ("CT1" INTEGER NOT NULL, "CT2" INTEGER);
CREATE TABLE "C2"."T1" ("CT1" INTEGER NOT NULL, "CT2" INTEGER);
CREATE TABLE "C3"."TFK" ("CT1" INTEGER NOT NULL, "CT2" INTEGER);
ALTER TABLE "C1"."T1" ADD CONSTRAINT "PK1" PRIMARY KEY ("CT1");
ALTER TABLE "C3"."TFK"
ADD CONSTRAINT "FKKK1" FOREIGN KEY
("CT1")
REFERENCES "C1"."T1"
("CT1")
ON DELETE NO ACTION
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
Comparing C1/C2 always bring the print preview exception.
WORKAROUND: None
STATUS: Waiting for fix in a future release of Toad for DB2.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center