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

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 hundreds of Community platforms