How can we help you today? How can we help you today?

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?

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)

jaspernygaard
0

Comments

5 comments

Sort by
  • jaspernygaard
    Any input here?
    jaspernygaard
    0
  • 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



    Eddie D
    0
  • jaspernygaard
    Hi Eddie,

    Yes I sanitized the logs. I'll try to look into the permission issue and see if anything has changed.
    jaspernygaard
    0
  • jaspernygaard
    @Eddie D , changing to the dedicated deployment user, solved the issue. Thanks
    jaspernygaard
    0
  • jaspernygaard
    Solved by using a user with the correct permission.
    jaspernygaard
    0

Add comment

Please sign in to leave a comment.