trouble running dataload
Submitted by dadmin on Fri, 29/05/2009 - 13:24
I am trying to do a fresh install openvpms on windows 2000 and keep running into this error when running dataload setup. I have just tried to install on osX to check I wasn't doing something wrong and have got the same error message:
INFO StaxArchetypeDataLoader,main:233 - Using application context [../conf/applicationContext.xml] log4j:WARN No appenders could be found for logger (org.hibernate.util.JDBCExceptionReporter). log4j:WARN Please initialize the log4j system properly. Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'archetypeDescriptorCache' defined in file [/Users/macbook/Desktop/openvpms-release-1.3/bin/../conf/applicationContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.FatalBeanException: Could not instantiate class [org.openvpms.component.business.service.archetype.descriptor.cache.ArchetypeDescriptorCacheDB]; constructor threw exception; nested exception is org.openvpms.component.business.dao.im.common.IMObjectDAOException: Failed to find IMObjects for class org.openvpms.component.business.dao.hibernate.im.archetype.AssertionTypeDescriptorDO with shortName: descriptor.assertionType and instanceName: null. org.springframework.beans.FatalBeanException: Could not instantiate class [org.openvpms.component.business.service.archetype.descriptor.cache.ArchetypeDescriptorCacheDB]; constructor threw exception; nested exception is org.openvpms.component.business.dao.im.common.IMObjectDAOException: Failed to find IMObjects for class org.openvpms.component.business.dao.hibernate.im.archetype.AssertionTypeDescriptorDO with shortName: descriptor.assertionType and instanceName: null. org.openvpms.component.business.dao.im.common.IMObjectDAOException: Failed to find IMObjects for class org.openvpms.component.business.dao.hibernate.im.archetype.AssertionTypeDescriptorDO with shortName: descriptor.assertionType and instanceName: null. at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:455) at org.openvpms.component.business.service.archetype.descriptor.cache.ArchetypeDescriptorCacheDB.loadAssertionTypeDescriptors(ArchetypeDescriptorCacheDB.java:84) at org.openvpms.component.business.service.archetype.descriptor.cache.ArchetypeDescriptorCacheDB.(ArchetypeDescriptorCacheDB.java:74) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:75) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:669) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:329) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:318) at org.springframework.context.support.FileSystemXmlApplicationContext. (FileSystemXmlApplicationContext.java:83) at org.springframework.context.support.FileSystemXmlApplicationContext. (FileSystemXmlApplicationContext.java:68) at org.springframework.context.support.FileSystemXmlApplicationContext. (FileSystemXmlApplicationContext.java:59) at org.openvpms.tools.data.loader.StaxArchetypeDataLoader.init(StaxArchetypeDataLoader.java:238) at org.openvpms.tools.data.loader.StaxArchetypeDataLoader. (StaxArchetypeDataLoader.java:115) at org.openvpms.tools.data.loader.StaxArchetypeDataLoader.main(StaxArchetypeDataLoader.java:125) Caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select assertiont0_.assertion_type_desc_id as assertion1_11_, assertiont0_.version as version11_, assertiont0_.linkId as linkId11_, assertiont0_.name as name11_, assertiont0_.arch_short_name as arch5_11_, assertiont0_.arch_version as arch6_11_, assertiont0_.active as active11_, assertiont0_.property_archetype as property8_11_ from assertion_type_descriptors assertiont0_ where assertiont0_.arch_short_name=? and assertiont0_.active=1]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openvpms.assertion_type_descriptors' doesn't exist at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:223) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:363) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:331) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.execute(IMObjectDAOHibernate.java:1093) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:587) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:451) ... 20 more Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openvpms.assertion_type_descriptors' doesn't exist at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2136) at org.hibernate.loader.Loader.list(Loader.java:2096) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$5.doInHibernate(IMObjectDAOHibernate.java:619) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:358) ... 24 more
trouble running dataload
This error is the key: MySQLSyntaxErrorException: Table 'openvpms.assertion_type_descriptors' doesn't exist
You need to have created the database first, as per http://www.openvpms.org/documentation/new-install
-Tim
Re: New or updated comment for Implementation discussion Forum t
Thanks Tim,
I knew it would be something obvious.
Matt.