Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

[SOLVED] How to solve ascii 4,00 Stuk(s 4 5 ordinal not in range(128)

Subscribe

Get notified when there's activity on this post

This question has been flagged
modulespythonubuntuupgradeasciiupgrades
1 Reply
8859 Views
Avatar
Michael Bos

I upgraded Ubuntu 12.04 to 14.04 LTS and after having some problems not being able te print, which were solved with help from this community. I now have the problem I cannot print sales orders which have been created before the upgrade (also upgraded OpenERP).

But the new ones are printable. Error msg is :

ascii
4,00 Stuk(s
4
5
ordinal not in range(128)

(<type 'exceptions.UnicodeEncodeError'>, UnicodeEncodeError('ascii', u'4,00\xa0Stuk(s', 4, 5, 'ordinal not in range(128)'), <traceback object at 0x7fbea533a7a0>)

Log file says :

Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 296, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 654, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 760, in exp_report_get
    return self._check_report(report_id)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 738, in _check_report
    netsvc.abort_response(exc, exc.message, 'warning', exc.traceback)
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 71, in abort_response
    raise openerp.osv.osv.except_osv(description, details)
except_osv: (u'ascii\n4,00\xa0Stuk(s\n4\n5\nordinal not in range(128)', (<type 'exceptions.UnicodeEncodeError'>, UnicodeEncodeError('ascii', u'4,00\xa0Stuk(s', 4, 5, 'ordinal not in range(128)'), <traceback object at 0x7fbea533a7a0>))

Hope this rings a bell for someone. Looking at this I would says it is complaining about the number of items and the uom used for that.

0
Avatar
Discard
Simplify it!

Please post your code where you are creating that string

Michael Bos
Author

Dear Grover, I have no code regarding that string. It is in standard OpenERP. After the upgrade this has started on all old orders.

Avatar
Michael Bos
Author Best Answer

I have solved this problem. I was checking my database and suddenly saw that there was no instance of our widely used "Stuk(s)" (pieces in Dutch) as UOM. The problem existed because somehow in the upgrade Ubuntu did to Postgres this entry in the table was lost. I recreated this UOM and now everything works fine again.

Thanks Grover for taking some time to look into it.

Problem Solved!

 

EDIT!!!: As it turns out this was only a partial answer. It works now on most reports, but not on all of the reports. This is somewhat strange. It keeps saying this on the standard order forms from OpenERP. So If somebody know more about this, please share this with me.

EDIT 2 : Now I solved it by removing the UOM on the report and then readding it. This solved my problem.

I opened the report in Openoffice, removed the UOM under Quantity. Saved and uploaded the report.

Readded UOM under Quantity and saved and uploaded the report again and it works!

Hope it helps someone.

0
Avatar
Discard
Ludo - 21South

This could be due to translation issues. The default OpenERP reports will look for a generated UoM from the default data (when you first install a module). This is most likely "Unit(s)", using the "Stuks" translation for the dutch translation. Check the translated terms to see if you properly translated the new record. Another option would most likely be to update the database using flag "-u all" in order to let OpenERP re-create the record for the missing UoM, as well as reloading the Dutch translation to replace the missing translation.

Michael Bos
Author

Ludo, just for the hell of it I will try that too, it never does any harm :)

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Impossible to print in standard output
modules python print
Avatar
Avatar
Avatar
3
May 25
4506
bug on updating app/module?
modules upgrade bug
Avatar
Avatar
1
Dec 23
2647
How To Upgrade Nightly Build Solved
v7 ubuntu upgrade
Avatar
Avatar
Avatar
Avatar
3
Jan 24
16241
How to upgrade specific file in module odoo 15
modules upgrade v15
Avatar
Avatar
1
May 22
3179
Is it possible to upgrade odoo 12 module using windows powershell ?
windows modules upgrade
Avatar
Avatar
1
Feb 19
3856
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now