Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • More
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki ORA-29283 loading inspection defect file
    • Sign in
    • -Exor - Wiki
      • +ALIM Document Manager
      • +AWLRS
      • Exor Accidents Manager
      • +Exor Asset Manager
      • +Exor CIM / FIM
      • +Exor Document Manager
      • +Exor Enquiry Manager
      • +Exor Information Manager
      • +Exor Information Manager TMA Reporting Pack
      • -Exor Maintenance Manager
        • Adding a BOQ causes FRM-40200:Field is protected against update
        • Adding new standard item causes HIG-0169 Database constraint violated CNI_INDEX_P1
        • Asset missing from PED file
        • Budget not appearing in list from work order line
        • +Budgets - Exor Maintenance Manager
        • Can existing BOQ %uplift functionality in 4300/4400 still be used in 4500?
        • Can't Instruct Defects
        • Cannot add defects to an existing works order line at VALUATION
        • Cannot amend instructed work orders
        • Cannot assign schedule to works order line M_MGR-0252
        • Can’t export PED file in MAI3863
        • Can’t open a Work Order MAI3800 form
        • Changing v2 Asset Type Attributes on MAI1400
        • COMPLEDELE option for MAI
        • Complete defect manually when interfaces on
        • Completing a repair causes ORA-01722 Invalid Number
        • Could not create map in locator
        • Create new budgets after financial year start
        • +Cyclic Maintenance - Exor Maintenance Manager
        • Defect created through Locator not appearing in Defects Form when trying to edit
        • Defect details changed after load
        • Defect priority list
        • +Defects - Exor Maintenance Manager
        • Duplicate defects created
        • +E5 Payment Run - Exor Maintenance Manager
        • Erroneous defect repair dates
        • Error during Inspection Loader Part 2
        • Error instructing Work Orders M_MGR-0267
        • Error message ‘REP-271468672: A temporary file cannot be created’ is appearing.
        • Error messages HIG-0530 and HIG-0556 on inspection loading
        • Exor MAI M_MGR-0234 in cyclic work orders
        • Forced to add road group when adding standard item to contract
        • HIG-0067 when query cyclic work orders
        • +Hosting/Accessibility - Exor Maintenance Manager
        • How to find MAP Viewer log files
        • How to restart MapViewer Service
        • Illegal Activity Area Code in inspection by group form
        • In Map, zooming in takes a lot of time
        • Inspection Date less on loading RDI files
        • Inspection Loader 'could not read file content'
        • Inspection upload failure (from MCP to Exor MAI)
        • +Inspections - Exor Maintenance Manager
        • +Interface - Exor Maintenance Manager
        • Invalid path when running interfaces
        • Loader creates doc assoc record but doesnt move files post load
        • +Loaders - Inspection - Exor Maintenance Manager
        • +Loaders - Inventory - Exor Maintenance Manager
        • +Locator - Exor Maintenance Manager
        • Max chainage of defect exceeds section length
        • Method to clear older defect at zero cost
        • Missing Financial Code EXORR feeder
        • Missing LOCATION keyword when single quote in filename
        • M_MGR-0090 date raised must be <= todays date
        • Notify field on defects form
        • On loading Work Order Invoice (WI) file an error ‘ORA-06502’ appears
        • On scroll BOQ items error “FRM-41050:You cannot update this record” appears
        • ORA 00001 IC PK violation when processing WC file
        • ORA-01400: cannot insert NULL into ("HIGHWAYS"."BOQ_ITEMS"."BOQ_EST_DIM1")
        • ORA-04063 'MAI' package body error
        • ORA-06502: PL/SQL: numeric or value error: character string buffer too small
        • ORA-29283 loading inspection defect file
        • Package signature errors
        • Payment Approval Form ORA 00942 table or view does not exist
        • Payment Run halted M_MGR-0888 displayed
        • Payment run taking a long time to run post upgrade
        • Percentage Uplift
        • Prevent budget being selected mid way through financial year
        • Problem entering completion date for works order line
        • Query regarding work order creation timing
        • +Reference - Inspections - Exor Maintenance Manager
        • Register Status Not Changed
        • Restrict user completion of work orders
        • Type 24 records not appearing in ped file when file created as a sub user
        • Unable to create works order
        • Unable to load inspection file - Primary Inspector cannot be located
        • Unable to run reports
        • Unable to zoom in locator
        • Unknown Module MAI3620
        • Where to find Batch Works Order Printing output?
        • +Work Orders - Exor Maintenance Manager
      • +Exor Maintenance Mobile
      • +Exor MapCapture
      • +Exor MapCapture (ESRI)
      • +Exor MCI MapCapture Interface
      • +Exor Network Event Manager
      • +Exor Network Manager
      • +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 API and Web Service
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • ORA-20000: HIG-0230: Inconsistency detected error on login
      • +Transportation Intelligence Gateway
      • +Video Series for Exor
      • Working From Home with Exor

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

    ORA-29283 loading inspection defect file

       
      Applies To 
       
      Product(s): Exor Maintenance Manager
      Version(s): 4300
      Environment:  N/A
      Area:  Loaders - Inspection
      Subarea:  N/A
      Original Author: Bentley Technical Support Group
       

    Problem

    Trying to load an inspection defect file

    ORA-29283: invalid file operation
    ORA-06512: at "SYS.UTL_FILE" line 475
    ORA-29283: invalid file operation
    ORA-06512: at "HIGHWAYS.NM3FILE" line 1545

    Also later got (as a sub user loading data):

    HIG-0126: You do not have privileges to perform this action: create job.

    The user has MAI_USER role.

    Solution

    Navigate to exor, Directory Management, Directories (or fastpath HIG1895)
    Check MAI_INSP_DIRECTORY setup to a directory on the database server as the database sees it.
    Assign MAI_USER role save, then goto java role privs tab, against MAI_USER role select ALL ON and save.
    Check on Roles tab that the applied check box is ticked.
    Then check can upload and down load a file to the directory, again use Upload file to Oracle Directory, Download file to Oracle directory options accessible from exor, Directory Management.
    If form doesn't appear when downloading or uploading, likely the Oracle DAD not setup or incorrectly setup on the Application Server. Or product options that relate to the DAD not set in the application. See DBA to resolve. Check NM3WEBHOST and NM3WEBCSS product options.
    Amended DAD /exortest/nm3web setup to (Default portal from Reset Package state  - might not be necessary )  ,  Oracle Directory MAI_INSP_DIRECTORY reassigned correct directory on database server, E:\Exor\MAI_Inspections\ -reassigned MAI_USER roles, re-assigned java privs.

    Once this done ORA messages dissappeared.

    In order to read a maintenance manager inspection file ( usually inspection file from Map Capture )  automatically, ensure PROCESS TYPES (fast path hig2500, or navigate to exor, processes, process type Ensure Maintenance Inspection Loader process type setup correctly. Check all tabs at the bottom of the screen. Usually assigned MAI_ADMIN , MAI_USER in roles tab. Frequencies have once and 5 minutes/30 minutes etc. Area polled locations need to be setup if coming from an ftp server. Please check Process locations tab has File Type eg Inspection File, Input Data Store Oracle Directory, Input File Location  MAI_INSP_DIRECTORY. If want files to load automtically can add file extensions here eg  Amended ESI datatype ( suffix of the inspection file )

    Ensure users or sub users processing inspections files in,  have PROCESS_USER role. This corrects HIG-0126: You do not have privileges to perform this action: create job message.  The main user may want PROCESS_ADMIN role too.

    Erronoeous records can be edited in the error correction form, records can be deleted here too

     

    See Also

    Product TechNotes and FAQs

    External Links

    Bentley Technical Support KnowledgeBase

    Bentley LEARN Server

    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!

    • ORA-29283
    • invalid file operation
    • UTL_FILE
    • MAI
    • HIG - 0126
    • Inspection loader
    • HIG -0126
    • HIG0126
    • Exor Maintenance Manager
    • HIG-0126
    • Share
    • History
    • More
    • Cancel
    • Elisabeth Pry Created by Bentley Colleague Elisabeth Pry
    • When: Mon, Aug 26 2013 4:29 PM
    • NT Last revision by Bentley Colleague NT
    • When: Fri, Jul 19 2019 5:52 AM
    • Revisions: 9
    • 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

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