RS01160: EDIT IN EXCEL FAILS WITH TABLES WITH TIME PERIOD HELPER TABLE IN ASIAN LANGUAGES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When performing Edit in Excel (EIE) some tables export extra
    "helper" worksheets to assist with filling in the data.  For
    tables of this kind that export the Time Period helper table,
    the following exception occurs when the user attempts to use
    EIE: "System.Data.SqlClient.SqlException: Expression type int is
    invalid for COLLATE clause."
    
    This was originally reported for Japanese, but is present in
    other supported Asian languages as well (Korean, T-Chinese,
    S-Chinese).
    
    Affected Tables:
     * Demand
     * Forced Opening: Line
     * Forced Opening: Plants
     * Forced Opening: Warehouse
     * Group Constraints
     * Pre-defined Inventory Customer
     * Pre-defined Inventory Warehouse
     * Pre-defined Lanes
     * Pre-defined Production
     * Pre-defined Recipes
     * Production Line Series
     * Recipe Time Period Eligibility
     * Warehouse Product Constraints
     * Pipeline Flow Warehouse Min Inventory
    
    To Reproduce:
     * Navigate to the Application Options form (Application Button
    > Options) and select an Asian language in the User Interface
    Language drop-down
     * Open an existing scenario or a create a new one
     * Open one of the affected tables from above
     * Do whatever is necessary to show records in the table
     * Click on the EIE button
    

Local fix

  • Use Multi-scenario Edit in Excel (thus avoiding the creation of
    the Time Period helper table).  Alternately, export the table
    data to Excel and then import it manually.
    

Problem summary

  • This issue has been resolved and the fix will be available in
    IBM ILOG LogicNet Plus XE 7.2.24.30.
    

Problem conclusion

  • The fix is now available on FixCentral.
    

Temporary fix

Comments

APAR Information

  • APAR number

    RS01160

  • Reported component name

    ILOG LOGICNET P

  • Reported component ID

    5724Y2500

  • Reported release

    720

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-29

  • Closed date

    2013-04-04

  • Last modified date

    2013-04-04

  • 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 LOGICNET P

  • Fixed component ID

    5724Y2500

Applicable component levels

  • R720 PSY

       UP

  • R600 PSN

       UP

  • R700 PSN

       UP

  • R710 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM ILOG LogicNet

Software version:

720

Reference #:

RS01160

Modified date:

2013-04-04

Translate my page

Machine Translation

Content navigation