Trunk: Document-Button in Outlook-Addin gives Error message

Bug #931523 reported by René Glauser
18
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Fix Released
Medium
OpenERP R&D Addons Team 1

Bug Description

I try to evaluate the new Outlook-Plugin on a x64-System with Outlook 2007 and get always the followin error-message when I push the button: "Documents"

"fault response contains string calue where integer expected [fault response : struct mapped to type Fault : member faultCode mapped to type Int32]"

Connection to server and broqsing of partners works well...

Tags: maintenance

Related branches

Revision history for this message
Michael (OpenERP) (mva-openerp) wrote :

Could you give us more information: The exact steps or maybe a screencast recording. And the traceback found in the server logs ?

Changed in openobject-addons:
status: New → Incomplete
Revision history for this message
René Glauser (rene-glauser) wrote :

Please find below my traceback and the attached screenshot:

2012-02-16 13:05:34,171 3515 INFO ? mail: Parsing Message without message-id, generating a random one: 1329397534.17
2012-02-16 13:05:34,171 3515 ERROR ? openerp.sql_db: Programming error: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (132939...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT "mail_message".id FROM "mail_message" WHERE (mail_message."message_id" in (%s)) ORDER BY date desc
2012-02-16 13:05:34,172 3515 ERROR ? openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
  File "/home/erp/openerp6.1rc1/server/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/erp/openerp6.1rc1/server/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/erp/openerp6.1rc1/server/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/erp/openerp6.1rc1/addons/plugin/plugin_handler.py", line 51, in document_get
    msg_ids = mail_message_obj.search(cr, uid, [('message_id','in',references)])
  File "/home/erp/openerp6.1rc1/server/openerp/osv/orm.py", line 2241, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/erp/openerp6.1rc1/server/openerp/osv/orm.py", line 4561, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/erp/openerp6.1rc1/server/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/home/erp/openerp6.1rc1/server/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (132939...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

2012-02-16 13:05:34,173 3515 ERROR ? openerp.netsvc: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (132939...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Revision history for this message
Michael (OpenERP) (mva-openerp) wrote :

Thank you for your answering,

could you answer some questions:
-What kind of email is it? (draft, send email ?)
-Do you have this issue with every mail?

Best regards,

Michael

Revision history for this message
René Glauser (rene-glauser) wrote :

Hi Michael
It seems that i have tha same issue with every object in outlook from type "E-Mail" (draft, sent, inbox). There are other objects in Outlook from type Task, Meeting without error-message, but nothing happens when I press the button "Documents" on these objects.
René

Revision history for this message
Maximo Schettini (maximo-b) wrote :

I have the same problem and I found that the object returned by message_from_string is not getting back the headers. The problem is on the function that is not parsing ok. Why this could be happening?

Revision history for this message
René Glauser (rene-glauser) wrote :

Now I installed the new 64bit-Version of the outlook-plugin and the "OpenERP"-menu in Outlook dissappeard completely !!!!!????

Revision history for this message
Nimesh Contractor(Open ERP) (nco-openerp) wrote :

Hello René Glauser (rene-glauser) ,

             For "OpenERP"-menu in Outlook dissappeard problem can you see the https://bugs.launchpad.net/openobject-addons/+bug/916670 branch.
             And it is also available in trunk.

Thank You,
    NCO.

Revision history for this message
Nimesh Contractor(Open ERP) (nco-openerp) wrote :

Hello René Glauser,

  It has been fix in https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-931523-nco
branch.
           Revision ID: <email address hidden>
           Revision num : 6623.

           Thanks for reporting us .

Thanks,
 NCO.

Changed in openobject-addons:
status: Incomplete → Fix Committed
Amit Parik (amit-parik)
Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 1 (openerp-dev-addons1)
importance: Undecided → Medium
Revision history for this message
Raphael Collet (OpenERP) (rco-openerp) wrote :

Landed in trunk
revno: 6628 [merge]
revision-id: <email address hidden>

Changed in openobject-addons:
status: Fix Committed → Fix Released
Revision history for this message
6reduk@gmail.com (6reduk) wrote :

how i can get plugin for outlook with this patch?
I use openerp 6.1 nightly build that contains all plugins. I try install separetly plugin "outlook" for openerp(in nightly build he called plugin_outlook), i thinks that he contain new version plugin for outlook, but can't do it cause he depense from "mail_gateway plugin". Plugin mail_gate already install but called simple "mail". I need reinstall all modules that provide nightly build? Plz help or show/direct to correct documentation. Thanks.

Revision history for this message
Gianluca Gori @ LS (gaga) wrote :

Hi,
with openerp 6.1.1, addons rev 6792 I have the same error again, the same evidenced before the fix on 6628.

Can somebody confirm it ?
Thanks
LG

Revision history for this message
Gianluca Gori @ LS (gaga) wrote :

hello...any news?

Revision history for this message
Ignas Karpiejus @ hbee (ignas-karpiejus) wrote :

Hello,

I still get the same described error "fault response contains string calue where integer expected [fault response : struct mapped to type Fault : member faultCode mapped to type Int32]" with 6.1 stable addons and none menu with trunk outlook addon with outlook 2007 version, are there some news on this?

tags: added: maintenance
Revision history for this message
Ravi Gohil (OpenERP) (rgo-openerp) wrote :

For V6.1, this issue should be fixed by,
Branch: lp:~openerp-dev/openobject-addons/6.1-opw-584763-rgo
Rev Id: <email address hidden>
Rev #: 7199

Thanks.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.