ROUND, FLOOR and CEILING Functions Causing "BAM-01611: Math expression contains a non-numeric operand" when Using Calculated Fields

(Doc ID 1317060.1)

Last updated on DECEMBER 21, 2012

Applies to:

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

Symptoms

When a calculated field is using the FLOOR, ROUND or CEILING function in an expression, the following error is thrown before the calculated field is created:

BAM-01611: Math expression contains a non-numeric operand

 

[ERROR] [] [oracle.bam.adc] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 11d1def534ea1be0:-6286606a:12e90d9b309:-8000-00000000000002a6,0] [APP: oracle-bam#11.1.1] ActiveDataCache: Exception occurred in method openViewset(_NR_DO,0)[[
Exception: oracle.bam.adc.common.exceptions.InvalidExpressionException: BAM-01611: Math expression contains a non-numeric operand.
at oracle.bam.adc.common.core.ExpressionValidation.validateMathExpression(ExpressionValidation.java:85)
at oracle.bam.adc.common.core.ExpressionValidation.validateExpression(ExpressionValidation.java:744)
at oracle.bam.adc.kernel.datasets.ModifierExpander.validateCalculatedFields(ModifierExpander.java:92)
...
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
]]

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