Symptom
Story Report Query Preview displays error when we add Feedback Comment Field from Ask for Feedback Table
This error displays in network logs: "SAP DBTech JDBC: [3]: fatal error: invalid CESU-8 encoding for Unicode string"
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
People Analytics
Report Stories
Embedded Analytics
Reproducing the Issue
1. Create a Story report query with Performance Management domain
2. Join Ask For Feedback table and select Feedback Comment field
3. Click on Preview Query
Result You will get an error of We found an issue while processing the request. For assistance, please contact the administrator or the SAP Product Support team, if needed.
Correlation ID: xxx-xxxx-xxxx
This is the error displayed in Network Logs
"SAP DBTech JDBC: [3]: fatal error: invalid CESU-8 encoding for Unicode string"
Cause
There are emoji or invalid characters added in Feedback Comments provided by the user that makes data incompatible to CESU-8 and UTF-8.
Resolution
Ask users to avoid using emoji characters on their comment for Ask for Feedback
Keywords
Feedback Comment, Ask for Feedback, Story, People Analytics, Performance Management, invalid CESU-8, Error , KBA , LOD-SF-ANA-SAC-FWK , Framework, Infrastructure, Network, Performance , Problem