Having issues getting the OpenEMPI web site working properly

» Back to forum topics
  6 posts   Feedicon  
Replies: 5 - Last Post: March 03, 2012 08:44
by: yiminxie
« Older Topic » Newer Topic
showing 1 - 6 of 6
 
bmalec
Defaultpersonimage
Posted: March 08, 2011 17:29 by bmalec
» Permalink
Hi guys, hope this is an easy one...

I'm trying to get the OpenEMPI running on my machine so we can eventually push some patient data through it in order to get an idea of how many duplicate patients we have in our system. I have Postgres 8.3 and JBoss 4.2.3.GA installed. I deployed the .war file and have no problem hitting http://localhost:8080/openempi-admin/ but from then on, things start falling apart.

First off, I can get though login page regardless of what I enter. I can use the default admin values, or type in any random username/password and get to the next page. So, something doesn't seem correct there.

Once I'm in the management screen, the Admin menu is always empty.

I can go into the User File Manager and attempt to import the dataset_A_1000.csv file. It appears that the import step worked correctly, but when I look at the Postgres database, I see no data.

However, I do see rows getting inserted to the user_session table, so I know database connectivity is working.

Any ideas?

Thanks,

Ben
 
Csaba Toth
Ctoth-0_small
Posted: March 11, 2011 02:50 by Csaba Toth
» Permalink
Did you set up configuration files?
Which OpenEMPI version are you trying to use?
 
odysseas
Defaultpersonimage
Posted: March 19, 2011 17:16 by odysseas
» Permalink
Ben,

At this point authorization and user management are not supported at the end user level although deep inside the architecture we have the hooks for when this feature is ready. The login screen is basically a placeholder for when this functionality will be available . We are planning to add this functionality in the near term but for now pressing enter to accept the default authentication credentials is all you can do.

The upload of data is a two step process. You first upload the file which brings the file of person demographics to the web server and then you import it to load it into the system. If you have done both steps, upon successful completion the application should indicate next to the filename that it has been successfully uploaded by setting the column uploaded to true. If you are seeing all that an you still don't see any data in the database, then I would look at the openempi.log file to see if there are any errors.

You can post the log file if you need more help.

Odysseas
 
vj1200
Defaultpersonimage
Posted: February 29, 2012 03:11 by vj1200
» Permalink
I am still struggling with the exact same issue Ben mentioned.
This is the log from openempi.log file
thanks


