User Tools

Site Tools


Stuck Transfers Discrepancies

Ali at Handcross sometimes raises a ticket indicating that that are transfers discrepancies that have been completed but have not been picked up by the job that creates the movements - probably due to it timing out. If this is the case please use the follow steps:

Select the Discrepancy from the traxs web page and note the queue_id from the URL when selected

Use that here

SELECT * FROM [vw_TransferIn_DD_SessionWithAction] WHERE queue_id = ?

From that you can re-run the adjustments for any outstanding lines by getting the session_no value and running

EXEC traxs_TransferIn_DD_Adjustments_Create @session_no = ?

Please note that this should only but done on those Transfer Discrepancies that have been completed!

See as an example -

stuck_transfers_discrepancies.txt · Last modified: 2021/02/10 09:33 by