Skip to main content
Question

Background jobs getting posted 1or 2 days later issue.

  • February 15, 2024
  • 1 reply
  • 113 views

Forum|alt.badge.img+6

Hi All,

We are using IFS apps 10. I have noticed that some of the jobs from below code is posted to background jobs screen 1 or 2 or more than two days later after the event action runs. But background jobs are executed ASAP after it gets posted. there is not much delay in that.

Due to this behaviour, we have lot of mismatches. How we can resolve this. 

In below code 'PURCHASE_API.PO_SAVE_NOTE' 

PURCHASE_API - custom package.

PO_SAVE_NOTE- custom procedure.

 

there is no problem with package or procedure, it is working as expected.

Below code is taken from event action.

Also, this behaviour is not occurring all the time, someday it happens for all records, some days for a few and some days running without any issues.

DECLARE
 ATTR_ VARCHAR2(2000);
 ROWKEY_ VARCHAR2(100) := '&NEW:ROWKEY';

 PROCEDURE_ VARCHAR2(200) := 'PURCHASE_API.PO_SAVE_NOTE';
BEGIN
 IFSAPP.CLIENT_SYS.CLEAR_ATTR(ATTR_);
 IFSAPP.CLIENT_SYS.ADD_TO_ATTR('ROWKEY_', ROWKEY_, ATTR_);
 IFSAPP.TRANSACTION_SYS.DEFERRED_CALL(PROCEDURE_, 'PARAMETER', ATTR_, 'Add notes');
END; 

 

Best Regards,

Hari 

1 reply

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • February 15, 2024

 @Harikrishnangr in order to start troubleshooting this I would:

  • create a new Batch Queue
  • add PURCHASE_API.PO_SAVE_NOTE to the new batch queue

That way you know that only this job runs on this queue and you could better observe if also this new batch queue will have the same issues.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings