Uploaded image for project: 'Jahia Community'
  1. Jahia Community
  2. JAHIA-4909

Can't delete a virtual site with SQL Server

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • xCM 6.1.0
    • xCM 6.0 SP1
    • None

    Description

      2010-03-23 15:03:24,641: ERROR [org.hibernate.util.JDBCExceptionReporter] - Conversion failed when converting the varchar value 'ContentField_' to data type int.
      2010-03-23 15:03:24,641: ERROR [org.jahia.bin.JahiaAdministration] - Error during sites operation of a new element we must flush all caches to ensure integrity betw
      viewing
      org.hibernate.exception.SQLGrammarException: could not execute update query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.hql.ast.UpdateStatementExecutor.execute(UpdateStatementExecutor.java:99)
      at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:297)
      at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:871)
      at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:89)
      at org.jahia.hibernate.dao.JahiaLinkDAO.deleteAllLinksForSite(JahiaLinkDAO.java:70)
      at org.jahia.hibernate.dao.JahiaSiteDAO.remove(JahiaSiteDAO.java:297)
      at org.jahia.hibernate.manager.JahiaSiteManager.remove(JahiaSiteManager.java:73)
      at org.jahia.hibernate.manager.JahiaSiteManager$$FastClassByCGLIB$$1ec2bf09.invoke(<generated>)
      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
      at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:546)
      at org.jahia.hibernate.manager.JahiaSiteManager$$EnhancerByCGLIB$$c9a77abc.remove(<generated>)
      at org.jahia.services.sites.JahiaSitesBaseService.removeSite(JahiaSitesBaseService.java:341)
      at org.jahia.services.sites.JahiaSitesBaseService$$FastClassByCGLIB$$4d40271e.invoke(<generated>)
      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
      at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
      at org.jahia.services.sites.JahiaSitesBaseService$$EnhancerByCGLIB$$e79403cb.removeSite(<generated>)
      at org.jahia.admin.sites.ManageSites.delete(ManageSites.java:2228)
      at org.jahia.admin.sites.ManageSites.processMultipleDelete(ManageSites.java:2128)
      at org.jahia.admin.sites.ManageSites.userRequestDispatcher(ManageSites.java:201)
      at org.jahia.admin.sites.ManageSites.<init>(ManageSites.java:154)
      at org.jahia.bin.JahiaAdministration.userRequestDispatcher(JahiaAdministration.java:401)
      at org.jahia.bin.JahiaAdministration.service(JahiaAdministration.java:266)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the varchar value 'ContentField_' to data type int.
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
      at org.hibernate.hql.ast.UpdateStatementExecutor.execute(UpdateStatementExecutor.java:76)
      ... 50 more
      2010-03-23 15:03:24,985: INFO [org.jahia.services.cache.CacheFactory] - Flushed all caches.

      TestRail: Results

        Attachments

          Activity

            People

              pap@commaro.com_old Benjamin Papez (Inactive)
              srouaud_old Stéphanie Rouaud (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                TestRail: Runs

                  TestRail: Cases

                    Packages

                      Version Package
                      xCM 6.1.0