Red Gate forums :: View topic - ERROR: Nullable object must have a value
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle
Schema Compare for Oracle forum

ERROR: Nullable object must have a value

Search in Schema Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
ddelmoli



Joined: 07 Mar 2013
Posts: 12

PostPosted: Sun Sep 01, 2013 6:42 pm    Post subject: ERROR: Nullable object must have a value Reply with quote

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"
Back to top
View user's profile Send private message
ddelmoli



Joined: 07 Mar 2013
Posts: 12

PostPosted: Sun Sep 01, 2013 7:19 pm    Post subject: Reply with quote

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 –Ž.€Ž.‰.“()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Mon Sep 02, 2013 11:25 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
ddelmoli



Joined: 07 Mar 2013
Posts: 12

PostPosted: Mon Sep 02, 2013 4:37 pm    Post subject: Reply with quote

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 :
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Tue Sep 03, 2013 3:15 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Wed Sep 04, 2013 1:23 pm    Post subject: Reply with quote

Hi Dominic,

I believe this is fixed in this build:

http://download.red-gate.com/EAP/SchemaCompareforOracle/SchemaCompareforOracle_3.0.0.727.exe

Can you please try it and let me know?

Thanks,
Neil
Back to top
View user's profile Send private message
ddelmoli



Joined: 07 Mar 2013
Posts: 12

PostPosted: Tue Sep 17, 2013 3:07 am    Post subject: Reply with quote

Thanks Neil! I've just seen this (notifications must have been turned off) -- I'll get right on it and check!
Back to top
View user's profile Send private message
ddelmoli



Joined: 07 Mar 2013
Posts: 12

PostPosted: Tue Sep 24, 2013 12:32 am    Post subject: Reply with quote

Neil, looks like we've gotten past this error. I'm getting another one, but so far I can generate a scripts directory now.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group