ION_Data Maintenance Job Fails | Schneider Electric Vietnam

Search FAQs

You are currently viewing the content available in Vietnam. If you are looking for information for another region, please select the correct country from the top-left dropdown in the page and 'Navigate to Browse FAQs' in the Support menu.

ION_Data Maintenance Job Fails

Issue
An error like the one below appears in the System Log Events for ION_Data database:

System Log Error: 1/14/2020 2:01:48 AM - Source: Database Maintenance Task, Description: An error occurred during the execution of the Maintenance task for ION_Data: Microsoft.SqlServer.Management.PowerShell.SqlPowerShellSqlExecutionException: Insufficient space is available on D: drive to execute the requested task. The system database tempdb must be able to grow to 83654.45 MB to complete the requested task.

Product Line
ION Enterprise
Struxureware Power Monitoring
Power Monitoring Expert

Environment
Windows Task Scheduler

Cause
The scheduled maintenance job for the ION_Data database fails due to insufficient space on the drive that the tempdb is on.

Resolution
Free up space on the drive with the tempdb to allow it to grow to the size of the ION_Data database.

Alternatively, move tempdb to a location where there is sufficient space. See FA219030 for instructions on how to do this.