RSS Feed
Knowledgebase : EC Professional
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: 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 program". SOLUTION: Open EnergyCAP Professional using the initials \"SYS\". Then go to FILE > DETACH DATABASE OR DELETE DATABASE. In the new windows d...
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...
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...