[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Problem : composite document with 2 parameters and and an Olap document (mondrian)  XML
Forum Index » Technical Help - SpagoBI Server - OTHER DOMAINS
Author Message
huvernes.spw

Newby

Joined: 30/08/2010 11:47:01
Messages: 21
Offline

Hi,

In a composite document, I made a document with 2 graph documents whith 2 parameters, the composite document takes the two parameters coming from a first stacked bar document for displaying/refreshing a another stacked bar second document.

But when I replace the second document with an olap document with the two same parameters, the first time the olap document is correctlly displayed with the default values, but when clicking for refreshing, I get the following error in the Olap window:
--------------------
<html><body>

<h2>java.lang.IllegalStateException: concurrent requests and no busy.jsp defined in web.xml</h2><pre>
java.lang.IllegalStateException: concurrent requests and no busy.jsp defined in web.xml
at com.tonbeller.wcf.controller.RequestFilter$MyHandler.showBusyPage(RequestFilter.java:185)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:14
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:221)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:29
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:774)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:896)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

If I just keep one parameter, the refreshing OLAP document is OK,
If I execute the Olap document directly with the two parameters entered at keybord, it works too.
Is it possible to use more than one parameter in an Olap doc in a composite document ?

Thank's
Hugo



giachino

SpagoBI hero
[Avatar]

Joined: 05/07/2010 15:41:54
Messages: 355
Location: Turin, Italy
Offline

Hi Ugo,
when JPIvot catches a 'busy' problem, it means the a new request is started without that the previous one is ended. Maybe it needs more times to terminate the loading of all data.

In the olap/web.xml file you can set some jsp that JPivot uses in some contexts. Here an example:




If you active this section the stack trace of the exception could be disappear...but the problem will persist if you don't give the necessary time to load all data.

Regards,

Antonella

Antonella Giachino
SpagoBI Consultant
[Email]
huvernes.spw

Newby

Joined: 30/08/2010 11:47:01
Messages: 21
Offline

Hi Antonella,

In that case of document composite, if a document is busy, may be that the Olap cube is executed twice with each parameters instead once with two parameters,

the config is : 1 stacked bar -> 2 parameters -> refresh 1 cube.

May be, it is problem with the configuration

<DOCUMENT sbi_obj_label="STACKED_BAR" local_file_name="STACKED_BAR.xml">
<PARAMETERS>
<PARAMETER type="OUT" sbi_par_label="domain" default_value="domain1" >
<REFRESH>
<REFRESH_DOC_LINKED labelDoc="CUBE" labelParam="domain" />
</REFRESH>
</PARAMETER>
<PARAMETER type="OUT" sbi_par_label="year" default_value="Y2009">
<REFRESH>
<REFRESH_DOC_LINKED labelDoc="CUBE" labelParam="year" />
</REFRESH>
</PARAMETER>
</PARAMETERS>
<STYLE .../>
</DOCUMENT>

coud-it be configured to call one refresh with the two parameters ?


Thank's

Hugo
giachino

SpagoBI hero
[Avatar]

Joined: 05/07/2010 15:41:54
Messages: 355
Location: Turin, Italy
Offline

Hi Hugo,
your configuration appears correct...

In fact the cross navigation doesn't start for each parameter that you set in OUT mode... but it runs one only time.

This is an example that run correctly:


In this example, you see, that the document 'rptVolumi_3' is called 4 times... but it's refreshed only one time!

Are you sure that between the first loading and the click ... the olap is totally loaded?

The logs tell you more informations?

Antonella


Antonella Giachino
SpagoBI Consultant
[Email]
huvernes.spw

Newby

Joined: 30/08/2010 11:47:01
Messages: 21
Offline

Hi Antonella,

OK for the explanation of one time execution,
the first loading works and the first click became after end of display,

the log SpagoBIJPivot indicate a concurrent request :

ERROR com.tonbeller.wcf.controller.RequestFilter.doFilter:277 - Error handling request
java.lang.IllegalStateException: concurrent requests and no busy.jsp defined in web.xml
at com.tonbeller.wcf.controller.RequestFilter$MyHandler.showBusyPage(RequestFilter.java:185)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:14
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:221)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:29
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:774)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:896)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:636)


1- the second part of config is
<DOCUMENT sbi_obj_label="CUBE" local_file_name="CUBE.xml">
<PARAMETERS>
<PARAMETER type="IN" sbi_par_label="domain" default_value="domain1" >
</PARAMETER>
<PARAMETER type="IN" sbi_par_label="year" default_value="Y2007">
</PARAMETER>
</PARAMETERS>
<STYLE style="position:absolute;margin:0px;left:500px;top:0px;width:469px;height:500px;" mode="auto"/>
<id>CUBE</id>
</DOCUMENT>

2 -This config works with this following composite document
1 pie for first output argument, 1 bar for the second output argument (instead of the stackedbar) and the olap cube with the two arguments on input

Hugo
giachino

SpagoBI hero
[Avatar]

Joined: 05/07/2010 15:41:54
Messages: 355
Location: Turin, Italy
Offline

ok...

if you click on the pie and then on the bar , probably the second doesn't wait the necessary time...

If this isn't your case.. it's strange... and we should test a case similar your.

Logically it should to work.

Anto

Antonella Giachino
SpagoBI Consultant
[Email]
huvernes.spw

Newby

Joined: 30/08/2010 11:47:01
Messages: 21
Offline

strange, I agree

OK => doc composite : pie (arg1), bar(arg2), olap jpivot (arg1,arg2)
no OK => doc composite : stacked bar(arg1,arg2), olap jpivot (arg1,arg2)

OK => stacked bar standalone (arg1,arg2) + cross navigation new document olap jpivot (arg1,arg2)

the 3 documents are the same in the 3 cases.

the olap is JPivotEngine document
the stacked bar is Dashboard/ChartEngine document
SpagoBI version 2.6
java java-6-openjdk
os ubuntu 8.

Regard's
Hugo
 
Forum Index » Technical Help - SpagoBI Server - OTHER DOMAINS
Go to:   
Powered by JForum 2.1.9 © JForum Team