Importing Larger Prism Doc Designs

Importing Larger Prism Doc Designs

If you are using MySQL as the database for Retail Pro Prism, you may notice that you can only import Doc Designs with a miximum size of 4Mb. This artice will explain how to import Doc Desgins that are larger than 4Mb. 

Symptom: When importing Doc Designs, you may receive the following error if the file size is too large. 

Diagnosis: To deterimine the cause of the error, check the RPSRRESTServiceModule Logs to review. If the cause of the error is the large file size, then you will see a "max allowed packet" error message, similar to this: 

2017.09.12.10.00.02.524 [5712]    !! ERROR !!    RESOURCE[430:transformdesign:TTransformDesignResource]: ApplyStateChange: EFireDacDatabaseEngineException: : [FireDAC][Phys][MySQL] Got a packet bigger than 'max_allowed_packet' bytes

How to Resolve: To resolve this issue and therefore be able to import the larger Doc Design files, you must increase the max_allowed_packet parameter in the my.ini file, located at C:\ProgramData\MySQL\MySQL Server 5.7\

Note: In this instance we have installed the MySQL database onto drive C, but this can differ between installations. In the file path above, replace drive C with the drive letter that the MySQL database is installed to.

Note: The max_allowed_packet parameter is shown above. Edit this number to allow larger Doc Designs to be imported. Then Save the file and exit. 

Finally, for the changes to take effect, please restart the Mysql database and the Retail Pro Prism related services. (Restarting the entire machine will automatically restart the database and the Prism related services).