SQL Error 42000 - column name 'EV_SortOrder' specified twice
Article ID: 92933
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
The following error message is appearing frequently in the AE WP log files:
MS SQL - U00003592 UCUDB - Status: '42000' Native error: '264' Msg: 'The column name 'EV_SortOrder' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code.'
Oracle - U00003592 UCUDB - Status: '' Native error: '957' Msg: 'ORA-00957: duplicate column name' .
MS SQL - U00003592 UCUDB - Status: '42000' Native error: '264' Msg: 'The column name 'EV_SortOrder' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code.'
Oracle - U00003592 UCUDB - Status: '' Native error: '957' Msg: 'ORA-00957: duplicate column name' .
Environment
Release: AUTWAB99000-11.2-Automic Workload Automation-Base Edition
Component:
Component:
Resolution
A hot fix has been made available - Automation.Engine 11.2.7 HF1.
The same fix will be made available in Automation.Engine 11.2.8.
The same fix will be made available in Automation.Engine 11.2.8.
Feedback
Yes
No
Powered by
