Management Console Scheduled Reports

Thread needs solution
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Beginner
Posts: 1
Comments: 1

Hello I am looking at trying to schedule reports from the Acronis Management console to be sent to an email address using the following Acronis article and script provided: https://kb.acronis.com/content/39205

Unfortunately when the task runs it never completes and remains in a 'running' state. We use Acronis Backup & Recovery 11 and I can see that the article is for 11.5

Can anyone confirm if this can/should work for version 11 too please?

Mon, 05/12/2014 - 10:22
0 Users found this helpful
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Forum Star
Posts: 0
Comments: 1379

There is no ActivityInitiator column in version 11 Update 0, but it appeared in Update 0.5 . If you are on Update 0, you can just remove this column from the query.
If you can get past "Set rs = amsCnn.Execute(query)" line, then your problem is not with Backup & Recovery version - maybe if fails on sending e-mail.

Mon, 05/12/2014 - 13:28
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Beginner
Posts: 1
Comments: 1

Thank you for your help Fedor. We are on version Acronis Backup & Recovery Management Server (build 11.0.17440 ) - not sure how to check the update version.

I tried removing the ActivityInitiator column from the select function on line 65 and also the entry on line 95 if that is correct? However I still get the same issue where the task just stays running.

When manually running the script I receive the following error:

Script: C:\.........email_daily_activities_report.vbs
Line: 74
Char: 3
Error: Invalid column name 'TaskName'.
Code: 80040E14
Source: Microsoft OLE DB Provider for SQL Server

I'm not sure what to check/look for with regards to this error so any advice would be greatly appreciated.

Kind regards.

Tue, 05/13/2014 - 08:16
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Forum Star
Posts: 0
Comments: 1379

No data for 'TaskName' is requested (or mentioned at all) in the original script. If MS SQL Server somehow requests it while processing the original request, I don't know how to fix it.

Fri, 05/16/2014 - 07:30