September 16, 2019
Urjanet has made an update to its data load scripts for customers using MySQL. This is a small change to prevent incomplete data loads in the event of an error during the load process. If you are using MySQL, we recommend updating the Urjanet MySQL Data Load Post script to the latest version attached to this article (UrjanetDataLoad_Post.sql).
Urjanet discovered that data values could exceed a SQL field length constraint without causing the import to fail or presenting data load errors. This resulted in an unpredictable data load for the entire delivery file when a constraint violation existed.
Urjanet has updated the MySQL load script to error out if an issue exists during the load process. This script features error messages to provide some visibility into the reason for failure.