Question
Cognizant
IN
Last activity: 15 Oct 2023 21:28 EDT
LINK-ATTACHMENT INSTANCE MISSING in LINK-ATTACHMENT table
For 2 documents, we have 2 data-work-attach instances created in the data-work-attach table,
but the corresponding link-attachment instance is missing for the 2nd instance mentioned below.
DATA-WORKATTACH-FILE MIB-WHIPLASH-WORK OIC-10-23-4047!20231012T055526.600 GMT(LINK-ATTACHMENT available)
DATA-WORKATTACH-FILE MIB-WHIPLASH-WORK OIC-10-23-4047!20231012T055544.849 GMT(LINK-ATTACHMENT missed)
How could this happen?
We are using LINK-OBJECTS to link the attachment using data-work-attach file.
We aren't sure if AttachToWork is failing to attach this instance to the LINK-ATTACHMENT table?
How can we confirm this, and what can be the solution for this issue?
Because, both the data-work-attach instances are generated at the same time (but with seconds difference)
Infosys Limited
IN
I believe you are using link-objects method to create link instances of the attachment. Ideally it should create the link instances. One option here is we can use an ootb activity pxlinkattachmenttocase to create the link instaces.
Is this issue occuring for all the time or sporadically this is happening?
If this happens for every time try to run the tracer with db events while attacing the doc and see whether the link instance is gettig saved into the link-attachments table or not?