trouble running dataload

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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

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

Linux/Windows:
cd <openvpms_tmp>
cd db
mysql -u root -p
mysql> drop database openvpms;
mysql> source createdb.sql;
mysql> use openvpms;
mysql> source db.sql;
mysql> quit;

 

-Tim

 

Re: New or updated comment for Implementation discussion Forum t

Thanks Tim,

I knew it would be something obvious.

Matt.

Syndicate content