The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as Facility Hero) app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
ION Enterprise Database Manager allows a user to Trim data from the ION_Data database on an ad-hoc basis. If Trim... is chosen from the pop-up menu, it is possible to define a date range and select one or all of the three types of logged data - Interval, Waveform and Event. However, If ION Enterprise 6.0 SP1 is installed with SQL Server 2008, this operation will fail with an error indicating that TRUNCATE_ONLY is not supporter:
The following error occurred:
Error trimming database while truncating the transaction log
'TRUNCATE_ONLY' is not a recognized BACKUP option.
Database Manager uses PMLMSDEManager.dll to execute the TrimRecords stored procedure. This file needs to be updated so that it no longer uses the TRUNCATE_ONLY command. Versions of RS2008ConfigurationWizard.exe produced prior to December 23, 2010 will not update this file, however the most recent version of the tool will. RESL 203767 has been updated to include the most recent version of RS2008ConfigurationWizard.exe.
There is a workaround. It is possible to run the stored procedure directly in SQL Server Management Studio as shown below: The two dates are a start and end date, and the bit flags are Data/Waveform/Event respectively. In the example below, Waveform and Event data from January 1 to January 2 2010 would be deleted.
Last Revised: December 23, 2010
All content © 1992-2011 Schneider Electric
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!