Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Big issue untraceable. Workflow stucked

By
Zahin
on 1/16/15, 10:07 AM 907 views

Working around Open ERP since a long, a generic issue most comes is workflow stucked.

We create daily 100s of sales order, some of sales order  stucked in workflow. 

Like when sale order workflow at create invoice, & when try to create invoice related to it.

It just create new blank , just ugly openerp/odoo, never idetify what problem their.

 

 

@Zahin,

have you tried checking your logs, or changing the logs to debug sql or debug? This may help point you in the right direction of what is going wrong.

Luke Branch
on 2/12/15, 4:38 AM

SOLUTION 1 Q1 => UPDATE wkf_workitem SET act_id = 128, state = 'complete' WHERE inst_id IN (SELECT id from wkf_instance WHERE res_id IN (SELECT distinct(s.id) FROM sale_order AS s LEFT JOIN sale_order_line AS l on s.id = l.order_id WHERE s.state = 'manual' AND l.state != 'done' ORDER BY s.id) AND res_type='sale.order' AND state='active') Q2 => UPDATE sale_order_line SET state = 'done' WHERE order_id IN (SELECT distinct(s.id) FROM sale_order AS s LEFT JOIN sale_order_line AS l on s.id = l.order_id WHERE s.state = 'manual' AND l.state != 'done' ORDER BY s.id) SOLUTION 2 Module sale_set_to_draft

bernscheinder
on 2/12/15, 8:37 AM

act_id = 128, state = 'complete 128 => workflow action in manual state

bernscheinder
on 2/12/15, 8:38 AM
3
bernscheinder
On 2/12/15, 4:01 AM

Hi zahin,

same problem for me, I resolved it by sql query in "wkf_workitem" table.

The problem is that the status of the order lines is draft instead of done.

If you have managed it, please share!!

Sincerly,

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)

Stats

Asked: 1/16/15, 10:07 AM
Seen: 907 times
Last updated: 3/16/15, 8:10 AM