Failed to Add Users To Projects;
Failed to add users sgud003 to project Mobile;
com.mercury.optane.core.CTdException: Failed to add users sgud003 to project Mobile;
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 ")
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.