Jarosław Maciejewski created OPENMEETINGS-1019:
--------------------------------------------------
Summary: RemoteControl: problem with sql
Key: OPENMEETINGS-1019
URL: https://issues.apache.org/jira/browse/OPENMEETINGS-1019
Project: Openmeetings
Issue Type: Bug
Components: Moodle-Plugin, SOAP/REST API
Affects Versions: 3.0.3
Environment: linux mint 17
java 1.6
Reporter: Jarosław Maciejewski
Assignee: SebastianWagner
Fix For: 3.0.3
I installed OM from night building.... ok... works
I installed plugin OM for Moodle, I created room, I want enter to this room
from Moodle and... I get error.
In console I get message:
RROR 06-10 02:12:45.794 MainService.java 251703 391
org.apache.openmeetings.remote.MainService [NioProcessor-5] -
[loginUserByRemote]
javax.persistence.NoResultException: Query "SELECT u FROM User u WHERE
u.deleted = false AND u.externalUserId LIKE :externalId AND u.externalUserType
LIKE :externalType" selected no result, but expected unique result.
at
org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:332)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openmeetings.db.dao.user.UserDao.getExternalUser(UserDao.java:524)
~[openmeetings-db-3.0.3-SNAPSHOT.jar:na]
at
org.apache.openmeetings.db.dao.user.UserDao$$FastClassByCGLIB$$1492ba5a.invoke(<generated>)
~[com.springsource.net.sf.cglib-2.2.0.jar:na]
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
~[com.springsource.net.sf.cglib-2.2.0.jar:na]
at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
~[spring-tx-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.apache.openmeetings.db.dao.user.UserDao$$EnhancerByCGLIB$$95f91b43.getExternalUser(<generated>)
~[com.springsource.net.sf.cglib-2.2.0.jar:na]
at
org.apache.openmeetings.remote.MainService.loginUserByRemote(MainService.java:342)
[openmeetings-core-3.0.3-SNAPSHOT.jar:na]
at
org.apache.openmeetings.remote.MainService.secureLoginByRemote(MainService.java:217)
[openmeetings-core-3.0.3-SNAPSHOT.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.6.0_45]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
~[na:1.6.0_45]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
~[na:1.6.0_45]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_45]
at
org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196)
[red5.jar:na]
at
org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115)
[red5.jar:na]
at
org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157)
[red5.jar:na]
at org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399)
[red5.jar:na]
at
org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)
[red5.jar:na]
at
org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164)
[red5.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
[mina-core-2.0.4.jar:na]
at
org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124)
[red5.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141)
[mina-core-2.0.4.jar:na]
at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
[mina-core-2.0.4.jar:na]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
[na:1.6.0_45]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
[na:1.6.0_45]
at java.lang.Thread.run(Thread.java:662) [na:1.6.0_45]
DEBUG 06-10 02:12:45.804 MainService.java 251713 235
org.apache.openmeetings.remote.MainService [NioProcessor-5] - loginReturn IS <
0 for SID: 37113af137dc0cdcc2643d26781b7c56
[INFO] [NioProcessor-5] org.red5.server.net.rtmp.codec.RTMPProtocolDecoder -
Action xmlcrm.getTimeZones
[INFO] [NioProcessor-5] org.red5.server.net.rtmp.codec.RTMPProtocolDecoder -
Action errorservice.getErrorByCode
DEBUG 06-10 02:12:45.972 ErrorService.java 251881 56
org.apache.openmeetings.remote.ErrorService [NioProcessor-5] - errorid,
language_id: -1|1
DEBUG 06-10 02:12:45.985 ErrorService.java 251894 60
org.apache.openmeetings.remote.ErrorService [NioProcessor-5] -
eValues.getFieldvalues_id() = 334
DEBUG 06-10 02:12:45.986 ErrorService.java 251895 61
org.apache.openmeetings.remote.ErrorService [NioProcessor-5] -
eValues.getErrorType() =
org.apache.openmeetings.db.entity.basic.ErrorType@120f5c9
[INFO] [NioProcessor-5] org.red5.server.net.rtmp.codec.RTMPProtocolDecoder -
Action xmlcrm.getTimeZones
[INFO] [NioProcessor-5] org.red5.server.net.rtmp.codec.RTMPProtocolDecoder -
Action xmlcrm.getTimeZones
[INFO] [NioProcessor-5] org.red5.server.net.rtmp.codec.RTMPProtocolDecoder -
Action xmlcrm.getTimeZones
How can I fix it?
--
This message was sent by Atlassian JIRA
(v6.2#6252)
