View Issue Details

IDProjectCategoryView StatusLast Update
0004131SymmetricDSBugpublic2019-11-01 08:44
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.10.5Fixed in Version3.10.5 
Summary0004131: DB2 AS400 error trying to remove a column
DescriptionWhen 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.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 cd1a398e

2019-10-29 10:32:27

admin

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

Issue History

Date Modified Username Field Change
2019-10-29 10:31 elong New Issue
2019-10-29 10:31 elong Status new => assigned
2019-10-29 10:31 elong Assigned To => elong
2019-10-29 10:32 elong Status assigned => resolved
2019-10-29 10:32 elong Resolution open => fixed
2019-10-29 10:32 elong Fixed in Version => 3.10.5
2019-10-29 11:00 admin Changeset attached => SymmetricDS 3.10 cd1a398e
2019-11-01 08:44 admin Status resolved => closed