Null reference exception SCO v5.1.0.1030 /DMS-36240

jaspernygaardjaspernygaard Posts: 38 Bronze 1
edited January 11, 2019 12:24PM in Schema Compare for Oracle
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)

Tagged:
· Share on Twitter

Best Answers

  • Eddie DEddie D Posts: 1,807 Rose Gold 5
    Answer ✓
    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



    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • jaspernygaardjaspernygaard Posts: 38 Bronze 1
    Answer ✓
    @Eddie D , changing to the dedicated deployment user, solved the issue. Thanks
    · Share on Twitter
  • jaspernygaardjaspernygaard Posts: 38 Bronze 1
    Answer ✓
    Solved by using a user with the correct permission.
    · Share on Twitter

Answers

Sign In or Register to comment.