Error While Generating Report

Technical queries
#1

Hi Team Helical,

I am using Oracle database with Helical Insight 3.1. I am getting the following error while generating report:
Error: SQLSyntaxErrorException: ORA-00972: identifier is too long.
How do I proceed?

Thank You.

1 Like
#2

Hi Marc,

The SQL query generated by Helical Insight is in the format: schema_name.table_name.column_name
When the entire length of the above is very long then database throws error. In order to overcome this error, change the Alias name of the column at the Metadata level to reduce the length of the column name alias. Use this renamed column to generate the report.

Thank You
From Team Helical