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 ?
Do you have 'outer join allowed' set to deny in your report queries?