KB235345: "ORA-00917: missing comma" error is seen in DSSErrors.log files when inserting statistics into IS_PR_ANS_STATS table in MicroStrategy 9.x

SUMMARY
This technical note discusses the error encountered when inserting statistics data into the IS_PR_ANS_STATS table due to a known issue using single apostrophes in filter names.
 
SYMPTOM
The following error may be encountered in the DSSErrors.log and statistics data may be missing from the IS_PR_ANS_STATS table:
 

ORA-00917: missing comma Connection String: DSN=ENTERPRISE MANAGER WAREHOUSE;UID=mstr;HOST=mstr.com;PORT=123;SID=mstr;. SQL Statement: insert into IS_PR_ANS_STATS ...

 
NOTE:  This exact error is for Oracle database but a similar error can be seen for other databases.
 
STEPS TO REPRODUCE

1. Create new filter that contains a prompt
2. Save the filter as “Filters’ Name”
3. Create a report using the filter created in step 3 above as report filter
4. Run the report choosing any prompt answer
5. The error inserting into IS_PR_ANS_STATS will be seen in the DSSErrors.log

 
CAUSE
This is a known issue in Strategy 9.x if a single apostrophe, ' , is used in the filter name which contains a prompt.  The SQL statement used to insert data into the IS_PR_ANS_STATS table incorrectly parses the name, not accounting for the single apostrophe causing an error.
 
ACTION
Contact Strategy Technical Support for an update on this defect.
 
WORKAROUND
Remove the use of the single apostrophes in filter names that contains prompts.
 
 
The Strategy Internal Reference Number for the issue discussed in this technical note is 738220.