Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki HIG-0169: Database constraint violated: TNSW_UK
    • 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. 

    HIG-0169: Database constraint violated: TNSW_UK

      Product(s): Exor TMA Noticing Manager
      Version(s): All
      Environment: N/A
      Area: Works
      Subarea: N/A

    Problem

    User is not able to save Non-Street Works activities form (TMA1150). The following error message is displayed:

    HIG-0169: Database constraint violated: TNSW_UK

    Solution

    1. If Non-SWA Ref is being entered manually, check that no other Non-SWAs exist with that reference number already.
    2. If automatic Non-SWA Ref generation is being used, check the user has at least one organisation and district assigned to them in the Administer User Districts form (NSG0120).  They need at least one assigned before this form will work.
    3. If they do have an organisation / district assigned, contact Support for instructions on how to check if the sequence needs resetting.

    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!

      Original Author: Bentley Technical Support Group
    • HIG-0169
    • TMA1150
    • non-street works
    • constraint violated
    • TNSW_UK
    • Share
    • History
    • More
    • Cancel
    • Kristina Jarmalaviciene Created by Bentley Colleague Kristina Jarmalaviciene
    • When: Tue, Oct 11 2016 7:56 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Wed, Mar 27 2019 9:23 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