Environment

Data Hub 25.4.7125.248 (25.4 u01)

Problem

After importing the new 25.4 u01 default objects, running data collection, transformation and enrichment tasks, it was found that the "Data Analysis > Portfolio Optimization > Software Portfolio Overview > Software optimisation" task failed due to the following error:  

Cause

As the 25.4 u01 Raynet One data collection task now brings in edition values, a new edition column was added to certain steps within the 25.4 u01 "Standardized Data Transformation" process and its tables.  This data is used by our Technology Catalog and several catalog related tables and data analysis task tables also contain this column.  

The "Software optimisation" tasks query references this column from two different tables, and does not use a table alias for one of the columns:  

Workaround

Update line 64 so that it looks like this:  

This change will be included in a future version of the product.