APAR status
Closed as program error.
Error description
If the primary key of a previously imported table is changed, Re-importing the table produces an error message " The lower bound constraint was violated for feature uses_DataField on the KeyComponent object with identity ... and RID ..."
Local fix
Problem summary
After deleting the Primary Key while trying to re-import the table lowerbound constraint violation exception occurs on KeyComponent->uses_DataField. Error message in Websphere Application Server log looks similar to the following: com.ascential.xmeta.exception.data.ImportConstraintViolationExc eption: The lower bound constraint was violated for feature uses_DataField on the KeyComponent object with identity ' :R_1:THIRD_TEST_CHILD_2:DB2ADMIN:srcdb:DB2:localhost:ISLFTP010: ' and RID b1c497ce.99fdad7e.vv936r9aq.jujnep4.d426i1.7gltn8mom59stolev2ov6
Problem conclusion
Fix is made to delete Primary Key or Foreign Key when the column used by the key is deleted
Temporary fix
Comments
APAR Information
APAR number
JR41141
Reported component name
WIS INFORM ANAL
Reported component ID
5724Q36IA
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-11-07
Closed date
2011-12-01
Last modified date
2012-04-13
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
R850 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5"}]
Document Information
Modified date:
12 October 2021