liquibase.exception.JDBCException: Error executing SQL UPDATE [dbo].[DATABASECHANGELOG] SET [DATEEXECUTED] = 'GETDATE()', [MD5SUM] = '2:c37bc10575fc36d1b09257c3b6de4dc2' WHERE ID='15' AND AUTHOR='nvoxland' AND FILENAME='changelogs/mssql/complete/root.changelog.xml'

JIRA | Oleg Taranenko | 7 years ago
  1. 0

    Running JUnit test get an error: liquibase.exception.JDBCException: Error executing SQL UPDATE [dbo].[DATABASECHANGELOG] SET [DATEEXECUTED] = 'GETDATE()', [MD5SUM] = '2:c37bc10575fc36d1b09257c3b6de4dc2' WHERE ID='15' AND AUTHOR='nvoxland' AND FILENAME='changelogs/mssql/complete/root.changelog.xml' at liquibase.executor.DefaultExecutor.execute(DefaultExecutor.java:59) at liquibase.executor.DefaultExecutor.execute(DefaultExecutor.java:89) at liquibase.database.AbstractDatabase.markChangeSetAsReRan(AbstractDatabase.java:1284) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:30) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:39) at liquibase.Liquibase.update(Liquibase.java:113) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testUpdateTwice(AbstractSimpleChangeLogRunnerTest.java:170) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:228) at junit.framework.TestSuite.run(TestSuite.java:223) at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Syntax error converting datetime from character string. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown Source) at liquibase.executor.DefaultExecutor$1ExecuteStatementCallback.doInStatement(DefaultExecutor.java:80) at liquibase.executor.DefaultExecutor.execute(DefaultExecutor.java:52) ... 25 more

    JIRA | 7 years ago | Oleg Taranenko
    liquibase.exception.JDBCException: Error executing SQL UPDATE [dbo].[DATABASECHANGELOG] SET [DATEEXECUTED] = 'GETDATE()', [MD5SUM] = '2:c37bc10575fc36d1b09257c3b6de4dc2' WHERE ID='15' AND AUTHOR='nvoxland' AND FILENAME='changelogs/mssql/complete/root.changelog.xml'
  2. 0

    Running JUnit test get an error: liquibase.exception.JDBCException: Error executing SQL UPDATE [dbo].[DATABASECHANGELOG] SET [DATEEXECUTED] = 'GETDATE()', [MD5SUM] = '2:c37bc10575fc36d1b09257c3b6de4dc2' WHERE ID='15' AND AUTHOR='nvoxland' AND FILENAME='changelogs/mssql/complete/root.changelog.xml' at liquibase.executor.DefaultExecutor.execute(DefaultExecutor.java:59) at liquibase.executor.DefaultExecutor.execute(DefaultExecutor.java:89) at liquibase.database.AbstractDatabase.markChangeSetAsReRan(AbstractDatabase.java:1284) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:30) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:39) at liquibase.Liquibase.update(Liquibase.java:113) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testUpdateTwice(AbstractSimpleChangeLogRunnerTest.java:170) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:228) at junit.framework.TestSuite.run(TestSuite.java:223) at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Syntax error converting datetime from character string. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown Source) at liquibase.executor.DefaultExecutor$1ExecuteStatementCallback.doInStatement(DefaultExecutor.java:80) at liquibase.executor.DefaultExecutor.execute(DefaultExecutor.java:52) ... 25 more

    JIRA | 7 years ago | Oleg Taranenko
    liquibase.exception.JDBCException: Error executing SQL UPDATE [dbo].[DATABASECHANGELOG] SET [DATEEXECUTED] = 'GETDATE()', [MD5SUM] = '2:c37bc10575fc36d1b09257c3b6de4dc2' WHERE ID='15' AND AUTHOR='nvoxland' AND FILENAME='changelogs/mssql/complete/root.changelog.xml'
  3. 0

    [SPR-1832] Wrong translation of MS SQL Server SQLException - Spring JIRA

    spring.io | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: INSERT permission denied on object 'NotebooksFrec', database 'matcher', owner 'dbo'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Transaction Isolation Snapshot Exception on 2.1.1 upgrade

    GitHub | 4 years ago | NickPadilla
    com.microsoft.sqlserver.jdbc.SQLServerException: Transaction failed because this DDL statement is not allowed inside a snapshot isolation transaction. Since metadata is not versioned, a metadata change can lead to inconsistency if mixed within snapshot isolation.

    9 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. com.microsoft.sqlserver.jdbc.SQLServerException

      Syntax error converting datetime from character string.

      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError()
    2. com.microsoft.sqlserver
      SQLServerStatement.execute
      1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
      2. com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
      3. com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
      4. com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source)
      5. com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecute(Unknown Source)
      6. com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown Source)
      6 frames
    3. Liquibase Core
      Liquibase.update
      1. liquibase.executor.DefaultExecutor$1ExecuteStatementCallback.doInStatement(DefaultExecutor.java:80)
      2. liquibase.executor.DefaultExecutor.execute(DefaultExecutor.java:52)
      3. liquibase.executor.DefaultExecutor.execute(DefaultExecutor.java:89)
      4. liquibase.database.AbstractDatabase.markChangeSetAsReRan(AbstractDatabase.java:1284)
      5. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:30)
      6. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:39)
      7. liquibase.Liquibase.update(Liquibase.java:113)
      7 frames
    4. liquibase.dbtest
      AbstractSimpleChangeLogRunnerTest.testUpdateTwice
      1. liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testUpdateTwice(AbstractSimpleChangeLogRunnerTest.java:170)
      1 frame
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    6. JUnit
      OldTestClassRunner.run
      1. junit.framework.TestCase.runTest(TestCase.java:164)
      2. junit.framework.TestCase.runBare(TestCase.java:130)
      3. junit.framework.TestResult$1.protect(TestResult.java:110)
      4. junit.framework.TestResult.runProtected(TestResult.java:128)
      5. junit.framework.TestResult.run(TestResult.java:113)
      6. junit.framework.TestCase.run(TestCase.java:120)
      7. junit.framework.TestSuite.runTest(TestSuite.java:228)
      8. junit.framework.TestSuite.run(TestSuite.java:223)
      9. org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
      9 frames
    7. JUnit4 Runner
      JUnit4TestReference.run
      1. org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
      1 frame
    8. JUnit3 Runner
      RemoteTestRunner.main
      1. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
      2. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
      3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
      4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
      5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
      5 frames