My Oracle Support Banner

BAM 11g: Data Object Using EDS Generates SQLSYNTAXERROREXCEPTION_REPORTSERVER_BARCHART_INITIALIZE (Doc ID 1568262.1)

Last updated on JULY 11, 2013

Applies to:

Oracle SOA Platform - BAM (Business Activity Monitoring) - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

An external view is used for a data object. One of the columns has the type varchar2(4000).
If a report is grouped after the column that has the type varchar2(4000) the following exceptions are generated:

In the Report:

SQLSYNTAXERROREXCEPTION_REPORTSERVER_BARCHART_INITIALIZE

In the logs:

[2013-05-21T12:09:59.738+08:00] [bam_server1] [ERROR] [] [oracle.bam.adc] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: d56456a611d76266:-3f77e869:13ebbd9bc0b:-8000-0000000000007895,0] [APP: oracle-bam#11.1.1] ActiveDataCache: Exception occurred in method openViewset(_bam_lgt_veh_apply_v,0)[[
Exception: oracle.bam.adc.common.exceptions.InvalidUseOfClobException: BAM-01299: One of the Sting columns being used as a filter, group by, or sort in this view is too large。
at oracle.bam.adc.dse.oracle.OracleExceptionHelpers.getStorageException(OracleExceptionHelpers.java:142)
at oracle.bam.adc.dse.oracle.OracleStorageEngine.getDataTable(OracleStorageEngine.java:1063)
at oracle.bam.adc.kernel.viewsets.ViewsetBase.runGroupQuery(ViewsetBase.java:571)
......
Caused by: java.sql.SQLSyntaxErrorException: SQLError(932) SQLState(42000) ORA-00932: inconsistent datatypes: expected - got CLOB
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

 

Changes

 The length for the column type VARCHAR2 is automatically set by the database to 4000.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.