From the PI DataLink point of view, Excel 2010 (32-bit) is compatible with PI DataLink 2010 (you can find this information in the release notes for PI DataLink).
From the operating system point of view, Excel 2010 is compatible with Windows Server 2012 (see Microsoft documentation at System requirements for Office 2010).
Is your issue reproducible? If not, the information provided is not enough to tell us why Excel has crashed, or if PI DataLink or PI ACE is responsible for the crash. If the issue is reproducible, please let us know under what operations/circumstances do the crash occur. Any additional information will be helpful in troubleshooting the issue.
yes the isuue is reproducible.
I was working on Upgrading the PI ACE Server from older version the new Version Windows 2012. I need to make the new server just as a replica to the Old PI ACE Server as part of this we are having some excel sheets (Static Reports) which will be running using a batch job and sending those batch jobs to the end users via email.
When we run the batch job below is the batch job command
Set Excel_exe="E:\APPS\Microsoft Office\Office\Office14\EXCEL.EXE"
%Excel_exe% %excel_xls% -run
it will 1st call the excel sheet then it will call the static reports, when the static reports is opened it is failing to open the excel sheet and i can see the below message in the eventvwr .
Faulting application name: EXCEL.EXE, version: 14.0.4756.1000, time stamp: 0x4b9c08e8
Faulting module name: KERNELBASE.dll, version: 6.3.9600.17055, time stamp: 0x532943a3
Exception code: 0xc0000005
Fault offset: 0x0000e756
Faulting process id: 0x288
Faulting application start time: 0x01d0b86bde16539b
Faulting application path: E:\APPS\Microsoft Office\Office\Office14\EXCEL.EXE
Faulting module path: C:\Windows\SYSTEM32\KERNELBASE.dll
Report Id: 22567d0b-245f-11e5-80e0-005056b20ed0
Faulting package full name:
Faulting package-relative application ID:
I hope this explanation will be clear to you for understanding on the issue.
Note : their were macros in the excel sheet too.
As an add on i had opened a case with tech support on this too,
please find the case number : 640571
Thank you for the additional information. It looks like you were able to open the Excel application, but failed to open the associated spreadsheet. Without using the batch script, can you open that spreadsheet manually? If you could not, I would recommend looking into the spreadsheet to see what could have caused the crash.
I failed to see how the issue could be related to PI ACE (correct me if I'm wrong). If you suspect the issue could be related to PI DataLink, try disabling it to see if Excel still crashes. If the behavior is the same, this is likely an issue with Excel instead of any PI components. If disabling PI DataLink prevented Excel from crashing, let us know. I would also encourage you to upgrade to the latest PI DataLink version (or at least to the 2010 SP1 version).
I'm inclined to agree with Daphne's analysis, but I notice that you're using drive E: in your application. Is this a network drive mapping? Does excel allow you to run applications off a network drive? Try running excel and loading the spreadsheet manually to see if you're getting security issues relating to a network.
Hello Every One,
I had resolved the issue.
The issue is not related to PI ACE Server, in PI ACE Server i had hosted this spread sheets.
Its not related to PI Data Link version too, i can open empty excel sheet and i can pull the data using pi Data Link from the respective servers.
Yes, I am using E: Drive because as per our standards we need to host all the Applications other than C: Drive. In C:Drive we need to have only OS related.
Finally, the issue is related to the Macros and VB Scripting which had written in the spread sheets. The Kernel32 is declared as String Variable previously when this code had written years back, but when i am trying to use the same code in Windows 2012 servers the KERNEL32 was not accepting String as a variable , so i had changed the String Variable declaration to Long then the KERNEL32 is ablet to call the Modules what it has been delcared in that Function.
Thanks to all for helping me to resolve the issue.