Forum

Question

900 views07 - 07 - 2017Technical Supportbackup database sql-server

0

ram 67 Posted 01 - 07 - 2017 ram unselected answer 07 - 07 - 2017

ClosedQuestion is closed for new answers

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

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 67 Posted 04 - 07 - 2017

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

score 0 · 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.

Forum

8 Answers

Search questions

Question stats

Other Questions