Primavera P6 Professional R8.2 EXPORT excel xml problem

Hi all!

We are using Primavera Professional R8.2 for long time. But we have problem about export. When we try to export excel file it gives:

"An application event has been intercepted. Please note the event code for reference. Event code 1917-3"

When try to export as xml or project file it does not give error message. But the created file always becomes empty - 0 Kb size.

I need your support about this.

Oracle Primavera - PM6

Zoltan Palffy 👤 Member for 16 years 10 months

Thu, 2017-11-30 15:38 · Permalink

This issue has been resolved in the following Microsoft Windows updates:

Windows 7 / Windows 2008 R2:
- KB4048957 (Monthly Roll-up): https://support.microsoft.com/en-us/help/4048957/windows-7-update-kb4048957
  
  KB4048960 (Security-Only Update): https://support.microsoft.com/en-us/help/4048960/windows-7-update-kb4048960
Windows 2012:
- KB4048959 (Monthly Roll-up): https://support.microsoft.com/en-us/help/4048959/windows-server-2012-update-kb4048959
  
  KB4048962 (Security-Only update): https://support.microsoft.com/en-us/help/4048962/windows-server-2012-update-kb4048962
Windows 2012 R2 / Windows 8.1:
- KB4048958 (Monthly Roll-up): https://support.microsoft.com/en-us/help/4048958/windows-81-update-kb4048958
  
  KB4048961 (Security-Only Update): https://support.microsoft.com/en-us/help/4048961/windows-81-update-kb4048961
Windows 10:
- KB4048952: https://support.microsoft.com/en-us/help/4048952
- KB4048953: https://support.microsoft.com/en-us/help/4048953
- KB4048954: https://support.microsoft.com/en-us/help/4048954/windows-10-update-kb4048954
Windows 2016:
- KB4048953: https://support.microsoft.com/en-us/help/4048953

How to get this update:

This update will be downloaded and installed automatically from Windows Update.
If you want to apply a standalone package for this update, refer to the associated KB links above for your operating system and click the link which will redirect you to the Microsoft Update Catalog.

there are 3 other work arounds

Workaround 1:
- Upgrade to a release of P6 Professional which does not utilize MS JET engine for the XLS integration.
  - Using r15.2, the x64 distribution uses the Microsoft Access Database Engine (ACE) driver for excel integration, which is not affected by the security patches.
  - Using r16.1, the x64 distribution uses the Microsoft Access Database Engine (ACE) driver for excel integration, which is not affected by the security patches.
  - Using r16.2 and later release version, both x64 and x86 utilize Open XML for excel integration, which is not affected by the security patches.
Workaround 2:
- Keep MS Security Patches applied and complete the following steps:
  1. Find prior version (4.0.9801.0) of msexcl40.dll
    - Note: Can search windows for references to the .dll than right-click, select Properties and the Details tab to determine version of driver. If you do not have a copy of the older version, you can remove the security patches to obtain the version, then reapply the patches after completing below steps.
  2. Place in another directory.
    - Note: This can be placed in any directory, or the working directory of P6 Professional
  3. Open the registry editor (Start > run > regedit)
  4. Browse to: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel
  5. Double-click the 'Win32' string value and point to the location and name of the older msexcl40.dll copied to an alternate location in step b.
  6. Restart P6 Professional for the change to be picked up
Workaround 3:
- Remove the noted security patches:
  1. Browse to Control Panel > Programs and Features
  2. Click "View Installed Updates"
  3. Find and remove the noted security updates
    - Windows 7: KB4041681 & KB4041678
    - Windows 10: KB4041676

Bayram Yogurtcu 👤 Member for 8 years 6 months

Thu, 2017-11-30 07:13 · Permalink

Thank you Zoltan. Should I roll back the updates of Excel from the server or on the client computers?

Zoltan Palffy 👤 Member for 16 years 10 months

Thu, 2017-11-09 14:51 · Permalink

if this just recently happened it maybe due to an update to excel from microsoft roll back the update

Forum Sponsor

Menu

Primavera P6 Professional R8.2 EXPORT excel xml problem

Top Posters

Menu

Primavera P6 Professional R8.2 EXPORT excel xml problem

Forum Sponsor

Spider Project is most functional and powerful professional project management software.

Top Posters