Hi,
Don't know if anyone else is experiencing this when installing but I'm
getting a java exception and the install fails
Windows 2k3 box, Xampp 1.7.3, r4260
Install creates the database and starts populating it. It gets to
adding ID 236 then starts on the language files. When it reaches
Italian it throws an exception. as below.
Has anyone come across this Incorrect String Value and more
importantly does anyone know how to fix?
Many thanks
David
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException:
Incorrect string v
alue: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1
{prepstmnt 16307
093 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id,
language_id, star
ttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?)
[params=?, ?, ?, ?, ?, ?]} [
code=1366, state=HY000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:281) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:257) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(Lo
ggingConnectionDecorator.java:72) ~[openjpa-2.1.0.jar:2.1.0]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator
$LoggingConnect
ion
$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.executeUp
date(PreparedStatementManagerImpl.java:267) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndU
pdate(PreparedStatementManagerImpl.java:118) ~[openjpa-2.1.0.jar:
2.1.0]
... 56 common frames omitted
ERROR 09-22 16:26:46.624 Install.java 181441 405
org.openmeetings.servlet.output
handler.Install [http-0.0.0.0-5080-2] - Install:
org.springframework.orm.jpa.JpaSystemException: The transaction has
been rolled
back. See the nested exceptions for details on the errors that
occurred.; neste
d exception is <openjpa-2.1.0-r422266:1071316 fatal general error>
org.apache.op
enjpa.persistence.PersistenceException: The transaction has been
rolled back. S
ee the nested exceptions for details on the errors that occurred.
FailedObject:
org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues@1
89c979
at
org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAcces
sExceptionIfPossible(EntityManagerFactoryUtils.java:311)
~[org.springframework.o
rm-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at
org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPos
sible(DefaultJpaDialect.java:120)
~[org.springframework.orm-3.0.5.RELEASE.jar:3.
0.5.RELEASE]
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransac
tionManager.java:471) ~[org.springframework.orm-3.0.5.RELEASE.jar:
3.0.5.RELEASE]
at
org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java:754)
~[org.springfra
mework.transaction-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at
org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java:723)
~[org.springframework.
transaction-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at
org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java:393)
~[org.springf
ramework.transaction-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:120)
~[org.springframework.transaction-3.0.5.RE
LEASE.jar:3.0.5.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
~[org.springframework.aop-3.0.5.RELEASE.jar
:3.0.5.RELEASE]
at org.springframework.aop.framework.Cglib2AopProxy
$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:621)
~[org.springframework.aop-3.0.5.RELEASE
.jar:3.0.5.RELEASE]
at org.openmeetings.app.data.basic.Fieldmanagment$
$EnhancerByCGLIB$$9df7
c0fe.addFieldValueByFieldAndLanguage(<generated>)
~[cglib-2.2.2.jar:na]
at
org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(
ImportInitvalues.java:793) ~[openmeetings.jar:na]
at
org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.
java:338) ~[openmeetings.jar:na]
at
org.apache.velocity.tools.view.VelocityViewServlet.doRequest(Velocity
ViewServlet.java:217) [velocity-tools-view-2.0.jar:2.0]
at
org.apache.velocity.tools.view.VelocityViewServlet.doPost(VelocityVie
wServlet.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(Appl
icationFilterChain.java:290) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina-6.0.26.jar:6.0.26]
at
org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilte
r(ServletRequestExFilter.java:35) [openmeetings.jar:na]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina-6.0.26.jar:6.0.26]
at
org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.jav
a:78) [red5.jar:na]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:465) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
555) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298) [catalina-6.0.26.jar:6.0.26]
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:852) [tomcat-coyote-6.0.26.jar:6.0.26]
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.proce
ss(Http11Protocol.java:588) [tomcat-coyote-6.0.26.jar:6.0.26]
at org.apache.tomcat.util.net.JIoEndpoint
$Worker.run(JIoEndpoint.java:48
9) [tomcat-coyote-6.0.26.jar:6.0.26]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_27]
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.jav
a:2316) ~[openjpa-2.1.0.jar:2.1.0]
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:
2153) ~[op
enjpa-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) ~[op
enjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManage
rImpl.java:609) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.kernel.StateManagerImpl.assignField(StateManagerIm
pl.java:696) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateMan
agerImpl.java:1608) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManage
rImpl.java:1591) ~[openjpa-2.1.0.jar:2.1.0]
at
org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.pcGe
tfieldlanguagesvalues_id(Fieldlanguagesvalues.java)
~[openmeetings.jar:na]
at
org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.getF
ieldlanguagesvalues_id(Fieldlanguagesvalues.java:44)
~[openmeetings.jar:na]
at
org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAn
dLanguage(Fieldmanagment.java:332) ~[openmeetings.jar:na]
at org.openmeetings.app.data.basic.Fieldmanagment$
$FastClassByCGLIB$$fd1
196f9.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
$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:688)
~[org.springframework.aop-3.0.5.RELEA
SE.jar:3.0.5.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
~[org.springframework.aop-3.0.5.RELEASE.jar
:3.0.5.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:110)
~[org.springframework.transaction-3.0.5.RE
LEASE.jar:3.0.5.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 163
07093 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id,
language_id, st
arttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?)
[params=?, ?, ?, ?, ?, ?]}
[code=1366, state=HY000]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:486
9) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictiona
ry.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.flushAndU
pdate(PreparedStatementManagerImpl.java:143) ~[openjpa-2.1.0.jar:
2.1.0]
at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.f
lushAndUpdate(BatchingPreparedStatementManagerImpl.java:81)
~[openjpa-2.1.0.jar:
2.1.0]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInte
rnal(PreparedStatementManagerImpl.java:99) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(Pre
paredStatementManagerImpl.java:87) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(Constrai
ntUpdateManager.java:550) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(Constrai
ntUpdateManager.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(AbstractUp
dateManager.java:103) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUp
dateManager.java:76) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManage
r.java:742) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStor
eManager.java:131) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheSto
reManager.java:661) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStor
eManager.java:131) ~[openjpa-2.1.0.jar:2.1.0]
... 44 common frames omitted
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException:
Incorrect string v
alue: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1
{prepstmnt 16307
093 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id,
language_id, star
ttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?)
[params=?, ?, ?, ?, ?, ?]} [
code=1366, state=HY000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:281) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:257) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(Lo
ggingConnectionDecorator.java:72) ~[openjpa-2.1.0.jar:2.1.0]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator
$LoggingConnect
ion
$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.executeUp
date(PreparedStatementManagerImpl.java:267) ~[openjpa-2.1.0.jar:2.1.0]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndU
pdate(PreparedStatementManagerImpl.java:118) ~[openjpa-2.1.0.jar:
2.1.0]
... 56 common frames omitted
[ERROR] [http-0.0.0.0-5080-2] org.apache.catalina.core.ContainerBase.
[red5Engine
].[0.0.0.0].[/openmeetings].[Install] - Servlet.service() for servlet
Install th
rew 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:9
02) ~[velocity-tools-view-2.0.jar:2.0]
at
org.apache.velocity.tools.view.VelocityViewServlet.mergeTemplate(Velo
cityViewServlet.java:318) ~[velocity-tools-view-2.0.jar:2.0]
at
org.apache.velocity.tools.view.VelocityViewServlet.doRequest(Velocity
ViewServlet.java:220) ~[velocity-tools-view-2.0.jar:2.0]
at
org.apache.velocity.tools.view.VelocityViewServlet.doPost(VelocityVie
wServlet.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(Appl
icationFilterChain.java:290) ~[catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) ~[catalina-6.0.26.jar:6.0.26]
at
org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilte
r(ServletRequestExFilter.java:35) ~[openmeetings.jar:na]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235) ~[catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) ~[catalina-6.0.26.jar:6.0.26]
at
org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.jav
a:78) ~[red5.jar:na]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235) ~[catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) ~[catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233) ~[catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:465) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
555) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109) [catalina-6.0.26.jar:6.0.26]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298) [catalina-6.0.26.jar:6.0.26]
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:852) [tomcat-coyote-6.0.26.jar:6.0.26]
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.proce
ss(Http11Protocol.java:588) [tomcat-coyote-6.0.26.jar:6.0.26]
at org.apache.tomcat.util.net.JIoEndpoint
$Worker.run(JIoEndpoint.java:48
9) [tomcat-coyote-6.0.26.jar:6.0.26]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_27]
DEBUG 09-22 16:29:00.466 Sessionmanagement.java 315283 499
org.openmeetings.app.
data.basic.Sessionmanagement
[org.springframework.scheduling.quartz.SchedulerFac
toryBean#0_Worker-5] - ****** clearSessionTable:
DEBUG 09-22 16:29:00.466 Sessionmanagement.java 315283 483
org.openmeetings.app.
data.basic.Sessionmanagement
[org.springframework.scheduling.quartz.SchedulerFac
toryBean#0_Worker-5] - Sessions To Delete :: 0
DEBUG 09-22 16:29:00.466 Sessionmanagement.java 315283 503
org.openmeetings.app.
data.basic.Sessionmanagement
[org.springframework.scheduling.quartz.SchedulerFac
toryBean#0_Worker-5] - clearSessionTable: 0
--
You received this message because you are subscribed to the Google Groups
"OpenMeetings User" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/openmeetings-user?hl=en.
