BusinessObjects Board

Dashboard Design SWF issue

other Xcelsius - Crystal Dashboard Design
#1

Hi,
I am getting repeated dashboard error messages when running against our BOE 4.0 SP7 BI Platform via Web Service connections (BIWS) after a period of time. Currently, we have developed 33 BIWS connections in data manager. Running them individually is fine.

Question: Is there a limitation on how many BIWS requests that can be submitted at once? Seems like the magic number is 20.

Example errors that we see:
com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException

An internal error occured while calling ‘loadState’ API. (Error: ERR_WIS_30270)

To test this we broke out the remaining 13 BIWS using a Connection Refresh component to “delay” the refresh a bit until the last of the first 20 finished first. The next batch do not kick off a refresh until the last of the first 20 BIWS complete. However, this did not work.

We also tried creating multiple BO Enterprise service user accounts and assigned per group of BIWS connections. This seemed a bit more stable but only bought a little more time, hence, we eventually received the same error message after more stress testing.

Does this have to do with a WEBI PRocessing Server limitation on how many repository objects can be accessed at one time? Or does this have to do with the web.properties “Storage_Token_Stack_Size”? Which currently by default is 11. Found here: <install_dir>\Tomcat6\webapps\BOE\WEB-INF\eclipse\plugins\webpath.AnalyticalReporting\web\WEB-INF\classes\

We have also tried removing the check box “Save for All Users” from the published BIWS block but did not resolve.

Has anyone come across this scenario in the past? Does this appear to be a configuration issue to handle the number of requests?

Thanks,
Phil

pmm150 (BOB member since 2008-11-14)

#2

Hi Phil

33 BIWS is a lot, especially if they are all firing at the same time - do you have to do this, or can they be more on demand/on click driven refreshes?

Can you consolidate the queries, i.e. merging 2 or 3 blocks in WebI to create one larger BIWS block?

Adding another WebI Proc Server may help…

cdavies :uk: (BOB member since 2005-01-28)

#3

Thanks for your reply.

We broke out the BIWS into batches to fire off/retrieve the first 20, then use the refresh connection component to trigger/launch the remaining 13 when the 20th BIWS finished successfully.

We also have tried adding the property “qaaws.closedocument=true” to \dswsbobje\WEB-INF\classes\dsws.properties.

Someone also mentioned to split up the BIWS connections using several Enterprise service accounts instead.

-Phil

pmm150 (BOB member since 2008-11-14)

#4

same issue here anyone find a solution,

thanks in advance,

Jose

josecs90 (BOB member since 2014-08-20)

#5

We upgraded to BOE 4.1 SP4. Seems to help quite a bit but does not explain the root cause of the core issue.

pmm150 (BOB member since 2008-11-14)