Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki On loading Work Order Invoice (WI) file an error ‘ORA-06502’ appears
    • 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
        • Adding a BOQ causes FRM-40200:Field is protected against update
        • Adding new standard item causes HIG-0169 Database constraint violated CNI_INDEX_P1
        • +Budgets - Exor Maintenance Manager
        • Can't Instruct Defects
        • Cannot amend instructed work orders
        • Changing v2 Asset Type Attributes on MAI1400
        • Complete defect manually when interfaces on
        • Could not create map in locator
        • Create new budgets after financial year start
        • +Cyclic Maintenance - Exor Maintenance Manager
        • 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
        • 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-06502: PL/SQL: numeric or value error: character string buffer too small
        • Prevent budget being selected mid way through financial year
        • +Reference - Inspections - Exor Maintenance Manager
        • Unable to run reports
        • Unknown Module MAI3620
        • +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 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. 

    On loading Work Order Invoice (WI) file an error ‘ORA-06502’ appears

      Product(s): Exor Maintenance Manager
      Version(s): 04.x
      Environment: N/A
      Area: Other
      Subarea: N/A

    Problem

    When loading Work Order Invoice file an error in the spooled output appears.

    The error “ORA-06502: PL/SQL: numeric or value error: character string buffer too small”

    Solution

    A common error happens on loading, when records do not correspond specification

    (document called - EXOR Specification for Contractor and Financial interface Manager).

    On MAI3854 Invoice Verification form, a error message is displayed. Usually, it shows the erroneous record(s) which must be amended.

     

    The error “ORA-06502: PL/SQL: numeric or value error: character string buffer too small” appears when at least one record's field has length which is greater than specified.

    You can reject erroneous already loaded data on MAI3854, then amend the data file and try to load it into the system again. 

      Original Author: Renatas
    • Invoice
    • numeric or value error
    • Invoice Verification
    • ORA-06502
    • MAI3854
    • character string buffer too small
    • 06502
    • Share
    • History
    • More
    • Cancel
    • renatas Created by Bentley Colleague renatas
    • When: Tue, Apr 1 2014 10:23 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Fri, Sep 27 2019 11:45 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

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