Problem creating Calculation in Query Subject Definition

[drepso]

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

[tupac_rd]

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