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

When i try to print a custom report i get a InternalError: current transaction is aborted, commands ignored until end of transaction block

By
Erhuvwu Akpobaro
on 11/18/14, 9:40 AM 748 views

I am getting a tricky error and was wondering of anubody has come across or can help , the error reads :

 File "/opt/odoo/odoo/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block

 

 

Module background

the custom module made , create a database view which takes data from other tables(account voucher and account analytic) in the database and displays the infromation, currently  the model persist in odoo and it shows data records i want it to show , however when i print i get the error stated above , also in my report xml file if i leave it blank , i can then print a blank pdf document.

 

Here below is the :

My class :

class cm_sales_receipt(osv.osv):
    _name = "cm.sales.receipt"
    _description = "Camden Market Sales Receipt"
    _auto = False
    _columns = {
        'paymentref':fields.char('PaymentRef'),
        'date':fields.date('Date'),
        'receipt_number':fields.char('Receipt Number'),
        'customer':fields.char('Customer',size=128),
        'unit':fields.char('Unit',size=128),
        'company':fields.char('Name',size=128,required=True),
        'invoicing_company':fields.char('Invoicing Company', size=128,required=True),
        'street':fields.char('Street',size=128,required=True),
        'street2':fields.char('Street2',size=128,required=True),
        'zip':fields.char('Zip',size=10,required=True),
        'state':fields.char('State',size=128,required=True),
        'city':fields.char('City',size=128,required=True),
        'email':fields.char('Email',size=128),
        'fax':fields.integer('Fax'),
        'phone':fields.integer('State'),
        'paid_amount':fields.float('Paid_Amount'),

    }

_order = 'date desc, paid_amount desc'
    def init(self, cr):
        tools.sql.drop_view_if_exists(cr, 'cm_sales_receipt')
        cr.execute("""
            create or replace view cm_sales_receipt as (
                select
                    c.id as id,
                    a.name as customer,
                    c.number as receipt_number,
                    c.reference as PaymentRef,
                    (select e.name from res_company e where c.company_id = e.id) as company,
                    (select f.name from res_company f where a.invcompany_id = f.id) as invoicing_company,
                    (select s.street from res_partner s where s.id = (select w.partner_id from res_company w where id = a.invcompany_id)) as street,
                    (select s.street2 from res_partner s where s.id = (select w.partner_id from res_company w where id = a.invcompany_id)) as street2,
                    (select s.zip from res_partner s where s.id = (select w.partner_id from res_company w where id = a.invcompany_id)) as zip,
                    (select t.name from res_country_state t where t.id = (select s.state_id from res_partner s where s.id = (select w.partner_id from res_company w where id = a.invcompany_id))) as state,
                    (select s.city from res_partner s where s.id = (select w.partner_id from res_company w where id = a.invcompany_id)) as city,
                    (select s.email from res_partner s where a.invcompany_id = s.id) as email,
                    (select s.fax from res_partner s where a.invcompany_id = s.id) as fax,
                    (select s.phone from res_partner s where a.invcompany_id = s.id) as phone,
                    c.amount as paid_amount,
                    c.date as date from
                    account_analytic_account a,
                    account_voucher c where a.partner_id = c.partner_id
                group by
                        c.id,
                        a.name,
                        c.number,
                        c.reference,
                        c.amount,
                        c.company_id,
                        a.invcompany_id,
                        c.date
                         
            )
        """)

Here below is the code used  to print the report (note function is indented so part of above class :

 def print_receipt(self, cr, uid, ids, context=None):
        """
        This function prints the Property Rental Sales receipt
        """
        assert len(ids) == 1, 'This option should only be used for a single id at a time.'
        #self.sent = True
        return self.pool['report'].get_action(cr, uid, ids, 'cm_sales_receipt.report_salesreceipt', context=context)

 

extract from view which has print button (note: print button displays correctly in module:

 <!-- Property Rental Sales Receipt Form View -->
        <record model="ir.ui.view" id="view_cm_sales_receipt_form">
            <field name="name">cm.sales.receipt.form</field>
            <field name="model">cm.sales.receipt</field>
            <field name="arch" type="xml">
                <form string=" Sales Receipt" version="8.0">
                <header>
                    <button name="print_receipt" string="Print Receipt" type="object" class="oe_highlight" groups="base.group_user"/>
                </header>
                                <sheet>
                                <group>
                                        <group>
                                               <field name="invoicing_company"/>
                           <field name="customer"/>
                                               <field name="paymentref"/>
                           <field name="receipt_number"/>
                           <field name="company"/>
                                               <field name="paid_amount"/>
                                    </group>
                                        </group>
                                        </sheet>
                </form>
            </field>
        </record>

 

 

here is the report xml file(note: if i change the model below to account.voucher i can print a report from that model if i use the correct fields , but with the cm.sales.receipt i cannot :

<openerp>
    <data>
        <report
            string="Sales Rental Receipt"
            id="action_cm_report_sales_receipt"
            model="cm.sales.receipt"
            report_type="qweb-pdf"
            name="cm_sales_receipt.report_cm_salesreceipt"
            file="cm_sales_receipt.report_cm_salesreceipt"
            attachment_use="True"
            attachment="(object.state in ('open','paid')) and ('RCPT'+(object.number or '').replace('/','')+'.pdf')"
        />
    </data>
</openerp>

 

 

  1. It seems that the model cannot call the data listed in the created database view
  2. maybe the xml syntax for calling the view is different from when you want call a particular field from  a  module
0
Osval Reyes
On 9/15/15, 7:41 PM

Hi Erhuvwu,

How you handled out this error?

Hello Osval , The reason I had this error was because if you look at my code I had a field called units , which was not being populated by the def init(self, cr): function resulting in an error , once I removed this it work.

Erhuvwu Akpobaro
on 9/16/15, 7:11 AM

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: 11/18/14, 9:40 AM
Seen: 748 times
Last updated: 9/15/15, 7:41 PM