Summary
When try to add the user in to the Projects getting the below error.
We are adding this user by using the Site Admin role, not sure why we are getting the error.
Question
Messages:
Failed to Add Users To Projects;
Failed to add users sgud003 to project Mobile;
Stack Trace:
com.mercury.optane.core.CTdException: Failed to add users sgud003 to project Mobile;
Answer
As checked in the salog file, there is the SQL statement send from the ALM to DB on adding the user into the project & failed at the DB side as below..
"
Failed SQL: INSERT INTO USERS (US_USERNAME) VALUES (/*P*/'sgud003')
ORA-04031: unable to allocate 4192 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","modification ")
Fix:
Requested customer to have just bounced the DB to refresh the shared momory issue to resolve the issue & restarted the HP QC service.
After that we are able to add the users to Projects.