Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki Locator export fails but shows no errors
    • Sign In
    • -Exor - Wiki
      • +ALIM Document Manager
      • An Attempt to Reset Your Password Has Failed
      • +AWLRS
      • +Exor Asset Manager
      • +Exor CIM / FIM
      • +Exor Document Manager
      • +Exor Enquiry Manager
      • +Exor Information Manager
      • +Exor Information Manager TMA Reporting Pack
      • +Exor Maintenance Manager
      • +Exor Maintenance Mobile
      • +Exor MapCapture
      • +Exor MapCapture (ESRI)
      • +Exor MCI MapCapture Interface
      • +Exor Network Event Manager
      • -Exor Network Manager
        • 'Group has overlaps' error adding section to group
        • "HIG 0182: User not instantiated correctly. Probable missing INSTANTIATE_USER trigger. Contact exor support for assistance" when login
        • Allow users to use Locator but not to change network data
        • Batch emails ignore table tag
        • Changing Base Themes
        • Create New User
        • Database clone product options
        • Default-web-access.log taking up too much space
        • Elements - Exor Network Manager
        • Error ORA-105100 uploading documents.
        • Error received while resizing route using toolbar, ORA-01422 unhandled exception
        • Error whilst creating theme
        • Errors while creating asset layer using GIS Layer Tool
        • Exor listener processes are not currently running
        • Exor password format rules
        • Export Asset data from grid in Locator cannot locate file once exported
        • Export location of surveyp.ped in NM0580
        • FRM-92101 Error when opening application
        • GRI/GIS Data - Exor Network Manager
        • Groups of Sections - Exor Network Manager
        • HIG-0067 error when entering a form because of user options
        • HIG-0179 error message trying to select local file
        • How to block read-only users from uploading data using CSV files
        • How to Change Highways Owner User Password
        • How to change the user password on a MAS System
        • How To Clear Your Java Cache
        • How to Enable the Java Console
        • How To Find Out Which Fixes Are Installed
        • How To Set Up Exor Listeners
        • How to unlock a user or change a users password
        • In which table is the user account email stored?
        • +Install/Upgrade - Exor Network Manager
        • Instantiate user error
        • Invalid number error ordering results by a string field in the Locator form
        • Java Certificate issue
        • JDBC Datasource Failed error when starting Locator or Map Viewer Servlet Failed
        • +Jobs - Exor Network Manager
        • Legend Tool doesn’t work on Locator
        • +Locator - Exor Network Manager
        • Locator - Initial extent of map does not appear correctly
        • Locator - Measure tool does not work - Your query failed
        • Locator export fails but shows no errors
        • Locator: Map doesn’t open. FRM-92104 A network error or server failure has occurred.
        • My Database has been updated - I can't login - get errors trying to save
        • Navigating between fields in the form
        • Navigator: ORA-28112: failed to execute policy function
        • NET-0339 error when using CSV Loader
        • New Asset Type Not Selectable In Alert Manager
        • New Defect Scheduled Alerts do not work
        • No network found within Tolerance error when creating a Defect
        • No snaps at this position when creating an asset
        • ORA 29279 SMTP Permanent Address error in alerts
        • ORA-20000: HIG-0230: Inconsistency detected error on login
        • ORA-20110: Unable to close Element it has un-replaceable inventory
        • ORA-257: archiver error. Connect internal only, until freed.
        • +Other - Exor Network Manager
        • Popup windows do not display
        • Process Framework Manager - Default Installed Processes
        • Process Submission module shows wrong time
        • +Reclassify - Exor Network Manager
        • Refresh Java Permissions For An Oracle Directory
        • Report fails with REP-300: CONNECT BY clause
        • +Reports - Exor Network Manager
        • Results are not returned in the correct order in Locator
        • Split/Merge - Exor Network Manager
        • Subordinate users cannot see all options in the Feature Edit menu
        • The specified environment ID EXORLIVE invalid for Job Type report
        • Unable to Delete System or User Menu Items
        • Understanding Datum, Non Datum, Linear groups, Non-Linear groups, Group of groups
        • Useful scripts to identify database sessions and locks
        • Users form HIG1832 FRM-40200. Field is protected against update.
        • WMS alternatives
        • WMS Map is not visible in Locator
        • You do not have privileges to perform this action error on logon
      • +Exor Oracle
      • Exor Problems and Solutions
      • +EXOR product placeholder
      • Exor Public Enquiry Manager API
      • +Exor Schemes Manager
      • +Exor Spatial Manager
      • +Exor Street Gazetteer Manager
      • Exor Streetworks Manager
      • Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • +Transportation Intelligence Gateway
      • Unable to connect to Power BI dataset
      • +Video Series for Exor
      • Working From Home with Exor
    • +AssetWise ALIM for Transportation

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

    Locator export fails but shows no errors

      Product(s): Exor Network Manager
      Version(s): 4.5.0.0 and above
      Environment: N/A
      Area: Locator
      Subarea: N/A

    Problem

    When exporting results in CSV format from Locator (NM0572), nothing happens.  There is no error message and the file is not created.

    Solution

    1. The first thing to check is usually pop-up blockers in your browser settings.  
    2. Security settings: 

      Click on the ‘Tools’ button on the top right-hand side of any Internet Explorer page as you look at it and select ‘Internet Options’ from the drop down box

      Click on the ‘Security’ tab. Click on the ‘Trusted Sites’ and it will highlight.

      Then click on the button marked ‘Custom level… ‘

      This will take you to the ‘Security Settings – Trusted Sites Zone’. Scroll down till you reach the Downloads section.

      When you arrive at the Downloads section, You will see that the Automatic prompting for file downloads has been set to ‘Disable’ – you should change this to ‘Enable’

      You will be prompted with a warning – click ‘Yes’.

      Once returned to the Security screen, click ‘Apply’, then ‘OK’, then close

    3. Verify that the asset metamodel is correct.  If there are attribute values that exceed the length specified in the metamodel, the export may not work correctly. This may happen if the underlying tables have been changed and the column in the database allows more characters for the same attribute value than allowed by metamodel. If a certain attribute value meets the length requirement of the table column but is bigger than that defined in the metamodel – export will not work. To fix this, set the length of the attribute in the asset metamodel to the length of the column in the table.
    4. Verify that the DAD is functioning correctly.
    5. Verify that the webutil.cfg options are set correctly to allow download:    
      • transfer.database.enabled=TRUE
      • transfer.appsrv.enabled=TRUE
      • transfer.appsrv.workAreaRoot=
      • transfer.appsrv.accessControl=TRUE
                                                                                                                               
    6. Check for records in NM_UPLOAD_FILES.  If the statement below returns a row, then there is a problem.

    with cnt as (  SELECT COUNT(*) + 1 fnum   FROM nm_upload_files   WHERE name LIKE 'NM0572'||'%')   select name from nm_upload_files, cnt where name LIKE 'NM0572_'||FNUM || '%';

    To correct the problem found above:

    delete nm_upload_files where name LIKE 'NM0572%'; commit;

            7. Run the query below to see how many LOCATOR_EXPORT$$xx temporary tables have been created in the database.

               select * from all_objects where object_name like 'LOCATOR_EXPORT%' and owner = 'HIGHWAYS';

               if there are up to 99 (LOCATOR_EXPORT$$99) tables then delete them from the database and try to do asset export again.

              8. Contact Bentley Support for assistance

    Comments or Corrections?

    Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!

      Original Author: Elisabeth Pry
    • field length
    • Export
    • Locator
    • CSV
    • Net
    • asset metamodel
    • Exor Network Manager
    • Share
    • History
    • More
    • Cancel
    • Elisabeth Pry Created by Bentley Colleague Elisabeth Pry
    • When: Wed, Sep 18 2013 11:39 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Thu, Aug 2 2018 5:21 AM
    • Revisions: 8
    • 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