Null reference exception SCO v5.1.0.1030 /DMS-36240

Hi
Trying to create an initial update to a folder (15000 objects) from an existing DB and receive a null reference exception. I'm using v5.1.0.1030 of SCO. Same problem if I uncheck 'Deploy all affected objects'.
Didn't get the error with v4.0.11.536. Any idea what is wrong?
Trying to create an initial update to a folder (15000 objects) from an existing DB and receive a null reference exception. I'm using v5.1.0.1030 of SCO. Same problem if I uncheck 'Deploy all affected objects'.
Didn't get the error with v4.0.11.536. Any idea what is wrong?
09:38:18.116|Error |Engine Service |1 |Exception in progress dialog
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.Oracle.SchemaCompare.Actions.ActionGenerators.UserObjectPrivilegesActionGenerator.TargetObjectIsMissing(PrivilegeDifference diffrence, DatabaseComparison comparison, IObjectMapper objectMapper)
at RedGate.Oracle.SchemaCompare.Actions.ActionGenerators.UserObjectPrivilegesActionGenerator.<GetMissingObjectsFromTarget>d__13.MoveNext()
at RedGate.Oracle.SchemaCompare.Actions.ActionGenerators.UserObjectPrivilegesActionGenerator.<FindSyncIssues2>d__9.MoveNext()
at System.Linq.Enumerable.<DistinctIterator>d__64`1.MoveNext()
at System.Linq.Enumerable.<ExceptIterator>d__73`1.MoveNext()
at RedGate.Oracle.SchemaCompare.Actions.ActionGenerators.UserObjectPrivilegesActionGenerator.FindSyncIssues(IEnumerable`1 differences, FindSyncIssuesState state)
at RedGate.Oracle.SchemaCompare.Actions.SyncActions.FindSyncIssues()
at RedGate.Oracle.Compare.EngineController.Schema.ProgressTasks.FindSyncIssuesProgressTask.<>c__DisplayClass0_0.<.ctor>b__0()
at RedGate.Shared.Controls.ProgressDialogEx.<>c__DisplayClass7.<DoTasks>b__4(Object q)
Tagged:
Best Answers
-
Eddie D Posts: 1,808 Rose Gold 5
Hi,
Looking at the attached log file, there are 15 entries prior to the Null Reference exception that report 'Finding sync issues in type 'RedGate.Oracle.SchemaCompare.Comparison.', like this example:Finding sync issues in type RedGate.Oracle.SchemaCompare.Comparison.TableDifference
This includes:- IndexDifference
- FunctionDifference
- ProcedureDifference
- TypeDifference
- PackageDifference
- PackageBodyDifference
- ViewDifference
- MaterializedViewDifference
- MaterializedViewLogDifference
- TriggerDifference
- SequenceDifference
- SynonymDifference
- PublicSynonymDifference
- UserOjectPrivilegesDifference
I suspect a permissions error, where the comparison engine is expecting a value where running queries for the above objects.
A support ticket has been created for you, ticket number is 127508.
Many Thanks
Eddie
-
jaspernygaard Posts: 38 Bronze 1
@Eddie D , changing to the dedicated deployment user, solved the issue. Thanks
Answers
Yes I sanitized the logs. I'll try to look into the permission issue and see if anything has changed.