COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: LR on 15 May 2012 05:16:35 AM

Title: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions
Post by: LR on 15 May 2012 05:16:35 AM
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?
Title: Re: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions
Post by: bi4u2 on 15 May 2012 07:58:37 AM
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.