Error creating Taks

Collapse
This topic is closed.
X
X
Collapse
+ More Options
Posts
 
  • Time
  • Show
Clear All
new posts
  • juwo
    Junior Member
    • Nov 2010
    • 14

    #1

    Error creating Taks

    Hi,

    i get some strange error message while trying to create a task:

    "Table sequence_task contains no row for context 1"

    The task cannot be created. This error seems to appear since the update to version 6.18.2 Rev16 ( 2011-01-18 17:07:11 )

    Kind Regards,
    Jürgen
    Last edited by juwo; 01-28-2011, 01:01 PM. Reason: Spelling....
  • Martin Heiland
    Open-Xchange Quality Assurance
    • Feb 2007
    • 3695

    #2
    Hi Jürgen,

    please check the open-xchange logfile at the server. There must be some entry for the specific error. This detailed error message greatly helps finding the issue. When updating, please make sure that the database update tasks are executed correctly and all OX packages are updated to the same minor version number.

    Greetings

    Comment

    • juwo
      Junior Member
      • Nov 2010
      • 14

      #3
      Hi Martin,

      thanks for the reply. The database update scripts ran fine during the update. The packages seem to be all at the same major and minor version. In the logs I see the following entries when the error is triggered:

      Feb 1, 2011 6:13:05 PM com.openexchange.ajax.Tasks doPut
      SEVERE: TSK-0001 Category=8 Message=Error while inserting task: Table sequence_task contains no row for context 1. exceptionID=574781701-2800
      TSK-0001 Category=8 Message=Error while inserting task: Table sequence_task contains no row for context 1. exceptionID=574781701-2800
      at com.openexchange.groupware.tasks.Tools.convert(Too ls.java:308)
      at com.openexchange.groupware.tasks.TasksSQLImpl.inse rtTaskObject(TasksSQLImpl.java:216)
      at com.openexchange.ajax.request.TaskRequest.actionNe w(TaskRequest.java:187)
      at com.openexchange.ajax.request.TaskRequest.action(T askRequest.java:154)
      at com.openexchange.ajax.Tasks.doPut(Tasks.java:153)
      at javax.servlet.http.HttpServlet.service(HttpServlet .java:619)
      at com.openexchange.ajax.AJAXServlet.service(AJAXServ let.java:402)
      at com.openexchange.ajax.SessionServlet.service(Sessi onServlet.java:184)
      at com.openexchange.ajax.PermissionServlet.service(Pe rmissionServlet.java:81)
      at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
      at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.doServletService(AJPv13RequestHandlerImpl.java: 517)
      at com.openexchange.ajp13.AJPv13Request.response(AJPv 13Request.java:129)
      at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.createResponse(AJPv13RequestHandlerImpl.java:32 9)
      at com.openexchange.ajp13.najp.AJPv13ConnectionImpl.c reateResponse(AJPv13ConnectionImpl.java:235)
      at com.openexchange.ajp13.najp.AJPv13Task.call(AJPv13 Task.java:352)
      at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:269)
      at java.util.concurrent.FutureTask.run(FutureTask.jav a:123)
      at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:750)
      at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:776)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: TSK-0001 Category=8 Message=Error while inserting task: Table sequence_task contains no row for context 1. exceptionID=574781701-2799
      at com.openexchange.groupware.tasks.TaskLogic.insertT ask(TaskLogic.java:730)
      at com.openexchange.groupware.tasks.TasksSQLImpl.inse rtTaskObject(TasksSQLImpl.java:214)
      ... 18 more
      Caused by: java.sql.SQLException: Table sequence_task contains no row for context 1
      at com.openexchange.groupware.impl.IDGenerator$NoDBFu nction.getInternal(IDGenerator.java:505)
      at com.openexchange.groupware.impl.IDGenerator$NoDBFu nction.getId(IDGenerator.java:447)
      at com.openexchange.groupware.impl.IDGenerator.getId( IDGenerator.java:174)
      at com.openexchange.groupware.impl.IDGenerator.getId( IDGenerator.java:158)
      at com.openexchange.groupware.tasks.TaskLogic.insertT ask(TaskLogic.java:720)
      ... 19 more


      Kind Regards,
      Jürgen

      Comment

      • Martin Heiland
        Open-Xchange Quality Assurance
        • Feb 2007
        • 3695

        #4
        Hi Jürgen,

        thanks for the information, do you only get this for tasks? Whats about appointments and contacts?

        Greetings

        Comment

        • juwo
          Junior Member
          • Nov 2010
          • 14

          #5
          Hi Martin,

          I only get this during task creation. Appointments, contacts, emails and email-lists are created without any errors.

          Kind Regards,
          Jürgen

          Comment

          • juwo
            Junior Member
            • Nov 2010
            • 14

            #6
            Hi,

            after updating to Version : 6.18.2 Rev19 ( 2011-02-03 13:19:23 ) the error is still there.

            Kind Regards,
            Jürgen

            Comment

            • Martin Heiland
              Open-Xchange Quality Assurance
              • Feb 2007
              • 3695

              #7
              Hi,

              please feel free to open a support ticket.

              Greetings

              Comment

              Working...