Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84572members
353845posts

Export table work_order_change_ticket

EcoStruxure IT forum

A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.

DCIM_Support
Picard
Picard
0 Likes
3
156

Export table work_order_change_ticket

This question was originally posted on DCIM Support by Olegas Domanskis on 2019-02-19


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)

3 Replies 3
DCIM_Support
Picard
Picard
0 Likes
0
156

Re: Export table work_order_change_ticket

This answer was originally posted on DCIM Support by Niels Kjeldsen on 2019-02-25


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)

DCIM_Support
Picard
Picard
0 Likes
0
156

Re: Export table work_order_change_ticket

This answer was originally posted on DCIM Support by Olegas Domanskis on 2019-02-25


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)

DCIM_Support
Picard
Picard
0 Likes
0
156

🔒 Closed

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.