Skip to Main Content
AVEVA™ PI System™ Feedback Portal

Welcome to our new feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

Status Completed
Categories Administration
Created by Guest
Created on Aug 19, 2022

Remove requirement for SQL setting 'disallow results from triggers' to be set to 0

When 'disallow results from triggers option' SQL feature is enabled and set to 1 on the SQL serverwhere the PI Vision database is hosted, PI Vision displays cannot be saved resulting in error: "A trigger returned a resultset and the server option 'disallow results from triggers' is true" Existing versions of PI Vision do not support this feature to be enabled and must be set to 0 for a proper functioning of PI Vision saving displays capabilities. However, this SQL feature is reportedly recommend to be set to 1 by Microsoft and it is mandatory for some customers to have it this way on their SQL server environment (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/disallow-results-from-triggers-server-configuration-option?view=sql-server-ver15). To support this, we would like to allow PI Vision to save displays when this SQL feature is set to 1.
  • ADMIN RESPONSE
    Aug 19, 2022
    PI Vision 2021 removed the reliance on results from SQL triggers.
  • Attach files