EcoStruxure IT forum
Schneider Electric support forum about installation and configuration for DCIM including EcoStruxure IT Expert, IT Advisor, Data Center Expert, and NetBotz
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 05:16 PM . Last Modified: 2024-04-03 03:25 AM
Hello
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.
(CID:140218699)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 05:16 PM . Last Modified: 2024-04-03 03:25 AM
Hi
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.
Best,
Niels
(CID:140707771)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 05:17 PM . Last Modified: 2024-04-03 03:25 AM
Hello
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.
(CID:140707779)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 05:17 PM . Last Modified: 2023-10-22 02:04 AM
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.