Automatic Server Tasks - Failed or Terminated

[Former Member]

Hello everybody!

Merry Cristmas and happy new year!

I have ePO 4.6 running on 2003 R2, starting 29.12.2012 the disk C is full and in the Server Task Log all tasks is "Failed" of "Terminated", also in the Dashboard i can't see "Available" products.

PLEASE HELP!!!

The server was restarted several times...

[Former Member · Accepted solution]

Before start to troubleshoot need to resolve disk full issue.

1. Check Total disk space which folder take most used of disk.

2. Which SQL version you are using. If you use express edition of SQL thencheck database size if it rich the size limit of 4 GB. Then it might increasesize or Error logs.

After this all activity done reboot the systems and ones Test connect withdatabase in core config and check the issue

Hope it will help you.

[Former Member]

Thank You!

I use SQL Express 2005

The database has 4 GB, now on C:\ I have ~9 GB free space. How to clean or comprime the database?

[Former Member]

Before start any activity take backup of SQL database

Dont purge all events. Puge events date vise and monitor the log file size.

This activity take time but you can successfuly geted out into this.

[Hem]

Once you stop the ePO application service and start. Is the task not getting terminated?

If it's not then please create the space in the machine as other reader's suggested and run the query.

"select * from OrionSchedulertaskLog where Status=3"

The status value 3 will show all the tasks which are in waiting and we can delete them from DB by running query

"delete  from OrionSchedulertaskLog where Status=3"

[Former Member]

Solved!!!

Just upgraded my SQL Server Express 2005 to SQL Server Express 2008 R2! Because in 2005 limitation of database is 4 GB and in 2008 R2 is 10 GB.

Thank you!