Forum Discussion
Error Message OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Column 'Gang Name' in Table 'Attendance Grouped for Effic' contains a duplicate value 'Ashton Clemmings' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Hi,
Issue solved by the following:
- Uncheck 'Enable Load' especially for the query that is not required in the output
- Refresh in order that any other changes filter through to the dashboard
- Review the queries that feed into the main output visual and assess the level of the data, for example two fields come from query 1 and the other other from query 2, however both must be at the same level as in a team name in 1 may have 2 orders per day yet in 2 it is all agregated. Once 1 is also grouped all the visuals calcs will work.
2 Replies
Hi,
Issue solved by the following:
- Uncheck 'Enable Load' especially for the query that is not required in the output
- Refresh in order that any other changes filter through to the dashboard
- Review the queries that feed into the main output visual and assess the level of the data, for example two fields come from query 1 and the other other from query 2, however both must be at the same level as in a team name in 1 may have 2 orders per day yet in 2 it is all agregated. Once 1 is also grouped all the visuals calcs will work.