Error on compare

Compares and synchronizes Oracle data

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Error on compare

Postby Infoadv » Mon Mar 07, 2011 12:13 pm

I'm trying Data Compare for Oracle for my customer and when compare two oracle db ( one is 9.2 and the second is 10g ) during a table compare I receive the following error :

Bug report generated at 07/03/2011 12.03.11
Program version 1.0.1.346

System.Exception: Couldn't execute statement:
SELECT SEQUENCE, LASTMODIFIED, LASTUSER, _GROUP_, _INACTIVE_:, COMMITMENT_ID, FISCAL_YEAR, COMM_AMOUNT FROM "_SMDBA_"."BUDG_COMM" ORDER BY SEQUENCE ---> Devart.Data.Oracle.OracleException: ORA-00911: invalid character
at Devart.Data.Oracle.bo.b(Int32 A_0)
at Devart.Data.Oracle.an.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 RedGate.Oracle.Compare.EngineController.Data.DataCompareEngine.#t.#GKb.#UsY()
at RedGate.Shared.Controls.ProgressDialogEx.e()

if we remove _GROUP_ and _INACTIVE_: colmuns from compare all work fine.

it's enough that column name be in double quotes (") to solve this problem , how can I do that ?

thanks in advance for help
Infoadv
 
Posts: 4
Joined: Thu Aug 04, 2005 5:33 pm

Postby Tom Harris » Wed Mar 09, 2011 3:26 pm

Hi,

I'm sorry that you've run into this problem. As you correctly point out the problem is caused by the column names containing special charcaters, but not being enclosed in quotes. I've marked this as a bug against our product - ODC-193.

Is it difficult for you to rename those columns to add the missing quotes?

Kind regards, Tom

Tom Harris,
Red Gate Software
Tom Harris
 
Posts: 308
Joined: Wed Oct 06, 2004 3:45 pm

Error on compare

Postby Infoadv » Wed Mar 09, 2011 3:31 pm

It's impossible to change column name becasue the 2 database are repository of an application data and the table cannot be changed.

Bye
Infoadv
 
Posts: 4
Joined: Thu Aug 04, 2005 5:33 pm

Postby Tom Harris » Mon Mar 28, 2011 12:43 pm

Hi there,

this issue has now been fixed. Please email productsupport@redgate.com to get an updated installer

Kind regards, Tom

Tom Harris, Red Gate Software
Tom Harris
 
Posts: 308
Joined: Wed Oct 06, 2004 3:45 pm

Postby Tom Harris » Thu Mar 31, 2011 11:54 am

Hi there,

the fix for the issue is now incorporated into the Red Gate Oracle tools download. You can grab the latest version from

http://www.red-gate.com/products/oracle-development/

Kind regards, Tom

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


Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests