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 TIG: PLS-00566: type name “DATE” cannot be constrained
    • 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
      • +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
        • Blurry Images in TIG
        • Login Error: Authorization Required
        • Login failure in TIG
        • Scrollbar issue in TIG 2.3 fix1
        • TIG How to export an extract to a (not ‘Imported’) catalog
        • TIG: PLS-00566: type name “DATE” cannot be constrained
      • +Video Series for Exor
      • Working From Home with Exor

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

    TIG: PLS-00566: type name “DATE” cannot be constrained

      Product(s): Transportation Intelligence Gateway
      Version(s): 02.03.00.00
      Environment: N/A
      Area: N/A
      Subarea: N/A

    Problem

    The user created a new extract, selected the “All of the Above” under <Select an Action> drop down and clicked “OK” button. The warning message box appeared

     

     

    In “Activity Log” from <Select an Action> dropdown there are following errors:

     

    1. “Error on line: 46: PLS-00566: type name “DATE” cannot be constrained”
    2. “Error on line: 70: PLS/SQL: ORA-00942:table or view does not exist”
    3. “Error on line: 70: PLS/SQL: Statement ignored”
    4. “Error on line: 111: PLS/SQL: ORA-00942:table or view does not exist”
    5. “Error on line: 111: PLS/SQL: Statement ignored”

    Solution

    These errors appear because the Date type field should be converted to character. Go to Step 1

    and change Date type to Character.

      Original Author: NT
    • Exor
    • TIG
    • Share
    • History
    • More
    • Cancel
    • NT Created by Bentley Colleague NT
    • When: Tue, Oct 17 2017 1:57 AM
    • Revisions: 1
    • 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