Skip to Content
This question has been flagged
croncloudazurev18
2 Replies
563 Views
Avatar
Friedrich Sauer

Hi, 

we activated the cloud storage integration with MS Azure, that is natively integrated since v18.


Additionally we are trying to migrate historical data to Azure, too. Odoo has added a new module called cloud storage migration to handle this process via a cron job.


Apparently the cron job migrates files in the ir.attachment ID range of between the system parameters for min and max attachment ID. 


We started the cronjob and also saw files coming into our Azure blob - after around 40hrs, the cron job showed 100% progress. However many files that were clearly above the min file size specified for cloud integration of 500.000B were still stored in odoo. Why did the cron job miss so many files?


Also, rerunning the cron job does not work, as the ID range resets to a Null-gap. No further attachments are processed. If restarting, even after manually editing the ID range, the cron progress goes to 100% after one run.


Does anyone have experience with the cloud integration cron for large filestores?



Help is greatly appreciated!

Avatar
Discard
faOtools

Probably, for some scenarios the alternative version of the sync - https://apps.odoo.com/apps/modules/19.0/cloud_base - might serve your goals

Avatar
Kunjan Patel
Best Answer
Hello Friedrich Sauer,
I hope you are doing well

Why files were missed: The cron only migrates attachments belonging to models you explicitly configured in Settings > Cloud Storage > Migration. Files are also skipped if they are inline binary fields (res_field), created in the last 7 days, linked to Documents, or outside the size range.

Why the ID range resets: When the cron finishes, it sets min_attachment_id = max_attachment_id. Now min == max → query returns nothing → 100% instantly.

Fix:
1. Set cloud_storage_migration_min_attachment_id to 0 and cloud_storage_migration_max_attachment_id to 0 in System Parameters
2. Add all needed models (e.g. product.template, account.move, sale.order, etc.) to "All Attachments" in the migration settings - this is likely the main reason files were skipped
3. Re-trigger the cron

Note: Inline binary fields (product images stored directly on record fields) are excluded by design and will never be migrated by this cron.

I hope this information helps you

Thanks & Regards,
Kunjan Patel
Avatar
Discard
Friedrich Sauer
Author

Thanks! It's unfortunate, that document.document assigned attachtments are not being migrated. Imo, that is not well documented, and somewhat defeats the purpose of a cloud storage integration. For most larger Filestores, most files will be documents.

Friedrich Sauer
Author

Hi Kunjan,

do you have an Idea why document.document outsourcing is skipped? Do you have any experience with enabling it for that model and the consequences?

Thanks
Friedrich

Avatar
Yassin Radwan
Best Answer

 Friedrich Sauer 
Hello, i think you could do it with OCA models ?
I did something similar, where i assigned my share point as the default storage for odoo.
Every attachment, except odoo generated ones (xml, js, etc), is uploaded automatically to my share point.

Avatar
Discard
Related Posts Replies Views Activity
How can employees easily manage corporate card receipt uploads
v18
Avatar
0
Dec 25
39
Where is the PDF Partner Ledger QWeb Report and View in Odoo Online?
v18
Avatar
Avatar
1
Dec 25
4632
Change Sign & Pay Button on Quotation E-mails
v18
Avatar
Avatar
Avatar
Avatar
3
Nov 25
1976
Problem including JS asset in v18 Solved
v18
Avatar
Avatar
Avatar
3
Feb 26
10676
Is it possible to sell on credit directly at the point of sale and leave the order pending payment? Solved
v18
Avatar
Avatar
1
Apr 26
1778