bug report: capitals

Compares and synchronizes Oracle data

Moderators: eddie davis, richardjm, Michelle Taylor, alice.easey

bug report: capitals

Postby mmo » Thu Oct 21, 2010 4:59 pm

Hi Support,

I get following error from the Data compare for Oracle. The tool looks promising for my goal, but there seem to be some quotation marks missing. (yes, the name of the column is "Key_SITE")

Or am i doing something stupid?

Best regards,
Martijn Mooij

Bug report generated at 21-10-2010 17:44:12
Program version 1.0.0.318

System.Exception: Couldn't execute statement:
SELECT Key_SITE, Key_MAJOR, Key_MINOR FROM "PAS_STORAGE_MIGRATION"."Q_FILTER" ORDER BY Key_SITE, Key_MAJOR, Key_MINOR ---> Devart.Data.Oracle.OracleException: ORA-00904: "KEY_MINOR": ongeldige ID
at Devart.Data.Oracle.bp.b(Int32 A_0)
at Devart.Data.Oracle.ap.a(Int32 A_0, a4 A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at RedGate.Oracle.DataCompare.DBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
--- End of inner exception stack trace ---
at RedGate.Oracle.DataCompare.DBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
at RedGate.Oracle.DataCompare.OracleDBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
at RedGate.Oracle.DataCompare.DataComparer.Compare()
at #IQK.#HQK.#t.#2Db.#jeR()
at RedGate.Shared.Controls.ProgressDialogEx.e()
mmo
 
Posts: 1
Joined: Thu Oct 21, 2010 4:53 pm
Location: -1

Postby neil.anderson » Thu Oct 21, 2010 5:20 pm

Hi Martijn,

Thanks for reporting this to us. You are not doing something stupid, it is a bug in the EAP. We will fix it asap and have a new build for you soon.


Regards,
Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby Tom Harris » Fri Oct 22, 2010 12:50 pm

Hi there,

we believe that we have fixed this issue. You can upgrade to the latest build via

http://downloads.red-gate.com/Deploymen ... Oracle.exe

Do let us know how you get on?

Regards, Tom
Tom Harris
 
Posts: 308
Joined: Wed Oct 06, 2004 3:45 pm


Return to Data Compare for Oracle EAP

Who is online

Users browsing this forum: No registered users and 1 guest