If your Database Query step is failing with this error, the SQL server is blocking the task due to a locked table.
This error means the SQL server prevented the task from running because a table was locked. Try running the task manually to check whether the lock has cleared. If this happens frequently, reschedule the task to a time when the SQL server is less busy.