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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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 number

    RS01169

  • Reported component name

    ILOG INV & PFO

  • Reported component ID

    5725A0400

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-06

  • Closed date

    2013-01-23

  • Last modified date

    2013-01-23

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM ILOG Inventory and Product Flow Analyst

Software version:

7.5

Reference #:

RS01169

Modified date:

2013-01-23

Translate my page

Machine Translation

Content navigation