liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE organization MODIFY COLUMN ACTIVE BIT(1) NOT NULL DEFAULT 1: Data truncated for column 'ACTIVE' at row 1

Stack Overflow | Dave | 3 months ago
  1. 0

    Getting "Data truncated for column " when running Liquibase changeset

    Stack Overflow | 3 months ago | Dave
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE organization MODIFY COLUMN ACTIVE BIT(1) NOT NULL DEFAULT 1: Data truncated for column 'ACTIVE' at row 1
  2. 0

    GitHub comment 1#200814582

    GitHub | 9 months ago | pascalgrimaud
    liquibase.exception.DatabaseException: Column "TEST_ENTITYS_ID" not found; SQL statement: ALTER TABLE PUBLIC.test_entity_user_many_to_many ADD CONSTRAINT fk_test_entity_user_many_to_many_user_id FOREIGN KEY (test_entitys_id) REFERENCES PUBLIC.test_entity (id) [42122-191] [Failed SQL: ALTER TABLE PUBLIC.test_entity_user_many_to_many ADD CONSTRAINT fk_test_entity_user_many_to_many_user_id FOREIGN KEY (test_entitys_id) REFERENCES PUBLIC.test_entity (id)]
  3. 0

    GitHub comment 3978#240652930

    GitHub | 4 months ago | pascalgrimaud
    liquibase.exception.DatabaseException: Identifier name 'test_many_to_many_test_custom_table_name_test_custom_table_names_id' is too long [Failed SQL: ALTER TABLE travisMysql.test_many_to_many_test_custom_table_name ADD CONSTRAINT test_many_to_many_test_custom_table_name_test_custom_table_names_id FOREIGN KEY (test_custom_table_names_id) REFERENCES travisMysql.test_custom_table_name_entity (id)]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Liquibase: getting "Data truncated" error when trying to add an unsigned integer column

    Stack Overflow | 3 years ago | Dave
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `my_table` MODIFY `MY_COLUMN` INTEGER UNSIGNED NOT NULL: Data truncated for column 'MY_COLUMN' at row 1
  6. 0

    User App 4.5 without SSPR logout redirection issue [Archive] - NetIQ Forums

    netiq.com | 1 year ago
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE IAMUSER.CONFIGURATION_ITEM MODIFY ID DEFAULT CONFIGURATION_ITEM_ID_SEQ.NEXTVAL: ORA-00984: column not allowed here at liquibase.executor.jvm.JdbcExecutor.execute(JdbcEx ecutor.java:61) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcEx ecutor.java:106) at liquibase.database.AbstractJdbcDatabase.execute(Ab stractJdbcDatabase.java:1189) at liquibase.database.AbstractJdbcDatabase.executeSta tements(AbstractJdbcDatabase.java:1172) at liquibase.changelog.ChangeSet.execute(ChangeSet.ja va:352) at liquibase.changelog.visitor.UpdateVisitor.visit(Up dateVisitor.java:40) at liquibase.changelog.ChangeLogIterator.run(ChangeLo gIterator.java:64)

    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. liquibase.exception.DatabaseException

      Error executing SQL ALTER TABLE organization MODIFY COLUMN ACTIVE BIT(1) NOT NULL DEFAULT 1: Data truncated for column 'ACTIVE' at row 1

      at liquibase.executor.jvm.JdbcExecutor.execute()
    2. Liquibase Core
      AbstractJdbcDatabase.executeStatements
      1. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
      2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
      3. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1206)
      4. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)
      4 frames