What are the challenges you face when working across database platforms? Take the survey
Options

Columns with clob type is failing (maybe lob partitions are failing)

Hi, i tried to do comparison, but getting error that index was out of range. 

My table script is:
-- Create table
create table TEST.TEST
(
  test1                DATE not null,
  test2                    CLOB
)
PARTITION BY RANGE ("TEST1") INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) 
 (PARTITION "P202208"  VALUES LESS THAN (TO_DATE(' 2018-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ) ;

In table was inserted one row;
insert into TEST.TEST values (TO_DATE('2022-03-31', 'YYYY-MM-DD'), '{}')

This error occurs only when system partitions are included into comparison.

As i see for clob column was generated partition_index in DBA_PART_INDEXES table:



Also tried to add and remove lobs and varrays check button ( but didnt help)

REDGATE version 6.0.10.553

THERE IS WHAT I SEE IN LOGS:

SELECT
q.owner,
q.queue_name,
q.consumer_name,
q.address,
q.protocol,
q.transformation,
q.delivery_mode,
q.queue_to_queue
FROM
dba_queue_subscribers q
WHERE q.owner = 'TEST' ;
16:59:32.087|Error  |Object Model        |43 |Failed to populate lob partitions
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at RedGate.Oracle.SchemaCompare.ObjectModel.OrderedKeyedCollection`1.get_Item(Int32 index)
   at RedGate.Oracle.SchemaCompare.ObjectModel.OrderedKeyedCollectionListWrapper`2.get_Item(Int32 index)
   at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.PopulateLobPartition(IDataReader reader, IScriptExecutor executor)
   at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.ExecuteScript(IScriptExecutor executor, ScriptType scriptType, Action`2 rowProcessor, String friendlyName, Func`2 customErrorHandler)
16:59:32.087|Error  |Object Model        |4  |Failed to populate lob partitions
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at RedGate.Oracle.SchemaCompare.ObjectModel.OrderedKeyedCollection`1.get_Item(Int32 index)
   at RedGate.Oracle.SchemaCompare.ObjectModel.OrderedKeyedCollectionListWrapper`2.get_Item(Int32 index)
   at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.PopulateLobPartition(IDataReader reader, IScriptExecutor executor)
   at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.ExecuteScript(IScriptExecutor executor, ScriptType scriptType, Action`2 rowProcessor, String friendlyName, Func`2 customErrorHandler)
16:59:32.088|Debug  |Object Model        |43 |LOB information took 230 ms
16:59:32.088|Debug  |Object Model        |4  |LOB information took 231 ms
16:59:32.088|Info   |Object Model        |43 |Populating queues 103%
16:59:32.088|Info   |Object Model        |4  |Populating queues 103%
16:59:32.088|Info   |Executor Cache      |43 |Executor cache released to pool - 3
16:59:32.088|Info   |Executor Cache      |4  |Executor cache released to pool - 0
16:59:32.097|Debug  |Object Model        |80 |Query returned reader in : 37 ms
16:59:32.098|Trace  |Object Model        |80 |Executing script type 29 - QueueSubscribers
16:59:32.098|Debug  |Object Model        |80 |-- Executing query



Tagged:

Answers

Sign In or Register to comment.