RSS Feed
Knowledgebase : EC Enterprise
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...
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...
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...
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 operating system: ISSUE: When installing this software or others on Windows 7 with the UAC (User Account Control) turn up or on, it fails to install certain components. SOLUTION: Run As Administrat...
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...