RS01229: DATASTORE MAINTENANCE RULES FAIL TO RUN WHEN A TABLE THAT CONTAINS SPACES IS INCLUDED IN THE CONDITION CLAUSE

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

  • DataStore Maintenance Rules are created by the user.  The user
    can create the rule using any available "Destination" Table.
    The Destination table's columns can then be used to create
    conditions on the rule when it is run.  If the Destination
    Table's name has spaces in it and a condition is created using
    that table's columns, the Rule will fail to run successfully.
    
    Steps to Reproduce
    
    1. Import a Custom Table and give it a name that contains spaces
    2. Go to the Data Maintenance Rules Column Properties form
    3. Add the custom table name to the Destination_Table Dropdown
    Items list and save.
    4. Go to the Data Maintenance Rules Form.
    5. Add a new rule and choose the custom table from the
    Destination Table dropdown. Complete the rule and save. Make
    sure the rule is enabled.
    6. Click on 'Create/edit Conditions'.
    7. Select a column and action from the dropdowns on the popup
    and then click 'Add Condition'.
    8. Click 'Save Conditions' and exit the popup.
    9. From the Data Menu, Select Table Data Synchronization
    10. Deselect all the Synchronization Tasks
    11. Select 'Run Data Maintenance Rules'
    12. Click on "Next>"
    13. See the Rule fail.
    

Local fix

  • The Destination table should be renamed to not contain spaces.
    
    1. Go to the Advanced Table Management page
    2. Select the table name from the list and click on 'Configure'
    3. Change the Table Name from "Table Name" to "Table_Name" (for
    example).
    4. Delete the existing Data Maintenance Rule
    5. Update the Destination Table Dropdown Item list with the
    correct Custom table name.
    6. Recreate the rule using the new Table Name that does not
    contain spaces.
    

Problem summary

  • This issue has been resolved and the fix will be available in
    IBM ILOG Inventory and Product Flow Analyst 7.6.15.4.
    

Problem conclusion

  • The fix is now available on FixCentral.
    

Temporary fix

Comments

APAR Information

  • APAR number

    RS01229

  • Reported component name

    ILOG INV & PFO

  • Reported component ID

    5725A0400

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-25

  • Closed date

    2013-02-08

  • Last modified date

    2013-02-08

  • 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

  • R760 PSY

       UP

  • R750 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM ILOG Inventory and Product Flow Analyst

Software version:

760

Reference #:

RS01229

Modified date:

2013-02-08

Translate my page

Machine Translation

Content navigation