Error RSV-VAL-0010-Failed to load report specification

[erics]

Hi There,
I'm working on a report that I wrote last month based on data that was modeled before I got into this company.
I've added 1 extra field, which is an updated product name.
In Framework manager, it works great, I have the correct number of rows being returned, with the correct data.
Now, I'm bringing it into my existing report and adding a filter where [Updated_Product_Code]=?prmProduct? and get the following error:
Error RSV-VAL-0010-Failed to load report specification. CCL_ASSERT_NAMED(FALSE,"Switch(dataType)");

I've googled the error, but no one seems to mention this error with a switch.

Also, I'm not sure that this matters, but this field is a calculated field in framework manager. I use a case statement to only overwrite the product name if the new product name is not null. But it shows up properly in framework manager.

Anyone have any ideas?

Thanks,
Eric

[bdbits]

Does the report work without the filter? Have you tried creating a very simple report (a list maybe) with just a few items from the query subject and your filter?

If you validate the model in FM, do you get any informational or warning messages?

[erics]

Without the filter, I do not get an error. And I've created a blank report with just that one view, and the same filters, and didn't get an error.

Though, when I compile the code, I do get an error bmt-md-2008 needs reevaluation.
Not sure what it means though. When I test the data, it comes out ok, is there any way to get a more concrete error?

[bdbits]

"Needs reevaluation" generally means a query subject is out of sync with the database in one way or another.

I'd recommend opening your model, then choose menu item Project > Verify Model. Check all the checkboxes under Severity and Category, click Verify Model. If everything is kosher, you should get a simple message "No issues detected during model verification". If there are any messages, try and resolve the reason (should be icons on the right of the message to take you where you need to go). Then republish your package and try your report again.

[Joker]

Hi,

Is the field CLOB or BLOB type?