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] | 4 years 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

    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 | 4 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 | 4 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 | 5 months 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 | 2 years ago
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

    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