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

Odoo 9 Closed Cursor Issues

By
Blue Stingray Digital Agency
on 4/11/16, 12:02 AM 219 views

When a user tries to validate an invoice they get a closed cursor error after about the third validation. They log out and then back in again and can do a few more before getting the error. Below are some of my results from trying to narrow down the issue. 

Copy of DB on the same server - No issues. 
In the test database which is an exact duplicate of production. It's on the exact same server instance and it's using the exact same Odoo code as production. We are able to quickly validate around 20 invoices no problem. 
Then we log into production DB and try to validate invoices. We experience the issue where every time we validate an invoice we get the spinning wheel and then a closed cursor error. 
The only difference between the two instances is the number of users that are currently accessing the DB. 

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

1 follower(s)

Stats

Asked: 4/11/16, 12:02 AM
Seen: 219 times
Last updated: 4/11/16, 12:51 AM