org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian. crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] (blah blah blah)

Atlassian JIRA | Jesse Callaway | 6 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

    Going through the setup wizard I got an exception when trying to set the Deployment title, Session timeout, and Base URL. Error displayed: "could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] " From tomcat logs: 2011-08-18 21:33:17,363 http-8095-3 ERROR [console.action.setup.Options] could not load an entity: [com.atlassian.crowd.model.property.Property#compo nent[key,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.at lassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] org.springframework.dao.InvalidDataAccessResourceUsageException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key ,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian. crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] (blah blah blah) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) ... 114 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crowd.cwd_property' doesn't exist Looking at the database: mysql> use crowd; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +----------------------------+ | Tables_in_crowd | +----------------------------+ | cwd_app_dir_group_mapping | | cwd_app_dir_mapping | | cwd_app_dir_operation | | cwd_application | | cwd_application_address | | cwd_application_alias | | cwd_application_attribute | | cwd_directory | | cwd_directory_attribute | | cwd_directory_operation | | cwd_group | | cwd_membership | | cwd_token | | cwd_user | | cwd_user_credential_record | | hibernate_unique_key | +----------------------------+ 16 rows in set (0.00 sec) I'm using MyISAM, the hibernate dialect is MySQLDialect. My guess is that the schema creation code didn't create all the tables.

    Atlassian JIRA | 6 years ago | Jesse Callaway
    org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian. crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] (blah blah blah)
  2. 0

    Going through the setup wizard I got an exception when trying to set the Deployment title, Session timeout, and Base URL. Error displayed: "could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] " From tomcat logs: 2011-08-18 21:33:17,363 http-8095-3 ERROR [console.action.setup.Options] could not load an entity: [com.atlassian.crowd.model.property.Property#compo nent[key,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.at lassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] org.springframework.dao.InvalidDataAccessResourceUsageException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key ,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian. crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] (blah blah blah) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) ... 114 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crowd.cwd_property' doesn't exist Looking at the database: mysql> use crowd; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +----------------------------+ | Tables_in_crowd | +----------------------------+ | cwd_app_dir_group_mapping | | cwd_app_dir_mapping | | cwd_app_dir_operation | | cwd_application | | cwd_application_address | | cwd_application_alias | | cwd_application_attribute | | cwd_directory | | cwd_directory_attribute | | cwd_directory_operation | | cwd_group | | cwd_membership | | cwd_token | | cwd_user | | cwd_user_credential_record | | hibernate_unique_key | +----------------------------+ 16 rows in set (0.00 sec) I'm using MyISAM, the hibernate dialect is MySQLDialect. My guess is that the schema creation code didn't create all the tables.

    Atlassian JIRA | 6 years ago | Jesse Callaway
    org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian. crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] (blah blah blah)

    Root Cause Analysis

    1. org.hibernate.exception.SQLGrammarException

      could not load an entity: [com.atlassian. crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] (blah blah blah)

      at org.springframework.orm.hibernate3.HibernateTemplate.doExecute()
    2. Hibernate
      HibernateTemplate.doExecute
      1. org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
      1 frame