Building Automation Knowledge Base

Warning Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support Services for assistance. Issue The size of ContinuumDB has reached or is near the 2Gb limit imposed by MSDE. The size of ContinuumDB has reached or is near the 4Gb limit imposed by SQL Express. Environment MSDE SQL Express Continuum Stand Alone. Cause The database is well over the SQL size limit (2Gb for MSDE, 4Gb for SQL Express) Since the database size has already exceeded SQL's limitations it is not possible to use the deletion query statement to truncate the log tables.  This is because SQL will attempt to guard against data loss during the deletion process by making a copy of the tables contents before deletion occurs. Before a single row has been deleted from the table the size of the database will actually grow larger, exacerbating the problem. Resolution You must delete the contents of each log table entirely (Alarm, event, error, log) using the TRUNCATE statement. This will delete the contents of these tables entirely without first storing them the data. Please note, you must... Make arrangements with the customer so that they can archive any log and event data they wish to retain. Backup the database before using the TRUNCATE TABLE command. Here is the syntax for the TRUNCATE statements TRUNCATE TABLE ContinuumDB.dbo.AlarmEvent TRUNCATE TABLE ContinuumDB.dbo.AccessEvent TRUNCATE TABLE ContinuumDB.dbo.ActivityEvent TRUNCATE TABLE ContinuumDB.dbo.ErrorEvent TRUNCATE TABLE ContinuumDB.dbo.ExtendedLog Once the table have been truncated, Right click on ContinuumDB and select Shrink > Database. Once the database has been size has been reduced, check the size and retest. Please note that once the database size has exceeded SQL's limit it is likely that the database has been damaged.  This process may or may not correct damage that has occurred to the database.  

Issue Locating partners Environment Partner Continuum Cause Require engineer to visit for maintenance, servicing, installation or advice. Resolution Click here to be linked to the available UK and Ireland Continuum partner list.

Issue I have a large site and need to add a new Xenta controller. Can I add the group bindings manually as the option to create group bindings in the System Plug-in takes time and controllers are taken offline for the period of the process. Environment NL220 Cause This is possible to do and works very well and effectively if you understand the process. Resolution Follow these steps to add TAG 0 system binding and TAG 1 Xenta binding to your new Xenta controller. In NL220 go to the project setting option. Then check the "Message Tags Connections Tree" option under the Trees tab This will cause a new option to be selected in the tree view labeled Message connections In this tree there will be one TAG0 that covers the entire Xenta controllers. Right click on this TAG 0 connection and select Edit. With the connection window open then select the subsystem       view and drag the TAG 0 from the new Xenta controller into the connections window. This will add your new Xenta controller into the TAG 0 existing binding. Use the update button to update the database. The next step is similar to the TAG 0 but for the TAG 1. You will need to locate the TAG1 Xenta group that you are adding the new Xenta controller into. Look for the name of the Xenta controller in the Xenta group that you need to use. Once you have located this TAG 1 connection right click on this connection and select Edit, with the connection window open then select the subsystem view and drag the TAG 1 from the new xenta controller into the connections window. This will add your new Xenta controller into the Xenta TAG 1 existing binding. Use the update button to update the database.

Issue Integration of the Carlo Gavazzi EM21 Power Meter with the Xenta 5xx\Xenta7xx Xenta 913 and Modbus RTU Environment Xenta 511, 527, 55, 701, 711, 721 (5.1.5 up) Xenta 731, 913 (all versions) XBuilder Carlo Gavazzi EM21 Power Meter Cause Disclaimer:  This device template is intended to provide a starting point for an integrator and is not meant to be a mandatory points list for your integration project. Product Support Services has written this device template in an effort to give our customers a solid example of how to develop a device template for the above product.  The integrator will be responsible for any additions or modifications to this device template.   Please report any problems with this template to Product Support, via the Contact link at the top of this page. Resolution Please use the following dev file as a starting point and a guide to the integration.  This .dev file contains a subset of the registers in the device that PSS considers will be of most use to the integration process.  If any other data is required please see the latest Carlo Gavazzi documentation to make the necessary changes.   To use these files in XBuilder please follow these steps: 1.  Extract the .dev file from the .zip file in the link above and place it in a convenient location on your harddrive. 2.  In XBuilder, right-click on the Modbus Master device and choose 'Add Device'. 3.  Browse to the extracted dev file and choose 'Open'. 4.  Rename the newly added device to a unique name within the Modbus Master network.

