Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki Daily Failed Transactions Alert
    • 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
      • +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
        • Attachments in work reference cannot be seen
        • Change contact number in works form
        • Daily Failed Transactions Alert
        • Exor TMA unable to view street in Works
        • Failure accessing WMS theme.
        • FRM 41035 error when select notice type
        • HIG-0169: Database constraint violated: TNSW_UK
        • How to check if a notice was sent / received
        • How to configure TMA Attachments
        • How to fetch results on Review Notices form(TMA1030)
        • How to locate the .net wsdl file
        • How to remove and add recipients from S58s
        • How To Respond To A Temporary Traffic Signal Application
        • Incoming inspections fail to load
        • +Inspections - Exor TMA Noticing Manager
        • Interim Construction Method Warning Missing
        • Invalid enumeration value 0
        • Invalid XML error when sending notice
        • Major Works 3 Months Notice FPN
        • Many Inspection Records Updated
        • Missing Phase Data
        • New User Cannot Send Notices
        • No notice type for informal overrun warning
        • Notice Sent OK but Not Received
        • Notice went out of sequence in TMA3000
        • +Notices - Exor TMA Noticing Manager
        • Opening the EXOR Application Directly to TMA1000 Works Form
        • ORA 13356 adjacent points in a geometry are redundant
        • +Other - Exor Noticing Manager
        • +Other - Exor TMA Noticing Manager
        • Proximity Validation warning
        • Report not returning all records
        • +Reports - Exor Noticing Manager
        • +Reports - Exor TMA Noticing Manager
        • Restrictions - Exor Noticing Manager
        • Revoke Cancel FPN
        • Sample Inspection Quotas Report Figures Too Low
        • Scheduler only assigns to 1 inspector
        • Sender Does not Exist in NSG Error
        • Some DCD Inspections Not Downloaded
        • Start date for Major Notices
        • +Street Groups - Exor Noticing Manager
        • Street of Interest or Lane Rental Check Box
        • The XML page cannot be displayed Cannot view XML input using XSL style sheet
        • TMA Works Phase Master refresh: error in materialized view path
        • +Transactions - Exor Noticing Manager
        • +Transactions - Exor TMA Noticing Manager
        • Type 4 Street Used On Works
        • Unable to change one type of issued Direction notice type to another
        • Unable to select the Promoter/Contractor contact on Phase Details tab
        • Unable to use Links->Works function
        • What is the difference between created and modified dates
        • Works - Exor Noticing Manager
        • +Works - Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • Remove @ from the AWLRS Local Password Policy
      • +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. 

    Daily Failed Transactions Alert

    Applies To
    Product(s): Exor TMA Noticing Manager
    Version(s): All
    Environment: N/A
    Area: Works
    Subarea: N/A
    Original Author: Lee Jackson, Bentley Technical Support Group

    One thing users must deal with on a daily basis is failed transactions. This could be a small number of transactions that have failed to send to a particular recipient, or a large number of transactions because of an internal problem. Some of these transactions could be business critical and need to be sent the same day in order to avoid an FPN or deemed permit etc.

    Below are some details of an Alert Manager alert which will inform you of any failed transactions on a daily basis. This alert could also be duplicated to run at another interval so you have 2 alerts a day etc.

    Please note these instructions assume you have already configured the relevant product options and started the Alert Manager process to allow Alert Manager to send email alerts.  See the Alert Manager Admin Guide for more information.

    1 – Create a new asset metamodel record for the TMA_TRANSACTIONS table.

     

    2 – Add the attributes required for the alert calculation and email. The example uses a minimal number of columns, but you can add any column from the table.

     

    3 – Open the Alert Setup form and select the Scheduled Events tab

    4 – Select the ‘Select Query’ list of values to open the Bentley Navigator Query Builder

    5 – Select Advanced Query and copy the example below

     

    6 – Save the query and then select it.

    7 – In the Alert Setup form, set an interval suitable to your business. In the example below we used Daily at 3pm which should then give users an hour and a half to resolve any problem transactions, or send them to the intended recipients by other means. The frequency ‘Daily at 3pm’ didn’t exist by default, so we entered a new frequency via the Scheduling Frequencies form.

      

    8 – Enter the relevant details on the Mail Setup tab.

    9 – Save. Below is an example of the email alert sent for the above example:

    See also:

    Alert Manager Admin Guide

    https://communities.bentley.com/products/assetwise/exor/m/mediagallery/269470.aspx

    http://communities.bentley.com/products/assetwise/exor/w/wiki/19867.opening-the-exor-application-directly-to-tma1000-works-form

    • Ready To Send
    • Alert
    • tma
    • error
    • failed
    • Alert Manager
    • transactions
    • Alerts
    • Share
    • History
    • More
    • Cancel
    • Lee Jackson Created by Bentley Colleague Lee Jackson
    • When: Mon, Feb 10 2014 4:11 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Tue, Mar 10 2015 7:52 AM
    • Revisions: 16
    • 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