Apostrophe Causing Fatal Errors

Document ID : KB000097541
Last Modified Date : 01/06/2018
Show Technical Document Details
Issue:
When a user's last name has an apostrophe in it such as "O'brien", PPM will throw errors in the app_ca log as follows:

FATAL 2018-04-24 06:42:24,825 [http-nio-14001-exec-135] union.persistence (clarity:bob.o'brien@mycompany.com:71975596__98C9D029-7ED8-44FC-8E64-6D91B2A6596D:npt.overview) java.sql.SQLClientInfoException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 45: PLS-00103: Encountered the symbol "BRIEN" when expecting one of the following: ) , * & = - + < / > at in is mod remainder not rem => <> or != or ~= >= <= <> and or like like2 like4 likec as between from using || multiset member submultiset The symbol "," was substituted for "BRIEN" to continue. ORA-06550: line 1, column 60: PLS-00103: Encountered the symbol "); END;" when expecting one of the following: . ( ) , * @ & = - + < / > at in is mod remainder not rem => <> or != or ~= >= <= <> and or like like2 like4 likec between...

 
Environment:
CA PPM 14.4 and above
Resolution:
This is a known defect - DE41427 - Fixed in 15.5 GA