Maharashtra Metro Rail Bulk Update of Tags not working(Customization)

Problem Description:

User is trying for bulk update the tags and the job is getting stuck in SMC.

Error:

1. Error -1071636471 in Load Dynamic Tag Sheets - Data Flow Task/Char Data - OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR

2. Error -xxxxxxxxxxx in Tag to Document Relationship

3. Error -xxxxxxxxxxx in Add Responsibilities

4. Error -xxxxxxxxxxx in Tag to Tag Reationship

Root Cause:

SSIS package fails to load the sheet if some thing is wrong with the excel like excel is corrupted, Summary sheet is not able take the reference fr the Tags. 

Solution:

• Error 1
  1. For Error-1 ask user to check the Summary excel sheet. Are there any references missing for the Tags and if missing please check the Tag class sheet exists in the Excel and the Tags are there in that  Class sheet?
  2. Sometimes user mess with the excel sheet like where the drop downs are there for selection, user copy the value from some where and paste it in the excel. It corrupts the excel, and SSIS job fails to run the job.
• For Error-2 ask user to check the Document class sheet is filled correctly and the Documents are related with the correct revision. And the document no is correct.
• For Error-3 ask user to check the Responsibilities sheet. The person should be the member of Organization, whose name they are adding as responsible for that Tag.
• For Error-4 ask user to check the Tag revision is added.

Sometimes Error 1 occurs due to user mistakes, there are some documents which are provided to the user to avoid mistakes(Attaching the Pdf files)

0508.Asset Tag Excel Update Rev 01.pdf