Null reference exception SCO v5.1.0.1030 /DMS-36240

jaspernygaard

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?

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)

Eddie D

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 believe the log file has been sanitized, as it only contains 30 entries and for 15,000 objects would be much bigger, most likely due to you making it public by uploading it to the forum.

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

@Eddie D , changing to the dedicated deployment user, solved the issue. Thanks

jaspernygaard

Solved by using a user with the correct permission.

jaspernygaard

Any input here?

jaspernygaard

Hi Eddie,

Yes I sanitized the logs. I'll try to look into the permission issue and see if anything has changed.