View execution fails in 7.0.6 with "invalid column name" while it runs fine in 6.2 and 7.0.3.00.11
Article ID: KB0082048
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
Attached Parent SQL is failing with an "Invalid Column name" error. The same view is running fine on the 6.2 and 7.0.3.00.11 versions. There seems to be a regression bug in the 7.0.6 version causing this issue.
Issue/Introduction
View execution fails in 7.0.6 with "invalid column name" while it runs fine in 6.2 and 7.0.3.00.11
Resolution
The workaround is to set the below properties to ‘True’
1. Disable Join Pre-Aggregation: true
2. Disable Union Pre-Aggregation: true
They are located within Studio in the path mentioned below:
Studio > Administration > Configuration > Server > SQL Enging > Optimizations
The fix for this issue is targeted for the upcoming 7.0.7 GA release
Attachments
Feedback
Yes
No
Powered by
