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

Exception in cron

Subscribe

Get notified when there's activity on this post

This question has been flagged
cronrestorerestoredbcronjobdatabasemigration
2 Replies
3237 Views
Avatar
Carlo

Hello,

after restoring database (with option database was moved) on the same server (just deleted and restored database) I see following error in logs:


2024-10-24 20:25:52,401 6706 DEBUG ? odoo.service.server: cron0 polling for jobs
2024-10-24 20:25:52,405 6706 DEBUG db_name odoo.addons.base.models.ir_cron: job 58 acquired
2024-10-24 20:25:52,409 6706 WARNING db_name odoo.addons.base.models.ir_cron: Exception in cron:
Traceback (most recent call last):
  File "/opt/odoo/odoo16/odoo/odoo/addons/base/models/ir_cron.py", line 319, in _process_job
    interval = _intervalTypes[job['interval_type']](job['interval_number'])
               ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^
KeyError: None


How to debug and fix?

Thank you,

Carlo

0
Avatar
Discard
Avatar
Sujata
Best Answer

Hello Carlo, 


The KeyError: None error in your Odoo logs typically indicates that a cron job (automated background task) has an undefined or incorrect interval type. This can happen if the interval_type field in the ir.cron table is missing, set to None, or incorrectly configured after a database restore.

Here’s how you can debug and fix this issue:

1. Check the ir.cron Table for Missing or Invalid Values

  1. Access the Database:
    • Use a PostgreSQL client (e.g., psql on the command line) to connect to your database.
  2. Run a Query to Check interval_type:
    • Run this SQL query to identify any cron jobs with an invalid interval_type:
      SELECT id, name, interval_type, interval_number FROM ir_cron WHERE interval_type IS NULL OR interval_type NOT IN ('minutes', 'hours', 'days', 'weeks', 'months');
           This will show any records where interval_type is missing or invalid.
  3. Update the Missing Values:
    • If any rows have interval_type set to NULL or contain invalid values, update them with a valid interval_type value (such as 'days' or 'hours').
           Example SQL to update the value:
           UPDATE ir_cron SET interval_type = 'days' WHERE id = <id_of_the_cron_job>; 
           Replace <id_of_the_cron_job> with the actual ID of the cron job.

2. Restart the Odoo Service: After making changes to the database, restart the Odoo service to apply the fixes.
sudo service odoo restart

3. Debugging and Monitoring

  1. Check the Logs: After restarting, monitor the logs to ensure the error no longer appears.
  2. Verify Cron Jobs: Go to Settings > Technical > Automation > Scheduled Actions in Odoo, check that all cron jobs are enabled, and ensure they have valid interval types.

Let me this helps :)

1
Avatar
Discard
Avatar
Carlo
Author Best Answer

Thank you for great answer. Issue is resolved. I had two crons with NULL values and I managed to update values through pgAdmin.


0
Avatar
Discard
Sujata

Glad to hear that! 😊

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
Cron job does not execute python code on scheduler, only on Run Manually button. Solved
cron cronjob
Avatar
Avatar
Avatar
3
Sep 23
12964
Backup and restore staging db
restore restoredb BACKUP
Avatar
Avatar
Avatar
2
Sep 25
1858
issue while restoring database
restoredb res.groups databasemigration
Avatar
Avatar
1
Dec 24
1808
Using CRON job to download and attach pdf to binary field ODOO16
cron cronjob ODOO16
Avatar
0
Oct 24
3166
Cron getting timeout
cron timeout cronjob
Avatar
Avatar
1
Aug 24
6230
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