I have a meta data model with table T1. Now for a new requirement, I added an additional column to the table and in framework manager, I chose "tools->update object" so that the metadata model is now updated to include the new column that I added in T1.
While editing my query definition to include this new column, I get the following error:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions status='-9'.
Can someone tell me what can be the problem?
When you added the additional column, did you delete or rename any other columns? Perhaps the transformation/presentation layer object is looking for an item that does not exist. Try validating any objects that reference your T1 or have relationships defined with T1.