Fixes are available
APAR status
Closed as program error.
Error description
Deleting a decision operation from decision center doesn't seem to remove the query extractor, which caused an error like below when trying to publish a recreated rule of the exact same name: "There is already an item for which the property 'name' is 'Copy_extractor'" Following exception is found in the SystemOut.log: [1/11/17 22:26:32:803 PST] 000000cc IlrElementDAO E Got exception :The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'EXTRACTORNAMEUNIQ' defined on 'EXTRACTOR'. [1/11/17 22:26:32:803 PST] 000000cc IlrElementDAO E Was running std query: insert into ILOG.EXTRACTOR (ID, CONTAINER, TYPE, NAME, QUERY, VALIDATOR) values (?, ?, ?, ?, ?, ?)
Local fix
N/A
Problem summary
Deleting a decision operation from decision center might not remove the query extractor correctly so we need to fix error when dropping a branch or project for databases that do not use cascade delete.
Problem conclusion
The code is fixed
Temporary fix
Comments
APAR Information
APAR number
RS02619
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
881
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-01-24
Closed date
2017-04-26
Last modified date
2017-04-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
None 999
Fix information
Fixed component name
WS DECISION CTR
Fixed component ID
5725B6900
Applicable component levels
R890 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"881","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
11 January 2022