Issue: EnergyCAP displays an "Error saving record" message when the user is attempting to update/save a meter, building, or account in EnergyCAP.
There are two possible solutions to this error:
Solution 1: This issue can usually be addressed successfully by reindexing the tables in the EnergyCAP database. Good Steward Software (GSS) recommends that an individual with knowledge of database management obtain the reindexAllTables.sql script from our available Support Suite Downloads and run the script against the EnergyCAP database. Download script
NOTES: The reindex script can be scheduled to run regularly, and it is recommended that the tables be reindexedÂ every night in high-traffic databases. Clients with web-based databases hosted by GSS will need to submit a trouble ticket in Support Suite to request assistance for reindexing from GSS.
CAUTION: Prior to running the script, a full EnergyCAP database backup is strongly recommended.
Solution 2: There may be an issue with the Auto-Groups in EnergyCAP. Has one of the Blue Folders in the Groups Manager been deleted? Check to ensure that the following folders are present:
Place Primary Use Auto-Group folder
Meter Primary Use Auto-Group folder
Commodity Auto-Group folder
Vendor-Commodity Auto-Group folder
Vendor-Rate Auto-Group folder
If any of these folders are MISSING, contact Tech Support and indicate which Auto-Group folder(s) are missing. A Tech Support staff member will provide a SQL script similar to the following which should fix the problem.
-- To insert a missing Meter Auto-Group ... Missing Place Auto-Groups would be in the OrganizationType table
SET IDENTITY_INSERT aggregationtype ON
insert into aggregationtype (aggregationtypeid,aggregationtypecode,aggregationtypeinfo,autogroup)
values (4,'AGC', 'Commodity Auto-Group',1)
SET IDENTITY_INSERT aggregationtype OFF
Written by Ryan Ohlson on 7/3/2009 EnergyCAP Enterprise Rel 6.0