Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
Licensing and Activation
  • Product Communities
  • More
Licensing and Activation
Licensing and Activation Wiki SQL Error
    • Sign in
    • License Flowchart for Subscription Entitlement Service (SES) and legacy SELECTserver
    • +Understanding the Subscription Entitlement Service (SES) Workflow
    • Working from Home using Bentley Licensing
    • EVD Reporting Guide
    • -Understanding the (Legacy) SELECTserver Workflow
      • -SELECTserver TechNotes and FAQs
        • "An Error Has Occurred" when manually transmitting usage logs using a preconfigured URL
        • About SELECTserver
        • Connecting to the Bentley servers through Firewalls and Proxy Servers [FAQ]
        • Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel...'
        • Data Update Service Warning [TN]
        • Database Maintenance
        • Database Setup Tool Configuration and Explanation [FAQ]
        • Deployed SELECTserver Database and Internet Connectivity Insight [TN]
        • Deployed SELECTserver issue with new Bentley SSL certificate
        • Deployed SELECTserver Knowledge Requirements [TN]
        • Deployed SELECTserver Technical Requirements [TN]
        • Enabling Diagnostic Logging for SELECTserver
        • Error 1068: Cannot start the Bentley SELECTserver service
        • Error 417 : in SELECTserver and GateWay logs
        • Glossary Of Licensing Terms [FAQ]
        • Group Policy Administration (ADM) files
        • How do I keep usage reports current?
        • How do I set up or prevent license checkouts?
        • How to create a new website in IIS7
        • How to create a Virtual Directory in IIS7
        • How To Install a Gateways on Vista and Windows 7, Server 2008
        • How to Install the SELECTserver application
        • How to migrate users to a custom activation group
        • HTTP Error 404.13 "The request filtering module is configured to deny a request that exceeds the request content length" when importing response file
        • HTTP Error 500.21 - Internal Server Error on SELECTserver Administrative Site
        • Import xml File on Deployed Server
        • IP Address Hosted Server
        • License and SELECTserver Administration [FAQ]
        • +License Manager
        • License Tool Command Line Options
        • Manual Installation of SQL Express (2008 - 2012)
        • Moving (relocating) the SELECTserver application to a new server.
        • Moving Your SELECTserver Database
        • +Older SELECTserver Versions
        • Opening Admin site pager starts (runs) installer process
        • Opening Administration Site
        • Restricting access to a deployed SELECTserver Administration Site. Configuration example (video).
        • Running the Data Update Service and restarting IIS in order to immediately update a deployed license
        • Schedule Report - no Parameter selectable
        • Security [FAQ]
        • SELECT Server 08 11 Series [CS]
        • -SELECTserver
          • Access restriction via IP-address
          • Access to App_Offline.htm denied in SELECTserver Database Setup
          • -Administration - SELECTserver
            • +Client Access restrictions - Administration - SELECTserver
            • Error: Client not recognized as a valid client
            • Error: CREATE DATABASE or ALTER DATABASE failed
            • How does a checked out license work for SELECT or ELS customers with product usage logging?”
            • How to list multiple Gateway servers in LIC file
            • HTTP 407 Proxy Authentication Required
            • +License Management - Administration - SELECTserver
            • New database no being used
            • +Nightly Processing - Administration - SELECTserver
            • +Notifications - Administration - SELECTserver
            • +Reports - Administration - SELECTserver
            • SelectServer OnLine: Maximum Checkout Interval default value changed to 2 days
            • SQL Error
            • Unable to open the Administration Site
            • Unexpected Error 0x8ffe2740 after restart of Windows
            • +Usage Logs Transmittal - Administration - SELECTserver
          • Administration page at nonSELECT customers
          • Administration page does not open, page cannot be displayed
          • Create a log file on the client computer
          • Deployed SELECTserver Logs
          • Hosted server Administration page - Access for administrators only
          • How to start the Deployed SELECTserver and SELECTserver Gateway service via Windows Services
          • +Installation / Configuration - SELECTserver
          • +Installation / Configuration - SQL Management
          • No access to the Adminstration page
          • Ports and Domains
          • Program starts up slowly after the creation of a log file
          • Reset the webserver IIS
          • Response File larger than 7.93 MB - Error 404
          • Restrict access to the Hosted Administration page
        • SELECTserver 9 Known Issues
        • SELECTserver 9.xx.xx.xx Gateway Update Process [FAQ]
        • SELECTserver 9.xx.xx.xx Upgrade Information [FAQ]
        • SelectServer Client Access Restrictions technical overview (video).
        • SELECTserver Database Backup [TN]
        • +SELECTserver Gateway
        • SELECTserver Gateway error 1053
        • SELECTserver Gateway Explained
        • SELECTserver Gateway License Server Revoked License [TN]
        • SELECTserver Gateway Service Fails To Connect through Proxy Server [TN]
        • SELECTserver General [FAQ]
        • SELECTserver in a IPV6 Environment
        • SELECTserver Notifications
        • SELECTserver Online Technical Requirements [FAQ]
        • SelectServer V9 without connectivity and Bentley Passport
        • SELECTserver XM Database Backup [TN]
        • Server status - Log file
        • SQL Server 2005 Cachestore Flush Error
        • SQL Server Compatibility Mode - Internal Query Processor Error
        • Support Path User Registration [FAQ]
        • The response file corresponding to the following logs is not processed.
        • The SQL transaction logs are full
        • Transmit Usage Logs - 0 Logs Found To Process [TN]
        • Trust Licensing Basics [FAQ]
        • Unlock the SQL Server SA Account
        • Upgrading to SELECTserver 08 11 series [CS]
        • Upgrading to SELECTserver 08.11.xx.xx [TN]
        • Uploading SELECTserver Usage And Client Logs [TN]
        • Usage Log Processing - ERROR with status code 15014
        • Using Active Directory Group Policy Objects to Configure Licensing for Users Centrally (video).
        • What options are available to allow the external (WAN) user to access a Locally Deployed SELECTserver?
        • What's New in the latest SELECTserver?
    • +Product Activation TechNotes and FAQs
    • +Application Usage TechNotes and FAQs
    • +SELECTservices TechNotes and FAQs

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

    SQL Error

       
      Applies To 
       
      Product(s): SELECTserver
      Version(s): 08.11.07.35
      Environment:  N\A
      Area:  Administration
      Subarea:  N\A
      Original Author: Philip Conard, Bentley Technical Support Group
       

    Problem

    An insert query to a table that has foreign key references cannot generate a plan with error 8624 when arithabort is set to be off. Server: Msg 8624, Level 16, State 1, Line 1 Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

    SqlException: Internal Query Processor Error

    11-11-09 14:26:00.953 [(null)][1] ERROR - Shared - execute
    [ss_sp_UsageRecords_Tracking_Insert] @
    11-11-09 14:26:00.953 [(null)][1] ERROR - Shared -
    System.Data.SqlClient.SqlException: Internal Query Processor
    Error: The query processor could not produce a query plan. For more
    information, contact Customer Support Services.

    The root of the problem is a bug in SQLExpress / SQL Server 2005. You may have started out in an earlier version of SELECTserver XM, which used MSDE, SQL 2000 then upgraded to 8.11, which changed the database to SQLExpress 2005 SP2. This issue appears to be related to the fact database compatibility is set to 80.

    Solution

    Setting database compatibility to be 90 resolves the issue.
    ALTER DATABASE database_name
    SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 }

    See Also

    http://technet.microsoft.com/en-us/library/bb510680.aspx

    • Migrated
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Phil Conard Created by Bentley Colleague Phil Conard
    • When: Tue, May 6 2014 11:15 AM
    • Tamicca Sellars Last revision by Bentley Colleague Tamicca Sellars
    • When: Tue, May 6 2014 11:17 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

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