How can we help you today? How can we help you today?
ddelmoli
Activity overview Badges (0) Posts (4) Comments (8)

Activity overview

Latest activity by ddelmoli

WARNING: Schema names in deployment scripts and "Run As"
  1. Community
  2. Schema Compare for Oracle
I know that in the Behavior options for the project, I can configure SCO to exclude schema names in the deployment script. However, this can be confusing if the target schema differs from the conne...
0 followers 0 comments 0 votes
Thank you, Neil -- this fixed the issue. / comments
  1. Community
  2. Schema Compare for Oracle
  3. ERROR: Sequence contains no matching element
Thank you, Neil -- this fixed the issue.
0 votes
ERROR: Sequence contains no matching element
  1. Community
  2. Schema Compare for Oracle
Currently running Program version 3.0.0.763 I've successfully generated the DS2 schema into a scripts folder, with the only non-default option being to ignore schema names. However, when I now atte...
2 followers 2 comments 0 votes
Neil, looks like we've gotten past this error. I'm getting another one, but so far I can generate a scripts directory now. / comments
  1. Community
  2. Schema Compare for Oracle
  3. ERROR: Nullable object must have a value
Neil, looks like we've gotten past this error. I'm getting another one, but so far I can generate a scripts directory now.
0 votes
Thanks Neil! I've just seen this (notifications must have been turned off) -- I'll get right on it and check! / comments
  1. Community
  2. Schema Compare for Oracle
  3. ERROR: Nullable object must have a value
Thanks Neil! I've just seen this (notifications must have been turned off) -- I'll get right on it and check!
0 votes
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 : / comments
  1. Community
  2. Schema Compare for Oracle
  3. ERROR: Nullable object must have a value
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|Inf...
0 votes
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 –Ž.€Ž.‰.“ / comments
  1. Community
  2. Schema Compare for Oracle
  3. ERROR: Nullable object must have a value
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 |exConstr...
0 votes
ERROR: Nullable object must have a value
  1. Community
  2. Schema Compare for Oracle
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 schem...
2 followers 7 comments 0 votes
Resolved -- databases for existing projects must be up and available or else you will possibly receive this error (when working with 1.0.0.618) Also, confirmed as still being an issue with 1.0.0.648. / comments
  1. Community
  2. Source Control for Oracle
  3. v1.0 release upgrade won't launch
Resolved -- databases for existing projects must be up and available or else you will possibly receive this error (when working with 1.0.0.618) Also, confirmed as still being an issue with 1.0.0.648.
0 votes
Got it -- error report on its way. / comments
  1. Community
  2. Source Control for Oracle
  3. v1.0 release upgrade won't launch
Got it -- error report on its way.
0 votes
Total activity
15
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3