Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
AssetWise ALIM
  • Product Communities
  • AssetWise
  • AssetWise ALIM
  • Cancel
AssetWise ALIM
AssetWise ALIM - Wiki Maharashtra Metro Rail Bulk Update of Tags not working(Customization)
    • Sign In
    • +AssetWise ALIM - Wiki
    • +AssetWise Client
    • +eB - Training Recording
    • eB Create Backup and Restore
    • +eB Standard Viewer
    • Error using Bentley Sing-On (IMS)
    • External user failed to access ALIM site
    • Firewall File and Port Exclusion list
    • Maharashtra Metro Bulk export issue
    • Maharashtra Metro Rail Bulk Update of Tags not working(Customization)
    • NED Menu options
    • SSIS - eB Connection Manager not available in SSIS after Upgrade to ALIM 16.9.3
    • Troubleshooting logging on in using IMS as your authentication method

     
     Questions about this article, topic, or product? Click here. 

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

       
      Applies To  eB Web, eB SMC
       
      Product(s): eB
      Version(s): 16.4
      Environment:  PROD
      Area:  Bulk Update Of Tags (Customization)
      Subarea:  N/A
      Original Author: Nitin Bhui, Bentley Technical Support Group
       

    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)

    PDF

    • SMC
    • error in bulk update of Tags
    • jobs getting stuck in SMC
    • Share
    • History
    • More
    • Cancel
    • Nitin Bhui Created by Bentley Colleague Nitin Bhui
    • When: Tue, Feb 11 2020 4:19 AM
    • Nitin Bhui Last revision by Bentley Colleague Nitin Bhui
    • When: Tue, Jun 23 2020 9:20 AM
    • Revisions: 2
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies