4 Replies Latest reply on Apr 27, 2010 3:40 AM by Michal Vanco

    Gadget Problem With SQL Server 2005

    Fred Curry Newbie

      When I set my portal and persistence databases to use SQL Server 2005, I can no longer render gadgets. Instead, I get a file not found error:

       

      data/gatein/jcr/values/portal-system_portal/2/6/7/f/e/7/b/7c0a8640a490b477b4901b1f4/267fe7b7c0a8640a490b477b4901b1f40 (No such file or directory): /Applications/jbdevstudio/jboss-eap/GateIn-3.0.0-GA/server/SQLOnly/data/gatein/jcr/values/portal-system_portal/2/6/7/f/e/7/b/7c0a8640a490b477b4901b1f4/267fe7b7c0a8640a490b477b4901b1f40 (No such file or directory)
          at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.getItemByName(JDBCStorageConnection.java:918)
          at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.getItemData(JDBCStorageConnection.java:763)
          at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.getItemData(WorkspacePersistentDataManager.java:808)
          at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.getPersistedItemData(CacheableWorkspaceDataManager.java:621)
          at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.getItemData(CacheableWorkspaceDataManager.java:397)
          at org.exoplatform.services.jcr.impl.dataflow.persistent.ACLInheritanceSupportedWorkspaceDataManager.getItemData(ACLInheritanceSupportedWorkspaceDataManager.java:170)
          at org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWorkspaceDataManager.getItemData(VersionableWorkspaceDataManager.java:141)
          at org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.getItemData(TransactionableDataManager.java:232)
          at org.exoplatform.services.jcr.impl.core.SessionDataManager.getItemData(SessionDataManager.java:221)
          at org.exoplatform.services.jcr.impl.core.SessionDataManager.getItemData(SessionDataManager.java:178)
          at org.exoplatform.services.jcr.impl.core.SessionDataManager.getItem(SessionDataManager.java:320)
          at org.exoplatform.services.jcr.impl.core.NodeImpl.getProperty(NodeImpl.java:1198)
          at org.exoplatform.services.jcr.webdav.resource.FileResource.dataProperty(FileResource.java:396)
          at org.exoplatform.services.jcr.webdav.resource.FileResource.getContentAsStream(FileResource.java:347)
          at org.exoplatform.services.jcr.webdav.command.GetCommand.get(GetCommand.java:118)
          at org.exoplatform.services.jcr.webdav.WebDavServiceImpl.get(WebDavServiceImpl.java:548)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:597)
          at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:140)
          at org.exoplatform.services.rest.impl.RequestDispatcher.invokeSubResourceMethod(RequestDispatcher.java:302)
          at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:244)
          at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:147)
          at org.exoplatform.services.rest.impl.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:136)
          at org.exoplatform.services.rest.servlet.RestServlet.onService(RestServlet.java:82)
          at org.exoplatform.container.web.AbstractHttpServlet.service(AbstractHttpServlet.java:116)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.exoplatform.services.rest.servlet.RestEncodingFilter.doFilter(RestEncodingFilter.java:58)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitializedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:116)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilter(SetCurrentIdentityFilter.java:76)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
          at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
          at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
          at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
          at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
          at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
          at java.lang.Thread.run(Thread.java:637)

      ...

       

      which ultimaltely results in a 500 error:

       

      Failed to render gadget http://localhost:8080/rest/jcr/repository/portal-system/production/app:gadgets/app:Calculator/app:data/app:resources/Calculator.xml: Unable to retrieve gadget xml. HTTP error 500

       

      Has anyone seen this before? It is fine when I use the out-of-the box Hypersonic configuration.

       

      Fred