java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "bit" (-7) of column .cru_fisheye_user

Atlassian JIRA | Lukasz Pater | 11 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    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: {code} 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:?] {code} 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. h2. 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: {code} 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); {code} # Restart FishEye/Crucible

    Atlassian JIRA | 11 months ago | Lukasz Pater
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "bit" (-7) of column .cru_fisheye_user
  2. 0

    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: {code} 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:?] {code} 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. h2. 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: {code} 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); {code} # Restart FishEye/Crucible

    Atlassian JIRA | 11 months ago | Lukasz Pater
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "bit" (-7) of column .cru_fisheye_user
  3. 0

    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: {code} 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:?] {code} 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. h2. 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: {code} 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); {code} # Restart FishEye/Crucible

    Atlassian JIRA | 11 months ago | Lukasz Pater
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "bit" (-7) of column .cru_fisheye_user
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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: {code} 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:?] {code} 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. h2. 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: {code} 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); {code} # Restart FishEye/Crucible

    Atlassian JIRA | 11 months ago | Lukasz Pater
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "bit" (-7) of column .cru_fisheye_user

    Root Cause Analysis

    1. 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()
    2. com.atlassian.crucible
      BackupManagerImpl$2$1.perform
      1. com.atlassian.crucible.migration.item.SQLBackup$SaverImpl.backup(SQLBackup.java:82)[fisheye.jar:?]
      2. com.atlassian.crucible.migration.BackupManagerImpl.createBackup(BackupManagerImpl.java:264)[fisheye.jar:?]
      3. com.atlassian.crucible.migration.BackupManagerImpl.access$000(BackupManagerImpl.java:55)[fisheye.jar:?]
      4. com.atlassian.crucible.migration.BackupManagerImpl$2$1.perform(BackupManagerImpl.java:153)[fisheye.jar:?]
      5. com.atlassian.crucible.migration.BackupManagerImpl$2$1.perform(BackupManagerImpl.java:151)[fisheye.jar:?]
      5 frames