January 9, 2020 at 8:27 pm
I am starting to perform migrations of our Oracle Databases to SqlServer 2016. I can right click on the Oracle schema and select create report or create schema the process appears to run and fails with the above entry. Below is the log file entry that matches the above error. I have tried running repair on the install and I have also tried uninstalling and reinstalling the tool. I am running on the tool on the oracle end.
Thank you
Troy Sorbet
OS Windows Server 2012 R2
DB MSSQL Server 2016
SSMA Migration Assistant for Oracle V 8.5
[Error: Gui] [8924/11] [2020-01-09 14:21:47]: LowLevelAdapter.AssessmentTree : Assessment error: System.NullReferenceException: Object reference not set to an instance of an object.
at System.Collections.Generic.ObjectEqualityComparer`1.GetHashCode(T obj)
at System.Collections.Generic.HashSet`1.InternalGetHashCode(T item)
at System.Collections.Generic.HashSet`1.Contains(T item)
at Microsoft.SSMA.Framework.Oracle.SqlServerTreeConverter.Oracle2SqlServerTreeConverter.ShouldProcessNotCheckableObjects(XNode sourceSubtree)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser2.CollectSubTree(TContext context, TState state, XNode sourceSubtree, HashSet1 objectsToProcess, HashSet1 affectedNodes, TreeCheckManager manager, IUIStopOperationProvider stopOperationProvider, List1 notLoadedObjects)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser2.CollectSubTree(TContext context, TState state, XNode sourceSubtree, HashSet1 objectsToProcess, HashSet1 affectedNodes, TreeCheckManager manager, IUIStopOperationProvider stopOperationProvider, List1 notLoadedObjects)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser2.CollectSubTree(TContext context, TState state, XNode sourceSubtree, HashSet1 objectsToProcess, HashSet1 affectedNodes, TreeCheckManager manager, IUIStopOperationProvider stopOperationProvider, List1 notLoadedObjects)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser2.CollectSubTree(TContext context, TState state, XNode sourceSubtree, HashSet1 objectsToProcess, HashSet1 affectedNodes, TreeCheckManager manager, IUIStopOperationProvider stopOperationProvider, List1 notLoadedObjects)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser2.CollectSubTree(TContext context, TState state, XNode sourceSubtree, HashSet1 objectsToProcess, HashSet1 affectedNodes, TreeCheckManager manager, IUIStopOperationProvider stopOperationProvider, List1 notLoadedObjects)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser2.CollectSubTree(TContext context, TState state, XNode sourceSubtree, HashSet1 objectsToProcess, HashSet1 affectedNodes, TreeCheckManager manager, IUIStopOperationProvider stopOperationProvider, List1 notLoadedObjects)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser2.CollectSubTree(TContext context, TState state, XNode sourceSubtree, HashSet1 objectsToProcess, HashSet1 affectedNodes, TreeCheckManager manager, IUIStopOperationProvider stopOperationProvider, List1 notLoadedObjects)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser2.GetNodesToProcess(TContext context, TState state, XNode subtree, HashSet1 nodesToProcess, HashSet1 affectedNodes, List1 notLoadedObjects, IUIStopOperationProvider stopOperationProvider, IUIOutputWindowProvider outputWindow)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser`2.TraverseTree(TContext context, TState state, XNode sourceNode)
at Microsoft.SSMA.Framework.Generic.Factories.Utils.OpTreeTraverser`2.TraverseTree(TContext context, TState state, XNode sourceNode)
at Microsoft.SSMA.Framework.Generic.TreeConverters.Default.DefaultTreeConverter.ConvertTree(XNode sourceNode, ITreeConversionContext context)
at Microsoft.SSMA.GUI.Generic.LowLevel.AppCommandProcessing.Commands.SsmaAppAssessmentCommand.StartAssess(Object context).
January 9, 2020 at 9:15 pm
Are you using the latest version of SSMS? And did you also install the SSMA for Oracle Extension Pack that comes with the download?
This is a link to download the latest version. The page lists the requirements as well as installation requirements which you'd want to make sure you follow:
Microsoft SQL Server Migration Assistant 8.5 for Oracle
Sue
January 10, 2020 at 5:53 pm
I don't see SSMS as a listed prerequisite for the SSMA installation. This is installed on the Oracle server with the a remote connection to the MSSQL server. I have used the latest version of the SSMA I haven't tried the installation on the SQL server side, it should matter but I will try that next.
Troy
January 10, 2020 at 6:17 pm
Sorry...typo. I meant the latest version of SSMA.
The download instruction include: In addition to the SSMA program files, you must also install the SSMA for Oracle Extension Pack on the SQL Server machine.
Sue
January 10, 2020 at 8:14 pm
That was all done, I just did the install on the sqlserver side and no difference same error message on the same spot. I even tried running a repair after the install.
Troy
January 22, 2021 at 9:25 pm
Hi Troy, i had the same error with the latest SSMA version 8.16 an older version 8.11 (SSMA + extension pack) worked flawless for me.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply