Maharashtra Metro Bulk export issue

Problem Description:

Bulk Export job, it is getting stuck at SMC.

Error:

Case 1:

Error 1 in Load tags and populate the Summary and Class sheet  - Script Task/: Exception has been thrown by the target of an invocation.

Case 2: 

Sometimes the job gets stuck in SMC and give error like "Issue in load of Tag in the summary sheet"

Solution:

Case 1:

1. Firstly do a check on to the Tags which user is trying to Export

2. Here one wrong Tag which is having some mismatch of code and class is selected for export. Please see the attached screenshot below.

3. This kind of Tags create issues while creating export.

4. So user has to remove/delete this Tag from that Bulk Export Work Order

Follow any one option from below:

1. Delete these tags from eB and then recreate them with correct template and add them in to the same work order. Then resubmit the job from SMC.
2. Delete this Work Order and then Create a new work order but do not add these wrong tags in to that work order, unless they are corrected by deleting and recreating them with correct templates

Case 2:

1. First of all check that all the tags are provided with the revision some times the SSIS package fails, if the revision value is null in the Database.

2. If any tag is there without any revision no then just provide a revision no '000'

3. And resubmit the export job in SMC.