Issue Log data is not being logged into SQL. The Reports Server indicates that the database is full.   This view will be shown when logging into the WebReports interface. If this chart is not shown, the PC is not running an Express edition of SQL. Product Line EcoStruxure Building Operation Environment Reports Server 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. Cause In most instances, the data that quickly fills the SQL database are Events. Event data fills the SQL Database and prevents log data from passing to the Reports Server database. If the data has filled within a few days, this would indicate an issue, and contacting your local support is the best option here. The Process below allows the user to stop the reporting agent from passing specific information to the Reports Server. If the data files are due to the amount of data stored, then an upgrade to the Standard/Full version of SQL is recommended.   Resolution To verify that the Events table is the likely cause of the SQL filling up, there are Standard Reports in the later versions of SQL.  The below example uses SQL Server version 13.x and shows the "Disk Usage by Top Tables."   If the Standards Reports are not available, then use the following article Building Operation Reports SQL Database Full, for instructions on how to show the details for each table.     The Process below allows the user to stop the reporting agent from passing Event information to the SQL Database: Download the latest SBO Reports Agent Config tool from the community. Load the Tool onto the Reports Server PC. Stop the Reporting Agent Using the Tool Press F7 to get to the Advanced Agent Configuration Page Change the numEventRecordToRead property to 0. This will prevent future event data from being written to the Reports Server database. Press Ok Under the Maintenance tab of the tool - there are two options under Events  Delete future events, alarms, and trends  Delete events and alarms older than... Restart the Reporting Agent This will stop any further Events from being passed through to the SQL Database.  

Issue In some cases the event and trend database can grow really big although not all the space in the files is used Product Line EcoStruxure Building Operation Environment SQLite Building Operation Enterprise Server 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 for assistance. Cause Frequent inserts, updates, and deletes can cause the database file to become fragmented - where data for a single table or index is scattered around the database file. Running VACUUM ensures that each table and index is largely stored contiguously within the database file. In some cases, VACUUM may also reduce the number of partially filled pages in the database, reducing the size of the database file further. Read further information here: https://www.sqlite.org/lang_vacuum.html Resolution Stop the Enterprise Server Open SQLiteStudio (link to download) Select "Databases" --> "Add database" Select the event.db or trend.db file from the "historical" folder of the SmartStruxure database folder Execute the following command: vacuum;

Issue Require a method on how to apply individual setpoints in EBO when Users are granted access at a Security Expert  Door. Product Line EcoStruxure Security Expert, EcoStruxure Building Operation Environment Security Expert EcoStruxure Building Operation 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. Cause An example of this would be to have room temperature setpoints, or other specific settings, be changed when specific Users are granted access to a room or area. One method on how to do this would be to create a separate Access Level and Access Level Output for each user. When the User with that Access Level is granted access the associated output will be enabled. Using the EWS integration, the states of these virtual outputs can then be monitored within EBO and action were taken when they change state. Resolution Perform the following steps to configure this: Create an Access Level for each User object. Create a virtual output for each User object. A virtual output is an output object that is not assigned to an output expanders physical outputs. You could create outputs on existing expanders above the maximum output channel that you will be using but it is recommended putting these virtual outputs on a completely different module address outside the range that will be used for any physical modules. Module address = 32 would be a recommended starting value. Steps would be: Under Programming | Outputs create three new outputs. Set Module Type to "Output (PX)" Set module address to "32" or greater. Set Module Output to "1", "2", "3", etc... Save the changes. For each of the Access Levels add the corresponding virtual output to the Access Levels Output tab. Access Level OutputsAccess Level Outputs Ensure the Access Level has access to the Door(s) in question. Set the Time to Activate (seconds) in the Access Level | General tab to something appropriate such as 5s. The output will disable after this time period. Set the Reader Access Activates Output on the Access Level. Set Activate Access Level Output on the Reader Expander | Misc Options.    

EBO doesn't support save from controller for B3s

Issue Issues upgrading Automation Servers (AS, AS-B, AS-P) connected to an Enterprise Server (ES) from versions prior to 2.0.x to a version that is 2.0.x. ES and one Automation Server will upgrade but no others connected to that same ES will upgrade and will show an error while attempting to download the new software.  Product Line EcoStruxure Building Operation Environment Building Operation Automation Server v1.9.x Building Operation Enterprise Server v1.9.x   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 for assistance. Cause If the Automation Servers within the ES environment are not uniquely named, and/or are the same name as the ES, an error will be received if upgrade is attempted stating "Deploy upgraded database failed". Resolution As found within the Enterprise Central section of the 2.0 Release Notes, "All servers must have unique names".   *NOTE* Renaming the Automation Server will break any paths to that Automation Server, as such they will need to be corrected.   Follow these steps to address this issue: Prior to upgrading any devices within the environment, check for and find any servers with non-unique names Detach the Automation Server (with the naming identical to the ES or any other server) from the ES Rename the Automation Server with a unique name Correct any binding path issues Reconnect Automation Server to the ES Upgrade the environment to 2.0.x

Issue Integrating MNL-VAV controllers into the EBO system successfully Product Line EcoStruxure Building Operations, TAC IA Series Environment Building Operation Automation Server Building Operation Automation Server Premium I/A Series MNL VAV 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 for assistance. Cause Lost flow balancing values during integration Lost S-link offset calibrations Resolution Use the following steps to bring a controller into the Automation Server with all data intact. Using WorkStation connected to the AS/AS-P; right click on the LonWorks Network and select New then Device. Choose the appropriate device object type from the list for the MNL-VAV controller being added, give it a name and click Next. Type in the Neuron ID or use the Service pin method to identify the controller. Check the box next to “Commission” and the radio button next to “Keep current configuration in the device” and click “Create” then click “Close” when complete. Right-click on the new device object in the tree and select MNL and then “Backup flow balance information”. When this is complete notice the blue circle with a white checkmark next to the nciHighFlowCal and nciLowFlowCal SNVT’s indicating the AS-P DB contains the balance data from the controller. If special S-link offset values exist in the controller right click on the device object in the tree and select MNL and then “Backup S-link offsets”. Right-click on the controller device object and select MNL and “Assign application” and click on the appropriate application file for this controller and click on “Assign”. Right-click on the controller and select MNL and “Download application”. Click on “Close” when complete. Right-click on the controller and select MNL and “Restore the flow balance information” Right-click on the controller and select MNL the “Restore S-link offsets”. Verify all data is correct and the controller is functioning properly.

Issue Require details on how to migrate Users from an SP-C-WEB to Security Expert. Product Line Security Expert Environment SP-C-WEB Security Expert 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 for assistance. Cause Have a site that has outgrown it's SP-C-WEB installation and is upgrading to Security Expert to expand. Resolution Door configuration and programming cannot be migrated from an SP-C-WEB installation to Security Expert, but the User database can be exported to a CSV file and then imported into Security Expert to help with the migration. Exporting User database from SP-C-WEB to CSV file From the SP-C-WEB user interface navigate to Users | User Search. In the User Search page on the top right (under date) is the Export button. Clicking the Export button will generate a .csv file of all User details. (See attached example Exported Users.zip) Editing User CSV file for importing into Security Expert The Security Expert User import requires the CSV file to be in a specific format: FirstName,LastName,FullName,Facility,Card,PIN,AccessLevel The rules for this format are that: Each field must have a value however the firstname/lastname can be omitted if the fullname is used and vice versa. The facility can be omitted if it is prepended to the card number and separated with a colon (eg 123:4567). If a matching Access Level is not found, a new access level is created. The PIN and Card must be unique for each user. The file cannot contain a header row. Some examples of correctly formatted data are: Joe, Stanley,Joe Stanley,123,4587,1418,Warehouse Staff Georgia, Smith,,123,4654,6884,Warehouse Staff ,,Billy Randall,123,4727,3492,Warehouse Staff Frank,Powell,,,123:4639,3160,Warehouse Staff Importing Users from a CSV File into Security Expert In the Security Expert Client navigate to Sites | Import Users to launch the Import Users Wizard. Browse to and select the CSV File you wish to import the users from, then click OK. Figure 1 - User Import DialogFigure 1 - User Import Dialog The Users records are created and a message is displayed to indicate the action was successful.

Issue When you attempt to save a Menta application in Workstation you will get an "Invalid Data" Error. Product Line EcoStruxure Building Operation Environment Building Operation Workstation Building Operation Menta Editor 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 for assistance. Cause Some public variable in the Menta application has had Initial bindings added that conflict with the EBO bindings. Resolution Remove the Initial bindings from the variables in the Menta application and use EBO bindings. To find these Initial bindings follow these steps, Edit the Menta device with the issue From the File Menu "export" the Menta application to a known location on the PC and save it as a MTA file. Browse to this MTA file you exported and open this file with the Menta Editor From the File menu select "Save as" option. Give the file a name and in the Save as Type select FDB (*.AUT) Using Note Pad++ edit the AUT file you just created. Search the AUT file for the label "InitialBindings" [see Figure1 below] Make a note of the objects with Initial bindings so the initial bindings can be deleted from the Menta file. In Workstation edit the Menta device and remove the initial bindings from the objects found in step 7 and change the name of the object noting the original name down. Save the Menta application to the server. In Workstation edit the same Menta device and rename the object back to the noted name in step 8. Save the Menta application.

Issue Uninstall PCT doesn't uninstall Oracle VirtualBox Product Line EcoStruxure Building Operation Environment Building Operation Project Configuration Tool (PCT) 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 for assistance. Cause The uninstaller of PCT doesn't include VirtualBox as part of the uninstallation. Resolution 1. Uninstall PCT from “Control Panel\All Control Panel Items\Programs and Features”. 2. Uninstall PCT Client. 3. Uninstall Oracle VM VirtualBox.

Issue SP-C Controllers randomly going offline / online.  Restarting the controller resolves the issue for a short period of time. SP-C Controller ports showing TIME_WAIT when a netstat command is run. Product Line EcoStruxure Security Expert Environment Security Expert Controller (SP-C) Warning Hazard of Electric Shock: Remove all power from all devices before removing any covers or doors of the system. Disconnect power at the device and at the power source. Electrostatic Discharge Required: Always discharge static electricity from your person by touching metal prior to handling any hardware. Failure to do so may result in damage to devices. 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 for assistance. Cause Under normal conditions an SP-C needs to update the Security Expert Server with new data. During this time the IP Socket of the SP-C is in a Waiting State, refusing to communicate to anyone else while waiting for an opportunity to upload. Once the controllers data has been uploaded to the server however the controller releases the IP Socket and it is open again to new communication. In an extremely small number of cases the SP-C controller goes into this waiting state as usual but then never comes out of that state, holding onto the IP Socket forever and blocking any further communication until the controller is power reset. This only affects a very small percentage of SP-C controllers running Microsoft Windows CE OS Version 16. Resolution In these extremely rare cases the first step is to identify if the affected controllers are indeed running OS Version16.  For SP-C Firmware builds before 2.08.921 Log into the controllers configuration web page. Browse to the Configuration tab. Check the OS Version field at the bottom of the page. For SP-C Firmware build 2.08.921 and above the OS is now shown in a different location.   Once it is clear, that the OS is version 16, Product Support can be contacted to arrange to upgrade the controller OS to Version 20 (or greater) as is found in SP-C controllers shipping now. As this is a high risk procedure and can result in complete failure of the controller if anything goes wrong there are two options for upgrading the OS. Install the affected controller on a test bench with remote access for Product Support to remote in to and perform the update. Have the controller sent back to the factory to be updated and returned to site. Both options will require replacing the controller with temporary stock while the upgrade is being performed.

Issue After switching the recovery model from Full to simple, the shrink task fails to shrink the transaction log file. Product Line Continuum Environment Continuum Microsoft SQL Server 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 for assistance. Cause A transaction log cannot be shrunken while there is a process actively accessing the log file. Resolution Use the log_reuse_wait_desc function in a SQL query to help you identify the process that is preventing the shrinking of the transaction log. Open SQL Server Management Studio.  Click on the New Query button. In the query window type the following SQL statement: SELECT log_reuse_wait_desc FROM sys.databases WHERE name = 'ContinuumDB' Note: The name in single quotes should be the name of the Continuum Database. In some cases, it may have been changed to something other than "ContinuumDb." This query will return one or more of the following keywords.  Each of the following keywords indicates a transaction log process that is taking place. Here is a list of keywords that could be returned. NOTHING CHECKPOINT LOG_BACKUP ACTIVE_BACKUP_OR_RESTORE ACTIVE_TRANSACTION DATABASE_MIRRORING REPLICATION DATABASE_SNAPSHOT_CREATION LOG_SCAN OTHER_TRANSIENT For example, if this query were to return REPLICATION, this would indicate that the replication process has control of the transaction log.  In that case you might investigate the replication configuration or perhaps even turn replication off temporarily to successfully shrink the log. You can find a detailed description for what each keyword indicates by searching the following website Eight Reasons Transaction Log Files Keep Growing

