How can we help you today? How can we help you today?
jspibey
Activity overview Badges (0) Posts (5) Comments (10)

Comments

Sort by recent activity
OK, can I the hotfix then please because I probably can't wait that long Thanks / comments
  1. Community
  2. SQL Compare Previous Versions
  3. "Index was outside the bounds of the array"
OK, can I the hotfix then please because I probably can't wait that long Thanks
0 votes
Hi, Thanks for the reply. Yes we are using CLR assemblies so I'm pretty sure it must be the same issue. My immediate need for a fix has gone now because I used a co-workers system to get around this so I could wait for the final release if it's going to be soon? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. "Index was outside the bounds of the array"
Hi, Thanks for the reply. Yes we are using CLR assemblies so I'm pretty sure it must be the same issue. My immediate need for a fix has gone now because I used a co-workers system to get around thi...
0 votes
Hi, Thanks for your prompt response - that worked perfectly. Regards James / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Check For Updates
Hi, Thanks for your prompt response - that worked perfectly. Regards James
0 votes
Any news on this Tom? I can't use it until this is fixed Thanks James / comments
  1. Community
  2. Schema Compare for Oracle
  3. Error when running deployment wizard
Any news on this Tom? I can't use it until this is fixed Thanks James
0 votes
Hi Neil, I have managed to reproduce the issue with the following steps 1. Open data compare and select my destination on the left and my source on the right and the 'compare to' arrow pointing towards the left (Yellow Background). 2. Run comparison 3. Run Synchroinisation Wizard, then select Next to view synchronisation script. 4. In the window, the generated SQL is referring to updating my Source database even though the direction of update is to my destination (i.e. database scripts say 'UPDATE SOURCE SET Blah ' when they are actually to be executed on the destination Any yes I understand the crash was due to insufficient privilleges but should that have crashed Data Compare? Thanks James / comments
  1. Community
  2. Data Compare for Oracle EAP
  3. Strange behaviour in 1.0.1.224
Hi Neil, I have managed to reproduce the issue with the following steps 1. Open data compare and select my destination on the left and my source on the right and the 'compare to' arrow pointing tow...
0 votes
And I also just generated a crash Bug report generated at 24/11/2010 16:31:30 Program version 1.0.1.224 System.Exception: When synchronising couldn't execute the statement: DECLARE null_value CHAR(1) := NULL; statement1 CHAR(103); BEGIN statement1 := 'INSERT INTO "TWEBSITE"."ACCESS_REQUESTS" (USERNAME,ROLENAME,DATE_APPLIED,NOTES) VALUES (:0, :1, :2, [image] )'; EXECUTE IMMEDIATE statement1 USING 'aparr', 'scg', TO_DATE('29/OCT/2010AD 18:21:27','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'areed', 'kpi', TO_DATE('21/JUL/2010AD 13:05:20','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'awarry', 'bi_employees', TO_DATE('23/NOV/2010AD 10:41:27','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'awarry', 'scg', TO_DATE('23/NOV/2010AD 10:41:05','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'carmel occhini', 'bi_bsa', TO_DATE('16/NOV/2010AD 10:32:10','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'carmel occhini', 'kpi', TO_DATE('16/NOV/2010AD 10:32:05','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'clittlejohn', 'bi_bsa', TO_DATE('23/JUN/2010AD 16:30:21','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'cxgraham', 'bridgwater', TO_DATE('15/NOV/2010AD 12:50:51','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'dawn webster', 'scg', TO_DATE('12/AUG/2010AD 13:52:40','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'eblackwell', 'bi_bsa', TO_DATE('22/NOV/2010AD 11:34:50','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'eblackwell', 'bi_employees', TO_DATE('28/OCT/2010AD 11:05:28','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'guisey', 'kpi', TO_DATE('29/JUL/2010AD 13:04:08','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'jeffnagy', 'bi_customers', TO_DATE('26/MAY/2010AD 16:55:05','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'jeffnagy', 'salesdb_confed', TO_DATE('26/MAY/2010AD 17:04:00','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'jeffnagy', 'scg', TO_DATE('26/MAY/2010AD 17:06:35','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'jtownsend1701', 'bi_bsa', TO_DATE('12/NOV/2010AD 16:24:28','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'jtownsend1701', 'kpi', TO_DATE('12/NOV/2010AD 16:25:17','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'karencullen', 'bi_bsa', TO_DATE('17/NOV/2010AD 11:16:30','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'kaujla', 'bi_customers', TO_DATE('26/MAY/2010AD 18:20:42','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'kwhittle', 'bi_customers', TO_DATE('15/NOV/2010AD 12:48:46','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'kwhittle', 'bi_employees', TO_DATE('15/NOV/2010AD 12:45:50','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'kwhittle', 'kpi', TO_DATE('15/NOV/2010AD 12:48:33','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'kwright', 'bi_bsa', TO_DATE('12/NOV/2010AD 14:30:51','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'michalafoott', 'kpi', TO_DATE('08/NOV/2010AD 09:32:56','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'mmcclue', 'bi_bsa', TO_DATE('26/OCT/2010AD 15:49:56','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'mmcclue', 'bi_customers', TO_DATE('26/OCT/2010AD 15:50:03','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'mmcclue', 'bi_employees', TO_DATE('26/OCT/2010AD 15:49:34','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'mwinslet', 'bi_customers', TO_DATE('24/AUG/2010AD 15:31:26','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'mwinslet', 'rangemanagement', TO_DATE('24/AUG/2010AD 15:32:08','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'mwinslet', 'scg', TO_DATE('24/AUG/2010AD 15:31:38','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'pway', 'bi_employees', TO_DATE('22/NOV/2010AD 12:12:01','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'pway', 'rangemanagement', TO_DATE('22/NOV/2010AD 12:14:41','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; EXECUTE IMMEDIATE statement1 USING 'rhullafont', 'dc_kpi', TO_DATE('24/JUN/2010AD 09:15:09','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value; END; ---> Devart.Data.Oracle.OracleException: ORA-01031: insufficient privileges ORA-06512: at line 6 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.Data.Oracle.OracleCommand.ExecuteNonQuery() at RedGate.Oracle.Common.OracleStatementExecutor.Execute() --- End of inner exception stack trace --- at RedGate.Oracle.Common.OracleStatementExecutor.Execute() at RedGate.Oracle.Compare.EngineController.Data.DataCompareEngine.#t.#O3c.#w0X() at RedGate.Shared.Controls.ProgressDialogEx.e() / comments
  1. Community
  2. Data Compare for Oracle EAP
  3. Strange behaviour in 1.0.1.224
And I also just generated a crash Bug report generated at 24/11/2010 16:31:30 Program version 1.0.1.224 System.Exception: When synchronising couldn't execute the statement: DECLARE null_value CHAR(...
0 votes
1.0.0.475 - I only downloaded it an hour or two ago but it was an upgrade of a previous version / comments
  1. Community
  2. Schema Compare for Oracle Beta
  3. Error when comparing databases
1.0.0.475 - I only downloaded it an hour or two ago but it was an upgrade of a previous version
0 votes
Thanks for the quick reply. I tried adding in the other schemas which were referenced but couldn't get any further. I'll wait for the next build before I look at it again / comments
  1. Community
  2. Schema Compare for Oracle Beta
  3. Error when comparing databases
Thanks for the quick reply. I tried adding in the other schemas which were referenced but couldn't get any further. I'll wait for the next build before I look at it again
0 votes
Thanks, I gave that a try and I get a little further but I still get an error ORA-00904: "P"."OBJECT_TYPE": invalid identifier / comments
  1. Community
  2. Schema Compare for Oracle Beta
  3. Error when comparing databases
Thanks, I gave that a try and I get a little further but I still get an error ORA-00904: "P"."OBJECT_TYPE": invalid identifier
0 votes
I've sent you the log file via email Thanks / comments
  1. Community
  2. Schema Compare for Oracle Beta
  3. Error when comparing databases
I've sent you the log file via email Thanks
0 votes
Total activity
20
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
5