IBM Support

JR56739: INFORMATION ANALYZER COLUMN ANALYSIS REPORTS ERROR ANALYZING TEXT COLUMN IF ANY RECORDS HAVE MORE THAN 255 CHARACTERS.

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

  • Information Analyzer column analysis reports error analyzing
    text column if any records have more than 255 characters.
                                                                   .
    The actual errors shown in WebSphere log are:
      PersistenceUt E valueLength=404 for attribute=GeneralFormat
      exceeds annotatedLength=255
                                                                   .
      [9/15/16 14:32:39:809 EDT] 000000f3 RepositoryMet E Error
      executing saveAndDelete_25: A data length constraint was
      violated on attribute "GeneralFormat". The maximum allowed
      length is 255, but the length of the value is 404.
                                                                   .
    The expected behavior is that text field limit is 512 bytes
    rather than 255, and additionally when a string exceeds that
    size we truncate to that size and analyze the available 512
    characters (rather than generating an error).
    

Local fix

Problem summary

  • CA for Varchar col > 255 which contains text value on some
    records which is also > 255 causes errors.
    

Problem conclusion

  • Issue is fixed with APAR JR56739 and is delivered with
    Governance Rollup5
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR56739

  • Reported component name

    WIS INFORM ANAL

  • Reported component ID

    5724Q36IA

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-28

  • Closed date

    2016-11-20

  • Last modified date

    2016-11-20

  • 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

    WIS INFORM ANAL

  • Fixed component ID

    5724Q36IA

Applicable component levels

  • R912 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"}, "Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B50","Edition":""}]

Document Information

Modified date:
20 November 2016