Question
Datacom group
NZ
Last activity: 16 Oct 2018 12:03 EDT
Microsoft connectors and script components are not working in VisualStudio 2015
I was developing some robotics automations on Robotics studio and decided use VisualStudio 2015 Professional with Update 3 + Pega plug-in to connect with TFS. But after coping the solution to VS 2015, the Excel connector throws as exception and there is another popup when running the automation.I have included the errors bellow. Anyone trouble shoot these errors before?Seems like the script component and the excel connector is not recognized in VS 2015.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Datacom group
NZ
I recently solved the issue.I copied the related dlls(eg:Openspan.script.dll) from openspan to Visualstudio and its working fine.
But not sure whether it will lead to new errors when Pega updates the dlls.
Pegasystems Inc.
US
Excel must be open to call GetCellValue() successfully. That is why you are seeing the 'Object reference not set to an instance' exception.
I am not familiar with the second error. Do you know what the error is referring to? a component maybe?
Datacom group
NZ
The error is thrown when I am trying to start the Excel.I tried to create a new project and tried including Excel and the script components there as same as I used them in Openspan. They worked fine.Even the automations worked fine in Openspan but after coping the solution to VS2015 only, it was throwing those errors.I think the internal wiring-up is different.Can you give me the steps to copy a solution from Openspan to VS correctly?
Accepted Solution
Datacom group
NZ
I recently solved the issue.I copied the related dlls(eg:Openspan.script.dll) from openspan to Visualstudio and its working fine.
But not sure whether it will lead to new errors when Pega updates the dlls.