#Troubleshooting guide
#Auto_increment reaches max value for pim_catalog_completeness table
Impacted versions: PIM <= 5.0
After some time, the completeness table auto_increment identifier could reach the defined maximum. We made a fix to to allow for a lot more identifier in PIM-9750 ticket but for older database schema, you must apply this fix with the following MySql ALTER command:
ALTER TABLE pim_catalog_completeness MODIFY id bigint NOT NULL AUTO_INCREMENT;
#Asset family identifiers stored with a different case in attributes properties (EE only)
Impacted versions: PIM EE <= 5.0
We fixed the attributes import to sanitize the asset family identifiers in PIM-9753, and you may need to fix data already stored in database with the following clean command:
bin/console --env=prod pim:asset-manager:clean-asset-family-in-asset-collection-attributes
#Asset & Asset family codes being case-sensitive (EE only)
Impacted versions: PIM EE <= 5.0
The Asset index mapping has been updated to be case-insensitive on the Asset & Asset family codes. You may need to reset your index and re-index all Assets:
bin/console akeneo:elasticsearch:reset-indexes --index=akeneo_assetmanager_asset
bin/console akeneo:asset-manager:index-assets --all
Found a typo or a hole in the documentation and feel like contributing?
Join us on Github!