WCC view stuck on "loading data", in collector.log error ORA-01425: escape character must be character string of length 1

Document ID : KB000048255
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

WCC view is stuck on "loading data".
In collector.log gets the messages :


@collector  ERROR #ViewsUpdater                       # Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: [CA][Oracle JDBC Driver][Oracle] ORA-01425: escape character must be character string of length 1 Error Code: 1425 Call: SELECT t1."ID", t1."DTYPE", t1."AGENT_STATUS", t1."CREATE_TIME", t1."END_TIME", t1."MACHINE", t1."MOD_TIME", t1."NAME", t1."NEXT_TIME",
t1."OWNER", t1."RUN_NUM", t1."START_TIME", t1."STATUS_TIME", t1."TARGET_MACHINE", t1."TIMEZONE", t1."TYPE", t1."SERVER_ID", t1."STATUS_ID",
t1."AGENT_LSTATUS", t1."APPLICATION", t1."EXIT_CODE", t1."GROUP", t1."JOID", t1."LINEAGE", t1."NTRY", t1."PRIORITY", t1."BOX_ID" FROM
"MON_JOB_STATUS" t0, "MON_JOB" t1 WHERE ((((t1."SERVER_ID" = ?) AND ...

Solution:

This problem is encountered when Oracle is configured for WCC monitoring database.

The problem can be worked around by changing the Oracle "cursor_sharing"parameter from "FORCE" to "EXACT".

There is also a known problem in this area reported on Oracle 11.2.0.1 release.

This problem can be addressed by Oracle upgrade to 11.2.0.4 release.