"Please update the customization" error when publishing

Question

Hello all, we just installed a local sandbox. I imported a snapshot to cover the data side, and I downloaded all of our Live customization projects to then import into the sandbox. When publishing, one of the packages is throwing the error:

Cannot create 'UsrCIsBarCodeOrSerial' column in table 'TSMIGOpportunityQuotePricing' because that table is not found in the database. Please update the customization to match the current data schema.

I seem to remember in the past reading about updating a customization to a current schema but can find no information… any ideas? Thanks

Django · Accepted Answer

You might have to publish the customizations in order. And you might also need to use the functionality of Publish To Multiple Tenants where you and force Acumatica to Execute All Database Scripts.

Typically, when I’m setting up new, I’ll load one of the Sales datasets, then load the customizations and publish, then load the snapshot. Sometimes I’ve restored a snapshot and didn’t get the custom field data and had to reload the snapshot again.

Ahhhh, I never tried the “…” ellipsis in Customization Projects!

The site just validated, forced database scripts and the site compiled and launched Successfully! Thanks Django, I now have a new tool in the tool box. :)

swartzfeger · Answer

You might have to publish the customizations in order. And you might also need to use the functionality of Publish To Multiple Tenants where you and force Acumatica to Execute All Database Scripts.

Typically, when I’m setting up new, I’ll load one of the Sales datasets, then load the customizations and publish, then load the snapshot. Sometimes I’ve restored a snapshot and didn’t get the custom field data and had to reload the snapshot again.

Ahhhh, I never tried the “…” ellipsis in Customization Projects!

The site just validated, forced database scripts and the site compiled and launched Successfully! Thanks Django, I now have a new tool in the tool box. :)

"Please update the customization" error when publishing

1 Attachments

2 replies

1 Attachments

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded