Knowledgebase : EC Professional
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...
ISSUE: While pulling reports or navigating through EnergyCAP Online
using Google Chrome, the application freezes and I am unable to click
on anything and must close out.
RESOLUTION: This is an issue with Google Chrome. With one of the
latest updates to ...
ISSUE: When using EnergyCAP in my web browser, the login screen is
not loading. This is due to Adobe Flash plugin being disabled through
your web browser's update (EnergyCAP requires the Adobe Flash plugin
to be enabled). Please see the possible options b...
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: 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...
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: I am getting an error when I attempt to import a Setup Sheet in
EnergyCAP Enterprise Online (ECO). Generating a new Setup Sheet does
not resolve the issue.
ERROR: File cannot be imported
The format of the file selected does not meet the requireme...
ISSUE: EnergyCAP Online won't run on my iOS (iPad/iPhone), Android
device, or other mobile device.
SOLUTION: Most mobile devices do not natively support Flash Player.
Since EnergyCAP Online is Flash-based, you will not be able to
natively access the ...
Actual Cost and use in CAP reports don't agree with the BILL reports
for the same period
BILL reports pull the data from the utility bill database in
EnergyCAP. For example, when you run Bill 08 report for Jan-Dec 2009,
the report includes all of the ac...
I RECEIVE "FREE" KWH FROM A ROOF-MOUNTED SOLAR ARRAYS. HOW DO I TRACK
THIS? DOES IT AFFECT COST AVOIDANCE?
ASSUMPTIONS:
* The solar system provides electricity to the host building first.
Any excess electricity is either stored or directed back to th...
ISSUE: Click on Monthly Data - Utility Bills and receive an error
message saying that 1/1/2000 is an invalid date. Cannot proceed and
enter bills.
SOLUTION: The problem is the date format in your Windows settings. Go
to Control Panel, Regional and Langu...
*WARNING - Do not attempt this unless you feel comfortable in
performing this task. If not, please contact EnergyCAP Technical
Support.
ISSUE: Natural Gas and THERMS are not showing in the Roll-up Tabs
under Global
SOLUTION: The following is th...
ODBC Data Source Administrator (Data Sources) not showing database
(Data Source)
ISSUE: After using the ODBC Data Source Administrator to create an
ODBC connection, the System Data Source does not appear in the ODBC
Data Source Administrator SYSTEM DSN...
Issue:
User is unable to run reports in EnergyCAP Pro due to an error
indicating connection or login issues to the database.
Solution:
Have the user test the ecuser and ecsysadmin logins to the SQL 2005 or
SQL 2000 server by attempting to create a new ...
EnergyCAP Professional Reports Fail Due to Database Connection Errors
ISSUE: I can access data in EnergyCAP Professional but when I try to
run any report I receive an error concerning Database Connection
failure.
SOLUTION: This can occur when Energy C...
ISSUE: When I go to enter in any of the report sections, Billing, Cost
Avoidance, or Setup, I get an error message - ERROR 512: REPORT ENGINE
NOT OPENED PRINT ENGINE
SOLUTION: What has happened is that the Crystal Runtime engine, which
ru...
How to install the EnergyCAP software on the Windows 7 operating
system:
ISSUE 1: Run As Administrator
When installing EnergyCAP Software on a computer with the Windows 7
operating system, the user MUST install by right-clicking the
installation executa...
ISSUE: When entering bills, one of my gas meters is not showing up in
the drop down box.
SOLUTION: Please notice what version/build you are running of
EnergyCAP Professional. If you are running a version/build less than
Pro 2011 (Build 2.0.5.622), pleas...
Below is the direct link to download the install file for Pro Desktop
2011.
http://www2.energycap.com/pro_desktop/SetupPro2011.exe
[http://www2.energycap.com/pro_desktop/SetupPro2011.exe]
Please contact Support at http://support.energycap.com
[http://...
Problem: An EnergyCAP Professional version report has been updated.
How do I install it?
Solution: Updating EnergyCAP Pro 2011 report CAP19 is presented as an
example:
1. Run EnergyCAP. Navigate to and highlight the existing report that
is to be repla...
ISSUE: When entering bills in EnergyCAP Professional, the dates appear
to change on their own.
SOLUTION: This is Windowsissue relating to date formats, not an
EnergyCAP Professional issue.
*
Close EnergyCAP.
*
Go to the WindowsCONTROL PANEL and...
ISSUE: Actual cost on Bill08 report does not equal actual cost on
CAP01C.
SOLUTION: It is possible that the actual cost shown on Bill08 will not
equal the actual cost shown on CAP01C even though the range of billing
periods is exactly the same.
BILL08 ...
ISSUE: I want to change the vendor assigned to an account. In account
properties I select the desired vendor from the drop down list but
when I click OK I get an error message. ("Subquery returned more than
1 value.")
SOLUTION: This message occurs if you...
ISSUE: One or more CAP reports encounter error messages during the
database upgrade phase of EnergyCAP Pro 2005 installation. Reports
that may fail include CAP07, CAP13, CAP 16/17/18.
SOLUTION: The problem is caused by a very minor glitch that occurs
whe...
ISSUE: EnergyCAP Pro 05 -- Report CAP 07 encounters error message on
some PCs.
SOLUTION: There are two possible solutions:
1. On some PCs, the error is ONLY encountered when the user has a
limited account in Windows. Logging in to Windows with a full
a...
ISSUE: I run the CAP14 report for all bills (all filters set to ALL)
but not all bills appear.
SOLUTION: The quickest way to verify the number of bills is to run
report BILL02 with all filters set to ALL. See the total bill count at
the top of the report...
This document provides information for enabling display/printing of
"missing" CAP15 report data.
ISSUE: The following is a typical user experience:
"I have the 2008 ECAP version installed and CAP Report 15 does not
list cars removed or trees planted in t...
ISSUE DESCRIPTION: You want to change the units of measure shown on
summary reports from the built-in defaults to some other reporting
units. For example, THERM to CCF for natural gas or from KGAL to CCF
for water.
Solution:
EnergyCAP Pro 2005 and late...
NOTE: EnergyCAP support for FASER data will expire 12/31/2010.
SUBJECT: Conversion of FASER datasets
ISSUE: Converting FASER datasets to EnergyCAP database format
Follow this checklist to convert FASER data to EnergyCAP.
1. The FASER data must be in ...
ISSUE: The unit price of natural gas is much higher this year. We
reduced our gas usage. I think that our cost avoidance should be high
but it's not. What's the reason?
SOLUTION: You may need to adjust the Global setting that controls the
unit cost "safe...
ELECTRONIC BILL IMPORT
You can import bills provided you are able to format an Excel file per
these precise rules.
Use the provided Excel Bill Import template (located in the EnergyCAP
program folder).
When you import, you will prompted to enter a...
EnergyCAP Professional 2006 and prior releases use a desktop version of Microsoft SQL Server 2000 called "MSDE." MSDE is not compatible with Vista. Microsoft has elected to abandon MSDE in favor of the most recent desktop version of SQL Server 2...
Issue: I can access data in EnergyCAP Professional but when I try to
run any report I receive an error concerning DATABASE CONNECTION
FAILURE.
Solution: This can occur when Energy CAP databases are attached to SQL
Server via SQL Management Studio or Ente...
ISSUE: EnergyCAP Professional runs fine except for reports. When a
report is attempted an ERROR 599, SQL CONNECTION ERROR, is displayed
on the screen.
Error 599 has been observed in a number of circumstances:
1. There is a software firewall on the PC th...
Three EnergyCAP Pro 2003 users have reported that when trying to run
reports, the program shows error code 609.
No cases have been reported with Pro 2005.
In two cases, this was on a Gateway laptop running Windows XP. As of
this date we have been un...
ISSUE: Reports fail to run. Error message says 'failed to open
connection, error:756.' (Running on SQL Server rather than MSDE.)
SOLUTION: This error was caused by the ecuser password being
incorrect. The password is automatically set for MSDE users but ...
ISSUE: When I run a back up on my database, I get an error message
"backup failed, please restart the program".
SOLUTION: Open EnergyCAP Professional using the initials "SYS". Then
go to FILE > DETACH DATABASE OR DELETE DATABASE. In the new windows
drop...
EC PRO - When I submit for my weather stations from the web, I am
getting an HTTP error messages and to contact my technical support.
SOLUTIONS:
1. Your firewall may be blocking the URL we use to get our weather
data. Check with your IT group an...
ISSUE: EnergyCAP reports that are exported to Excel have columns
combined so rows can't be sorted.
SOLUTION: The problem is that you are not using the EXCEL FORMAT
OPTION. Follow these steps:
1. Run the report in EnergyCAP.
2. Click the EXPORT icon...
ISSUE: When opening EnergyCAP Pro 2011 on Windows 7, I get an error
message saying "CAN'T ACCESS DATABASE IN SERVER XXXXX" (XXXXX being
your SQL server name)
SOLUTION: First, with Windows 7 you want to make sure that you have
permissions to the SQL data...
ISSUE: My actual data does not appear in EnergyCAP Professional. In
the lower right corner of the screen it shows: (local) DemoData
SOLUTION: A demo database called DemoData is provided with EnergyCAP
for training and testing. Your EnergyCAP program is ...
Issue: During installation of SQL Express, it errors out during the
MSXML parser, workstation, and server components. This is turns fails
the install of ECAP Pro and SQL Express. This occurs on a machine with
Service Pack 3 and MSXML 6.0 Service Pack 2 al...
It is possible to connect your EnergyCAP Professional database to your
own SQL Server rather than use the provided MSDE Desktop Data Engine.
However, do NOT use the SQL Enterprise Manager tools to attach the
database to SQL. You must use the SYS login to...
ISSUE: My meter is still showing on the BILL 01, BILL 02, BILL 20 and
BILL 21 Reports even after I have selected EXCLUDE FROM REPORTS in
the Meter Properties.
SOLUTION: Although a meter that you have marked to EXCLUDE will NOT
show up on most Roll...
To move an existing EnergyCAP Professional database to another PC:INSTALL EnergyCAP Professional AND the SQL data engine on the new PC. DETACH the database from SQL on the source PC. You can do this two ways: (1) Stop the MSSQL Server service by going t...
Version: Pro 2003-2009 Subject: Setting up multi-user databases Issue: I want two or more users to share the same EnergyCAP database across a small peer-to-peer network. Typical situations: • An energy manager and an assistant want to share the same ...
ISSUE: I would like to print the history or graphs from the enter
monthly screen. Is there any way to do this?
SOLUTION: Printing can not be done directly from the enter monthly
screen, but it can be done using PowerViews(TM). To get to a screen
where yo...
ISSUE: User has aborted an EC PRO installation, then reinstalled the
program with apparent success. However, errors are generated when
trying to run reports.
SOLUTION: Logon to EnergyCAP Professional as normal user and make a
backup of the database (FIL...
ISSUE: Report Headers have lines printing on top of one another.
SOLUTION: The following line must be run as an SQL script:
DELETE From tblDataset Where Dataset = 2
To apply the fix:
1. Using a text editor, save the above script to a file name of y...
ISSUE: The Report Settings buttons for OK and CANCEL are partially or
totally off of the monitor screen.
This can occur with some monitors/displays when the font size for the
PC is set to LARGE instead of NORMAL.
SOLUTION: Change the Font Size to NORMA...
ISSUE: When entering EnergyCAP Pro 2005 I get this message: Error:103
Incompatible CRPE version: requires version 11.x CRPE32.DLL ::
7.0.0.192
(Your message may end in something different than "CRPE32.DLL
::7.0.0.192")
SOLUTION: Pro 2005 uses version 1...
ISSUE: No reports are shown in the reports menu. The categories are
there (Setup, Billing, etc) but no reports are listed.
SOLUTION: Reports are installed into the database when the database is
created or upgraded. This condition can occur if a '599' err...
EC PRO 2009: SQL Error - server does not exist or access denied
ISSUE: After you have upgraded to EnergyCAP Professional 2009, you
start up EnergyCAP and you get an error from SQL stating that your
server doesn't exist or you don't have access rights.
...
EC PRO System Requirements
* Windows 2000 or later. The most commonly used operating systems are
XP and Window 7 (32 or 64-bit). Our initial testing has found no known
issues with Windows 7. You just need to install by right mouse
clicking and Run As Ad...
EC PRO: UNABLE TO OPEN DATABASE IN PROGRAM OR SQL MANAGEMENT
ISSUE: Unable to open the database in ECAP Pro 2008 or through SQL
Management Studio Express. Getting an error message "INACCESSIBLE FILE
OR INSUFFICIENT MEMORY OR DISK SPACE: ERROR CODE:945" ...
ISSUE: I need to uninstall and reinstall EnergyCAP Professional
SOLUTION: Below is the link to the download of ENERGYCAP PRO 2009
SP1 if you do not have this install file already. So please make sure
you have this file and a current back up of your dat...
UPGRADING FROM PRO 2004/2005/2006 TO PRO 2009 SP1:
Before you install Pro 2009 SP1, you will need to a BACK-UP of your
database and then uninstall the older version of Pro and the SQL
engine, (MSDE/SQL Server 2000).
1. Back-up your database to C:ECAPB...
There are three steps in using the EPA eGrid Power Profiler:
1. Access the Power Profiler:
http://www.epa.gov/cleanenergy/energy-and-you/how-clean.html
[http://www.epa.gov/cleanenergy/energy-and-you/how-clean.html]
2. In the ZIP CODE LOOKUP field, ent...
Pro Using XP Poweruser login
06/23/2005
ISSUE: I want to install EnegyCAP Professional as an administrator and
give the user poweruser rights, but when I do that and the user logs
in, the server can't be seen. How do I correct this?
SOLUTION: The system...
Several issues have been identified with respect to installation of
the EnergyCAP Professional software on the VISTA operating system:
* When installing EnergyCAP Professional Rel. 2008 on a computer with
the VISTA operating system, the user must in...
PROBLEM: The total cost avoidance in Pro 11 is slightly higher than
it was in Pro 09. Why is it higher?
SOLUTION: A correction made to the Pro 11 cost avoidance processor
provides more accurate and appropriate cost avoidance calculations for
meters that...
ISSUE: Cost avoidance reports filter out records when Cost Without CAP
is zero. We have found this to be true when using Heating Oil as a
commodity. This issue will be fixed in the next software release.
SOLUTION: There are two temporary workarounds:
1...
ISSUE: While navigating through EnergyCAP Online, I keep receiving
the Whoops! pop-up message.
RESOLUTION: If you are receiving this message, it could be that you
were "logged out" from the connection. Try logging out and back in
again to see if this r...
INSTRUCTIONS FOR BACKING UP DATABASE AND MOVING THE BACK UP TO A
FLASHDRIVE OR NETWORK DRIVE.
Open EnergyCAP Professional>Go to File>Backup Database.
New window will open. In that window, make sure that the backup
location is going to the local har...
ECPRO: I am getting an error message when I first login after upgrade
(SA Login Failed)
ISSUE: After upgrading my EnergyCAP Professional Software to
Professional 09 SP1, I am getting an error message of 'SA' LOGIN
FAILED and a second error message o...
There is an issue with some EnergyCAP Professional Online clients
where Greenhouse Gas (GHG) factors are not assigned to meters. The
root cause of this is the absence of a building address (specifically
the state). This causes the GHG/emissions numbers th...
**_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