Hello,
I believe this issue may have been here for a while but we finally narrowed it down. I just confirmed now on 9.12.3 and the issue still occurs.
The deployment tool (either an immediate transfer, or with a deployment package) fails to update the database schema. It's most likely with the SchemaDataItemProvider, and it seems to only happen with fields of type Checkbox.
You can repro with the following steps:
- Create a new product group field, or a product field on a site (for the sake of this example, let's make it a product group field)
- Use the deployment tool and push out to another site both the EcomProductGroupField data (using SqlDataItemProvider) and the field schema (using SchemaDataItemProvider).
- Run the following queries:
- select * from EcomProductGroupField
- select * from EcomGroups
You should notice that the EcomProductGroupField data comes over, but the EcomGroups schema doesn't update.
You can test with other field types like datetime, string, int, and they all work (unless a few are done together and the Checkbox type will cause all of the ones after it to fail).
The log doesn't show the failure. It fails silently and just doesn't work.
Thanks,
Scott
