2 Replies Latest reply on Jan 15, 2014 4:55 PM by Gregor

    PIACE Executables on Windows server2008 R2 calling excel with third-part add-ins

    e-matica

      Hi, 

       

      we are running ACE scheduler 1.x on windows2008R2 server.

       

      There is one ACE executable (VB6) that perform some calculation calling excel, using custom funtion (third-part add-in) and then return and write to PI TAG.

       

      All is OK during debugging (ACE wizard) , but, when running in background with ace scheduler, the ACE MODULE write to PI tag "2029", that is the excel error for "function not found".

       

      The excel add-in is loaded/unloaded correctly from code.

       

      The add-in works correctly when using excel.

       

       

       

      Any suggestions?

       

      Thanks

        • Re: PIACE Executables on Windows server2008 R2 calling excel with third-part add-ins
          xwang

          Hi Ernesto,

           

          I am not sure if my idea could solve this problem, but it could be try.  When you use third-part add-in in the excel, I do not think the calculation result in the excel form will be the standard data type, like string, double, int or some others.  Is that possible to try to convert your results into the standard data type before PI ACE calls them?

           

          Xi Wang

           

          vCampus team

            • Re: PIACE Executables on Windows server2008 R2 calling excel with third-part add-ins

              Hello Ernesto,

               

              Based on the error that you get, I believe that loading the Excel add-in properly is indeed the issue.

               

              One reason that I can think of is that the add-in cannot be found. Have you tried placing into the folder where the ACE 1.x executable calling it is located?

               

              The second reason that I can think of is inappropriate access permissions and to me this appears to be more likely. When debugging through PI ACE Wizard, this happens in the context of the user, you are logged on with; when running the ACE Module through PI ACE Scheduler 1.x the user context is the one set up with the PI ACE Scheduler service. If you are on a development platform, you can try setting up PI ACE Scheduler service to run under the credentials of your log-on user account to verify my theory.

               

              Is the Excel add-in you are using publicly available? What functionality do you use from the Excel add-in? Maybe similar can be done with PI ACE directly.