Hi
Hoping someone can help out with this issue.
Framework Manager - 8.4
Issue: After creating a new calculation within a Query Subject Definition, it tests correctly. After clicking OK the query subject doesn't update successfully. The following error messge is produced:
BMT - MD - 0003 UDA - SQL - 0191 The column was not found in the table or view
UDA_SQL_0191 The column was not found in the table or view
The calculation is just a concatenation from the same table and tests successfully:
[RelationshipView].[subject_code].[subject_code] ||' - '||[RelationshipView].[subject_code].[subject_code_name]
The particular column which framework manager mentions as causing the problem, is not in the calculation but it is in the query definition as a field and also tests successfully and returns data if I test the query definition before beginning to add this calculation.
I do not know what could be causing this problem, any help is appreciated.
Datasource is set to *limited local* and the database is a SQL db.
Thanks in advance
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bUDA-SQL-0191&uid=swg21342606&loc=en_US&cs=utf-8&cc=us&lang=all