Issue Need to backup or share the project with another user. Product Line EcoStruxure Building Operation Environment Building Operation Project Configuration Tool (PCT)  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 for assistance. Cause One way of sharing a project is to move it and another way is to Export the project. Resolution Move the project Stop all servers in each project and stop all projects. Close PCT application. Copy the “projects” folder from the PCT storage location and paste it to another storage location (suggested by WebHelp topic Move a Project) OR backup all servers through Workstation. Default PCT Project Folder Locations Versions prior to PCT 1.2 C:\ProgramData\Schneider Electric StruxureWare\Building Operation\Project Configuration Tool\storagemodule\projects PCT 1.2 or higher C:\ProgramData\Schneider Electric EcoStruxure\Building Operation\Project Configuration Tool\storagemodule\projects Default PCT Template Folder Locations Versions prior to PCT 1.2 C:\ProgramData\Schneider Electric StruxureWare\Building Operation\Project Configuration Tool\templates PCT 1.2 or higher C:\ProgramData\Schneider Electric EcoStruxure\Building Operation\Project Configuration Tool\templates   Export the project In Project Configuration Tool, in the Project view, select the project you want to export. On the Header toolbar, click the Export project button or right-click on the project and select "Export". On the Export selected project(s) dialog box, in the Folder box, browse to the folder on your hard drive where you want to save the exported project. Click OK. TIP: You can select multiple projects and export all of them at once. Note: In order to be more future proof, there is a new export/import format of PCT projects starting in PCT v1.3.2 with exports having an extension of '.pct_export'.  Projects exported at an earlier version have an extension of '.ppb' and they must be converted to '.pct_export' files before import into PCT v1.3.2.    Please refer to point 2.1 in the release notes.   Also prior to PCT v1.3.2 the project had to be stopped before export was possible.  In PCT v1.3.2 the project has to be running before it can be exported.    

Issue Security Expert Installation steps for separate SQL, SX application Server, and Client for use with Windows Authentication and Active Directory Product Line EcoStruxure Security Expert Environment Microsoft SQL Server Microsoft Windows10 Security Expert Server and Client  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 for assistance. Cause Access Denied error appears when attempting to log into Security Expert with Windows Authentication with a multiple PC Security Expert Installation Resolution Important considerations when connecting Security Expert to an external SQL Server: Machines should be on the same network and Domain. When you install Security Expert, reference the SQL database in this form:  Machine Name\SQL Instance Name The Windows user account doing the installation must have admin rights on both machines. The windows login you're using to install on the Security Expert machine has to have admin privileges to alter the SQL Database on the remote machine. The easiest way to do this is to use the same account to set up all machines. Different accounts can be used, but the accounts have to have privileges added to the SQL Database manually. (Not covered in this document)   Assumptions: Active Directory server has a domain user that can be used to install the applications on all machines. Licenses cover all machines Security Expert users are set up to use Windows Authentication (snapshots at the end of the document) If the SQL server ever had Security Expert Installed on it, uninstall Security Expert and reboot. If the Security Expert application server had SQL on it, uninstall SQL, reboot and reinstall Security Expert without local SQL. If the Client PC had Server components installed, uninstall Security Expert, reboot and install the client only.   Perform the SQL Server Installation onto a separate Server per the Security Expert Installation Instructions Security Expert Application Server/Client installation (No SQL) If this box is selected, the install may fail because the service has not been installed yet. With this option selected, the install will finish and then the service can be configured later. 3. Change the database server to NOT be localhost\SecurityExpert Use machinenameofSQLServer\SecurityExpert (Ex. SECEXPERTVM\SecurityExpert) 4. Select Windows Authentication Complete the installation.   5. Open Windows Services on the Security Expert Application Server (Run> services.msc) Right-click on Security Expert Data Service> Properties Select the Log On tab Deselect Login As Local System Account Select This account and then click browse to search for the domain admin user   Start the service. Security Expert Data Service, Security Expert Event Service, and Security Expert Update should all start   Client only setup - Ensure the Server option is deselected In the following dialog select Custom   7. Select the drop-down next to Server> then select “This feature will not be available” Complete the installation   A successful login with the domain admin account using Windows Authentication from the Security Expert machine and also the client PC should work.   From the Client PC – Security Expert application server = 10.169.90.170 From the Security Expert Server/Client SecurityExpertSV.exe.config (Server) – This file did not have to be changed    SecurityExpert.exe.config (Client) - This file did not have to be changed   Note: There may be circumstances where these files do need to be configured. See LL https://community.se.com/t5/Knowledge-Base/Security-Expert-Error-Server-Has-Rejected-Client-Credentials/ta-p/698   Domain Tab example set up in Security Expert for Active Directory Windows Authentication   Operator Example setup in Security Expert for Windows Authentication   Global Support Lab Testing SX Application Server (Windows10 1803) SQL Server – Server 2012 R2 with SQL 2016 SP1 (VM) SX Client – Window 8.1 Pro

