Applications Systems

Character Set Mismatch error occurs when a user attempts to open the DPA Storage I/O tab

When you are attempt to open the Storage I/O tab in DPA, the page will not load and an error similar to the following is displayed: ORA-12704: character set mismatch

First published date

11/9/2018 4:22 PM

Last published date

11/9/2018 4:22 PM

Overview

When you are attempt to open the Storage I/O tab in DPA, the page will not load and an error similar to the following is displayed:

 

Unable to generate the chart: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into CONDATA1_TEMP(ID,NAME,VALUE) select TOPN.FILEID,COALESCE(F.NAME, 'NULL'),TOPN.RANK from CONF_14 F,(select * from (select FILEID,sum(SCORE) RANK from (select FILEID,READ_LATENCY_SCORE SCORE from CON_IO_DAY_14 where D between ? and ? and READ_LATENCY_SCORE > 0 union all select FILEID,READ_LATENCY_SCORE SCORE from CON_IO_HOUR_14 where D between ? and ? and D >= ? and READ_LATENCY_SCORE > 0) ALLDATA where FILEID not in (select ID from CON_IO_EXCLUSIONS where DBID=14 and TYPE='F' union select FILEID from CONF_DRIVE_MAP_14 DM, CON_IO_EXCLUSIONS FE where DM.DRIVEID=FE.ID and FE.TYPE='D' and FE.DBID=14) group by FILEID order by RANK desc) where rownum <= 100) TOPN where F.ID=TOPN.FILEID]; SQL state [72000]; error code [12704]; ORA-12704: character set mismatch ; nested exception is java.sql.SQLException: ORA-12704: character set mismatch 
 

Environment 

  • DPA version 11.1
  • Oracle repository database with a double-byte character set

Product section

Database Performance Analyzer

Cause

There was an issue with the query used to poll the data from the repository. 

Resolution

This issue has been fixed in DPA 12.0. Please upgrade to resolve the error.