jpayne - Wednesday, October 5, 2011 7:15 AM:
I am new to ARAS. I wanted to look at the engineering change process. I created a part called Test1. I right-click on the part and select "Add Item(s) to Change. A window pops up with "Change Type: ECR" and "Item:Create new". I click OK. The ECR window pops up with the part, Test1, in as the affected items tab at the bottom. When I click save I get this error.
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="schemas.xmlsoap.org/.../"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="www.aras.com/.../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>
In my workspace, these messages come up.
I feel like something is not setup correctly with the server or I am not linking the parts correctly. I can save the part. Any help is appreciated.
Thanks
Brian - Tuesday, October 11, 2011 6:00 PM:
This is certainly an unusual error. The Images that you posted did not come through so I am not sure if there is something subtle in them that is getting in the way.
I have submitted the same AML (SOAP message etc) that you posted here via the Nash script and it did not fail so I am at loss to explain what might be happening.
Some questions that come to mind.
What else have you played with in the system that might have a knock on affect?
What user were you logged in as? The "locked by id" line in the AML looks a little strange in that there are no names just an ID. It probably doesn't make any real difference but it is different to the equivalent AML that my system produces.
You might do well to create a brand new database, log in as the Innovator Admin, create the Test1 part, save and add to change then save the ECR. See if you get the same error on a clean database.
Did you put any other information into the Part other than the Part Number when you created it? Again it shouldn't matter but just for completeness it's good to know.
Cheers,
Brian.
dstephen - Monday, October 17, 2011 9:10 AM:
Can you add the affected item the old fashioned way? Change Management > ECR > Create New ECR... > click New Relationship on affected Items tab > Add the part and save?
I tried to reproduce your errors and had no luck. Usually, my install issues appear before I can login so I don't know what to say there but you could always try uninstalling and check your system MSXML 4 patch level current? .Net 3.5 patch level current? IE settings per the IE configuration guide? If using SQL Express is it the SQL Express linked from the Aras website, I had a problem once upon a time trying to grab the right one from the MS site. Are you using the x86 version of IE?
Best guess is if you can't do the ECR the old fashioned way, try to uninstall, verify all the OS stuff above and re-install.
Good luck,
Don
dstephen - Monday, October 17, 2011 9:29 AM:
Hi again,
I'm assuming your using 9.3.0
Was reading Brian's post and it gave me an idea.
I created a fresh Innovator Solutions db and checked for a user with the id = 3AC82B5B2BC94E12909FC4017DBA2DA6 . This was the locked_by_id on the ECR without a keyed_name from your message above. <locked_by_id keyed_name="">3AC82B5B2BC94E12909FC4017DBA2DA6</locked_by_id> . I don't see any user in a fresh db that has that ID. The Innovator Admin user is 30B991F927274FA3829655F50C99472E.
Could you have played with adding users/deleting users? Not having a keyed_name for a user generally means that the first name and last name were not filled in when completing the new user form.
Don
jpayne - Monday, October 17, 2011 7:57 AM:
Brian,
Thank you for the response. We have not done anything else to the system except save parts. We just started trying to use it. So this could be due to my ignorance of the software. I was logged in as the system admin.
What is the best way to wipe the database? We have nothing in there so starting over is no problem. I would have thought that the current install but we can certainly try again.
No other information was put into the part. Should there be?
Thank You,
- Jason
jpayne - Monday, October 17, 2011 10:00 AM:
I tried adding the Part the old fashioned way you outlined above. It still came up with the same error. I will ask out IT about the install questions you asked.
jpayne - Monday, October 17, 2011 10:05 AM:
Yes we are using 9.3.0. The install has 4 users installed. I double check them and they all have First and Last names. But maybe something was done with them that corrupted the data base. The 3AC user is my login. I tried to save an ECR as the innovator adminstrator and I get a similar error. It is looking like a reinstall.
Is their an easy way to create a new db that I can show our IT department? They may already know but if their is an easy way I would appreciate you letting us know.
Brian - Monday, October 17, 2011 5:39 PM:
Hi Jason,
There is a document on this page http://www.aras.com/support/documentation/ called Backup and Recovery.
It goes through how to add a database from a backup.
In your download of Innovator there will be a "CoreandSolutions.bak" file that is the empty database.
Create a new database in SQL Server Management Studio and restore this .bak file to that database per the document then edit the InnovatorConfig.xml file etc.
This should give you a completely clean database to try again with.
Cheers,
Brian.
jpayne - Tuesday, October 18, 2011 3:47 PM:
Thank You Brian. We did that but I could not login with the user name: admin and password: innovator as is the default from the video's. Does this backup have a different password for the admin user?
Thanks,
- Jason
Brian - Tuesday, October 18, 2011 5:19 PM:
Hi Jason,
From SQL Server Management Studio.
Select the newly restored database. Right click and select "New Query".
Paste these three commands into the new query window and execute each one separately.
exec sp_change_users_login 'Update_One', 'innovator', 'innovator'
exec sp_grantdbaccess 'innovator','innovator'
exec sp_addrolemember 'db_owner','innovator'
The 2nd one will normally display an error but that is OK.
Once you have done this you should be able to log into the database.
Cheers,
Brian.
jpayne - Tuesday, November 1, 2011 8:10 AM:
Brian,
That did the trick. We reset the database. Without doing anything else I went in and could successfully save and ECR. I then stepped through my tracks. I created a user. I was still able to save an ECR. I added all of the identies to the user with the exception of admin and super user. I could not save the ECR. I removed the identies and I could save the ECR logged in as that user again.
I added just admin identies, no other identies, to the user and I could not save the ECR again. Apparently it is my ignorance to the identies. I will post more to this if I figure anything else out.
Thanks for all of your help,
- Jason
dennis - Thursday, June 19, 2014 4:07 PM:
See this post for a possible cause and fix.
