Exception when I click Synchonize button in Schema Compare tool

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Maggus1985
Posts: 1
Joined: Tue 12 May 2020 06:44

Exception when I click Synchonize button in Schema Compare tool

Post by Maggus1985 » Tue 12 May 2020 06:49

Hi
Im trying to compare two oracle 12.2 databases.
Latest compare tool version: 4.1.28 Professional Edition

When I click synchronize I have error

=========================
General
=========================
Application: dbForge Schema Compare for Oracle
Product: Devart dbForge Schema Compare for Oracle
Product Edition: Professional
Product Locale: English
Trial Info: Activated
HardwareID: 0C74-A3E6-0CB8-6544-5CD4
Assembly: schemacompare, Version=4.1.28.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\Compare Bundle for Oracle\dbForge Schema Compare for Oracle\schemacompare.exe
Global cache: False
Framework: 4.6.2 or later

=========================
Exception Information
=========================
Place: 2
ExceptionId: b71307a6-f70a-4be2-9931-8263873bfb1d
Message: Object reference not set to an instance of an object.
Source: Devart.DbForge.DbObjects.Oracle
TargetSite: Void see64n873y(Devart.DbForge.DbObjects.Oracle.OracleTable)
HelpLink:
Type: System.NullReferenceException
Stack:
at Devart.DbForge.DbObjects.Oracle.OracleTableDifference.see64n873y(OracleTable )
at Devart.DbForge.DbObjects.Oracle.OracleTableDifference.Merge(IDbObject result, ISchemaSyncContext context)
at Devart.DbForge.DbObjects.Oracle.OracleTableDifference.GetRecreateTableActions(IList`1 removeDependenciesActions, IList`1 invalidDependencies, IDictionary`2 detachedActionsMap, ISchemaSyncContext context)
at Devart.DbForge.DbObjects.Oracle.OracleTableDifference.GetRecreateActions(IList`1 removeDependenciesActions, IList`1 invalidDependencies, IDictionary`2 detachedActionsMap, ISchemaSyncContext context)
at Devart.DbForge.DbObjects.Difference`1.GetSyncActions(IList`1 removeDependenciesActions, IList`1 invalidDependencies, IDictionary`2 detachedActions, ISchemaSyncContext context)
at Devart.DbForge.DbObjects.Oracle.OracleTableDifference.GetSyncActions(IList`1 removeDependenciesActions, IList`1 invalidDependencies, IDictionary`2 detachedActions, ISchemaSyncContext context)
at Devart.DbForge.Synchronization.Schema.ObjectSynchronizer.SynchronizeTargetObject(SynchronizationContext context, SyncObject syncObject)
at Devart.DbForge.Synchronization.Schema.ActionComposer.<>c__DisplayClass0_0.<GenerateSyncActions>b__1(SynchronizationContext _context, SyncObject syncObject)
at Devart.DbForge.Synchronization.Schema.ObjectSynchronizer.SynchronizeObjects(SynchronizationContext context, IList`1 objects, SynchronizeObjectDelegate syncProcedure)
at Devart.DbForge.Synchronization.Schema.ActionComposer.GenerateSyncActions(SynchronizationContext context)
at Devart.DbForge.Compare.SchemaSynchronization.fW5OW0GWUD(Boolean )
at Devart.DbForge.Compare.SchemaSynchronization.UpdateAdditionalDependencies()
at Devart.DbForge.Compare.SchemaSynchronization.GetSyncActions()
at Devart.DbForge.Compare.SchemaComparisonControl.DoSynchronize(Boolean runInMainThread)
at Devart.DbForge.Compare.ComparisonControl`1.QDZaOibA2J(ICommand , CommandStatus& , Object )
at Devart.Shell.Common.CommandTargetHelper.InvokeCommand(ICommand command, Object instance)
at Devart.DbForge.Compare.ComparisonPopupProvider.InvokeCommand(ICommand command, Object instance)
at Devart.DbForge.Compare.ComparisonControl`1.InvokeCommand(ICommand command, Object instance)
at Devart.Shell.CommandService.InvokeCommand(ICommand command, Object instance, IList`1 commandTargetChain)
at Devart.Shell.CommandBarBase.OnItemClicked(IInternalBarControl control)
at Devart.Shell.CommandBarButton.Button_Click(Object sender, ItemClickEventArgs e)
at Controls.Bars.BarItem.OnClick(BarItemLink link)
at Controls.Bars.BarButtonItem.OnClick(BarItemLink link)
at Controls.Bars.BarItemLink.OnLinkClick()
at Controls.Bars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)
at Controls.Bars.ViewInfo.BarSelectionInfo.ClickLink(BarItemLink link)
at Controls.Bars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link)
at Controls.Bars.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 Controls.Bars.Controls.DockedBarControl.WndProc(Message& msg)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


=========================
Window Layout
=========================
Active document window: 'cs.scomp*' (Compare)
Active window: 'cs.scomp*'
Active document 'cs.scomp'

Documents:
Name: 'schema.scomp', Caption: 'schema.scomp', Visible: False, Initial view: ''

Name: 'cs.scomp', Caption: 'cs.scomp*', Visible: True, Active view: 'Compare', Initial view: 'Compare'

Toolwindows (visible or have been shown in current session):
Caption: 'Schema Update Script', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Error List', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Output', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'False', Caption: 'Start Page', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed

=========================
Connections
=========================
sys@vmora (open) - 'User Id=sys;Server=vmora;Connect Mode=SysDba;Unicode=True'. Server version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production. Client version: 12.2.0.0
sys@vmora2 (open) - 'User Id=sys;Server=vmora2;Connect Mode=SysDba;Unicode=True'. Server version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production. Client version: 12.2.0.0

=========================
Execution History
=========================
Store queries: True
Store period : 60 (days)
Available period : 60 (days)
Folder: %appdata%\Devart\dbForge Schema Compare for Oracle\ExecutedQueries
Max script size: 1024 (KB)
Initial interval: Week
History folder content:
C:\Users\Mateusz\AppData\Roaming\Devart\dbForge Schema Compare for Oracle\ExecutedQueries\ExecutedQueries.db (241664 B)

=========================
Loaded Assemblies
=========================
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Accessibility\v4.0_4.0.0.0__b03f5f7f11d50a3a
Accessibility.dll
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\Program Files\Devart\Compare Bundle for Oracle\dbForge Schema Compare for Oracle
Autofac.dll
Autofac, Version=4.2.1.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.AnalyticsCore.dll
Devart.AnalyticsCore, Version=1.0.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Antlr3.Runtime.dll
Devart.Antlr3.Runtime, Version=1.0.10.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Common.Oracle.dll
Devart.DbForge.Common.Oracle, Version=4.1.94.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.CommonServices.dll
Devart.DbForge.CommonServices, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Compare.dll
Devart.DbForge.Compare, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Compare.Oracle.dll
Devart.DbForge.Compare.Oracle, Version=4.1.94.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Data.Interfaces.dll
Devart.DbForge.Data.Interfaces, Version=5.0.22.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Data.Oracle.dll
Devart.DbForge.Data.Oracle, Version=5.0.162.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DataEditor.dll
Devart.DbForge.DataEditor, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DbObjects.dll
Devart.DbForge.DbObjects, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DbObjects.Oracle.dll
Devart.DbForge.DbObjects.Oracle, Version=4.1.94.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DeclarationRepository.dll
Devart.DbForge.DeclarationRepository, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.DeclarationRepository.Oracle.dll
Devart.DbForge.DeclarationRepository.Oracle, Version=4.1.94.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.ExecutionHistory.dll
Devart.DbForge.ExecutionHistory, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Interfaces.dll
Devart.DbForge.Interfaces, Version=4.0.84.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.LanguageService.dll
Devart.DbForge.LanguageService, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.LanguageService.Oracle.dll
Devart.DbForge.LanguageService.Oracle, Version=4.1.94.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Oracle.dll
Devart.DbForge.Oracle, Version=4.1.94.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Provider.dll
Devart.DbForge.Provider, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Resources.dll
Devart.DbForge.Resources, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Resources.Oracle.dll
Devart.DbForge.Resources.Oracle, Version=4.1.94.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.SchemaTools.dll
Devart.DbForge.SchemaTools, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.SchemaTools.Oracle.dll
Devart.DbForge.SchemaTools.Oracle, Version=4.1.94.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.SqlComplete.dll
Devart.DbForge.SqlComplete, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.SqlComplete.Oracle.dll
Devart.DbForge.SqlComplete.Oracle, Version=4.1.94.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.TextComparer.dll
Devart.DbForge.TextComparer, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.UI.dll
Devart.DbForge.UI, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.Utils.dll
Devart.DbForge.Utils, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.DbForge.VersionControl.dll
Devart.DbForge.VersionControl, Version=6.1.1556.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Ole.UndoManager.dll
Devart.Ole.UndoManager, Version=1.0.1352.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Shell.Compare.dll
Devart.Shell.Compare, Version=2.1.22.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Shell.Core.dll
Devart.Shell.Core, Version=2.1.22.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Shell.Resources.dll
Devart.Shell.Resources, Version=2.1.22.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Shell.Studio.dll
Devart.Shell.Studio, Version=2.1.22.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Devart.Shell.UI.dll
Devart.Shell.UI, Version=2.1.22.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Data.v18.1.dll
DevExpress.Data.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Mvvm.v18.1.dll
DevExpress.Mvvm.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Utils.v18.1.dll
DevExpress.Utils.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Xpf.Core.v18.1.dll
DevExpress.Xpf.Core.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Xpf.Themes.VS2017Dark.v18.1.dll
DevExpress.Xpf.Themes.VS2017Dark.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraBars.v18.1.dll
DevExpress.XtraBars.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraEditors.v18.1.dll
DevExpress.XtraEditors.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraGrid.v18.1.dll
DevExpress.XtraGrid.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraLayout.v18.1.dll
DevExpress.XtraLayout.v18.1, Version=18.1.4.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Ionic.Zip.dll
Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c
LiteDB.dll
LiteDB, Version=3.1.4.0, Culture=neutral, PublicKeyToken=4ee40123013c9f27
Newtonsoft.Json.dll
Newtonsoft.Json, Version=12.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed
ParallelExtensionsExtras.dll
ParallelExtensionsExtras, Version=1.2.3.0, Culture=neutral, PublicKeyToken=665f4d61f853b5a9
schemacompare.exe
schemacompare, Version=4.1.28.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Windows\Microsoft.NET\Framework64\v4.0.30319
mscorlib.dll
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_64\PresentationCore\v4.0_4.0.0.0__31bf3856ad364e35
PresentationCore.dll
PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework\v4.0_4.0.0.0__31bf3856ad364e35
PresentationFramework.dll
PresentationFramework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework.Aero2\v4.0_4.0.0.0__31bf3856ad364e35
PresentationFramework.Aero2.dll
PresentationFramework.Aero2, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework-SystemXml\v4.0_4.0.0.0__b77a5c561934e089
PresentationFramework-SystemXml.dll
PresentationFramework-SystemXml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\SMDiagnostics\v4.0_4.0.0.0__b77a5c561934e089
SMDiagnostics.dll
SMDiagnostics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089
System.dll
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ComponentModel.Composition\v4.0_4.0.0.0__b77a5c561934e089
System.ComponentModel.Composition.dll
System.ComponentModel.Composition, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ComponentModel.DataAnnotations\v4.0_4.0.0.0__31bf3856ad364e35
System.ComponentModel.DataAnnotations.dll
System.ComponentModel.DataAnnotations, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.Configuration.dll
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089
System.Core.dll
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089
System.Data.dll
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Data.Linq\v4.0_4.0.0.0__b77a5c561934e089
System.Data.Linq.dll
System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.Drawing.dll
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\WINDOWS\Microsoft.Net\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.EnterpriseServices.dll
System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.IdentityModel\v4.0_4.0.0.0__b77a5c561934e089
System.IdentityModel.dll
System.IdentityModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.IdentityModel.Selectors\v4.0_4.0.0.0__b77a5c561934e089
System.IdentityModel.Selectors.dll
System.IdentityModel.Selectors, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Management\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.Management.dll
System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Net.Http\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.Net.Http.dll
System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089
System.Numerics.dll
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089
System.Runtime.Serialization.dll
System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a
System.Security.dll
System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel\v4.0_4.0.0.0__b77a5c561934e089
System.ServiceModel.dll
System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Internals\v4.0_4.0.0.0__31bf3856ad364e35
System.ServiceModel.Internals.dll
System.ServiceModel.Internals, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\WINDOWS\Microsoft.Net\assembly\GAC_64\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089
System.Transactions.dll
System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ValueTuple\v4.0_4.0.0.0__cc7b13ffcd2ddd51
System.ValueTuple.dll
System.ValueTuple, Version=4.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089
System.Windows.Forms.dll
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089
System.Xaml.dll
System.Xaml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089
System.Xml.dll
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\UIAutomationClient\v4.0_4.0.0.0__31bf3856ad364e35
UIAutomationClient.dll
UIAutomationClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\UIAutomationProvider\v4.0_4.0.0.0__31bf3856ad364e35
UIAutomationProvider.dll
UIAutomationProvider, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\UIAutomationTypes\v4.0_4.0.0.0__31bf3856ad364e35
UIAutomationTypes.dll
UIAutomationTypes, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\WindowsBase\v4.0_4.0.0.0__31bf3856ad364e35
WindowsBase.dll
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\WindowsFormsIntegration\v4.0_4.0.0.0__31bf3856ad364e35
WindowsFormsIntegration.dll
WindowsFormsIntegration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

Dynamic Assemblies :
C:\WINDOWS\Microsoft.Net\assembly\GAC_64\mscorlib\v4.0_4.0.0.0__b77a5c561934e089
mscorlib.dll
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null
C:\Program%20Files\Devart\Compare%20Bundle%20for%20Oracle\dbForge%20Schema%20Compare%20for%20Oracle
Devart.DbForge.Data.Oracle.dll
OciCall.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null
DevExpress.Xpf.Core.v18.1.dll
ReflectionHelperTypesPublicWrappers, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null

=========================
Thread Information
=========================
Name:
Priority: Normal
ThreadState: Running
CurrentCulture:
ApartmentState: STA
IsThreadPoolThread: False
IsAlive: True
IsBackground: False

=========================
System Information
=========================
Processor architecture: amd64
Processor quantity: 8
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12

Total physical memory: 32683Mb
Total available paginal memory: 16695Mb
Process available virtual memory: 134211590Mb
Process private memory size: 621Mb
Display1: 2560x1440, 100% DPI
Display2: 2560x1440, 100% DPI

Operating System Name: Windows 10 Pro
Operating System Version: Microsoft Windows NT 10.0.17763.0
UAC status: Enabled
UAC level: Notify when app try to make changes
Is user in admin group: True
Is run as admin: False
Is process elevated: False
Elevation type: Limited
Integrity level: Medium

Instances: 1
Culture: English (United States)
Process started at 05/12/2020 08:01:03
Report created at 05/12/2020 08:41:59\

Exception is generated when I try to generate script for table:

New version:

CREATE TABLE DBO.xx (
ID NUMBER(10, 0) NOT NULL,
DESCRIPTION NVARCHAR2(250) NOT NULL,
VALUEONE NVARCHAR2(1024) NOT NULL,
VALUEONELOOKUP NVARCHAR2(50),
VALUEONEKEY NVARCHAR2(50) NOT NULL,
VALUETWO NVARCHAR2(1024) NOT NULL,
VALUETWOLOOKUP NVARCHAR2(50),
VALUETWOKEY NVARCHAR2(50) NOT NULL,
STATUSID NUMBER(10, 0) NOT NULL,
LEGALENTITYID NUMBER(10, 0) NOT NULL,
CREATEDDATE TIMESTAMP(6) NOT NULL,
CREATEDBY NVARCHAR2(50) NOT NULL,
LASTUPDATEDBY NVARCHAR2(50) NOT NULL,
LASTUPDATEDDATE TIMESTAMP(6) NOT NULL,
ISACTIVE NUMBER(1, 0) NOT NULL,
RESOLUTIONTYPEID NUMBER(10, 0) NOT NULL,
INCONSISTENCYTYPEID NUMBER(5, 0) DEFAULT 1 NOT NULL,
CONSTRAINT PK_INCONSISTENCY PRIMARY KEY (ID),
CONSTRAINT FK_INCONSISTENCY_LEGALENTITYID FOREIGN KEY (LEGALENTITYID)
REFERENCES DBO.LEGALENTITY(ID),
CONSTRAINT FK_INCONSISTENCY_RESOLUTIONID FOREIGN KEY (RESOLUTIONTYPEID)
REFERENCES DBO.LOOKUPVALUE(ID),
CONSTRAINT FK_INCONSISTENCY_STATUSID FOREIGN KEY (STATUSID)
REFERENCES DBO.LOOKUPVALUE(ID),
CONSTRAINT INCONSISTENCY_INCTYPE_FK FOREIGN KEY (INCONSISTENCYTYPEID)
REFERENCES DBO.INCONSISTENCYTYPE(ID))
LOGGING;

Old version

CREATE TABLE DBO.xx (
ID NUMBER(10, 0) NOT NULL,
DESCRIPTION NVARCHAR2(250) NOT NULL,
VALUEONE NUMBER(10, 0) NOT NULL,
VALUEONELOOKUP NVARCHAR2(50) NOT NULL,
VALUEONEKEY NVARCHAR2(50) NOT NULL,
VALUETWO NUMBER(10, 0) NOT NULL,
VALUETWOLOOKUP NVARCHAR2(50) NOT NULL,
VALUETWOKEY NVARCHAR2(50) NOT NULL,
STATUSID NUMBER(10, 0) NOT NULL,
LEGALENTITYID NUMBER(10, 0) NOT NULL,
CREATEDDATE TIMESTAMP(6) NOT NULL,
CREATEDBY NVARCHAR2(50) NOT NULL,
LASTUPDATEDBY NVARCHAR2(50) NOT NULL,
LASTUPDATEDDATE TIMESTAMP(6) NOT NULL,
ISACTIVE NUMBER(1, 0) NOT NULL,
RESOLUTIONTYPEID NUMBER(10, 0) NOT NULL,
CONSTRAINT PK_INCONSISTENCY PRIMARY KEY (ID),
CONSTRAINT FK_INCONSISTENCY_LEGALENTITYID FOREIGN KEY (LEGALENTITYID)
REFERENCES DBO.LEGALENTITY(ID),
CONSTRAINT FK_INCONSISTENCY_RESOLUTIONID FOREIGN KEY (RESOLUTIONTYPEID)
REFERENCES DBO.LOOKUPVALUE(ID),
CONSTRAINT FK_INCONSISTENCY_STATUSID FOREIGN KEY (STATUSID)
REFERENCES DBO.LOOKUPVALUE(ID))
LOGGING;

alexa

Re: Exception when I click Synchonize button in Schema Compare tool

Post by alexa » Tue 12 May 2020 17:43

Could you please perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce this issue and send us the *.log file with the latest date from the folder:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Schema Compare for Oracle\
You can send the reply straight to our support system at supportATdevartDOTcom .

brandscill
Posts: 8
Joined: Thu 01 Aug 2019 12:53

Re: Exception when I click Synchonize button in Schema Compare tool

Post by brandscill » Fri 05 Jun 2020 07:54

I have the same issue. Did you ever get a resolution? I've emailed support with the logs.

alexa

Re: Exception when I click Synchonize button in Schema Compare tool

Post by alexa » Sat 06 Jun 2020 11:44

Could you please provide us the CREATE definitions of the compared Source and Target objects causing the error?

brandscill
Posts: 8
Joined: Thu 01 Aug 2019 12:53

Re: Exception when I click Synchonize button in Schema Compare tool

Post by brandscill » Sat 06 Jun 2020 21:29

What do you mean sorry?

Given I've raised a support request but had no response what channel does devart generally use for official support when dealing with customers paying an annual licence fee?

brandscill
Posts: 8
Joined: Thu 01 Aug 2019 12:53

Re: Exception when I click Synchonize button in Schema Compare tool

Post by brandscill » Sat 06 Jun 2020 21:40

If you're asking for the database definition then it's huge.

The difference between it crashing and not crashing seems to be that if I don't compare foreign keys, primary keys and constraints it crashes.

alexa

Re: Exception when I click Synchonize button in Schema Compare tool

Post by alexa » Tue 09 Jun 2020 08:43

Thank you for replying by e-mail on this.

Please let us know if any questions arise.

Post Reply