[
https://issues.apache.org/jira/browse/OPENMEETINGS-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maxim Solodovnik resolved OPENMEETINGS-1019.
--------------------------------------------
Resolution: Fixed
Fix Version/s: 3.1.0
Assignee: Maxim Solodovnik (was: SebastianWagner)
Committed revision 1601542.
> 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: Maxim Solodovnik
> Fix For: 3.0.3, 3.1.0
>
>
> 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)
