Apostrophe in Resource 'User Name' generates Fatal error messages in app-ca.log log file

Document ID : KB000100737
Last Modified Date : 29/01/2019
Show Technical Document Details
Issue:
Apostrophe in Resource 'User Name' generates Fatal error messages in app-ca.log log file 
when the user navigates around CA PPM application, for example in Project list, Project Properties, 
to mention but a few. 
App-ca.log file is filled with these errors: 

FATAL 2018-05-11 08:31:01,471 [http-nio-80-exec-122] union.persistence (clarity:peter.o'Lane@ca.com:9985056__D1A952BF-4AFE-4988-AD9A-3FC25875D224:odata.GetNavigatorMenuBean) 
java.sql.SQLClientInfoException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 45: 
PLS-00103: Encountered the symbol "LANE" when expecting one of the following: 
) , * & = - + < / > at in is mod remainder not rem => 
<> or != or ~= >= <= <> and or default 
like like2 like4 likec as between from using || multiset 
member submultiset 
The symbol "," was substituted for "LANE" to continue. 
ORA-06550: line 1, column 60: 

STEPS TO REPRODUCE 

1. Create a labor resource with user name: peter.o'lane@ca.com and assign Project and Resource access rights. 
2. Login to CA PPM as the user created in step 1 above and navigate to Project list or a Project Properties page. 
3. Review the app-ca.log file 

Expected app-ca.log file to be clean 
Actual Results: app-ca.log file is filled with Fatal errors messages 
Resolution:
Defect ID: DE41427
Fixed in CA PPM15.5