Backup database problem

Question

6.71K views07 - 07 - 2017Technical Support

0

ram 311 01 - 07 - 2017 0 Comments

Using Maintenance Tools > Backup, the backups are working fine.

Using Scheduled Task > Backup database, the backups are not working fine.

The status is “Running” until complete the “Max Execution Time”. The message error is “Thread was being aborted” in “Audit Log”

Any suggestion?

System:
Windows Server 2012
SQL Server 2012
SolidCP 1.2.1

Question is closed for new answers.

ram unselected answer 07 - 07 - 2017

8 Answers

score 0 · Answer 1 · 2017-07-01T21:50:33+00:00

Hello,

Can you check the scheduler service is started on your enterprise server with the correct db info & crypto key.

Kind Regards,

Trevor Robinson

score 0 · Answer 2 · 2017-07-01T23:07:19+00:00

Yes! I have configured correctly. I can run Scheduled Task as “Send Email Notification” or “Check Web Site Availability” without issues.

Any suggestion?

score 0 · Answer 3 · 2017-07-03T22:27:44+00:00

I get this execution log message:

Thread was being aborted.

at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
at System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean exitContext)
at System.Net.LazyAsyncResult.WaitForCompletion(Boolean snap)
at System.Net.Connection.SubmitRequest(HttpWebRequest request, Boolean forcedsubmit)
at System.Net.ServicePoint.SubmitRequest(HttpWebRequest request, String connName)
at System.Net.HttpWebRequest.SubmitRequest(ServicePoint servicePoint)
at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.Providers.Database.DatabaseServer.BackupDatabase(String databaseName, String backupName, Boolean zipBackup)
at SolidCP.EnterpriseServer.DatabaseServerController.BackupSqlDatabase(Int32 itemId, String backupName, Boolean zipBackup, Boolean download, String folderName)

score 0 · Answer 4 · 2017-07-04T23:51:31+00:00

0

ram 311 Posted 04 - 07 - 2017 0 Comments

Any idea?

score 0 · Answer 5 · 2017-07-05T03:57:52+00:00

Hello,

I have just tried this on our live server and it appears to be working fine.

Can you tell me if the database is quite large?

Kind Regards,

Trevor Robinson

score 0 · Answer 6 · 2017-07-05T04:07:03+00:00

No, Trevor. The databases are litle as 30mb, 50mb, 200mb, etc

Manually I can do it the backup using Maintenance Tools > Backup but using Scheduled Task > Backup database, not works.

This very strange because permissions and connection with the sql server is fine.

In your live server, do you have installed the last version with the build 6/28/2017?

score 0 · Answer 7 · 2017-07-05T04:21:58+00:00

Hello,

I have tried it on the first release of 1.2.1 (5/27/2017) and also the latest version of the source code which runs on our development environment.

You could try increase the logging on the database servers SolidCP Server web.config to see if it is able to give you more details?

Kind Regards,

Trevor Robinson

ram · Answer 8 · 2017-07-07T20:43:56+00:00

Thanks for your help!

The problem was in the server configuration. The backups using scheduled tasks are working fine now.

Backup database problem

8 Answers

Search questions

Question stats

Other Questions