ERROR: Nullable object must have a value

Compares and synchronizes the schemas of Oracle databases

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

ERROR: Nullable object must have a value

Postby ddelmoli » Sun Sep 01, 2013 6:42 pm

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
 
Posts: 12
Joined: Thu Mar 07, 2013 7:58 pm

Postby ddelmoli » Sun Sep 01, 2013 7:19 pm

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
 
Posts: 12
Joined: Thu Mar 07, 2013 7:58 pm

Postby neil.anderson » Mon Sep 02, 2013 11:25 am

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
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby ddelmoli » Mon Sep 02, 2013 4:37 pm

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
 
Posts: 12
Joined: Thu Mar 07, 2013 7:58 pm

Postby neil.anderson » Tue Sep 03, 2013 3:15 pm

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
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby neil.anderson » Wed Sep 04, 2013 1:23 pm

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
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby ddelmoli » Tue Sep 17, 2013 3:07 am

Thanks Neil! I've just seen this (notifications must have been turned off) -- I'll get right on it and check!
ddelmoli
 
Posts: 12
Joined: Thu Mar 07, 2013 7:58 pm

Postby ddelmoli » Tue Sep 24, 2013 12:32 am

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
 
Posts: 12
Joined: Thu Mar 07, 2013 7:58 pm


Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 1 guest