[OPENMEETINGS-1019] RemoteControl: problem with sql

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.3
• Fix Version/s: 3.0.3, 4.0.0
• Component/s: Plugins, SOAP/REST API
• Environment: linux mint 17; java 1.6
• Assignee: Maxim Solodovnik
• Reporter: Jarosław Maciejewski
• Created: 10/Jun/14 00:54
• Updated: 06/Aug/14 18:03
• Resolved: 10/Jun/14 02:05

Description

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?