Issue PCT utilizes a large volume of hard drive space when the backup limit is not set. Product Line EcoStruxure Building Operation Environment Building Operation Project Configuration Tool (PCT) 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 for assistance. Cause The virtual machine reserves additional hard drive volume each time a backup is created. Once this space has been allocated to the VM’s hard drive, it can not be reversed without deleting, recreating the project server then restoring the station from a backup.  (Once a VM grows, it cannot shrink.) Resolution The number of backups should be limited to a maximum of two (2).

Issue The added to parent column shows incorrect information. PCT 1.X  PCT 2.x Product Line EcoStruxure Building Operation Environment Building Operation Project Configuration Tool (PCT) 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 for assistance. Cause PCT doesn't detect detachment in WorkStation. Resolution Do not detach the child server from its parent in PCT 1.x and 2.x. Webhelp information: Adding a Virtual EcoStruxure BMS Child Server to a Parent Server.

Issue PCT client can't start properly with "Hardware virtualization is not enabled" error. Product Line EcoStruxure Building Operation Environment Building Operation Project Configuration Tool (PCT) (All Versions) 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 for assistance. Cause Hardware Virtualization is Disabled or not available for PCT Resolution  Install "Intel® Processor Identification Utility" then verify the status of "Intel® Virtualization Technology" from the Utility. Using the table below, you can see if your processor supports Intel® Virtualization(provided by Intel).  The above information can also be found on Intel® Virtualization Technology web page If Virtualization is disabled in BIOS then enable it from BIOS else identify other software utilizing the Virtualization and stop the application.  Use Win key or press the Windows Start button Type: cmd Select Run as Administrator  Verify command prompt window title bar is Administrator: Command Prompt Type: shutdown /r /fw/ /f  Press enter and the computer will shut down immediately forcing all applications to close (/f) and restart (/r) into firmware interface (/fw)   If the issue persists, the following article may provide the answer Knowledge Base article - PCT error Hardware-virtualization is not enabled-Please-enable.

