I am trying to execute a macro through VC. I am getting an error message like “Unhandled exception in Task: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)”.

Whereas other macro execution tasks are running without any flaw in the same server . In addition the macro which I am referring in that particular task is running fine if we execute it manually i.e. through excel.

I have followed the below mentioned steps to resolve the this, but still the issue persist.

1. Create directory "C:\Windows\SysWOW64\config\systemprofile\Desktop " (for 64 bit Windows) or "C:\Windows\System32\config\systemprofile\Desktop" (for 32 bit Windows)
2. Set Full control permissions for directory Desktop (for user "SYSTEM")

Please advice me to resolve this.

Thanks in advance,
Krishna

Welcome to the forums, krishnat!

I think in order to help you diagnose the problem we're going to need some more information regarding what sort of macro, version of Excel, etc..

Describe your environment as closely as possible so some of the more advanced users and/or Support can try and give you some help.

Brian

Hi Brain,

The data resides at SQL server 2008, I have created .ODC file to link both excel and SQL server. Using .ODC file connection I will pull in the DB table data to excel pivot table. To get this data normally we will refresh manually, to automate this I have created a macro which will refresh the data connections which will help me to get the latest data.

Here the problem arise when I am trying to run this macro thorugh VC task I am getting the above mentioned error.

The strange thing is I have created more than 150 reports and macros, I have tagged them to VC task as well( in the same server). Everything is working fine except a particular task(I have tried recreating with extreme care - nothing seems to be wrong at creation part).

Version details:

Visual Cron - 4.9.40
MS Excel - 2010

Let me know if you need further details.

Thanks,
Krishna

I know you mentioned the number of macros, etc.. from the same server. I assume you mean the VC server. Is this the first one that connects to this particular SQL server via ODC connection info? I will admit i'm not a SQL person and likely won't be able to help personally, but the error "The RPC server is unavailable" in my world is usually due to a Firewall blocking access from the VC server to, in this case, the SQL Server. Or, DNS isn't resolving the SQL server properly from the VC server (see if you ping it, that it resolves), OR, and I doubt this if you've tried several times, it could be a typo in the ODC for the SQL server name.

I'm leaning towards DNS/name resolution or Firewall (hardware or Windows Firewall).

Brian

Yes, it is something with DNS resolution if other Tasks works again same server. Try specifying the ip instead of dns name.

---

Hi Henrik,

If that is the case I should be getting errors for all the other tasks as well but I am not. All the other tasks are getting linked to the same database only the DB table differs.

Correct me if I am wrong.

Thanks,
Krishna

It could be something else with the macro that is related to remote connection of any way. That error means it cannot connect. If that is a firewall issue or if ip or dns name is wrong is unknown by just looking at the error.

---