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

Atlassian JIRA | Lukasz Pater | 9 months ago
  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 | 9 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 | 9 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 | 9 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 | 9 months ago | Lukasz Pater
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "bit" (-7) of column .cru_fisheye_user
  6. 0

    sqoop import --hive-import failing for row_version (datatype: timestamp) column for MS SQL Server

    sqoop-user | 11 months ago | sudeep mishra
    java.io.IOException: Hive does not support the SQL type for column row_version

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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