openerp-india team mailing list archive

[Houssine <972482@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

on version 6.0.3 under windows

Trying to import coda files.

It doesn't happen with all CODA file only with the ones from one belgian
bank.

On the server logs I can see the following stacktrace :

[2012-03-28 17:14:05,460][TLB_2012] ERROR:db.cursor:bad query: insert into "account_bank_statement_line" (id,"partner_id","name","ref","statement_id","note","date","amount","voucher_id","type","account_id",create_uid,create_date) values (9001,1,E'Primes exceptionnelles 2010-2011 ',E'00010000',672,E'Partner name:Sabine RINGELHEIM
 Partner Account Number:BE51630500209962
 Communication:Primes exceptionnelles 2010-2011
001Sabine RINGELHEIM
Rue Antoine Breart, 165
Ordre de paiement : Bénéficiaire : IBAN : BE51630500209962 Sabine RINGELH
EIM Rue Antoine Breart, 165
 Communication: Primes exceptionnelles 2010-2011 R
éférence du donneur d''ordre : 201203161130024083ISABEL
 Value Date:2012-03-16
 Entry Date:2012-03-16
',E'(''2012-03-16'',)',E'-230.68',NULL,E'general',2645,1,now())
Traceback (most recent call last):
  File "sql_db.pyo", line 131, in execute
DataError: invalid byte sequence for encoding "UTF8": 0xe96ee9
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

** Affects: openobject-addons
     Importance: Undecided
         Status: Fix Released

** Changed in: openobject-addons
       Status: New => Fix Released

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/972482

Title:
  bug importing coda

Status in OpenERP Addons (modules):
  Fix Released

Bug description:
  on version 6.0.3 under windows

  Trying to import coda files.

  It doesn't happen with all CODA file only with the ones from one
  belgian bank.

  On the server logs I can see the following stacktrace :

  [2012-03-28 17:14:05,460][TLB_2012] ERROR:db.cursor:bad query: insert into "account_bank_statement_line" (id,"partner_id","name","ref","statement_id","note","date","amount","voucher_id","type","account_id",create_uid,create_date) values (9001,1,E'Primes exceptionnelles 2010-2011 ',E'00010000',672,E'Partner name:Sabine RINGELHEIM
   Partner Account Number:BE51630500209962
   Communication:Primes exceptionnelles 2010-2011
  001Sabine RINGELHEIM
  Rue Antoine Breart, 165
  Ordre de paiement : Bénéficiaire : IBAN : BE51630500209962 Sabine RINGELH
  EIM Rue Antoine Breart, 165
   Communication: Primes exceptionnelles 2010-2011 R
  éférence du donneur d''ordre : 201203161130024083ISABEL
   Value Date:2012-03-16
   Entry Date:2012-03-16
  ',E'(''2012-03-16'',)',E'-230.68',NULL,E'general',2645,1,now())
  Traceback (most recent call last):
    File "sql_db.pyo", line 131, in execute
  DataError: invalid byte sequence for encoding "UTF8": 0xe96ee9
  HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/972482/+subscriptions