DMS-E-RBI_QCOLUMN error

[insurancereports]

Hello everyone,

I originally had a view T1 which had 5 columns. I altered the view, re-compiled it to have 8 columns. When queried, the view returns the appropriate results on Toad.

However, I tried to insert the 3 new columns into a report and I get the following error:

DMS-E-RBI_QCOLUMN, Column xyz was not found in table or view T1.

Details:

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-RBI_QCOLUMN, Column AGG_EXP_PAID_AMT_ was not found in table or view T1.


I have tried everything-- dropping the view, and recreating it, recompiling the view, creating a new catalog with just this view as a table, but no results are returned. I keep getting the error mentioned above. I have no idea on how to procced --can someone please help?

thank you
IR

 

[bobg4u]

Try this,
Open the Catalog in the Admin. Go to Catalog-> Tables and click on the view that is in question,and then click on Verify .If there are any errors,those fields will be crossed in red. Either remove those fields and add the correct ones from the database(the view or table), or just remove the whole view and add the new view. Then in your report, where all you have used that field in question, you replace with the new field. If you have joins on those fields,make sure you got the joins corect.
Looks like you created a new catalog, but you did you actually create a new report. You should take away all reference to the previous field,replacing it with the new field. Hope this helps!