Home › Forum › Allgemeines › Installation › Fehler beim Laden der Daten für das Businessobjekt
- Dieses Thema hat 2 Antworten und 2 Teilnehmer, und wurde zuletzt aktualisiert vor 9 Jahren, 8 Monaten von
Thomas Hempel.
-
AutorBeiträge
-
21 März 2014 um 16:29 Uhr #7530
Thomas Hempel
TeilnehmerHallo,
beim Anlegen der Benutzergruppen ist ein Fehler aufgetreten. Ich wollte eine Benutzergruppe administratoren anlegen. Danach konnten keine Gruppen mehr gelesen werden:
org.nuclos.common2.exception.CommonFatalException: Fehler beim Laden der Daten für das Businessobjekt exNI.
at org.nuclos.client.masterdata.MasterDataDelegate.getMasterDataProxyList(MasterDataDelegate.java:288)
at org.nuclos.client.ui.collect.search.MasterDataSearchStrategy.getSearchResult(MasterDataSearchStrategy.java:113)
at org.nuclos.client.ui.collect.search.MasterDataObservableSearchWorker.getResult(MasterDataObservableSearchWorker.java:41)
at org.nuclos.client.ui.collect.search.MasterDataObservableSearchWorker.getResult(MasterDataObservableSearchWorker.java:1)
at org.nuclos.client.ui.collect.result.SearchResultStrategy$1$1.work(SearchResultStrategy.java:176)
at org.nuclos.client.ui.CommonMultiThreader$WorkerThread.run(CommonMultiThreader.java:136)
Caused by: org.nuclos.server.dblayer.DbException: executeQuery(WITH PAGINGTEMP AS (SELECT t.STRUID STRUID, t.DATCREATED DATCREATED, t.STRCREATED STRCREATED, t.DATCHANGED DATCHANGED, t.STRCHANGED STRCHANGED, t.INTVERSION INTVERSION, t.STRROLE STRROLE, t.STRUID_T_MD_ROLE STRUID_T_MD_ROLE, t.STRUID_T_MD_NUCLET STRUID_T_MD_NUCLET, a_nuclet78.NAME STRVALUE_T_MD_NUCLET , ROW_NUMBER() OVER () AS RN FROM T_MD_ROLE AS t LEFT OUTER JOIN T_AD_APPLICATION a_nuclet78 ON (t.STRUID_T_MD_NUCLET = a_nuclet78.STRUID) WHERE (1=1)) SELECT * FROM PAGINGTEMP WHERE RN > 0 AND RN <= 2) failed at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.wrapSQLException(StandardSqlDBAccess.java:792) at org.nuclos.server.dblayer.impl.standard.TransactSqlDbAccess.wrapSQLException(TransactSqlDbAccess.java:112) at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:357) at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:243) at org.nuclos.server.dal.processor.jdbc.impl.EntityObjectProcessor.getChunkBySearchExpression(EntityObjectProcessor.java:333) at org.nuclos.server.dal.processor.jdbc.impl.EntityObjectProcessor.getChunkBySearchExpression(EntityObjectProcessor.java:258) at org.nuclos.server.masterdata.ejb3.MasterDataFacadeHelper.getMasterDataChunk(MasterDataFacadeHelper.java:1222) at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.getMasterDataChunk_aroundBody20(MasterDataFacadeBean.java:511) at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean$AjcClosure21.run(MasterDataFacadeBean.java:1) at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:59) at org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:65) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:63) at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.getMasterDataChunk(MasterDataFacadeBean.java:509) at org.nuclos.server.masterdata.MasterDataProxyList.fetchChunk(MasterDataProxyList.java:67) at org.nuclos.server.genericobject.AbstractProxyList.fetchChunk(AbstractProxyList.java:198) at org.nuclos.server.genericobject.AbstractProxyList.fetchDataChunk(AbstractProxyList.java:239) at org.nuclos.server.genericobject.AbstractProxyList.fetchDataIfNecessary(AbstractProxyList.java:185) at org.nuclos.server.genericobject.AbstractProxyList.get(AbstractProxyList.java:126) at org.nuclos.server.genericobject.AbstractProxyList.size(AbstractProxyList.java:104) at org.nuclos.server.genericobject.AbstractProxyList.initialize(AbstractProxyList.java:95) at org.nuclos.server.masterdata.MasterDataProxyList.(MasterDataProxyList.java:62)
at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.getMasterDataProxyList_aroundBody4(MasterDataFacadeBean.java:251)
at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean$AjcClosure5.run(MasterDataFacadeBean.java:1)
at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:59)
at org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:65)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:63)
at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.getMasterDataProxyList(MasterDataFacadeBean.java:247)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:77)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy86.getMasterDataProxyList(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205)
at org.nuclos.server.common.NuclosRemoteInvocationExecutor.invoke(NuclosRemoteInvocationExecutor.java:180)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)
at org.nuclos.server.common.NuclosHttpInvokerServiceExporter.invokeAndCreateResult(NuclosHttpInvokerServiceExporter.java:13)
at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:73)
at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:150)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.springframework.remoting.support.RemoteInvocationUtils.fillInClientStackTraceIfPossible(RemoteInvocationUtils.java:45)
at org.springframework.remoting.support.RemoteInvocationResult.recreate(RemoteInvocationResult.java:115)
at org.springframework.remoting.support.RemoteInvocationBasedAccessor.recreateRemoteInvocationResult(RemoteInvocationBasedAccessor.java:85)
at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:148)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy20.getMasterDataProxyList(Unknown Source)
at org.nuclos.client.masterdata.MasterDataDelegate.getMasterDataProxyList(MasterDataDelegate.java:281)
... 5 more
Caused by: java.sql.SQLException: Für die "ROW_NUMBER"-Rangfolgefunktion ist eine ORDER BY-Klausel erforderlich.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$4.perform(StandardSqlDBAccess.java:338)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:172)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:328)
... 113 more
Wie kann ich das rückgängig machen?
Dank und Gruß
Thomas Hempel23 März 2014 um 03:02 Uhr #7534Ramin Goettlich
TeilnehmerDas ist auf einen Bug zurückzuführen, der nur unter MS SQL auftritt. Der Bug ist bereits behoben (4.0.14), die Version wird am Montag zum Download auf unserer Website bereitgestellt.
Der Fehler tritt immer dann auf, wenn Daten vorhanden sind und in der Ergebnisliste nach keiner Spalte sortiert ist (das Problem betrifft alle Masken, nicht nur die Benutzergruppen).
Kurzfristiger Workaround: Eine Suchbedingung eingeben, die keinen Datensatz findet, dann im (leeren) Suchergebnis nach einer beliebigen Spalte sortieren. Danach funktionierts.
23 März 2014 um 05:22 Uhr #7535Thomas Hempel
Teilnehmerok, verstanden, workaround funktioniert
Danke!
-
AutorBeiträge