Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2010
    Posts
    14

    Default Error creating Tasks

    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 at 01:01 PM. Reason: Spelling....

  2. #2
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    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

  3. #3
    Join Date
    Nov 2010
    Posts
    14

    Default

    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

  4. #4
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    Hi Jürgen,

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

    Greetings

  5. #5
    Join Date
    Nov 2010
    Posts
    14

    Default

    Hi Martin,

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

    Kind Regards,
    Jürgen

  6. #6
    Join Date
    Nov 2010
    Posts
    14

    Default

    Hi,

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

    Kind Regards,
    Jürgen

  7. #7
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    Hi,

    please feel free to open a support ticket.

    Greetings

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •