View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004131 | SymmetricDS | Bug | public | 2019-10-29 14:31 | 2019-11-01 12:44 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.10.5 | Fixed in Version | 3.10.5 | ||
| Summary | 0004131: DB2 AS400 error trying to remove a column | ||||
| Description | When upgraded to 3.10 or when sending schema to AS/400 DB2 database that requires dropping a column, the alter receives an error and is prevented. ALTER TABLE "SYS400"."SYMDS"."SYM_DATA_GAP" DROP COLUMN "STATUS"; ALTER TABLE "SYS400"."SYMDS"."SYM_DATA_GAP" DROP COLUMN "LAST_UPDATE_TIME"; ALTER TABLE "SYS400"."SYMDS"."SYM_NODE" DROP COLUMN "HEARTBEAT_TIME" ; ALTER TABLE "SYS400"."SYMDS"."SYM_NODE" DROP COLUMN "TIMEZONE_OFFSET"; Error: [SQL0952] Processing of the SQL statement ended. Reason code 10. SQLState: 57014 ErrorCode: -952 AS400 is giving a warning because of possible data loss, and asking to Cancel or Ignore the requested operation. But, since this is a JDBC connection, it cannot interactively response with an "I" to ignore. As a workaround, ask the DDL Builder to migrate to a new table that does not have the column. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.10 cd1a398e 2019-10-29 10:32:27 Details Diff |
0004131: DB2 AS400 error trying to remove a column |
Affected Issues 0004131 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/db2/Db2As400DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/db2/Db2DdlBuilder.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-10-29 14:31 | elong | New Issue | |
| 2019-10-29 14:31 | elong | Status | new => assigned |
| 2019-10-29 14:31 | elong | Assigned To | => elong |
| 2019-10-29 14:32 | elong | Status | assigned => resolved |
| 2019-10-29 14:32 | elong | Resolution | open => fixed |
| 2019-10-29 14:32 | elong | Fixed in Version | => 3.10.5 |
| 2019-10-29 15:00 | admin | Changeset attached | => SymmetricDS 3.10 cd1a398e |
| 2019-11-01 12:44 | admin | Status | resolved => closed |