Uploaded image for project: 'MyCoRe'
  1. MCR-1085

The execution of the cli command "check classification" causes the error "Relation »mcrcategory« existiert nicht."

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 2015.05.0, 2015.07
    • Fix Version/s: 2015.05.01, 2016.02
    • Component/s: None
    • Labels:
      None
    • Environment:

      mir.war build from trunk
      postgress db (9.1.16)

      Description

      The execution of the cli command "check classification" causes the error "Relation »mcrcategory« existiert nicht".

      Complete Stacktrace:
      INFO: Processing command:'check classification mir_institutes' (0 left)

      INFO: Syntax matched (executed): check classification

      {0}

      INFO: Checking classifcation mir_institutes

      INFO: mir_institutes: checking left, right and level values and for non-null children

      ERROR: Some errors occured on last test, report will follow

      INFO: mir_institutes: checking for empty labels

      ERROR: FEHLER: Relation »mcrcategory« existiert nicht
      Position: 25

      ERROR: Command 'check classification mir_institutes' failed. Performing transaction rollback...

      java.lang.reflect.InvocationTargetException
      at sun.reflect.GeneratedMethodAccessor706.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:483)
      at org.mycore.frontend.cli.MCRCommand.invoke(MCRCommand.java:252)
      at org.mycore.webcli.servlets.MCRWebCLIContainer$ProcessCallable.runCommand(MCRWebCLIContainer.java:276)
      at org.mycore.webcli.servlets.MCRWebCLIContainer$ProcessCallable.processCommand(MCRWebCLIContainer.java:244)
      at org.mycore.webcli.servlets.MCRWebCLIContainer$ProcessCallable.processCommands(MCRWebCLIContainer.java:333)
      at org.mycore.webcli.servlets.MCRWebCLIContainer$ProcessCallable.call(MCRWebCLIContainer.java:224)
      at org.mycore.webcli.servlets.MCRWebCLIContainer$ProcessCallable.call(MCRWebCLIContainer.java:201)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      at java.lang.Thread.run(Thread.java:745)
      Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
      at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:2116)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1899)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1875)
      at org.hibernate.loader.Loader.doQuery(Loader.java:919)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
      at org.hibernate.loader.Loader.doList(Loader.java:2611)
      at org.hibernate.loader.Loader.doList(Loader.java:2594)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2423)
      at org.hibernate.loader.Loader.list(Loader.java:2418)
      at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:336)
      at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1898)
      at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:318)
      at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:125)
      at org.mycore.frontend.cli.MCRClassification2Commands.checkEmptyLabels(MCRClassification2Commands.java:531)
      at org.mycore.frontend.cli.MCRClassification2Commands.checkClassification(MCRClassification2Commands.java:490)
      ... 15 more
      Caused by: org.postgresql.util.PSQLException: FEHLER: Relation »mcrcategory« existiert nicht
      Position: 25
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
      ... 30 more

        Attachments

          Activity

            People

            • Assignee:
              yagee Thomas Scheffler
              Reporter:
              mcrpabor Paul Borchert
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: