pravinnalkande - Thursday, April 26, 2012 1:45 AM:
Dear All,
When I am going to save the ECR It's giving me error as like below:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="http://www.aras.com/InnovatorFault"><faultcode>SOAP-ENV:Server</faultcode><faultstring>Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.</faultstring><detail><af:legacy_detail>Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.</af:legacy_detail><af:exception message="Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." type="System.Data.SqlClient.SqlException" /></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>
Please help me on this problem.
Cheers,
Pravin
Brian - Wednesday, May 2, 2012 7:22 AM:
Hi Pravin,
Is it all ECR that you have this problem for?
If it is one ECR can you put a screen shot of the ECR details up?
Cheers,
Brian.
pravinnalkande - Wednesday, May 2, 2012 8:42 AM:
Hi Brian,
Actually I am creating the blank ecr means only I have given the name of the ecr while saving.
But still me shows the same error message.
When I disable the workflow default value over the relationship tab of the ecr item type then it works fine and ecr get save successfully.
So I found error root cause in the workflow but i am not understanding why it is happening?
Because I want to use another user instead of the admin user to create the ecr.
PFA
Any help on this is appreciated.
waiting for your reply.
Cheers,
Pravin
dennis - Thursday, June 19, 2014 4:04 PM:
I ran into this error today and found that it was related to assigning the "creator" to a workflow activity where the creator's user record has two alias relationship records. In the below image, I turned on the relationships from the toolbar to show the Aliases tab of the user item. On the tab, you can see two relationships to the same identity. The extra identity relationship cannot be deleted from the UI. I had to delete the relationship in SQL.
to the user's alias identity. 
pravinnalkande - Friday, June 20, 2014 2:22 AM:
Hi Dennis,
Thanks for your help :)
It works perfectly now.
Cheers,
Pravin
