SYMPTOMS

Some custom Cognos reports on budgets that were working fine in Changepoint V2012 no longer work in Changepoint V2014. These reports contain custom SQL queries.

ERROR

QE-DEF-0359 The query contains a reference to at least on object [...].[BudgetCode1] that does not exist. QE-DEF-0030 Expression parsing error. The query specification is incorrect. RQP-DEF-0457 Referenced query '....' is not defined or its query items contain unresolved references.
 


REASON

The data model has changed in V2014. The fields BudgetText1 .. 3 and BudgetCode1..3 are no longer stored in the budget table. As budgets support any number of custom fields in V2014, custom field data is now stored in the tables UDFCode, UDFText, UDFNumber and UDFDate, same as we already do for other entities (project, request, ...).

RESOLUTION

Reports containing explicit SQL to access any of the fields Budget.BudgetText1..3/BudgetCode1 ... 3 need to be modified. The queries need to join to the tables UDFCode, UDFText, UDFNumber and UDFDate in order to retrieve budget custom field data.