How can we help you today? How can we help you today?

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



ugzas
0

Comments

10 comments

Sort by
  • Kurt_M
    Hi @ugzas,

    Thanks for sending through all of this information. With the table you provided and the option of adding the system partitions, I was able to replicate the issue on my end. I even updated to the latest (6.0.12) to check.

    I will put this through to the development team to see what can be done. Once I hear back from them, I'll let you know.
    Kurt_M
    0
  • Kurt_M
    Hi @ugzas,

    Just a follow up question to this, what version of Oracle are you running?
    Kurt_M
    0
  • ugzas
    Hi, @Kurt_M
    our oracle version:
    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    ugzas
    0
  • Kurt_M
    Hi @ugzas

    Thanks for that, I'll pass that onto the developers. From their initial looks, it appears to be Oracle version related. Once I have an update, I'll let you know.
    Kurt_M
    0
  • ugzas
    Hi, maybe there are some news regarding this case?
    ugzas
    0
  • Kurt_M
    Hi @ugzas

    Apologies for the delay. I don't have an update at the moment, but I have followed up with this to get something for you.
    Kurt_M
    0
  • Kurt_M
    Hi @ugzas

    Thanks for your patience on this. I have been advised the developer looking into this has managed to replicate and fix the issue. They've advised me they're hoping for a release to be put out soon. They can't confirm the day, but are hoping for within the next 2 weeks (most likely next week).
    Kurt_M
    0
  • ugzas
    Thank you!
    ugzas
    0
  • Kurt_M
    Hi @ugzas

    I have been advised this has been fixed in the most recent release. You can download that via the below link:

    https://download.red-gate.com/checkforupdates/SchemaCompareforOracle/SchemaCompareforOracle_6.0.13.628.exe
    Kurt_M
    0
  • ugzas
    Thanks!
    ugzas
    0

Add comment

Please sign in to leave a comment.