Closed as program error.
"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.
Rather than using EiE, the user can manually export and import tables to achieve the same effect.
This issue has been resolved and fix will be available on an as-needed basis.
A new version of the EiE client is available upon request (version 220.127.116.11).
Reported component name
ILOG INV & PFO
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
ILOG INV & PFO
Fixed component ID
Applicable component levels