Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the 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
Everything you need to know about our IoT technology backbone.Learn more
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