IBM Support

Cleaning Task Queue Entries for abstract invoce transaction

Troubleshooting


Problem

Cleaning Task Queue Entries for abstract invoce transaction

Symptom

When you use a transaction which is Task Queue based, but dont actually use agents to execute the transaction (i.e; use APIs or carry out the transaction from the UI), then the entries in yfs_task_q stay in place until the order is purged.

PART: Agents-DM 5.0 Platform
PRODUCT: Distributed Order Management
COMPONENT: Create Shipment Invoice
OS: <None> - <None>
DATABASE: <None> - <None>
WEB SERVER: <None> - <None>
WEB BROWSER: Internet Explorer - 6.0

Cause

Resolving The Problem

It is difficult for the removal of these records to be done from the base product as it would definitely require custom code (which will determine which records to delete). The best solution can be :

1. Write a custom Agent to mark these records as complete, and then system will remove them.
2. Write SQLs to remove them
3. Have an enhancemement where people are able to disable the 'task q based' flag in the transaction itself.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI49185

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21529256