Clarity PPM

Expand all | Collapse all

Error: [CA Clarity][Oracle JDBC Driver]Transliteration failed, reason: invalid UTF8 data

  • 1.  Error: [CA Clarity][Oracle JDBC Driver]Transliteration failed, reason: invalid UTF8 data

    Posted 11-12-2018 11:01 AM
      |   view attached

    I’m trying to execute a XOG to read user information. I’m having trouble with a specific user. The XOG returns the following error:

    <Description>User Object read failed</Description><Exception><![CDATA[
    java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Transliteration failed, reason: invalid UTF8 data

    It only happens with this user. I have checked the information on the screen and I couldn’t find any field that looked like it has characters that are not UTF8.
    I checked the table NLS_DATABASE_PARAMETERS and the characterset is set to UTF8.



  • 2.  Re: Error: [CA Clarity][Oracle JDBC Driver]Transliteration failed, reason: invalid UTF8 data

    Posted 11-12-2018 08:05 PM

    Have you checked the log files.

     

    Though the data may appear compliant on the UI, potentially the XOG scripts you are reading are pulling down additional information (eg Role ID for Primary Role, Department ID for Department, as well as Contact Information which is available on a second page of the Resource). 

     

    The log files may point to the challenged attribute.



  • 3.  Re: Error: [CA Clarity][Oracle JDBC Driver]Transliteration failed, reason: invalid UTF8 data

    Posted 11-13-2018 02:48 AM

    Hi Silva,

     

    Can you share the init.ora files or health report if you are 15.2 and above

     

    Regards

    Suman Pramanik