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...
Help Desk Software by Kayako