Description
Users running FishEye/Crucible 4.0.0 or 4.0.1 with MS SQL Server will encounter the following error, when trying to perform a backup:
2016-03-21 10:25:19,952 WARN - Backup failed. java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "bit" (-7) of column .cru_fisheye_user at com.atlassian.crucible.migration.item.SQLBackup$SaverImpl.backup(SQLBackup.java:82) [fisheye.jar:?] at com.atlassian.crucible.migration.BackupManagerImpl.createBackup(BackupManagerImpl.java:264) [fisheye.jar:?] at com.atlassian.crucible.migration.BackupManagerImpl.access$000(BackupManagerImpl.java:55) [fisheye.jar:?] at com.atlassian.crucible.migration.BackupManagerImpl$2$1.perform(BackupManagerImpl.java:153) [fisheye.jar:?] at com.atlassian.crucible.migration.BackupManagerImpl$2$1.perform(BackupManagerImpl.java:151) [fisheye.jar:?]
This does not affect users who upgraded directly to 4.0.2, and didn't ever run 4.0.0 or 4.0.1.
Note, scheduled backups would not finish too, admins may not notice.
Workaround
Users can do the following to manually fix the functionality:
- Shutdown FishEye/Crucible
- Execute the following SQL script on the MS SQL Server database:
DROP INDEX cru_idx_perm_fisheye_user ON cru_global_permission; ALTER TABLE cru_global_permission ALTER COLUMN cru_fisheye_user TINYINT NOT NULL; CREATE INDEX cru_idx_perm_fisheye_user ON cru_global_permission (cru_fisheye_user); DROP INDEX cru_idx_perm_crucible_user ON cru_global_permission; ALTER TABLE cru_global_permission ALTER COLUMN cru_crucible_user TINYINT NOT NULL; CREATE INDEX cru_idx_perm_crucible_user ON cru_global_permission (cru_crucible_user);
- Restart FishEye/Crucible
Attachments
Issue Links
- is cloned from
-
FE-6434 Backup for instances using SQL Server fails with the message 'Cannot encode value for unsupported column type: "bit" (-7) of column .cru_fisheye_user'
- Closed
- is related to
-
FE-6550 Backup using Oracle Database fails with the message 'Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE'
- Closed
- mentioned in
-
Page Loading...