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

ERROR: Nullable object must have a value

I'm attempting to compare and deploy a full schema to an empty scripts folder. Schema is the Dell DVD Store Datatbase Test Suite found here: http://linux.dell.com/dvdstore/

I've installed the schema as DS2, and am running Schema Compare as the SYSTEM user. Comparison runs fine, but when deployment wizard runs (after I select "all objects") and displays the "Review dependencies window" I get a dialog box that says:

Schema Compare for Oracle - Aborting

Nullable object must have a value.

So far, single objects seem to run fine -- this only appears to happen when I select "all objects"
ddelmoli
0

Comments

7 comments

Sort by
  • ddelmoli
    Looks like it's erroring out on some specific tables, but I can't figure out why:

    18:07:34.115|Debug |exConstraintScripter|11 |:Scripting constraints for ds2.products
    18:07:34.115|Debug |exConstraintScripter|11 |:sw = CREATE TABLE ds2.products (
    prod_id NUMBER NOT NULL,
    "CATEGORY" NUMBER NOT NULL,
    title VARCHAR2(50 BYTE) NOT NULL,
    actor VARCHAR2(50 BYTE) NOT NULL,
    price NUMBER(12,2) NOT NULL,
    special NUMBER NOT NULL,
    common_prod_id NUMBER NOT NULL,

    parentSchema = DS2
    parentName = PRODUCTS
    constraint = pk_prod_id
    includeColumns = True
    includeIndexProperties = True
    includeStorage = True
    18:07:34.115|Debug |exConstraintScripter|11 |:constraint is not system named
    18:07:34.115|Debug |exConstraintScripter|11 |:using constraint name pk_prod_id
    18:07:34.115|Debug |exConstraintScripter|11 |:including columns
    18:07:34.115|Debug |exConstraintScripter|11 |:PROD_ID
    18:07:34.115|Debug |exConstraintScripter|11 |:index name now is PK_PROD_ID
    18:07:34.115|Debug |exConstraintScripter|11 |:constraint name = index name and index is unique
    18:07:34.115|Debug |ipters.IndexScripter|11 |:NORMAL INDEX ds2.pk_prod_id
    18:07:34.115|Debug |exConstraintScripter|11 |:ignoring USING INDEX
    18:07:34.177|Debug |Event Aggregator |1 |:Sending message RedGate.Oracle.Comparison.UI.Events.SelectedItemsChanged
    18:07:34.208|Debug |Event Aggregator |1 |:Sending message ‡.‡
    18:07:41.884|Fatal |Program |11 |:Exception in thread 11 ''
    System.InvalidOperationException: Nullable object must have a value.
    at System.Nullable`1.get_Value()
    at RedGate.Oracle.SchemaCompare.Scripters.ParallelScripter.GetParallelClause(Nullable`1 parallelDegree, Nullable`1 parallelInstances, Boolean beExplicit)
    at RedGate.Oracle.SchemaCompare.Scripters.IndexScripter.GetAlterParellelSql(IIndex index, IScriptInformation scriptInfo)
    at RedGate.Oracle.SchemaCompare.Scripters.TableScripter.#0v0c.#lBc()
    at RedGate.Oracle.SchemaCompare.Scripters.TableScripter.TablePropertiesRegion(ITable t, IScriptInformation scriptInfo)
    at RedGate.Oracle.SchemaCompare.Scripters.TableScripter.ScriptObject(ITable t, IScriptInformation scriptInfo)
    at #VNU.#iRK.#gAJ(ISchemaDifferenceRow #wBsc)
    at #ONU.#OQK.#gAJ()
    at –Ž.€Ž.‹‹(ISchemaDifferenceRow )
    at –Ž.€Ž.‰.“
    ddelmoli
    0
  • neil.anderson
    Hi DDelmoli,

    Thanks for letting us know about this. Can you please tell me what version of Schema Compare you are using when it hits this problem?

    Thanks,
    Neil
    neil.anderson
    0
  • ddelmoli
    From the top of the log file, looks like 3.0.0.719

    18:06:27.284|Info |Logging |1 |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
    18:07:05.130|Info |Object Model |5 |:Populating databases. Source: localhost(djd), Target C:\Users\ddelmoli\Documents\GitHub\Database\oracle\schemas\ds218:07:05.130|Info |Object Model |5 |:Program version 3.0.0.719
    18:07:05.145|Info |Object Model |5 |:Populating database localhost(djd)
    18:07:05.145|Trace |Object Model |5 |:Populating schemas DS2
    18:07:05.145|Info |Object Model |5 |:Initializing database connection
    18:07:05.145|Debug |Object Model |5 |:Opening connection
    18:07:05.145|Debug |Object Model |5 |:Devart.Data version 5.0.449.0
    18:07:05.145|Debug |Object Model |5 |:Devart.Data.Oracle version 6.80.350.0
    18:07:05.177|Debug |Object Model |5 |:Successfully selected from dba_users - using dba mode
    18:07:05.192|Debug |Object Model |5 |:Populating schema DS2
    18:07:05.333|Trace |Object Model |5 |:Database version: 11.2.0.1.0
    18:07:05.333|Trace |Object Model |5 |:Initializing object selector with schemas DS2
    18:07:05.333|Debug |Object Model |5 |:Opening connection
    18:07:05.333|Debug |Object Model |5 |:Devart.Data version 5.0.449.0
    18:07:05.333|Debug |Object Model |5 |:Devart.Data.Oracle version 6.80.350.0
    18:07:05.348|Debug |Object Model |5 |:Successfully selected from dba_users - using dba mode
    18:07:05.364|Debug |Object Model |5 |:Populating schema DS2
    18:07:05.364|Trace |Object Model |5 |:Database version: 11.2.0.1.0
    18:07:05.364|Trace |Object Model |5 |:Initializing object selector with schemas DS2
    18:07:05.379|Debug |Object Model |6 |:Populating dependencies for (DS2)
    18:07:05.379|Debug |Object Model |13 |:Populating dependencies for (DS2)
    18:07:05.395|Warn |Object Model |6 |:Fast dependencies enabled; some things may break
    18:07:05.395|Debug |localhost(djd) |6 |:Executing Dependencies Script 0 :
    ddelmoli
    0
  • neil.anderson
    Hi,

    I've been able to recreate this issue. Thanks for bringing it to our attention. I will fix it and be in touch with a new build.

    Thanks,
    Neil
    neil.anderson
    0
  • neil.anderson
    Hi Dominic,

    I believe this is fixed in this build:

    http://download.red-gate.com/EAP/Schema ... .0.727.exe

    Can you please try it and let me know?

    Thanks,
    Neil
    neil.anderson
    0
  • ddelmoli
    Thanks Neil! I've just seen this (notifications must have been turned off) -- I'll get right on it and check!
    ddelmoli
    0
  • ddelmoli
    Neil, looks like we've gotten past this error. I'm getting another one, but so far I can generate a scripts directory now.
    ddelmoli
    0

Add comment

Please sign in to leave a comment.