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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B50","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
20 November 2016