RS01169: IPFA EIE FAILS TO IMPORT WHEN WINDOWS 7 IS CLIENT OS

APAR status

• Closed as program error.

Error description

• "Edit in Excel" (EiE) in IPFA works through an ActiveX component
  that is installed on the client machine. If the client operating
  system is Windows 7, EiE can fail to import when UAC is turned
  on.
  
  The table will successfully export to Excel and the user can
  make changes. However, when the user tries to import their saved
  changes, the import will fail with an empty "Import Failed"
  message.
  
  Steps to Reproduce:
  
  1. Use a Windows 7 machine for the client
  2. Setup IPFA to run on your local IntrAnet zone.
  3. Uncheck "Enable Protected Mode" in IE. This is located under
  Internet Options>Security>Local IntrAnet from your IE menu.
  Restart IE from launching IPFA.
  4. Turn UAC (User Access Control) on.
  5. Open up IPFA and go to a table that is editable (e.g. Product
  Details in an IA scenario)
  6. Click on the Excel icon on the left toolbar.
  7. Excel should be launched with the records from the table.
  8. Edit some values and save. Close Excel.
  9. Click on "Import" and see that the import fails with no
  message
  
  Notes:
  
  When using IE 8, the user can receive an "Error (29)" error when
  "Enable Protected Mode" is checked. Excel will open but there
  will be no worksheet and the error will be a popup message. To
  fix this, Uncheck "Enable Protected Mode" in IE for Local
  Intranet Security Zone.
  
  The Import error is caused by a difference in Integrity Levels
  between IPFA running as a local intranet zone with Medium
  Integrity Level and the EiE client using an internet explorer
  object with a Low Integrity Level. To fix this, both process
  have to run with Medium Integrity Levels.
  
  When using IE 9, the same issue exists, but it results in a
  slightly different error than described above. First, the error
  is a dialog box that pops up with the text: "Error caught in
  FileUpload: Class does not support Automation or does not
  support expected interface." Second, the error occurs on the
  file upload portion of the EiE process. Downloading the
  spreadsheet proceeds as expected, changes can be made and saved
  with no problems. Then, after the Import button is clicked, the
  error is encountered. The workaround is the same as above for IE
  8.
  

Local fix

• Rather than using EiE, the user can manually export and import
  tables to achieve the same effect.
  

Problem summary

• This issue has been resolved and fix will be available on an
  as-needed basis.
  

Problem conclusion

• A new version of the EiE client is available upon request
  (version 4.0.0.2).
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  ILOG INV & PFO

• Fixed component ID

  5725A0400

Applicable component levels

• R750 PSY

     UP

• R760 PSY

     UP