Knowledgebase : EC Enterprise - v6
ADVANCING THE BASELINE YEAR Cost avoidance reports and charts show the avoided cost and use for the "performance" period vs. the "wasteful" baseline year. The performance period is the months and years following the implementation of energy (and perhaps...
ISSUE: I am getting the HRCHECK error attached when attempting to install reports using Version 6, installed client. RESOLUTION: IF YOU RECEIVE THIS ERROR, DO NOT SELECT CONTINUE. PLEASE CHOOSE TO TERMINATE OR CANCEL. Report Installation through the...
ISSUE:  I receive an error message when running EnergyCAP Enterprise build 128 for the first time. The error message displayed will be _"Class not Registered"_ and will close Enterprise. RESOLUTION:  Normally this error is caused by not unblocking the z...
_**This article applies to self-hosted clients only. EnergyCAP monitors and resolves issues with weather data, automatically, for our hosted clients._ For on-premises EnergyCAP clients, weather data should be imported into the EnergyCAP database on a re...
REQUIREMENTS FOR USING POWERPIVOT WITH ENERGYCAP:  * We require Excel 2013 or Microsoft Office Suite/Professional 2013 * The computer using the PowerPivot must running with Windows 64-bit operating system. WHY IS EXCEL 2013 REQUIRED? While there...
We have encountered two specific scenarios that have the potential to cause confusion when the Calculate Bills chargeback processor is run in Version 7. This KBA is written with the intent to explain the behavior in Version 7 and give assurance that the a...
With the release of EnergyCAP version 7 (v7), we have made some adjustments to the filter captions used in reports and throughout the software. Below we have listed the old caption and the corresponding new caption. A spreadsheet version of this list is a...
ISSUE: Crystal Reports are not showing images in the report for self-hosted clients. SOLUTION: This issue exists because the CrystalImageHandler.aspx is not registered in the IIS manager. _**Please make sure that an IIS administrator or someone with e...
EXTERNAL HELP RESOURCES It is not the scope of our Support team to train and support EnergyCAP users on basic functionality of Excel's Power Pivot. Use of Report Designer comes with the presupposition that EnergyCAP users are comfortable working with the...
PROBLEM: You receive an 'Invalid Argument Date Encode' error when clicking on any place in the EnergyCAP Enterprise Facility Tree SOLUTION: Check to make sure you have a 'Fiscal Year Starts' month selected in the Global Settings Tools > Options - Glob...
_**THIS ARTICLE ONLY PERTAINS TO ENERGYCAP ENTERPRISE HOSTED CLIENTS.**_ SET RD GATEWAY Go to the Advanced Tab in the Remote Desktop Connection dialog box and click Settings under Connect from anywhere. Then choose Use these RD Gateway server settings...
ISSUE:  When I double click on the EnergyCAP icon, it acts like it is open but is not on the screen but shows in the taskbar. SOLUTION: When EnergyCAP launches off-screen (to the left) this is as a result of a previous user's dual-monitor configuration,...
ISSUE - When I open EnergyCAP Enterprise I am getting a message - "There is an error with your Catalog Service URL" RESOLUTION - There was a Customer Service Message (CSM) that was emailed out on 03/03/2015 and an updated one on 03/20/2015 advising...
ISSUE: I get an error when I double click on the EnergyCAP Icon - No name string Switching to local ODBC data sources. SOLUTION: This error message is telling you that your connection strings are wrong for EnergyCAP Enterprise to connect/find your datas...
ISSUE: When I try to delete a building using the correct procedure, it just will not delete. The meter has already been deleted from this building. SOLUTION: Check to see if you have ENERGY STAR enabled on this building. If you do, you will need to unch...
How to install the EnergyCAP software on the Windows 7/8/8.1/10 operating systems: ISSUE: When installing this software or others on Windows 7/8/8.1/10 with the UAC (User Account Control) turn up or on, it fails to install certain components. SOLUTION:...
Fixing Report Distribution Manager Task in Energy Enterprise 6.2.64.150 (BUILD 150): When creating the report task for the Windows Task scheduler, you will need to add the full path of switches in order to get this to email the reports. Please see below...
The Custom Spreadsheets module in EnergyCAP Enterprise can be both wonderful and frustrating at the same time! This flexible tool allows users to execute custom queries on the EnergyCAP database, giving users access to data which may not be available with...
PROBLEM: When viewing the web grouping charts/benchmarking, the filters are staying at the default settings, "last twelve months" I would like to see specific changes that I define. SOLUTION: You will need to log into the Rich/LAN client, ECAP Program a...
ISSUE: Calculate Bills Processor executing without errors in EnergyCAP Enterprise Release 5.0 and/or Release 5.1. After upgrade to EnergyCAP Enterprise Release 6.0, the Calculate Bills Processor returns a "Could not locate any Meter Readings for Account <...
Question - I have a facility with dual electrical feeds from the utility. Therefore, I have two meters that are summed together to determine the total consumption. How do I set up the EnergyCAP Bill Entry Template(s) to accurately capture the data for eac...
Question - I have a commodity that is delivered in bulk, such as Fuel Oil, Propane, or Wood, and would like to have EnergyCAP calculate the Cost Avoidance for this commodity. As this commodity is used to heat my building(s), I also need EnergyCAP to corr...
Question - The number of Items listed in my Place Group Power Views is not consistent between the Members, Rank, and Per Area Rank. For example, I count 15 Members in my Place Group. However, when I look at the Cost Rank and Use Rank Power Views, only 12 ...
ISSUE: I have run the "Update Reports" process and now I am getting errors when running reports. SOLUTION:  This article is related to SELF-HOSTED CLIENTS using ECE6.3 SP2 (build 6.3.69.104) or EARLIER (ECE6.3) installed and using database version 72 or...
Problem: Your user account has permissions to execute Reports, but when you log into EnergyCAP, it says "Unavailable" for the Installed Reports. Solution: There is likely an issue with the underlying tables which hold the available reports for all the us...
Staging Tables Overview Staging tables are used in PowerViews for version 6.x of EnergyCAP and in EnergyCAP Online 1.6 and greater. They summarize meter data at all higher levels of the hierarchy - buildings, organizations, etc. The data contained in the...
Problem: When I run the Virtual Bill Processor, it overwrites bills that were already created for the Virtual Account. This occurs whether I run it in Automatic mode or for a specific date range. Solution: In EnergyCAP version 6.1, the Virtual Bill Proce...
In order for Production Data to appear on the AN20 Report, the Counter Code needs to begin with 'TOTAL'. EnergyCAP Enterprise Rel. 4.0 and following
OVERVIEW This article seeks to help you learn more about your AP/GL interfaces, which I'll refer to as "reformatters." The ultimate goal here is to equip you to be able to solve a host of reformatter-related issues which may come up over time. First, ...
ISSUE: I keep getting this error when I login to EnergyCAP - Assertion failed:p!=Null,file..dataobjectsOCObjectPtr.cpp, line63 error Solution: You are getting this error because you are pointing to the wrong datasource and you need to change it within...
PROBLEM: Bill splits on the sub-meters duplicate after re-importing the same bill info. SOLUTION: When you re-import bills from a CSV file using the ACE flag of "A" means the imported bill will overwrite any existing bill in the database that shares th...
Q1. Does the Calculated Accounts Processor perform unit conversions between the Channel Readings and the units on the bill? A1. No. The Calculated Accounts Processor creates a bill based on the unit of measure selected when the Calculated Account was crea...
Symptom: User in a Citrix environment can't run EnergyCAP reports. Resolution: Probably Active Directory is being used. Either uncheck the Active Directory check box in EnergyCAP (Setup/Users; select User and right-click to select User Properties; Gener...
PROBLEM: When running EnergyCAP Enterprise under a Citrix environment and trying to export a report, an error occurs that reads … 'Error in File *some report*: Missing or out-of-date export DLL. ExportWindow ' HOW TO REPLIC...
Issue: When creating a new template line for a template for a commodity, (IE, Water) the unit that you wish to use (IE, 10Gal) is not available in the Unit drop-down list. Solution: If the desired unit is not available, it either does not exist or the u...
ISSUE: When upgrading the database, you receive an error 'Cannot insert duplicate key row in object'dbo.ComputedUnitSystem' with unique index 'AK1ComputedUnitSystem'. RESOLUTION: This error is caused by duplicates in your common unit for either Hot Wate...
Problem: In Windows 7 (64bit) it is possible that you've created System DSN ODBC connections but they are not listed in the Datasource drop-down in the EnergyCAP login screen. Solution: Since your Windows 7 machine is 64-bit based, by default the ODBC ad...
PROBLEM: COMMODITIES PROBLEM: When viewing the Unit System or Template Manager, you notice that there are duplicate Commodities listed. If you have not created any new meters for these commodities, you can run the script referenced in this article to r...
There is a bug in EnergyCAP 6.2 (build 109) involved with editing and or entering monthly Channel data on either a Counter or a Meter. The bug appears to be limited to monthly Channels when manually entering/editing readings as a result of the entry scree...
Issue: I have one or more existing Bill Export Profiles, and I don't want to recreate them all by hand in an EnergyCAP installation on another computer. Can I export and then import the profiles? Solution: You may transfer Bill Export Profiles between in...
If you have set up GHG emission factors in your EnergyCAP database and have run the GHG processor, but do not see GHG emissions for some or all of your meters, the "Greenhouse Gases" tab of the meter may look something like this: If this is the case...
While taking a closer look to try and determine how to un-consolidate the accounts, I found that there is not a way to use a SQL Script to perform this task. Below are two procedural options that you can implement from within EneryCAP. Option A This op...
ISSUE: Importing and assigning updated GHG emission factors RESOURCES FOR UPDATED GHG EMISSION FACTORS: * Emissions & Generation Resource Integrated Database (eGRID) 2014: https://www.epa.gov/energy/emissions-generation-resource-integrated-database-e...
PROBLEM/ISSUE: EnergyCAP's Unit System may have an incorrect multiplier in the Equivalencies section. This would result in incorrect values when converting from MCF to DKTHM. RESOLUTION: To fix this issue, you will need to insert or change the equiva...
PROBLEM: Using EnergyCAP 6.0, a user who connects via Internet (aka Rich Client) is not able to see any results from the Custom Spreadsheet designed for the Line Item by Caption category. SOLUTION: There is no known workaround for this. The issue is that...
Problem: When importing bills using a bill import spreadsheet, the EnergyCAP bill importer is designed to read the flag in the ACE column to determine how it should handle the bill. If the flag is set to a value of A, then EnergyCAP will treat the bill be...
The issue is that the ReadingDelta function is not available for use in Virtual Account Scripts, it is only available for use in Virtual Channel Scripts/Equations. Therefore, to use the monthly meter readings to determine the consumption for a Virtual Ac...
Setup Sheet View required for Custom Spreadsheet: http://support.energycap.com/index.php?/default_import/Knowledgebase/Article/View/187/22/setup-sheet-view [1] Setup Sheet Custom Spreadsheet .xml File: http://support.energycap.com/index.php?/default_...
EC ENTERPRISE: Setup Sheet Import Aborted - Error Message PROBLEM: When trying to import a setup file through the ECAP import function, the user gets the following error: All required properties are not initialized Import aborted RESOLUTION: When you...
Problem: My EnergyCAP AP or GL interface/reformatter is malfunctioning.Solution: The following article should assist you in troubleshooting your own reformatter and give you a list of information items to deliver to Tech Support if you are unsuccessful....
Issue: EnergyCAP does not allow a user to turn off or disable an account configured for Bill Splits. Solution: Execute the script provided below, using the Administrator or SQL Management Studio. You will need to first edit the script and fill in the Acc...
ISSUE:  When trying to update reports, the user is getting error messages. One of which may be, ESUSER DOES NOT HAVE PERMISSION TO UPDATE REPORTS. SOLUTION:  The user installing the reports must have the following SQL DATABASE ROLES assigned to them in ...
QUESTION: What are EnergyCAP best practices for demand tracking? ANSWER: We don't have a single best practice recommendation; it depends upon the reporting and analysis needs of the user. Some clients prefer simple while others prefer detailed. Simp...
PROBLEM/ISSUE: Why doesn't the eGRID GHG emission factor(s) assigned to my electric meters in EnergyCAP correspond to the eGRID emission factor assigned in Portfolio Manager? The GHG emission factors found in both EnergyCAP and Portfolio Manager are fro...
Issue: When I attempt to login in to Enterprise, I keep getting an "Invalid Login" error message Solution: This error message is telling you that your Data Provider string is not correct. Open the EnergyCAP login window and click on the little world icon...
Problem: The bill export profile which I use to export bill data from EnergyCAP has suddenly changed or corrupted, without me doing anything to change it. Solution: The best way to avoid losing bill export profile information is to make a backup of the ...
** This article only pertains to Self-Hosted clients. If you are an EnergyCAP hosted client looking to use your Version 6 (installed client) export profiles with Version 7, please enter a SUPPORT TICKET [HTTPS://SUPPORT.ENERGYCAP.COM]. ISSUE: I would li...