If you are unable to create a new account, please email support@bspsoftware.com

 

Changing cardinality in our model is causing all existing reports to fail

Started by hawaii_desperado, 07 Mar 2014 03:59:27 PM

Previous topic - Next topic

hawaii_desperado

We discovered an error in our model which was causing data loss when a query item was added.

We need to change the cardinality between two query subjects.  Chaning from 1..1------1..N to 0..1-----1..N

When we do this and publish the package all existing reports are failing.  New reports work fine.

Opening the existing reports in query studio is impossible because it always runs the report first and this fails with an error DPR-ERR-2056
Seen here http://grab.by/uXMw
IBM site says this error is a space issue.  (
http://www-01.ibm.com/support/docview.wss?uid=swg21591671
) However that doesn't seem to be the issue because any new report created even if same as failing reports works.

If I open the report in report studio it fails validation with errors that it is unable to find the query information.
Seen here http://grab.by/uXMQ

However the data model clearly show these items.  In fact if I remove the data item and add it back in the same error is produced and testing the data items fails.

If I change the cardinality back to 1.1 then the existing reports start working again.....

I am at a loss as to how to fix all our existing reports.  We can't have to recreate ever report because of this issue.

Has anyone run into this issue ?
Is there a way to fix this ?




buddtholomew

Do you have 'outer join allowed' set to deny in your report queries?