BAM 11g: Data Object Using EDS Generates SQLSYNTAXERROREXCEPTION_REPORTSERVER_BARCHART_INITIALIZE
(Doc ID 1568262.1)
Last updated on APRIL 23, 2019
Applies to:
Oracle BAM (Business Activity Monitoring) - Version 11.1.1.6.0 and laterInformation 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)
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |