Knowledgebase
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...
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...
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...
_**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...
PROBLEM: The value for the Energy Use Index (EUI) for a building in
EnergyCAP may differ from the value for the same building in ENERGY
STAR's Portfolio Manager. What are the reasons why?
REASON:
* Timing of bills. The bills that make up the usage t...
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...
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: Executing Calculating Savings does not run on all my meters.
SOLUTION: This is a workaround for now. This issue will be repaired in
the next build/version.
For now, if your meter(s) do not update after running CALCULATE
SAVINGS, you will have t...
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...
Problem: How do I print the user manual?
Resolution: Go to > http://help.energycap.com/energycap-enterprise-user-manual/print_friendly_view
From here, you can click on File >
Print.
*****
There are approximately 382 pa...
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...
Symptom: User can't import xml file from local drive or citrix drives.
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; G...
These are the latest enhancements made to our automated ENERGY STAR
interface in EnergyCAP:
* Water meters will now be submitted.
* We will no longer modify bill data that has gaps/overlaps since
Portfolio
Manager now accepts the data unmodified. T...
ISSUE: I've run the Bill Split processor but my bills waiting to be
split were not split (i.e. no split bills were created).
SOLUTION: There are two probable solutions. You probably either have
Unapproved Bills (Bill Approval is turned on and the Bi...
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...
PROBLEM: In builds earlier than 110 in EnergyCAP Enterprise 6.2, an
error message appears when running the Facility Tree:
This is a known bug associated with dates.
SOLUTION: To fix this, please upgrade to the most recent build of
Energy, which is 6.2....
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...
The issue is when you don't have a billaccountmeter record for each
meter on the account being split you get a split error.
EXAMPLE:
Account 1
o Electric (Split 100%)
o Water (Split 100%)
o Sewer (Split 100%)
If the water and sewer bill inf...
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...
ISSUE: Some reports and/or Custom Spreadsheets in EnergyCAP Enterprise
Rel. 4.3 and previous don't show billing period filter options for
"last month," "last year" and other similar choices.
SOLUTION: New options were added to Billing Period report and C...
For some EnergyCAP releases predating version 5.0, an incorrect value
in an EnergyCAP report table can case the filter button labeled
Billing Period (YYYYMM) to display calendar date choices instead of a
blank field for entry of billing periods.
To corre...
If you receive the message: "Not all accounts processed completely"
Followed by: Processing Account XXXXX
No new readings for XXXXX after mm/dd/yyyy
And you are sure that there are new readings in the system, the issue
is related to a change made in Ene...
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...
PROBLEM: Channel records are not being created due to an issue in the
database.
SOLUTION: Make sure the Channel is created under Channel Properties:
After the Channel has been created click OK:
Created by: Matthew Heinz 05/20/11
Problem: When running Cost Avoidance, the processor indicates that you
have No Weather Data and so no adjustment is made to adjust for
weather.
Solution: Check to see that the building that the meter(s) are
associated with is a Place Type of 'Building'. ...
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...
PROBLEM: After installing EnergyCAP and launching it for the first
time, you get an error message relating to CRPE32.DLL which crashes
EnergyCAP.
SOLUTION: There is probably another version of Crystal Reports
installed on the PC which is newer than the v...
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...
Issue: When running the upgrade52to57.sql script during the upgrade of
an EnergyCAP database from DB52 to DB57, you receive the following
error:
"Server: Msg 50000, Level 16, State 1, Line 556
More than one record in table Community WHERE (communityID = ...
The only way to delete a bill export profile is by editing the
billexp.ini file by hand.
Be sure to make a backup of the billexp.ini file BEFORE editing it; if
you accidentally delete a profile you want to keep, you won't be able
to recover it. The file ...
This Technical Bulletin recommends a solution for a problem with
viewing bill images from within EnergyCAP.
PROBLEM: "We have one PC here that as of today will no longer allow us
to view a bill image from within eCap (.TIF). When we try to view
within eC...
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...
ENERGYCAP ENTERPRISE SYSTEM REQUIREMENTS
To access and use the application, your system should be equipped
with the following:
* 400 MHz processor (minimum) or faster (recommended)
* 128 MB RAM (minimum) or more (recommended)
* 500 MB free...
ISSUE: When updating reports you get an error message "ERROR
EXTRACTING FILES"
SOLUTION: If you get this error, it's telling you that you do not have
permissions for the reportupdate folder to be created/updated. You
need to make sure that you have ful...
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 succes...
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...
ISSUE: SQL Server has procedures for reducing the size footprint of a
database. When the AUTOSHRINK option is set to TRUE for a particular
database, SQL Server will periodically perform the AUTOSHRINK
operation.
However, some computer software/hardw...
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...
ISSUE: Interval data does not import. Error message says:
Unable to compute the data interval.
Import aborted.
SOLUTION:
If the Interval Data import file does NOT have a column specifying
the Interval (and Intervals should be expressed in te...
PROBLEM: Is it possible to have some bill images with a .tif extension
and some with.pdf?
RESOLUTION: Yes. You may "mix" file formats, provided that you do not
use/specify a file extension in the extension field in the Global
Settings Option window (Too...
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: I entered a bill. There is use and cost on the bill. But when
I look at it on some reports or with PowerViews charts the data is
missing.
SOLUTION: EnergyCAP stores bill data in several database tables. Each
bill is stored in the Bill and Bodyli...
ISSUE: The meter find/search does not find a meter that I know is
there.
SOLUTION: The meter find/search will fail if there is no
DEVICEPROPERTY record for the meter. The deviceProperty record appears
on the 'Specific' tab in the Meter Properties window,...
PROBLEM: I can't delete a building because I get a message saying
there is a meter assigned to it, but I don't see a meter under it in
the Facility Manager or I know an account exists but I can't see it in
the Account Manager.
SOLUTION: "Inactive" accoun...
Some internal system changes made in Enterprise release 6.2 may have
inadvertently changed your natural gas reporting unit of measure.
The reporting unit of measure, called the Common Usage Roll-Up, is
used on all reports except those at the individual ...
ISSUE: I used the EnergycAP ADMINISTRATOR program to create a new
user-defined field. It indicated that the field had been created
successfully, but when I go to meter, place, vendor or account
properties I don't see the tab for User Fields.
SOLUTION: Th...
Problem: User could not get results from BL17 using the batch code and
bill entry date filters.
Resolution: ECAP has an issue with the way it is handling the date
filters. User will need to use the BETWEEN operator with the date
filter.
EnergyCAP Ente...
PROBLEM: The OK and Cancel buttons are chopped off of the report
filter selector screen. I can only see the top of them. Edit - Find
screen is also missing buttons on the right side.
SOLUTION: This condition can occur when you have your monitor set to
La...
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...
The following URL points to a PDF which is a guide to troubleshooting
common errors and issues with the AP and or GL reformatter that
EnergyCAP has developed for you.
http://support.energycap.com/index.php?/Knowledgebase/Article/View/178/31/reformatter-t...
ISSUE: I'm trying to run a report, but the "Report Loading" message
appears with a blue screen.
SOLUTION: Usually in this context, "Report Loading" means "Report Not
Loading". The blue screen indicates that EnergyCAP is having trouble
generating the...
ISSUE: SOMETIMES WITH CERTAIN REPORTS, THE VALUE FOR A GIVEN FIELD
WILL EXCEED THE COLUMN LENGTH. WHEN THIS HAPPENS, THE VALUE IS
REPLACED BY A SERIES OF POUND SIGNS (#).
WORKAROUND: TO REDUCE THE SIZE OF THE VALUE IN THE REPORT FIELD, IT
MAY BE NECESSA...
Topic - Debugger
PROBLEM: A script debugger window appears when a rate schedule or
account processor is run.
Rate schedules and several other processors use Visual Basic scripting
language. Your PC may be configured to launch a script debugger
whenever ...
In some unusual circumstances, it may be necessary to assign or
re-assign begin and end dates to all meters in EnergyCAP.
The following script looks at the billing history of a meter in order
to set the begin and end (if necessary) dates of the meter. T...
The script below populates the meter address field by copying the
address of its parent place (building). It creates a new address
record, so that if the parent address is changed, the meter address
will NOT be changed. The script ignores any meter that a...
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...
SQL 2012 is not compatible with EnergyCAP Enterprise at this time. We
are working to make it compatible. The best solution at this time is
to stick with SQL 2005 or 2008.
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....
SAMPLE PROBLEM: I have EnergyCAP Enterprise Desktop release 4.3. When
I try to perform an Admin menu function I get the message: "Your
UserID is not valid for attaching databases."
SOLUTION: Incorrect login for these functions. Check organization user
pe...
MESSAGE: "The template for this bill has changed. Any unsaved data
will be lost. Do you wish to continue?"
Message: "The bill start date precedes the effective date of the
current bill entry template. You must use Historical bill entry mode
to enter thi...
PROBLEM: I dragged the vertical bar over to the left in order to make
the right pane wider (the report view pane or the bill list pane) and
now I can't grab it to move it back to the right. That means that the
center panel is no longer visible (the report...
To shrink the log, in Query Analyzer: (replace DBname with the
database name, replace "LogFileName" with the actual log
"filename" property of the log file, seen in database properties)
Use DBName
Go
BACKUP LOG DBName WITH TRUNCATE_ONLY
Go
DBCC SHRINKF...
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 ...
Troubleshooting the Reformatting Process
In order to get efficient support from EnergyCAP Technical Support
for a reformatter issue (usually relating to Bill Import/Export), the
user should be prepared to provide the following files and information
...
USING START MENU OR TASKBAR SHORTCUTS IN WINDOWS 7 TO LAUNCH ENERGYCAP
ENTERPRISE:
PROBLEM: Opening EnergyCAP by using the program shortcut pinned to the
Start Menu or the Taskbar in Windows 7 causes EnergyCAP to crash when
using certain modules, such a...
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...
Most Popular Reports (boldface are most often used)
Line Item: Individual line item on a bill, like "On Peak Usage"
BL16
AN21
BL19 (special case shows Late Fees only)
Bill-by-Bill: Each row is one bill
BL01 (also BL02/03/04)
BL07 (complete bill detail...
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...
PROBLEM: I am running EnergyCAP Rel. 4.1. When I run reports YY01 thru
YY06 I get a blank page.
SOLUTION: Each meter must be assigned to at least one meter group in
order to be included on YY reports. This problem was corrected in
EnergyCAP rel 4.2. If y...
Issue: I need to transfer files--documents, spreadsheets, database
files, etc.--to my EnergyCAP FTP site so that Tech Support can better
understand my issue.
Solution: Use Windows Explorer as an FTP Utility to upload my files.
See the instructions below...
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 ...
ISSUE: When attempting to update my validation code in EnergyCAP
Online, I'm receiving an "Oops! Something didn't work right." error
message.
SOLUTION: Be sure the user role of the login you're using when
updating the validation code is the "ADMINISTRAT...
**_APPLIES TO ENERGYCAP HOSTED CLIENTS ONLY**_
ISSUE: New vulnerabilities with processors has been brought to light
in recent months. Bugs/vulnerabilities are referred to as Spectre and
Meltdown.
FUTURE RESOLUTION: Currently, Intel, VMWare, and Dell h...
Help Desk Software by Kayako