I have one whole process flow in EG 7.1, scheduled to run every morning for a daily report.
This updates several datasets that are then stored in SAS Folders.
The SAS datasets are then opened using Add-In for Microsoft Office (AMO) in an Excel workbook that acts as a "template".
I have positioned all of the SAS datasets I need in the cells I want them to be in, and formatted everything.
After the process flow has finished running in EG, I have another vbs code scheduled that refreshes all the SAS datasets in the template file and saves a new file with the date today appended in the file name.
The error I am encountering is in the "Refresh". It tells me that I am unable to open the dataset. I have about ten datasets in the template and each of them gives me the same error. I know the issue is not in the vbs code because I tried to click on the refresh button manually and it gives the same error. It looks like the file has been corrupted because when I try to open a dataset in a fresh blank Excel workbook, it works with no issue. I need help because it is labor intensive to have to create a new template file again.
My AMO version is 7.15 HF3 (7.100.5.6140) (32-bit)
Here are the full details from the Exception tab in error window that popped up:
-------------------------- Technical Information Follows --------------------------
Exception Details:
----------------------------------------
Exception type: SAS.EG.SDS.SDSException
Message:
Source: mscorlib
Target Site: EndInvokeHelper
Stack Trace:
Server stack trace:
at SAS.EG.SDS.Model.Server.SASWorkspace(Boolean checkWorkspace)
at SAS.OfficeAddin.SasDataSource.Initialize()
at SAS.OfficeAddin.SasDataSource.OpenProc(Boolean readOnly)
at SAS.OfficeAddin.SasDataSource.OpenProc()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
at System.Threading.ThreadStart.EndInvoke(IAsyncResult result)
at SAS.OfficeAddin.SasDataSource.Open()
at SAS.OfficeAddin.DataViewItem.PrepareDataView(Boolean showDialog)
Inner Exception Details:
----------------------------------------
Exception type: SAS.EC.Directory.Model.SDSException
Message:
Source: EC.Directory
Target Site: Connect
Inner Exception Details:
----------------------------------------
Exception type: System.Runtime.InteropServices.COMException
Message:
Source: SASObjectManager
Target Site: CreateObjectByLogicalNameAndLogins
Stack Trace:
at SASObjectManager.ObjectFactoryMulti2Class.CreateObjectByLogicalNameAndLogins(String Name, Boolean synchronous, Object pIOMI, String LogicalName, LoginDef pOMRLoginDef, LoginDef pSASLoginDef, String nameValuePairs)
at SAS.EC.Directory.Model.Server.Connect(ConnectionInfo connInfo)