Issue How to connect to the Jace 8000 system shell Product Line TAC IA Series Environment I/A Series Jace 8000 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 for assistance. Cause Multiple diagnostic and low-level configuration processes need to be performed directly connected to the Jace 8000 in the system shell of the device. Resolution Connect the USB cable between the controller’s Debug port and the USB port you are using on your PC   On your PC, start your terminal emulation software. For example to start PuTTY from the Windows Start menu, this is typically Programs > PuTTY → PuTTY. PuTTy can be downloaded at no cost if you do not already have it on your PC. In the tree in the PuTTY Configuration dialog, expand Connection and click Serial. Set the “Serial line to connect to” for your PC’s (USB) COM port to use. For example, COM3. NOTE: You can examine Ports in Windows Device Manager to determine which serial port is in use on the PC. If you don't see the Jace in the COM ports, you will need to install the driver which can be Downloaded from FTDI.  It is also attached to this document below for Win10. Set the “Configure the serial line” fields as follows: • Speed (baud): 115200 • Data bits: 8 • Stop bits: 1 • Parity: None • Flow control: None In the tree in the PuTTY Configuration dialog, click Session and then click/select the “Connection type” as Serial NOTE: (Optional) You can save this configuration to reuse (load) in future PuTTY to JACE serial sessions. To do this, type in a connection name in the “Saved Sessions” field (for example, “JACE- 8000-S”), and click Save. When you start PuTTY again to serially connect to the JACE, select this name and click Load. At the bottom of the PuTTY Configuration dialog, click Enter. At the login prompt, enter a platform user name, and at the password prompt, the platform password. a. If prompted for system passphrase, enter the platform’s system passphrase. If login is successful, the TITAN System Shell menu appears. When finished making platform changes from the system shell, do the following: • If no changes or reboot is not necessary, simply type L to Logout. • If changes require rebooting, select the Reboot option. Type “y” at the “Are you sure you want to reboot [y/n]” prompt, and press Enter. Shutdown-related text appears in the terminal (PuTTY) window. Click the Close control (upper right corner) in the terminal session (PuTTY) window. Click OK in the “PuTTY Exit Confirmation” popup dialog. Unplug the USB connector from the JACE’s Debug port. This procedure is simply how to connect using USB serial port for system shell.  More information about functions available once connected can be found in other Knowledge Base articles and in the Jace 8000 Install and Startup Guide

Issue Sometimes as an administrator, you may need to kill a service which is stuck at starting or stopping in order to avoid having to reboot a server in the middle of the day. Or even after the reboot, the service will not start. Product Line EcoStruxure Building Operation Environment Building Operation Enterprise Server Building Operation Enterprise Central Building Operation Licensing Server Security Expert Windows Services Access Expert Windows Services (on-premise only) 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 for assistance. Cause Sometimes the service times out and gets stuck in a loop due to fallback protocols within the service Resolution Find out the name of the service To do this, go into services and double click on the service which has stuck.   Make a note of the “Service Name”. Find out the PID of the service Open an elevated command prompt and type in: "sc queryex servicename" (where servicename is the name of the service you obtained from Step 1). Make note of the PID Kill the PID From the same command prompt type in: "taskkill /f /pid [PID]" (Where [PID] is the service number).   If it is successful you should receive the following message: "SUCCESS: The process with PID XXXX has been terminated."     Be careful of what you are killing though. If you kill a critical windows service you may end up forcing the machine to reboot on it own.   If the service returns back into this state you may need to increase the time allotment for the service to start.   Global (entire system): Open Windows Registry: Start -> Run -> regedit.exe File --> Export --> make a backup of the current registry Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ Right click on the right page ---> New ---> DWORD call the new DWORD "AutoStartDelay" Set AutoStartDelay in milliseconds (decimal). E.G. 240000 is 240 seconds. Per-service: Open Windows Registry: Start -> Run -> regedit.exe File --> Export --> make a backup of the current registry Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\<servicename> To increase the default delay of 120 seconds, right click the registry key and add new key AutoStartDelay (DWORD (32-bit)) Set AutoStartDelay in milliseconds (decimal). E.G. 240000 is 240 seconds.

Issue Slow reading/writing of log values and events might be caused by a fragmented index in the SQL database. Product Line TAC Vista Environment Vista Server SQL log/event data SQL Server 2005, 2008 Microsoft SQL Server Management Studio Express 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. Cause If the SQL database has become fragmented in its index, these scripts can be run in SQL query software (e.g. Microsoft SQL Server Management Studio Express). Downloaded this software for free at: http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en Resolution Warning: Always take backups of the system prior to performing maintenance on the database. Run the following SQL query: SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'taclogdata'), OBJECT_ID(N'TrendLogValue'), NULL, NULL , 'DETAILED') WHERE index_level = 0 order by index_id Look at "avg_fragmentation_in_percent" Or DBCC SHOWCONTIG Look at Logical scan fragmentation If the database is fragmented, e.g more than 50% run this script to defrag the index: USE TACLOGDATA DBCC INDEXDEFRAG('taclogdata','TrendLogValue') Or USE TACLOGDATA DBCC DBREINDEX('TrendLogValue')