IBM Support

JR47466: SAVED SEARCH ACCELERATION TOOL "DATALOAD" FAILS WITH AN SQL ERROR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The saved search acceleration tool "DataLoad" fails, if
    variables of a user defined type are marked as
    searchable business data and process instance with values in
    this kind of variables exist.
    

Local fix

  • n/a
    

Problem summary

  • The saved search acceleration tool "DataLoad" fails, if
    variables of a user defined type are marked as searchable
    business data and process instance with values in this kind of
    variables exist.
    
    PROBLEM DETAILED DESCRIPTION:
    When a process application definition contains user defined
    variable type and the application uses variables of this type,
    which are also marked as searchable business data, then
    generates the "SchemaGenerator" tool an invalid database
    script. The script can be performed without problems, but the
    "DataLoad" tool fails with an SQL error.
    

Problem conclusion

  • The tools SchemaGenarator and DataLoad now handles user defined
    types like Strings and creates valid SQL scripts.
    
    FIX AVAILABILITY:
    iFix for 8.0.0.0 is available on Fix Central, search for APAR
    JR47466 at http://www.ibm.com/support/fixcentral/
    Fix is also targetted for inclusion in next fixpack for BPM
     8.0.1, BPM 8.5.0
    
    When obtaining any of the above fixes, be sure to download the
    accompanying readme, for itself, and any prerequisite fixes, and
    review them thorougly.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR47466

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-09

  • Closed date

    2013-11-21

  • Last modified date

    2013-11-21

  • 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

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R800 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
07 January 2022