This question was originally posted on DCIM Support by Olegas Domanskis on 2019-02-19
In the export database there is a table work_order_change_ticket, which if I understand right is supposed to contain work order to request tickets relations. But it seems that it is not updated for some reason. I've assigned different request tickets to the work order and that table contains both assignments. Even after I've deleted one of them. Via REST API I can see only one request ticket assigned to the work order.
This answer was originally posted on DCIM Support by Niels Kjeldsen on 2019-02-25
Just a quick thing to check is that the export actually did run after you updated the work orders. The export database is only update when the job runs.
If you still see a difference there might be a bug.
This answer was originally posted on DCIM Support by Olegas Domanskis on 2019-02-25
I've executed ETL manually from the DCO web portal. Also It was executed by scheduler.
The records are still there.
I've tried swoExportJob_v2.0.0 and "No transformation" transformations.
Discuss challenges and get support in energy and automation with 30,000+ experts and peers.
Over 10,000+ support articles are available to help you find answers to your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!