liquibase.exception.DatabaseException: Invalid column name 'DEPLOYMENT_ID'. [Failed SQL: INSERT INTO [dbo].[MTA_DATABASE_CHANGE_LOG] ([ID], [AUTHOR], [FILENAME], [DATEEXECUTED], [ORDEREXECUTED], [MD5SUM], [DESCRIPTION], [COMMENTS], [EXECTYPE], [CONTEXTS], [LABELS], [LIQUIBASE], [DEPLOYMENT_ID]) VALUES ('create-message-table', 'TAA.team', 'com/mcorp/tools/integration/persistence/liquibase/MTA.db.changelog-create.xml', GETDATE(), 1, '7:7fd70289c6cfc92aa9a8b2206743f4bf', 'createTable tableName=MTA_MESSAGES; sql', '', 'EXECUTED', 'table', NULL, '3.5.1', '7855321615')]

Stack Overflow | consultantleon | 10 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    DEPLOYMENT_ID not created for Sybase in DATABASECHANGELOG, liquibase 3.5.1

    Stack Overflow | 10 months ago | consultantleon
    liquibase.exception.DatabaseException: Invalid column name 'DEPLOYMENT_ID'. [Failed SQL: INSERT INTO [dbo].[MTA_DATABASE_CHANGE_LOG] ([ID], [AUTHOR], [FILENAME], [DATEEXECUTED], [ORDEREXECUTED], [MD5SUM], [DESCRIPTION], [COMMENTS], [EXECTYPE], [CONTEXTS], [LABELS], [LIQUIBASE], [DEPLOYMENT_ID]) VALUES ('create-message-table', 'TAA.team', 'com/mcorp/tools/integration/persistence/liquibase/MTA.db.changelog-create.xml', GETDATE(), 1, '7:7fd70289c6cfc92aa9a8b2206743f4bf', 'createTable tableName=MTA_MESSAGES; sql', '', 'EXECUTED', 'table', NULL, '3.5.1', '7855321615')]
  2. 0

    Exception during upgrade in build #7888

    YouTrack | 8 years ago
    org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state [S1000]; error code [5074]; The object 'PK__duplicate_fragme__5AEE82B9' is dependent on column 'FRAGMENT_ID'.; nested exception is java.sql.SQLException: The object 'PK__duplicate_fragme__5AEE82B9' is dependent on column 'FRAGMENT_ID'.
  3. 0

    Problem upgrading from 4.5 to 5.0.2 under MS SQL: Convertor RemoveCommentIdentifiersFromAgentTableConverter could not drop index 'agent.agent_status_comment_id'.

    YouTrack | 7 years ago
    jetbrains.buildServer.serverSide.versioning.ConvertException: Converter jetbrains.buildServer.serverSide.versioning.converters.RemoveCommentIdentifiersFromAgentTableConverter failed with error: Cannot drop the index 'agent.agent_status_comment_id', because it does not exist or you do not have permission.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Quick help with Symmetric + SQL Server + 2 databases

    symmetricds | 2 years ago | osimarmedeiros
    org.jumpmind.db.sql.SqlException: Cannot create trigger on 'jbo_ax50_sp1_db_pd.dbo.XT_NFE_CABECALHO' as the target is not in the current database.
  6. 0

    Error creating trigger on MSSQL 2008 (v3.7.10)

    symmetricds | 2 years ago | joeblow68
    org.jumpmind.db.sql.SqlException: Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.

  1. abrazeneb 8 times, last 8 months ago
1 unregistered visitors
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.sql.SQLException

    Invalid column name 'DEPLOYMENT_ID'.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
  2. jTDS
    JtdsStatement.execute
    1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
    2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2893)
    3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2335)
    4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)
    5. net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
    6. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
    7. net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
    8. net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1282)
    8 frames
  3. Commons DBCP
    DelegatingStatement.execute
    1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    2. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    3. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    3 frames
  4. Liquibase Core
    Liquibase.update
    1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
    2. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    4. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
    5. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:97)
    6. liquibase.changelog.StandardChangeLogHistoryService.setExecType(StandardChangeLogHistoryService.java:341)
    7. liquibase.database.AbstractJdbcDatabase.markChangeSetExecStatus(AbstractJdbcDatabase.java:1134)
    8. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:62)
    9. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
    10. liquibase.Liquibase.update(Liquibase.java:214)
    11. liquibase.Liquibase.update(Liquibase.java:192)
    12. liquibase.Liquibase.update(Liquibase.java:188)
    12 frames
  5. com.mcorp.tools
    LiquibaseExecutor.execute
    1. com.mcorp.tools.integration.persistence.liquibase.LiquibaseExecutor.execute(LiquibaseExecutor.java:195)
    1 frame