If you are using a SQL Server database, the product is configured by default to use the SQL Server versions of these queries, so no manual steps are required.
The Event Trend Daily and Event Trend Monthly summary reports are built using multiple queries, where some of those queries contain syntax that is database-specific and can be interpreted only on Oracle or SQL Server databases. If, however, you are using an Oracle database, you will need to configure the product manually to use the Oracle versions of these queries.
Specifically, the following queries are delivered with a SQL Server and Oracle version, where the Oracle version contains the text _Oracle in the name.
SQL Server Version |
Oracle Version |
---|---|
Event Trend Daily |
Event Trend Daily_Oracle |
Event Trend Monthly |
Event Trend Monthly_Oracle |
Past 10 Days List |
Past 10 Days List_Oracle |
Past 12 Months List |
Past 12 Months List_Oracle |
Steps
In the Oracle versions of the queries, remove the text _Oracle from the name.
Queries are configured for Oracle users.
Copyright © 2018 General Electric Company. All rights reserved.