Activity overview
Latest activity by Simon.Anderson
Thanks for that - but now I'm even more confused!
I set the logging to 'verbose' and found an error where it's trying to look at the Column comments: some of them were fairly long, and some contained single quotes as part of the text
But, having removed all the comments on the columns, although running the query directly returns no rows, I'm still getting the same error in the log:
SELECT
com.owner,
com.table_name,
com.column_name,
com.comments
FROM dba_col_comments com
WHERE (com.owner = 'MYSCHEMA' ) AND com.comments IS NOT NULL
15:20:36.601|Debug |Object Model |9 |:Query returned reader in : 1 ms
15:20:36.771|Debug |Object Model |9 |:Populating columns took 1192 ms
15:20:36.791|Error |Engine Service |1 |:Exception in progress dialog
RedGate.Oracle.Common.DetailedPopulationException: Index was outside the bounds of the array. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
at RedGate.Oracle.Utils.DataReaders.ArrayDataRecord.#4FD(String #hvPb)
at RedGate.Oracle.Common.Datatypes.DatatypeBuilder.GetDatatype(IDataRecord reader, Boolean includeNestedTables)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.#8WD()
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.#tE6d()
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.#C3.#ZSD(Action #sxPb, String #utPb)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.Populate()
--- End of inner exception stack trace ---
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.Populate()
at RedGate.Oracle.SchemaCompare.ObjectModel.LivePopulator.Populate()
at RedGate.Shared.Controls.ProgressDialogEx.<>c__DisplayClass7.<DoTasks>b__4(Object q)
Tried restarting the app, makes no difference... / comments
Thanks for that - but now I'm even more confused!
I set the logging to 'verbose' and found an error where it's trying to look at the Column comments: some of them were fairly long, and some contai...
ERROR: "Index was outside the bounds of the array"
I'm trying to compare two development schemas, but I get the same error when I try to take a snapshot of one of them:
The process aborts, with the message "index was outside the bounds of the array...