View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000947 | SymmetricDS | Bug | public | 2012-12-12 15:45 | 2014-02-03 01:53 |
| Reporter | rotten | Assigned To | chenson | ||
| Priority | low | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.1.11 | ||||
| Target Version | 3.2.0 | Fixed in Version | 3.2.0 | ||
| Summary | 0000947: Bad alter statement generated on oracle upgrade: ALTER TABLE "SYM_DATA_EVENT" MODIFY ("BATCH_ID" DEFAULT ) | ||||
| Description | After/While upgrading to 3.2.0 build 52, this alter table command is missing some arguments: 2012-12-12 10:39:52,869 WARN [SymmetricDS] [JdbcSqlTemplate] [symmetric-startup] ORA-00936: missing expression . Failed to execute: ALTER TABLE "SYM_DATA_EVENT" MODIFY ("BATCH_ID" DEFAULT ). | ||||
| Steps To Reproduce | upgrade to 3.2.0 (from 2.5.13) | ||||
| Tags | No tags attached. | ||||
|
|
I think the work-around is to run this alter table by hand and set the default to null: alter table sym_data_event modify ("BATCH_ID" DEFAULT null); Seems to stop SymmetricDS from trying to change the default anyway. |
|
|
I should have mentioned that this was an upgrade to an Oracle SymmetricDS instance. |
|
|
Prepare for release |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-12-12 15:45 | rotten | New Issue | |
| 2012-12-12 16:33 | rotten | Note Added: 0000101 | |
| 2012-12-12 16:43 | rotten | Note Added: 0000102 | |
| 2012-12-13 13:30 | chenson | Summary | 3.2.0 build 52 sym_data_event alter table incomplet => Bad alter statement generated on oracle upgrade: ALTER TABLE "SYM_DATA_EVENT" MODIFY ("BATCH_ID" DEFAULT ) |
| 2012-12-13 13:31 | chenson | Fixed in Version | => 3.2.0 |
| 2012-12-13 13:31 | chenson | Target Version | => 3.2.0 |
| 2012-12-13 13:31 | chenson | Status | new => resolved |
| 2012-12-13 13:31 | chenson | Resolution | open => fixed |
| 2012-12-13 13:31 | chenson | Assigned To | => chenson |
| 2012-12-16 17:31 | chenson | Note Added: 0000114 | |
| 2012-12-16 17:31 | chenson | Status | resolved => closed |
| 2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r6669 | |
| 2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 4fa6c056 |