Red Gate forums :: View topic - Error on compare
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Data Compare for Oracle
Data Compare for Oracle forum

Error on compare

Search in Data Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
Infoadv



Joined: 04 Aug 2005
Posts: 4

PostPosted: Mon Mar 07, 2011 12:13 pm    Post subject: Error on compare Reply with quote

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
Back to top
View user's profile Send private message
Tom Harris



Joined: 06 Oct 2004
Posts: 308

PostPosted: Wed Mar 09, 2011 3:26 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Infoadv



Joined: 04 Aug 2005
Posts: 4

PostPosted: Wed Mar 09, 2011 3:31 pm    Post subject: Error on compare Reply with quote

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

Bye
Back to top
View user's profile Send private message
Tom Harris



Joined: 06 Oct 2004
Posts: 308

PostPosted: Mon Mar 28, 2011 12:43 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Tom Harris



Joined: 06 Oct 2004
Posts: 308

PostPosted: Thu Mar 31, 2011 11:54 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group