EC Online: I receive a "Whoops" message when I click SAVE under Administrator section (Self-Hosted Only)
Posted by Joel Brickell, Last modified by Becky Gruber on 11 September 2020 02:44 PM
Issue: Whenever I click SAVE under the Administrator section in EnergyCAP Online, I receive a "Whoops" message stating something went wrong. It happens in any section under Administrator.
Resolution: You are receiving this because in the AccountPeriod table of the database there is a 13 line of data with the accountperiodID of '1025' and zero's. This is incorrect and needs to be removed/deleted. Please use the SQL script below to remove it.
Run this first:
SELECT * FROM AccountPeriod
Use this to determine if that 13th line exists. If it does use this to determine if the accountperiodID for that line is '1025' or something else.
Once you determine the accountperiodID that needs to be removed, run the script below: **Remember to run a backup of the database first before running this script.**
Once you have successfully run this script, go back and click SAVE again under the Administrator section.
If this does not resolve the issue, contact Technical Support by entering in a support ticket (http://support.energycap.com)
This is for EnergyCAP Self-hosted clients only