Issue How to change the IP address of the Automation Server and ensure proper communication. Product Line EcoStruxure Building Operation Environment Enterprise Server Automation Server Building Operation Device Administrator Building Operation Workstation Cause At times the IP address information for an Automation Server must be changed after being added to an Enterprise Server to accommodate changes in IP network design, correction of incorrect data, or any other reason. Changing the IP address needs to be done in the proper method to avoid artifacts and confusion after the change. Resolution To avoid complications, follow this process to modify the IP address of an Automation Server that is already communicating with an Enterprise Server. In the Building Operation Device Administrator connect the AS controller via USB or IP.  WebHelp Topic Connect to SmartX Servers Right-click on the AS and select Network Settings Modify the IP address settings to the new values Additionally, this can be changed through PuTTY with the "setip" command. Power Cycle the Automation Server (If a power cycle is not completed the AS will still have invalid data for network settings despite the physical network interface running with the new settings) Start Building Operation Workstation and log in to the Enterprise Server Select the Enterprise Server and open the Communication Tab Highlight the Automation Server that needs to be changed and modify the address field for the IP address of the device. (The Communications settings tab is enabled by selecting the Show/Hide tick icon). Click the Save button The Enterprise Server should now automatically establish communication with the AS, but if you want to speed this process you can right-click the Enterprise Server and select the "Advanced\Repair Server Communication" option. IMPORTANT: As of 1.41 if the IP address is changed on a server that is configured with a BACnet interface, the IP address and possibly the broadcast address of the IP Network under the BACnet interface must be updated manually. (see below)

Issue Micronet BACnet (MNB) AV and BV objects in G3 are purple indicating they are overridden. The AV and BV objects are read only, how can they be overridden? Product Line TAC IA Series Environment Niagara G3 Micronet BACnet MNB-300 MNB-VAV MNB-1000 Cause Purple BACnet values (I/A Series R2 and G3 graphic override color) are internal BACnet points that can not be modified (display only). This behavior is normal and began to appear in MNB controller firmware versions 1.2 and higher. Per the BACnet specification, read-only type points must be set to indicate an override condition. The root cause is a design change required by the BACnet specification to bring the controllers into compliance for BTL certification. The ASHRAE BACnet Specification 135-2004 specifies that the "read-only" type objects (e.g. Analog Value, Binary Value, etc.) OVERRIDDEN flag is: Logical TRUE (1) if the point has been overridden by some mechanism local to the BACnet device. In this context "overridden" is taken to mean that the Present Value property is not changeable through BACnet services.In this case, the override is meant to indicate to Niagara that the point is locally overridden (by the controller) and cannot be changed by the Niagara BACnet service (or user).When the ENC learns the device it reads what "Protocol Services" it supports. If it supports COV then the "use COV" flag is set to true in the device object and when the proxy points are brought in they are defined as COV and once subscribed they will send their present value and status flag values to the ENC. In this case the AVM & BVM (being read only) objects will show overridden along with their value and be purple by default. Resolution All MNB devices support COV so the use COV property is set to true when they are discovered in the ENC.If the use COV property of the Device object is changed to false the ENC will use readPropertyMultiple (if supported in the device) to poll for data. If readPropertyMultiple is not supported in the device the ENC will read one property at a time. Now when the points are learned they will be defined as polled and when polled only the present value (PV) is requested (by default). Hence the AVM & BVM objects will show their value but not show overridden because their status flags are not known at the ENC. If the use COV device property is set to true after the AVM and BVM proxy points are defined in the ENC they will show overridden and purple after they are successfully subscribed. Turning the use COV property in the device to false at this point will cause these objects to be polled but their status is already known so they will continue to show overridden along with their present value. The only way to change that is to delete and re-learn them while the device use COV property is sent to false.

Issue How is a subnet defined? Environment Refer to "TCP/IP Network Administration" by Craig Hunt, O’Reilly & Associates, Inc. Cause Sectioning network communication by subnets. Resolution A subnet is defined by applying a bit mask (subnet mask) to the IP address. If a bit is on in the mask, that equivalent bit in the address is interpreted as a network bit. If a bit in the mask is off, the bit belongs to the host part of the address. The subnet is only known locally.

Issue Error message "Access denied" when starting TAC Vista Server Environment Vista Server Cause To start TAC Vista server you have to be an administrator on the computer. Resolution To start TAC Vista server you have to be an administrator on the computer. If you want to log in to TAC Vista with a user that isn't an administrator, you have to run TAC Vista Server as a service. The service has to be started with an account that is an administrator on the computer.