[2012-02-28 17:22:37,711]DEBUG227739[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:410) - Found thread-bound Session for HibernateTemplate
[2012-02-28 17:22:37,762] WARN227790[http-127.0.0.1-8080-2] - org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:77) - SQL Error: 0, SQLState: null
[2012-02-28 17:22:37,763]ERROR227791[http-127.0.0.1-8080-2] - org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78) - Batch entry 0 insert into person (account, account_identifier_domain_id, address1, address2, address_type_cd, birth_order, birth_place, city, country, country_code, custom1, custom10, custom11, custom12, custom13, custom14, custom15, custom16, custom17, custom18, custom19, custom2, custom20, custom3, custom4, custom5, custom6, custom7, custom8, custom9, date_changed, date_created, date_of_birth, date_voided, death_ind, death_time, degree, email, ethnic_group_cd, family_name, family_name2, gender_cd, given_name, group_number, language_cd, marital_status_code, middle_name, mothers_maiden_name, multiple_birth_ind, name_type_cd, nationality_cd, phone_area_code, phone_country_code, phone_ext, phone_number, phone_type_cd, postal_code, prefix, race_cd, religion_cd, ssn, state, suffix, changed_by_id, creator_id, voided_by_id, person_id) values (NULL, NULL, 2 ellerston avenue, rosedale, NULL, NULL, NULL, epping, NULL, NULL, L, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, AL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2012-02-28 17:22:37.707000 -0800, 2012-02-28 17:22:37.707000 -0800, 1917-12-29 -0800, NULL, NULL, NULL, NULL, NULL, NULL, lee, NULL, NULL, elle, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 03 , NULL, NULL, 1056140, NULL, 7000, NULL, NULL, NULL, 7478073, nsw, NULL, 1, 1, NULL, 107) was aborted. Call getNextException to see the cause.
[2012-02-28 17:22:37,765] WARN227793[http-127.0.0.1-8080-2] - org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:77) - SQL Error: 0, SQLState: 42703
[2012-02-28 17:22:37,768]ERROR227796[http-127.0.0.1-8080-2] - org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78) - ERROR: column "account" of relation "person" does not exist
[2012-02-28 17:22:37,769]ERROR227797[http-127.0.0.1-8080-2] - org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:301) - Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateTemplate$28.doInHibernate(HibernateTemplate.java:892)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:890)
at org.openhie.openempi.dao.hibernate.PersonDaoHibernate.addPerson(PersonDaoHibernate.java:63)
at org.openhie.openempi.service.impl.PersonManagerServiceImpl.savePerson(PersonManagerServiceImpl.java:374)
at org.openhie.openempi.service.impl.PersonManagerServiceImpl.addPerson(PersonManagerServiceImpl.java:75)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy88.addPerson(Unknown Source)
at org.openhie.openempi.loader.SpringPersonLoaderManager.addPerson(SpringPersonLoaderManager.java:59)
at org.openhie.openempi.loader.AbstractFileLoader.loadPerson(AbstractFileLoader.java:48)
at org.openhie.openempi.loader.AbstractFileLoader.parseFile(AbstractFileLoader.java:122)
at org.openhie.openempi.loader.AbstractFileLoader.parseFile(AbstractFileLoader.java:97)
at org.openhie.openempi.loader.FileLoaderManager.loadFile(FileLoaderManager.java:55)
at org.openempi.webapp.server.PersonDataServiceImpl.importFileEntry(PersonDataServiceImpl.java:243)
at org.openempi.webapp.server.PersonDataServiceImpl.importUserFile(PersonDataServiceImpl.java:227)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:166)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into person (account, account_identifier_domain_id, address1, address2, address_type_cd, birth_order, birth_place, city, country, country_code, custom1, custom10, custom11, custom12, custom13, custom14, custom15, custom16, custom17, custom18, custom19, custom2, custom20, custom3, custom4, custom5, custom6, custom7, custom8, custom9, date_changed, date_created, date_of_birth, date_voided, death_ind, death_time, degree, email, ethnic_group_cd, family_name, family_name2, gender_cd, given_name, group_number, language_cd, marital_status_code, middle_name, mothers_maiden_name, multiple_birth_ind, name_type_cd, nationality_cd, phone_area_code, phone_country_code, phone_ext, phone_number, phone_type_cd, postal_code, prefix, race_cd, religion_cd, ssn, state, suffix, changed_by_id, creator_id, voided_by_id, person_id) values (NULL, NULL, 2 ellerston avenue, rosedale, NULL, NULL, NULL, epping, NULL, NULL, L, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, AL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2012-02-28 17:22:37.707000 -0800, 2012-02-28 17:22:37.707000 -0800, 1917-12-29 -0800, NULL, NULL, NULL, NULL, NULL, NULL, lee, NULL, NULL, elle, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 03 , NULL, NULL, 1056140, NULL, 7000, NULL, NULL, NULL, 7478073, nsw, NULL, 1, 1, NULL, 107) was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2512)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:399)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1310)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2574)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 57 more
[2012-02-28 17:22:37,772]DEBUG227800[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:435) - Not closing pre-bound Hibernate Session after HibernateTemplate
[2012-02-28 17:22:37,772]DEBUG227800[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:821) - Initiating transaction rollback
[2012-02-28 17:22:37,773]DEBUG227801[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:670) - Rolling back Hibernate transaction on Session [org.hibernate.impl.SessionImpl@19e6d8ab]
[2012-02-28 17:22:37,775]DEBUG227803[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doCleanupAfterCompletion(HibernateTransactionManager.java:730) - Closing Hibernate Session [org.hibernate.impl.SessionImpl@19e6d8ab] after transaction
[2012-02-28 17:22:37,776]DEBUG227804[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.SessionFactoryUtils.closeSession(SessionFactoryUtils.java:789) - Closing Hibernate Session
[2012-02-28 17:22:37,777]ERROR227805[http-127.0.0.1-8080-2] - org.openhie.openempi.loader.AbstractFileLoader.loadPerson(AbstractFileLoader.java:50) - Failed while adding person entry to the system. Error: org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:890)
at org.openhie.openempi.dao.hibernate.PersonDaoHibernate.addPerson(PersonDaoHibernate.java:63)
at org.openhie.openempi.service.impl.PersonManagerServiceImpl.savePerson(PersonManagerServiceImpl.java:374)
at org.openhie.openempi.service.impl.PersonManagerServiceImpl.addPerson(PersonManagerServiceImpl.java:75)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy88.addPerson(Unknown Source)
at org.openhie.openempi.loader.SpringPersonLoaderManager.addPerson(SpringPersonLoaderManager.java:59)
at org.openhie.openempi.loader.AbstractFileLoader.loadPerson(AbstractFileLoader.java:48)
at org.openhie.openempi.loader.AbstractFileLoader.parseFile(AbstractFileLoader.java:122)
at org.openhie.openempi.loader.AbstractFileLoader.parseFile(AbstractFileLoader.java:97)
at org.openhie.openempi.loader.FileLoaderManager.loadFile(FileLoaderManager.java:55)
at org.openempi.webapp.server.PersonDataServiceImpl.importFileEntry(PersonDataServiceImpl.java:243)
at org.openempi.webapp.server.PersonDataServiceImpl.importUserFile(PersonDataServiceImpl.java:227)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:166)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateTemplate$28.doInHibernate(HibernateTemplate.java:892)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
... 50 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into person (account, account_identifier_domain_id, address1, address2, address_type_cd, birth_order, birth_place, city, country, country_code, custom1, custom10, custom11, custom12, custom13, custom14, custom15, custom16, custom17, custom18, custom19, custom2, custom20, custom3, custom4, custom5, custom6, custom7, custom8, custom9, date_changed, date_created, date_of_birth, date_voided, death_ind, death_time, degree, email, ethnic_group_cd, family_name, family_name2, gender_cd, given_name, group_number, language_cd, marital_status_code, middle_name, mothers_maiden_name, multiple_birth_ind, name_type_cd, nationality_cd, phone_area_code, phone_country_code, phone_ext, phone_number, phone_type_cd, postal_code, prefix, race_cd, religion_cd, ssn, state, suffix, changed_by_id, creator_id, voided_by_id, person_id) values (NULL, NULL, 2 ellerston avenue, rosedale, NULL, NULL, NULL, epping, NULL, NULL, L, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, AL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2012-02-28 17:22:37.707000 -0800, 2012-02-28 17:22:37.707000 -0800, 1917-12-29 -0800, NULL, NULL, NULL, NULL, NULL, NULL, lee, NULL, NULL, elle, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 03 , NULL, NULL, 1056140, NULL, 7000, NULL, NULL, NULL, 7478073, nsw, NULL, 1, 1, NULL, 107) was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2512)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:399)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1310)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2574)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 57 more
[2012-02-28 17:22:37,779]ERROR227807[http-127.0.0.1-8080-2] - org.openempi.webapp.server.PersonDataServiceImpl.importFileEntry(PersonDataServiceImpl.java:245) - Failed to parse and upload the file C:\servers\jboss-4.2.3.GA\bin\fileRepository\dataset_A_1000.csv due to org.springframework.dao.InvalidDataAccessResourceUsageException cannot be cast to org.hibernate.exception.SQLGrammarException
[2012-02-28 17:22:37,780]DEBUG227808[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) - Creating new transaction with name [org.openhie.openempi.service.UserManager.getUserFile]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
[2012-02-28 17:22:37,781]DEBUG227809[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:496) - Opened new Session [org.hibernate.impl.SessionImpl@662ec7f1] for Hibernate transaction
[2012-02-28 17:22:37,782]DEBUG227810[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:507) - Preparing JDBC Connection of Hibernate Session [org.hibernate.impl.SessionImpl@662ec7f1]
[2012-02-28 17:22:37,784]DEBUG227812[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:572) - Exposing Hibernate transaction as JDBC transaction [jdbcTongueostgresql://localhost/openempi, UserName=openempi, PostgreSQL Native Driver]
[2012-02-28 17:22:37,785]DEBUG227813[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:410) - Found thread-bound Session for HibernateTemplate
[2012-02-28 17:22:37,793]DEBUG227821[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:435) - Not closing pre-bound Hibernate Session after HibernateTemplate
[2012-02-28 17:22:37,794]DEBUG227822[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:730) - Initiating transaction commit
[2012-02-28 17:22:37,795]DEBUG227823[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:651) - Committing Hibernate transaction on Session [org.hibernate.impl.SessionImpl@662ec7f1]
[2012-02-28 17:22:37,798]DEBUG227826[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doCleanupAfterCompletion(HibernateTransactionManager.java:730) - Closing Hibernate Session [org.hibernate.impl.SessionImpl@662ec7f1] after transaction
[2012-02-28 17:22:37,799]DEBUG227827[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.SessionFactoryUtils.closeSession(SessionFactoryUtils.java:789) - Closing Hibernate Session
[2012-02-28 17:22:37,800]DEBUG227828[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) - Creating new transaction with name [org.openhie.openempi.service.UserManager.saveUserFile]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-UserExistsException
[2012-02-28 17:22:37,801]DEBUG227829[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:496) - Opened new Session [org.hibernate.impl.SessionImpl@3ce40293] for Hibernate transaction
[2012-02-28 17:22:37,802]DEBUG227830[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:507) - Preparing JDBC Connection of Hibernate Session [org.hibernate.impl.SessionImpl@3ce40293]
[2012-02-28 17:22:37,803]DEBUG227831[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:572) - Exposing Hibernate transaction as JDBC transaction [jdbcTongueostgresql://localhost/openempi, UserName=openempi, PostgreSQL Native Driver]
[2012-02-28 17:22:37,804]DEBUG227832[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doGetTransaction(HibernateTransactionManager.java:442) - Found thread-bound Session [org.hibernate.impl.SessionImpl@3ce40293] for Hibernate transaction
[2012-02-28 17:22:37,805]DEBUG227833[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:469) - Participating in existing transaction
[2012-02-28 17:22:37,805]DEBUG227833[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doGetTransaction(HibernateTransactionManager.java:442) - Found thread-bound Session [org.hibernate.impl.SessionImpl@3ce40293] for Hibernate transaction
[2012-02-28 17:22:37,806]DEBUG227834[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:469) - Participating in existing transaction
[2012-02-28 17:22:37,807]DEBUG227835[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:410) - Found thread-bound Session for HibernateTemplate
[2012-02-28 17:22:37,814]DEBUG227842[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:435) - Not closing pre-bound Hibernate Session after HibernateTemplate
[2012-02-28 17:22:37,815]DEBUG227843[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:410) - Found thread-bound Session for HibernateTemplate
[2012-02-28 17:22:37,819]DEBUG227847[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:435) - Not closing pre-bound Hibernate Session after HibernateTemplate
[2012-02-28 17:22:37,820]DEBUG227848[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:730) - Initiating transaction commit
[2012-02-28 17:22:37,821]DEBUG227849[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:651) - Committing Hibernate transaction on Session [org.hibernate.impl.SessionImpl@3ce40293]
[2012-02-28 17:22:37,827]DEBUG227855[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doCleanupAfterCompletion(HibernateTransactionManager.java:730) - Closing Hibernate Session [org.hibernate.impl.SessionImpl@3ce40293] after transaction
[2012-02-28 17:22:37,828]DEBUG227856[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.SessionFactoryUtils.closeSession(SessionFactoryUtils.java:789) - Closing Hibernate Session
[2012-02-28 17:22:37,852]DEBUG227880[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) - Creating new transaction with name [org.openhie.openempi.service.UserManager.getUserByUsername]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
[2012-02-28 17:22:37,853]DEBUG227881[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:496) - Opened new Session [org.hibernate.impl.SessionImpl@14b512cb] for Hibernate transaction
[2012-02-28 17:22:37,854]DEBUG227882[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:507) - Preparing JDBC Connection of Hibernate Session [org.hibernate.impl.SessionImpl@14b512cb]
[2012-02-28 17:22:37,856]DEBUG227884[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:572) - Exposing Hibernate transaction as JDBC transaction [jdbcTongueostgresql://localhost/openempi, UserName=openempi, PostgreSQL Native Driver]
[2012-02-28 17:22:37,856]DEBUG227884[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doGetTransaction(HibernateTransactionManager.java:442) - Found thread-bound Session [org.hibernate.impl.SessionImpl@14b512cb] for Hibernate transaction
[2012-02-28 17:22:37,856]DEBUG227884[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:469) - Participating in existing transaction
[2012-02-28 17:22:37,857]DEBUG227885[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:410) - Found thread-bound Session for HibernateTemplate
[2012-02-28 17:22:37,861]DEBUG227889[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:435) - Not closing pre-bound Hibernate Session after HibernateTemplate
[2012-02-28 17:22:37,871]DEBUG227899[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:730) - Initiating transaction commit
[2012-02-28 17:22:37,872]DEBUG227900[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:651) - Committing Hibernate transaction on Session [org.hibernate.impl.SessionImpl@14b512cb]
[2012-02-28 17:22:37,876]DEBUG227904[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doCleanupAfterCompletion(HibernateTransactionManager.java:730) - Closing Hibernate Session [org.hibernate.impl.SessionImpl@14b512cb] after transaction
[2012-02-28 17:22:37,878]DEBUG227906[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.SessionFactoryUtils.closeSession(SessionFactoryUtils.java:789) - Closing Hibernate Session
[2012-02-28 17:22:37,880]DEBUG227908[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) - Creating new transaction with name [org.openhie.openempi.service.UserManager.getUserFiles]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
[2012-02-28 17:22:37,880]DEBUG227908[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:496) - Opened new Session [org.hibernate.impl.SessionImpl@4f0ea988] for Hibernate transaction
[2012-02-28 17:22:37,880]DEBUG227908[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:507) - Preparing JDBC Connection of Hibernate Session [org.hibernate.impl.SessionImpl@4f0ea988]
[2012-02-28 17:22:37,880]DEBUG227908[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:572) - Exposing Hibernate transaction as JDBC transaction [jdbcTongueostgresql://localhost/openempi, UserName=openempi, PostgreSQL Native Driver]
[2012-02-28 17:22:37,880]DEBUG227908[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:410) - Found thread-bound Session for HibernateTemplate
[2012-02-28 17:22:37,897]DEBUG227925[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:435) - Not closing pre-bound Hibernate Session after HibernateTemplate
[2012-02-28 17:22:37,898]DEBUG227926[http-127.0.0.1-8080-2] - org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:730) - Initiating transaction commit
[2012-02-28 17:22:37,898]DEBUG227926[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:651) - Committing Hibernate transaction on Session [org.hibernate.impl.SessionImpl@4f0ea988]
[2012-02-28 17:22:37,901]DEBUG227929[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.HibernateTransactionManager.doCleanupAfterCompletion(HibernateTransactionManager.java:730) - Closing Hibernate Session [org.hibernate.impl.SessionImpl@4f0ea988] after transaction
[2012-02-28 17:22:37,902]DEBUG227930[http-127.0.0.1-8080-2] - org.springframework.orm.hibernate3.SessionFactoryUtils.closeSession(SessionFactoryUtils.java:789) - Closing Hibernate Session
 
vj1200
Defaultpersonimage
Posted: February 29, 2012 03:12 by vj1200
» Permalink
Also, my openEMPI version is 2.2.0.
 
yiminxie
Defaultpersonimage
Posted: March 03, 2012 08:44 by yiminxie
» Permalink
Looks like the database schema is out of sync with the code version you are using.

For the 2.2.0 release you need to run the script:

create_new_database_schema-2.2.0.sql

followed by the update script:

update_database_schema-2.2.0.sql

Let me know if that resolves your issue.

Amy
showing 1 - 6 of 6
Replies: 5 - Last Post: March 03, 2012 08:44
by: yiminxie
« Older Topic » Newer Topic
  • Mysql
  • Glassfish
  • Jruby
  • Rails
  • Nblogo
Terms of Use; Privacy Policy;
© 2010, Oracle Corporation and/or its affiliates
(revision 20120518.3c65429)
 
 
Close
loading
Please Confirm
Close