Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem with rendering graph

785482Jul 23 2010 — edited Mar 20 2013
Hi OTN,

In my ADF BC application I have a requirement of displaying data in a barGraph. Also I need to apply some simple ViewCriterias adding "WHERE attr = value" clause at run-time.
In addition I dropped a VO as a table - to be sure that data is ok.

I apply ViewCriteria through ApplicationModule method exposed to client interface - using a commandButton and selectMultipleCheckbox (there are seven variants of criteria).

Initially the graph is diplayed and everything's fine. And six of seven criterias are fine too.
But when applying one of them the graph disappears and an exception is thrown. Dispite this I see that the data in a table are correct and the criteria was applied. Something's wrong with a graph.
Here's a stacktrace:
<ImageViewRendererUtils><renderXML> Could not export XML to ResponseWriter
oracle.dss.graph.pfj.AssertionException: Empty Cell for row = 0, col = 0
	at oracle.dss.graph.pfj.DataStorage.getData(DataStorage.java:321)
	at oracle.dss.graph.pfj.Perspective.insertMissingDates(Perspective.java:2324)
	at oracle.dss.graph.pfj.Perspective.checkIfBusinessDays(Perspective.java:2275)
	at oracle.dss.graph.pfj.Perspective.checkGroupLabels(Perspective.java:1322)
	at oracle.dss.graph.pfj.Perspective.setDataFromDataGrid(Perspective.java:15617)
	at oracle.dss.graph.pfj.Perspective.sendXMLToStreamExc(Perspective.java:11984)
	at oracle.dss.graph.CommonGraph.exportToXMLWithException(CommonGraph.java:7885)
	at oracle.adfinternal.view.faces.bi.renderkit.imageView.ImageViewRendererUtils.renderXML(ImageViewRendererUtils.java:1251)
	at oracle.adfinternal.view.faces.bi.renderkit.imageView.ImageViewRendererUtils.encodeBeginXMLAsComment(ImageViewRendererUtils.java:712)
	at oracle.adfinternal.view.faces.bi.renderkit.graph.RichGraphRenderer.encodeFlashGraphAndClientProperties(RichGraphRenderer.java:1084)
	at oracle.adfinternal.view.faces.bi.renderkit.imageView.RichImageViewRenderer.encodeFlashAndClientProperties(RichImageViewRenderer.java:1331)
	at oracle.adfinternal.view.faces.bi.renderkit.imageView.RichImageViewRenderer.encodeAll(RichImageViewRenderer.java:917)
	at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1369)
	at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
	at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:765)
	at org.apache.myfaces.trinidad.component.UIXComponentBase.__encodeRecursive(UIXComponentBase.java:1515)
	at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeAll(UIXComponentBase.java:785)
	at oracle.adfinternal.view.faces.util.rich.InvokeOnComponentUtils$EncodeChildVisitCallback.visit(InvokeOnComponentUtils.java:113)
	at org.apache.myfaces.trinidadinternal.context.PartialVisitContext.invokeVisitCallback(PartialVisitContext.java:222)
	at org.apache.myfaces.trinidad.component.UIXComponent.visitTree(UIXComponent.java:378)
	at org.apache.myfaces.trinidad.component.UIXComponent.visitTree(UIXComponent.java:326)
	at org.apache.myfaces.trinidad.component.UIXComponent.visitTree(UIXComponent.java:443)
	at org.apache.myfaces.trinidad.component.UIXComponent.visitTree(UIXComponent.java:326)
	at org.apache.myfaces.trinidad.component.UIXComponent.visitTree(UIXComponent.java:443)
	at org.apache.myfaces.trinidad.component.UIXComponent.visitTree(UIXComponent.java:326)
	at org.apache.myfaces.trinidad.component.UIXComponent.visitTree(UIXComponent.java:443)
	at org.apache.myfaces.trinidad.component.UIXComponent.visitTree(UIXComponent.java:326)
	at org.apache.myfaces.trinidad.component.UIXComponent.visitTree(UIXComponent.java:443)
	at oracle.adfinternal.view.faces.util.rich.InvokeOnComponentUtils.renderChild(InvokeOnComponentUtils.java:43)
	at oracle.adfinternal.view.faces.streaming.StreamingDataManager._pprComponent(StreamingDataManager.java:611)
	at oracle.adfinternal.view.faces.streaming.StreamingDataManager.execute(StreamingDataManager.java:460)
	at oracle.adfinternal.view.faces.renderkit.rich.DocumentRenderer._encodeStreamingResponse(DocumentRenderer.java:3200)
	at oracle.adfinternal.view.faces.renderkit.rich.DocumentRenderer.encodeAll(DocumentRenderer.java:1245)
	at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1369)
	at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
	at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:765)
	at org.apache.myfaces.trinidad.component.UIXComponentBase.__encodeRecursive(UIXComponentBase.java:1515)
	at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeAll(UIXComponentBase.java:785)
	at javax.faces.component.UIComponent.encodeAll(UIComponent.java:942)
	at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:271)
	at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:202)
	at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:189)
	at org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:193)
	at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._renderResponse(LifecycleImpl.java:710)
	at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:273)
	at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:205)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
	at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:191)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:97)
	at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:420)
	at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
	at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:420)
	at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:247)
	at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:157)
	at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:94)
	at java.security.AccessController.doPrivileged(Native Method)
	at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
	at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:414)
	at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:138)
	at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:330)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Type of graph dvt:barGraph, ADF BC, Jdeveloper 11.1.1.3

Is there any solution of this problem?

Comments

785482
New details found:
the problem ocurres only when I set ORDER BY clause. Tested several times, w/o ORDER BY it works fine.
The clause orders data by date.

Also tried setting sorting order in pageDef (in iterator) - same result.

Any ideas?
812206
Hello,

I have the same scenario.

Did you find any solution or workaround for the problem?

cheers,
gabor
User_PN9GP
I've encountered the same error today and thanks to your hint I could find a solution to the problem.

I'd queried a date value, ordered all the data by this date value and finally used the date value on the x-axis of a diagram.

After changing this date to a character value (to_char(date_val,'dd.mm.yyyy')) it worked fine. I just had to change the sort criteria to to_char(date_val, 'yyyy.mm.dd') and use the other value(to_char(date_val,'dd.mm.yyyy')) as the displayed value on the diagrams x-axis.


Hope this helps.
950525
We are also facing the same issue for dvt:linegraph. Without order by graph is rendering, with order by its giving exception.

Anybody found solution for the same?

Edited by: 947522 on Mar 20, 2013 5:22 AM
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 17 2013
Added on Jul 23 2010
4 comments
900 views