IBM Support

JR56991: WHEN YOU USE THE SCHEMAGENERATOR, YOU SEE AN ERROR LIKE "ORA-00972 IDENTIFIER IS TOO LONG ALIAS COLUMN NAME"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • While enabling search optimization with business data variable
    aliases that contain non-ASCII characters, you see an error like
    "ORA-00972 identifier is too long alias column name".
    

Local fix

Problem summary

  • When you use UTF8 characters in the alias name for business data
    variables, which need more than 1 byte, and use the
    SchemaGenerator, you might see an error like "ORA-00972
    identifier is too long alias column name" if the bytes needed to
    represent the alias name as the column name in a table are too
    many.
    

Problem conclusion

  • A fix is available for IBM BPM V8.5.7 cumulative fix 2016.06 on
    request.
    
    A fix will be included in IBM BPM V8.5.7 cumulative fix
    2016.12 that generates non-UTF8 column names for business
    data variable aliases that contain non-ASCII characters.
    
    To determine whether the IBM BPM V8.5.7 cumulative fix 2016.12
    is available and download it if it is, complete the following
    steps on Fix Central:
    
    1. On the Select product tab, select WebSphere as the product
    group, IBM Business Process Manager with your edition from the
    WebSphere options, All as the installed version, and All as the
    platform, and then click Continue.
    2. In the Text field, enter "cumulative fix", and click
    Continue.
    
    PRODUCTS AFFECTED
    IBM Business Process Manager (BPM) Advanced
    IBM BPM Standard
    IBM BPM Express
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR56991

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    857

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-11-14

  • Closed date

    2016-12-07

  • Last modified date

    2016-12-07

  • 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

  • R857 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
07 December 2016