org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute update query; SQL [update cwd_group set is_local='F' where is_local is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute update query

Atlassian JIRA | Amalia Sanusi [Atlassian] | 3 years ago
  1. 0

    h4. Steps to Reproduce # Install Crowd 2.0.6 using SQL Server # Upgrade Crowd to 2.7.x via [automatic database upgrade|https://confluence.atlassian.com/display/CROWD/Upgrading+Crowd+via+Automatic+Database+Upgrade] h4. Expected Results Upgrade should be successful h4. Actual Results Upgrade fails with the following errors: {code}2013-09-25 20:49:23,018 main INFO [crowd.manager.upgrade.UpgradeManagerImpl] Running upgrade task for build - 427: Updating the local column in cwd_group from null to false 2013-09-25 20:49:23,064 main WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 207, SQLState: 42S22 2013-09-25 20:49:23,064 main ERROR [org.hibernate.util.JDBCExceptionReporter] Invalid column name 'is_local'. 2013-09-25 20:49:23,067 main ERROR [crowd.manager.upgrade.UpgradeManagerImpl] could not execute update query; SQL [update cwd_group set is_local='F' where is_local is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute update query org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute update query; SQL [update cwd_group set is_local='F' where is_local is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute update query at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) {code} Crowd 2.0.x does not have {{is_local}} column in {{cwd_group}} table. However, during the upgrade, Crowd is trying to modify all null values in {{is_local}} column, which is non-existent h4. Environment Information Tested by upgrading from 2.0.6 to 2.6.4 and from 2.0.6 to 2.7 h4. Findings This issue does not occur in MySQL-based Crowd. During the upgrade, the {{is_local}} column is added *before* Crowd tries to modify data in this column. h4. Workarounds You can do one of the following: * Upgrade to Crowd 2.3.x first before upgrading to Crowd 2.6.x and above * Upgrade via [XML data transfer|https://confluence.atlassian.com/display/CROWD/Upgrading+Crowd+via+XML+Data+Transfer]

    Atlassian JIRA | 3 years ago | Amalia Sanusi [Atlassian]
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute update query; SQL [update cwd_group set is_local='F' where is_local is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute update query
  2. 0

    h4. Steps to Reproduce # Install Crowd 2.0.6 using SQL Server # Upgrade Crowd to 2.7.x via [automatic database upgrade|https://confluence.atlassian.com/display/CROWD/Upgrading+Crowd+via+Automatic+Database+Upgrade] h4. Expected Results Upgrade should be successful h4. Actual Results Upgrade fails with the following errors: {code}2013-09-25 20:49:23,018 main INFO [crowd.manager.upgrade.UpgradeManagerImpl] Running upgrade task for build - 427: Updating the local column in cwd_group from null to false 2013-09-25 20:49:23,064 main WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 207, SQLState: 42S22 2013-09-25 20:49:23,064 main ERROR [org.hibernate.util.JDBCExceptionReporter] Invalid column name 'is_local'. 2013-09-25 20:49:23,067 main ERROR [crowd.manager.upgrade.UpgradeManagerImpl] could not execute update query; SQL [update cwd_group set is_local='F' where is_local is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute update query org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute update query; SQL [update cwd_group set is_local='F' where is_local is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute update query at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) {code} Crowd 2.0.x does not have {{is_local}} column in {{cwd_group}} table. However, during the upgrade, Crowd is trying to modify all null values in {{is_local}} column, which is non-existent h4. Environment Information Tested by upgrading from 2.0.6 to 2.6.4 and from 2.0.6 to 2.7 h4. Findings This issue does not occur in MySQL-based Crowd. During the upgrade, the {{is_local}} column is added *before* Crowd tries to modify data in this column. h4. Workarounds You can do one of the following: * Upgrade to Crowd 2.3.x first before upgrading to Crowd 2.6.x and above * Upgrade via [XML data transfer|https://confluence.atlassian.com/display/CROWD/Upgrading+Crowd+via+XML+Data+Transfer]

    Atlassian JIRA | 3 years ago | Amalia Sanusi [Atlassian]
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute update query; SQL [update cwd_group set is_local='F' where is_local is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute update query
  3. 0

    Hibernate Criteria on different objects in a class

    Stack Overflow | 4 weeks ago | SnS
    org.springframework.dao.InvalidDataAccessResourceUsageException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [SAK-16451] DB2 - Glossary tool gets SqlGrammarException - Sakai

    sakaiproject.org | 1 year ago
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    Unexpected Token Error when Creating an XML Backup - Atlassian Documentation

    atlassian.com | 4 months ago
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

    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. org.springframework.dao.InvalidDataAccessResourceUsageException

      could not execute update query; SQL [update cwd_group set is_local='F' where is_local is null]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute update query

      at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException()
    2. Hibernate
      HibernateAccessor.convertHibernateAccessException
      1. org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635)
      2. org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
      2 frames