model error - ORA-01427: single-row subquery returns more than one row

[ry1633]

Hi all,

I'm testing out my model with some reports in Query Studio, and whenever I use this particular query subject from a particular data view it returns an error "ORA-01427: single-row subquery returns more than one row".  Going back into Framework Manager and looking at that particular Query Subject I see nothing wrong with it per se.  When I run a Test Sample in Framework Manager, it returns data that looks just fine, and the validation doesn't return any errors.

Is there something wrong somewhere between the model, the package, and Query Studio's use of the package?

thanks, ryan

[ry1633]

in further testing,  I'm finding that the error doesn't happen in my Dev environment, only in Test.  I will have to do so more digging and check in with my admin guy, and then report back.

[ry1633]

turns out the issue was that somehow the data view was wanting to return more than one row in my test environment.  Re-wrote part of the script to fix and remove some dupes, all seems ok now.