OBIEE 11g - Gauges Not Working Intermittently (Doc ID 2072694.1)

Last updated on NOVEMBER 06, 2015

Applies to:

Business Intelligence Answers Option - Version 11.1.1.7.131017 and later
Information in this document applies to any platform.

Symptoms

Problem occurs with both 11.1.1.7.131017 and 11.1.1.9.0. 

Gauges breaking on the dashboard once in 2-3 weeks. 
Need to bounce the services and restart BI System components in order to get environment to work again. 

Logs show the following error at the time of the issue: 

 

Sawlog:

[2015-05-20T06:00:30.000-04:00] [OBIPS] [ERROR:16] [] [saw.rpc.mis.read] [ecid: 0000Sm2DO5VF4EG6yzV^6G0003QK00000w,0:1:2:2:1:328] [tid: 908] RPCServer returned a error: Error while executing DVTChartRpcCall.processMessage

oracle.bi.nanserver.fwk.exception.BISvsException: oracle.bi.nanserver.fwk.exception.BISvsException: java.lang.NullPointerException

                at com.siebel.analytics.web.javahostrpccalls.dvt.DVTChartRpcCall.processMessageInternal(DVTChartRpcCall.java:220)

                at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:251)

                at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:193)

                at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)

                at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:207)

                at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:155)

                at java.lang.Thread.run(Thread.java:662)

Caused by: oracle.bi.nanserver.fwk.exception.BISvsException: java.lang.NullPointerException

                at oracle.bi.nanserver.svs.viewgen.dvt.chart.GaugeChartProcessor.generatePNG(GaugeChartProcessor.java:206)

                at oracle.bi.nanserver.svs.viewgen.dvt.chart.ChartProcessorBase.generateChart(ChartProcessorBase.java:191)

                at oracle.bi.nanserver.svs.viewgen.dvt.chart.ChartViewGenSvsImpl.generateView(ChartViewGenSvsImpl.java:113)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                at java.lang.reflect.Method.invoke(Method.java:597)

                at oracle.bi.nanserver.fwk.service.BISvsProxy.invoke(BISvsProxy.java:53)

                at $Proxy5.generateView(Unknown Source)

                at com.siebel.analytics.web.javahostrpccalls.dvt.DVTChartRpcCall.processMessageInternal(DVTChartRpcCall.java:188)

                ... 6 more

Caused by: java.lang.NullPointerException

                at oracle.dss.gauge.DrawableObject.convertSFXMapToGradientObj(DrawableObject.java:400)

                at oracle.dss.gauge.DrawableObject.render(DrawableObject.java:237)

                at oracle.dss.gauge.GaugeEngine._renderObjList(GaugeEngine.java:1858)

                at oracle.dss.gauge.GaugeEngine.render(GaugeEngine.java:445)

                at oracle.dss.gauge.CommonGauge._renderGauges(CommonGauge.java:3864)

                at oracle.dss.gauge.CommonGauge.renderGauges(CommonGauge.java:3572)

                at oracle.dss.gauge.CommonGauge.exportToPNGWithException(CommonGauge.java:2498)

                at oracle.bi.nanserver.svs.viewgen.dvt.chart.GaugeChartProcessor.generatePNG(GaugeChartProcessor.java:203)

                ... 15 more

[[

File:rpc.cpp

Line:473

Location:

                saw.rpc.mis.read

                saw.threadpool.chartthreadpool

                saw.threads

ecid: 0000Sm2DO5VF4EG6yzV^6G0003QK00000w,0:1:2:2:1:328

ThreadID: 908

]]

[2015-05-20T06:00:30.000-04:00] [OBIPS] [ERROR:31] [] [saw.rpc.mis.read] [ecid: 0000Sm2DO5VF4EG6yzV^6G0003QK00000w,0:1:2:2:1:328] [tid: 908] A fatal error occurred while processing the request. The server responded with: oracle.bi.nanserver.fwk.exception.BISvsException: java.lang.NullPointerException.[[

File:rpc.cpp

Line:479

Location:

                saw.rpc.mis.read

                saw.threadpool.chartthreadpool

                saw.threads

ecid: 0000Sm2DO5VF4EG6yzV^6G0003QK00000w,0:1:2:2:1:328

ThreadID: 908

JavaHost Logs:

[2015-05-20T06:00:30.881-04:00] [dvt] [WARNING] [] [saw.dvt] [tid: 16] [ecid: 0000Sm2DO5VF4EG6yzV^6G0003QK00000w,0:1:2:2:1:329:1] Error[[

oracle.bi.nanserver.fwk.exception.BISvsException: oracle.bi.nanserver.fwk.exception.BISvsException: java.lang.NullPointerException

                at com.siebel.analytics.web.javahostrpccalls.dvt.DVTChartRpcCall.processMessageInternal(DVTChartRpcCall.java:220)

                at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:251)

                at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:193)

                at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)

                at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:207)

                at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:155)

                at java.lang.Thread.run(Thread.java:662)

Caused by: oracle.bi.nanserver.fwk.exception.BISvsException: java.lang.NullPointerException

                at oracle.bi.nanserver.svs.viewgen.dvt.chart.GaugeChartProcessor.generatePNG(GaugeChartProcessor.java:206)

                at oracle.bi.nanserver.svs.viewgen.dvt.chart.ChartProcessorBase.generateChart(ChartProcessorBase.java:191)

                at oracle.bi.nanserver.svs.viewgen.dvt.chart.ChartViewGenSvsImpl.generateView(ChartViewGenSvsImpl.java:113)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                at java.lang.reflect.Method.invoke(Method.java:597)

                at oracle.bi.nanserver.fwk.service.BISvsProxy.invoke(BISvsProxy.java:53)

                at $Proxy5.generateView(Unknown Source)

                at com.siebel.analytics.web.javahostrpccalls.dvt.DVTChartRpcCall.processMessageInternal(DVTChartRpcCall.java:188)

                ... 6 more

Caused by: java.lang.NullPointerException

                at oracle.dss.gauge.DrawableObject.convertSFXMapToGradientObj(DrawableObject.java:400)

                at oracle.dss.gauge.DrawableObject.render(DrawableObject.java:237)

                at oracle.dss.gauge.GaugeEngine._renderObjList(GaugeEngine.java:1858)

                at oracle.dss.gauge.GaugeEngine.render(GaugeEngine.java:445)

                at oracle.dss.gauge.CommonGauge._renderGauges(CommonGauge.java:3864)

                at oracle.dss.gauge.CommonGauge.renderGauges(CommonGauge.java:3572)

                at oracle.dss.gauge.CommonGauge.exportToPNGWithException(CommonGauge.java:2498)

                at oracle.bi.nanserver.svs.viewgen.dvt.chart.GaugeChartProcessor.generatePNG(GaugeChartProcessor.java:203)

                ... 15 more

Implemented workaround as suggested in Bug 19057029  and added new report with gauges  and fact column having IFNULL condition.

However, this did not help to resolve the problem. 

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