You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openmeetings.apache.org by "John G (JIRA)" <ji...@apache.org> on 2014/05/22 06:30:39 UTC
[jira] [Commented] (OPENMEETINGS-126) Error during the installation
when MySQL is used for persistence
[ https://issues.apache.org/jira/browse/OPENMEETINGS-126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14005600#comment-14005600 ]
John G commented on OPENMEETINGS-126:
-------------------------------------
I am still experiencing the same issue with version 3.0.1-RELEASE 1587248 14-April-2014:
Incorrect string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1
{prepstmnt 2107496226 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?]}
[code=1366, state=HY000]
I did have to set MySQL default characterset to utf8 as mentioned above, just to get to this error. I then had to set MySQL default characterset to utf8mb4 to correct this issue from the logs above, as well as mine.
"This encoding allows storage of characters that occupy 4 bytes in UTF-8."
I still would get the same error reported, so I checked the database table and column where the error above pointed to (table: fieldlanguagesvalues column: 'value' at row 1). For some odd reason the that database table (fieldlanguagesvalues) had the collation for column 'value' set to latin1_swedish_ci. I changed that to utf8mb4_general_ci and the installation was able to run successfully. I'm not sure why it was just that column, but hope this helps someone.
SQL query to change collation of latin_swedish_ci table column:
ALTER TABLE `fieldlanguagesvalues` CHANGE `value` `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ;
Link that led me in the right direction:
http://stackoverflow.com/questions/10957238/incorrect-string-value-when-trying-to-insert-utf-8-into-mysql-via-jdbc
https://issues.apache.org/jira/browse/OPENMEETINGS-126#
> Error during the installation when MySQL is used for persistence
> ----------------------------------------------------------------
>
> Key: OPENMEETINGS-126
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-126
> Project: Openmeetings
> Issue Type: Bug
> Reporter: Michaël Mathieu
> Assignee: Maxim Solodovnik
> Priority: Blocker
>
> If I install with Derby, I have no error.
> I followed this tuto: http://code.google.com/p/openmeetings/wiki/Configuration_Mysql
> I got this exception:
> DEBUG 04-02 17:10:59.451 ImportInitvalues.java 257924 709 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - Languages ADDED
> DEBUG 04-02 17:10:59.451 ImportInitvalues.java 257924 777 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - loadInitLanguages lang: {id=1, name=english, rtl=false, code=en}
> loadInitLanguages rtl from xml: false
> DEBUG 04-02 17:11:07.427 ImportInitvalues.java 265900 824 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - Lang ADDED: {id=1, name=english, rtl=false, code=en}
> DEBUG 04-02 17:11:07.428 ImportInitvalues.java 265901 777 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - loadInitLanguages lang: {id=2, name=deutsch, rtl=false, code=de}
> loadInitLanguages rtl from xml: false
> DEBUG 04-02 17:11:10.472 ImportInitvalues.java 268945 824 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - Lang ADDED: {id=2, name=deutsch, rtl=false, code=de}
> DEBUG 04-02 17:11:10.472 ImportInitvalues.java 268945 777 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - loadInitLanguages lang: {id=3, name=deutsch (studIP), rtl=false, code=de}
> loadInitLanguages rtl from xml: false
> DEBUG 04-02 17:11:12.927 ImportInitvalues.java 271400 824 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - Lang ADDED: {id=3, name=deutsch (studIP), rtl=false, code=de}
> DEBUG 04-02 17:11:12.928 ImportInitvalues.java 271401 777 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - loadInitLanguages lang: {id=4, name=french, rtl=false, code=fr}
> loadInitLanguages rtl from xml: false
> DEBUG 04-02 17:11:16.326 ImportInitvalues.java 274799 824 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - Lang ADDED: {id=4, name=french, rtl=false, code=fr}
> DEBUG 04-02 17:11:16.327 ImportInitvalues.java 274800 777 org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] - loadInitLanguages lang: {id=5, name=italian, rtl=false, code=it}
> loadInitLanguages rtl from xml: false
> ERROR 04-02 17:11:18.438 Fieldmanagment.java 276911 326 org.openmeetings.app.data.basic.Fieldmanagment [http-0.0.0.0-5080-1] - [getConfKey]:
> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2316) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2153) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2051) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1822) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:609) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.StateManagerImpl.assignField(StateManagerImpl.java:696) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1608) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1591) ~[openjpa-2.1.0.jar:2.1.0]
> at org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.pcGetfieldlanguagesvalues_id(Fieldlanguagesvalues.java) ~[openmeetings.jar:na]
> at org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.getFieldlanguagesvalues_id(Fieldlanguagesvalues.java:44) ~[openmeetings.jar:na]
> at org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAndLanguage(Fieldmanagment.java:322) ~[openmeetings.jar:na]
> at org.openmeetings.app.data.basic.Fieldmanagment$$FastClassByCGLIB$$fd1196f9.invoke(<generated>) [cglib-2.2.2.jar:na]
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [cglib-2.2.2.jar:na]
> at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688) [org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621) [org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.openmeetings.app.data.basic.Fieldmanagment$$EnhancerByCGLIB$$7fe049d4.addFieldValueByFieldAndLanguage(<generated>) [cglib-2.2.2.jar:na]
> at org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java:820) [openmeetings.jar:na]
> at org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java:328) [openmeetings.jar:na]
> at org.apache.velocity.tools.view.VelocityViewServlet.doRequest(VelocityViewServlet.java:217) [velocity-tools-view-2.0.jar:2.0]
> at org.apache.velocity.tools.view.VelocityViewServlet.doPost(VelocityViewServlet.java:192) [velocity-tools-view-2.0.jar:2.0]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) [javaee-api-5.1.2.jar:5.1.2]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) [javaee-api-5.1.2.jar:5.1.2]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.32.jar:6.0.32]
> at org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:35) [openmeetings.jar:na]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.32.jar:6.0.32]
> at org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:78) [red5.jar:na]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina-6.0.32.jar:6.0.32]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) [tomcat-coyote-6.0.32.jar:6.0.32]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote-6.0.32.jar:6.0.32]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.32.jar:6.0.32]
> at java.lang.Thread.run(Thread.java:679) [na:1.6.0_22]
> Caused by: org.apache.openjpa.persistence.PersistenceException: Incorrect string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1 {prepstmnt 2107496226 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?]} [code=1366, state=HY000]
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:143) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:742) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:661) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) ~[openjpa-2.1.0.jar:2.1.0]
> ... 44 common frames omitted
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Incorrect string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1 {prepstmnt 2107496226 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?]} [code=1366, state=HY000]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:257) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1199) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:267) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:118) ~[openjpa-2.1.0.jar:2.1.0]
> ... 56 common frames omitted
> ERROR 04-02 17:11:18.450 Install.java 276923 398 org.openmeetings.servlet.outputhandler.Install [http-0.0.0.0-5080-1] - Install:
> org.springframework.orm.jpa.JpaSystemException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.; nested exception is <openjpa-2.1.0-r422266:1071316 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> FailedObject: org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues@6f7b847c
> at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:311) ~[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120) ~[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:471) ~[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754) ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393) ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120) ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621) ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.openmeetings.app.data.basic.Fieldmanagment$$EnhancerByCGLIB$$7fe049d4.addFieldValueByFieldAndLanguage(<generated>) ~[cglib-2.2.2.jar:na]
> at org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java:820) ~[openmeetings.jar:na]
> at org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java:328) ~[openmeetings.jar:na]
> at org.apache.velocity.tools.view.VelocityViewServlet.doRequest(VelocityViewServlet.java:217) [velocity-tools-view-2.0.jar:2.0]
> at org.apache.velocity.tools.view.VelocityViewServlet.doPost(VelocityViewServlet.java:192) [velocity-tools-view-2.0.jar:2.0]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) [javaee-api-5.1.2.jar:5.1.2]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) [javaee-api-5.1.2.jar:5.1.2]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.32.jar:6.0.32]
> at org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:35) [openmeetings.jar:na]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.32.jar:6.0.32]
> at org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:78) [red5.jar:na]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina-6.0.32.jar:6.0.32]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) [tomcat-coyote-6.0.32.jar:6.0.32]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote-6.0.32.jar:6.0.32]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.32.jar:6.0.32]
> at java.lang.Thread.run(Thread.java:679) [na:1.6.0_22]
> Caused by: org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2316) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2153) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2051) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1822) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:609) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.StateManagerImpl.assignField(StateManagerImpl.java:696) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1608) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1591) ~[openjpa-2.1.0.jar:2.1.0]
> at org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.pcGetfieldlanguagesvalues_id(Fieldlanguagesvalues.java) ~[openmeetings.jar:na]
> at org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.getFieldlanguagesvalues_id(Fieldlanguagesvalues.java:44) ~[openmeetings.jar:na]
> at org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAndLanguage(Fieldmanagment.java:322) ~[openmeetings.jar:na]
> at org.openmeetings.app.data.basic.Fieldmanagment$$FastClassByCGLIB$$fd1196f9.invoke(<generated>) ~[cglib-2.2.2.jar:na]
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[cglib-2.2.2.jar:na]
> at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688) ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> ... 29 common frames omitted
> Caused by: org.apache.openjpa.persistence.PersistenceException: Incorrect string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1 {prepstmnt 2107496226 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?]} [code=1366, state=HY000]
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:143) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:742) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:661) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) ~[openjpa-2.1.0.jar:2.1.0]
> ... 44 common frames omitted
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Incorrect string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1 {prepstmnt 2107496226 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?]} [code=1366, state=HY000]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:257) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1199) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:267) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:118) ~[openjpa-2.1.0.jar:2.1.0]
> ... 56 common frames omitted
> [ERROR] [http-0.0.0.0-5080-1] org.apache.catalina.core.ContainerBase.[red5Engine].[0.0.0.0].[/openmeetings].[Install] - Servlet.service() for servlet Install threw exception
> java.lang.NullPointerException: null
> at org.apache.velocity.tools.view.VelocityView.performMerge(VelocityView.java:942) ~[velocity-tools-view-2.0.jar:2.0]
> at org.apache.velocity.tools.view.VelocityView.merge(VelocityView.java:902) ~[velocity-tools-view-2.0.jar:2.0]
> at org.apache.velocity.tools.view.VelocityViewServlet.mergeTemplate(VelocityViewServlet.java:318) ~[velocity-tools-view-2.0.jar:2.0]
> at org.apache.velocity.tools.view.VelocityViewServlet.doRequest(VelocityViewServlet.java:220) ~[velocity-tools-view-2.0.jar:2.0]
> at org.apache.velocity.tools.view.VelocityViewServlet.doPost(VelocityViewServlet.java:192) ~[velocity-tools-view-2.0.jar:2.0]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) ~[javaee-api-5.1.2.jar:5.1.2]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) ~[javaee-api-5.1.2.jar:5.1.2]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) ~[catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina-6.0.32.jar:6.0.32]
> at org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:35) ~[openmeetings.jar:na]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) ~[catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina-6.0.32.jar:6.0.32]
> at org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:78) ~[red5.jar:na]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) ~[catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) ~[catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.32.jar:6.0.32]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina-6.0.32.jar:6.0.32]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) [tomcat-coyote-6.0.32.jar:6.0.32]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote-6.0.32.jar:6.0.32]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.32.jar:6.0.32]
> at java.lang.Thread.run(Thread.java:679) [na:1.6.0_22]
--
This message was sent by Atlassian JIRA
(v6.2#6252)