Options
ERROR: Nullable object must have a value
ddelmoli
Posts: 16
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"
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"
Comments
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 –Ž.€Ž.‰.“
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
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 :
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
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