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

Activity overview

Latest activity by jspibey

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
Error when running deployment wizard
  1. Community
  2. Schema Compare for Oracle
I have found a problem with Schema Compare for Oracle version 1.5.0.69 After successfully comparing two databases, selecting some changes to apply, click Deployment wizard, Choose 'Deploy using Sch...
5 followers 8 comments 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
Strange behaviour in 1.0.1.224
  1. Community
  2. Data Compare for Oracle EAP
Hi, I'm currently testing out DC for Oracle v1.0.1.224 64Bit on Windows 7 and I've had a few strange things happen - After performing a comparison, click on the 'Edit Project' -> 'Tables' and I get...
2 followers 4 comments 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
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
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
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
Error when comparing databases
  1. Community
  2. Schema Compare for Oracle Beta
I'm comparing two schemas on the same database server. The server is running Oracle 10.1.0.3.0, the client is Windows 7 x64. I am connecting to the database using a 'Manual Connection' using the sa...
4 followers 13 comments 0 votes
Total activity
20
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
5