Error in getColumnUniqueKey func. id or mode is missing

Technical queries
, , ,
#1

Hello Team,

I am using Helical Insight version 5.2.3 and have created a SQL view within the metadata.

However, when I try to save this view, I receive the following error:

“error in getColumnUniqueKey func. id or mode is missing.”

I have verified that my SQL syntax is correct. I have also tried clearing the application cache, performed a hard refresh, and even accessed the application in an incognito/private browser window. Despite these efforts, the issue still persists.

Can you please help me understand how to fix this so I can save the view successfully inside the metadata? I am using open source BI helical insight enterprise edition version 5.2.1

Thanks.

#2

Hello,

This error typically occurs when your SQL query result includes duplicate column names or aliases. Helical Insight requires that each column in the result set must have a unique name or alias. If any two columns share the same name or alias, the metadata system cannot uniquely identify them, which leads to the error:

“error in getColumnUniqueKey func. id or mode is missing.”

To resolve this:

Review your SQL query.

Make sure that every column has a unique alias or name.

Avoid using the same alias for multiple columns.

Once you update your SQL view with distinct aliases for each column and re-run it, you should be able to save the view inside the metadata successfully.

Thank you!