Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error in WAD Template when no data.

Hi All!!

I'm working with BW 7 SP 15

I have a query that has the characteristic 0FISPER in the Columns side, above the key figures, so the query displays the data per month.

The problem is when I include this query into a WAD Template and I set the property "new lines" to 1, when this template is executed and the result is empty the following error appears (only when there're no data to display and only when 0FISPER is above key figures, when I put 0FISPER on rows side, It does it correctly):

<i><b>Invalid state: Section I is valid, but neither II nor III.

java.lang.RuntimeException: Invalid state: Section I is valid, but neither II nor III.

at com.sap.ip.bi.webapplications.ui.items.analysis.virtualmatrix.impl.VirtualMatrixBlockMerge.init(VirtualMatrixBlockMerge.java:137)

at com.sap.ip.bi.webapplications.ui.items.analysis.control.AcPivotTableExport.validateRendering(AcPivotTableExport.java:510)

at com.sap.ip.bi.webapplications.ui.items.analysis.control.AcPivotTableInteractive.buildUrTree(AcPivotTableInteractive.java:325)

at com.sap.ip.bi.webapplications.ui.framework.base.impl.CompositeBuildUrTreeTrigger.process(CompositeBuildUrTreeTrigger.java:33)

at com.sap.ip.bi.webapplications.ui.framework.base.composites.UiRootContainer.iterateOverChildren(UiRootContainer.java:40)

[...]

Query String (Current Browser Request) BI_COMMAND=&BI_COMMAND-BI_ADVANCED=DLG_VARIABLE_DropdownVariants&BI_COMMAND-BI_COMMAND_TYPE=PASSIVE_VALUE_TRANSFER&BI_COMMAND-PASSIVE_ID=DLG_VARIABLE_DropdownVariants_combobox&BI_COMMAND-PASSIVE_VALUE=&BI_COMMAND-TARGET_DIALOG_REF=DLG_VARIABLE&BI_COMMAND_1=&BI_COMMAND_1-BI_ADVANCED=DLG_VARIABLE_VAR_1_INPUT&BI_COMMAND_1-BI_COMMAND_TYPE=PASSIVE_VALUE_TRANSFER&BI_COMMAND_1-PASSIVE_ID=DLG_VARIABLE_VAR_1_INPUT_inp&BI_COMMAND_1-PASSIVE_VALUE=1&BI_COMMAND_1-TARGET_DIALOG_REF=DLG_VARIABLE&BI_COMMAND_2=&BI_COMMAND_2-BI_ADVANCED=DLG_VARIABLE_VAR_2_INPUT&BI_COMMAND_2-BI_COMMAND_TYPE=PASSIVE_VALUE_TRANSFER&BI_COMMAND_2-PASSIVE_ID=DLG_VARIABLE_VAR_2_INPUT_inp&BI_COMMAND_2-PASSIVE_VALUE=10&BI_COMMAND_2-TARGET_DIALOG_REF=DLG_VARIABLE&BI_COMMAND_3=&BI_COMMAND_3-BI_ADVANCED=DLG_VARIABLE_VAR_3_INPUT&BI_COMMAND_3-BI_COMMAND_TYPE=PASSIVE_VALUE_TRANSFER&BI_COMMAND_3-PASSIVE_ID=DLG_VARIABLE_VAR_3_INPUT_inp&BI_COMMAND_3-PASSIVE_VALUE=009.2009-009.2009&BI_COMMAND_3-TARGET_DIALOG_REF=DLG_VARIABLE&BI_COMMAND_4=&BI_COMMAND_4-BI_ADVANCED=DLG_VARIABLE_VAR_4_INPUT&BI_COMMAND_4-BI_COMMAND_TYPE=PASSIVE_VALUE_TRANSFER&BI_COMMAND_4-PASSIVE_ID=DLG_VARIABLE_VAR_4_INPUT_inp&BI_COMMAND_4-PASSIVE_VALUE=v1&BI_COMMAND_4-TARGET_DIALOG_REF=DLG_VARIABLE&BI_COMMAND_5=&BI_COMMAND_5-BI_COMMAND_TYPE=OK&BI_COMMAND_5-TARGET_DIALOG_REF=DLG_VARIABLE&REQUEST_ID=1

Query String (Current Server Request) BI_COMMAND-BI_COMMAND_TYPE=UPDATE

Query String (Initial Browser Request) DUMMY=0&TEMPLATE=ZIP_WCO003_NOSIRVE

RTL false

Request URL http://achmexdvw1.mx.achfood.com:50200

SAP_BW_IVIEW_ID pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex

SAP_EXTERNAL_SID FMZuPSJbo1ORoV1*1wciywSsHHVBVUbgIy5fjefoHQTA

THEME_NAME captest

TRACE false

TRAY_TYPE PLAIN

Template (Main Object) BTMP ZIP_WCO003_NOSIRVE

Template (Main) ZIP_WCO003_NOSIRVE

Template Parameters <parameterList>

<param name="BODY_ONLY" value="X"/>

<param name="CHECK_POPUP_BLOCKER" value="X"/>

<param name="DATA_MODE" value="NEW"/>

<param name="DOCUMENT_SAVE_LEVEL" value="0"/>

<param name="ERRORS_VISIBLE" value="X"/>

<param name="INFORMATION_VISIBLE" value="X"/>

<param name="ITEMS_STATELESS" value="false"/>

<param name="MELT_VARIABLES" value="X"/>

<param name="REPORT_REPORT_DISPLAY_TARGET" value="X"/>

<param name="RRI_OPEN_MODE" value="OPEN_IN_SEPARATE_WINDOW">

<param name="OPEN_IN_SEPARATE_WINDOW" value=""/>

</param>

<param name="START_STATELESS_INTERVAL" value="0"/>

<param name="STATELESS" value="false"/>

<param name="SYSTEM_MESSAGES_VISIBLE" value="X">

<param name="SYSTEM_MESSAGES_DISPLAY_MODE" value="ALWAYS"/>

</param>

<param name="TEMPLATE_VERSION" value="1"/>

<param name="USE_CONTEXT_MENU_SNIPPETS" value="X"/>

<param name="USE_LAYERED_WINDOWS" value="X"/>

<param name="USE_SPECIFIC_VARIANT_CATALOG" value="X"/>

<param name="WARNINGS_VISIBLE" value="X"/>

<param name="WINDOW_MODE" value="modal"/>

</parameterList>

com.sap.ip.bi.base.exception.BIBaseRuntimeException: Error while generating HTML at com.sap.ip.bi.webapplications.ui.items.UiItem.render(UiItem.java:365) at com.sap.ip.bi.webapplications.runtime.rendering.impl.ContainerNode.render(ContainerNode.java:63) at com.sap.ip.bi.webapplications.runtime.rendering.impl.PageAssemblerRenderingRoot.processRendering(PageAssemblerRenderingRoot.java:52) at com.sap.ip.bi.webapplications.runtime.impl.Page.buildRenderingTree(Page.java:4080) at com.sap.ip.bi.webapplications.runtime.impl.Page.processRenderingRootNode(Page.java:4135) at com.sap.ip.bi.webapplications.runtime.impl.Page.processRendering(Page.java:3796) at com.sap.ip.bi.webapplications.runtime.impl.Page.doProcessRequest(Page.java:3756) at com.sap.ip.bi.webapplications.runtime.impl.Page.processRequest(Page.java:2661) at com.sap.ip.bi.webapplications.runtime.impl.Page.doServerRedirect(Page.java:3438) at com.sap.ip.bi.webapplications.runtime.impl.Page.doProcessRequest(Page.java:3662) at com.sap.ip.bi.webapplications.runtime.impl.Page.processRequest(Page.java:2661) at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.doProcessRequest(Controller.java:978) at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.processRequest(Controller.java:864) at com.sap.ip.bi.webapplications.runtime.jsp.portal.services.BIRuntimeService.handleRequest(BIRuntimeService.java:488) at com.sap.ip.bi.webapplications.runtime.jsp.portal.components.LauncherComponent.doContent(LauncherComponent.java:22) at com.sapportals.portal.prt.component.AbstractPortalComponent.serviceDeprecated(AbstractPortalComponent.java:209) at com.sapportals.portal.prt.component.AbstractPortalComponent.service(AbstractPortalComponent.java:114) at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189) at com.sapportals.portal.prt.component.PortalComponentResponse.include(PortalComponentResponse.java:215) at com.sapportals.portal.prt.pom.PortalNode.service(PortalNode.java:645) at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189) at com.sapportals.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:753) at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:240) at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:524) at java.security.AccessController.doPrivileged(Native Method) at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:407) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.servlet.InvokerServlet.service(InvokerServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)Caused by: java.lang.RuntimeException: Invalid state: Section I is valid, but neither II nor III. at com.sap.ip.bi.webapplications.ui.items.analysis.virtualmatrix.impl.VirtualMatrixBlockMerge.init(VirtualMatrixBlockMerge.java:137) at com.sap.ip.bi.webapplications.ui.items.analysis.control.AcPivotTableExport.validateRendering(AcPivotTableExport.java:510) at com.sap.ip.bi.webapplications.ui.items.analysis.control.AcPivotTableInteractive.buildUrTree(AcPivotTableInteractive.java:325) at com.sap.ip.bi.webapplications.ui.framework.base.impl.CompositeBuildUrTreeTrigger.process(CompositeBuildUrTreeTrigger.java:33) at com.sap.ip.bi.webapplications.ui.framework.base.composites.UiRootContainer.iterateOverChildren(UiRootContainer.java:40) at com.sap.ip.bi.webapplications.ui.framework.base.impl.CompositeBuildUrTreeTrigger.process(CompositeBuildUrTreeTrigger.java:36) at com.sap.ip.bi.webapplications.ui.advancedcontrols.bridge.AcItemBridge.iterateOverChildren(AcItemBridge.java:61) at com.sap.ip.bi.webapplications.ui.framework.base.impl.CompositeBuildUrTreeTrigger.process(CompositeBuildUrTreeTrigger.java:36) at com.sap.ip.bi.webapplications.ui.unifiedrendering.controls.FlowLayoutItem.iterateOverChildren(FlowLayoutItem.java:63) at com.sap.ip.bi.webapplications.ui.framework.base.impl.CompositeBuildUrTreeTrigger.process(CompositeBuildUrTreeTrigger.java:36) at com.sap.ip.bi.webapplications.ui.unifiedrendering.controls.FlowLayout.iterateOverChildren(FlowLayout.java:69) at com.sap.ip.bi.webapplications.ui.framework.base.impl.CompositeBuildUrTreeTrigger.process(CompositeBuildUrTreeTrigger.java:36) at com.sap.ip.bi.webapplications.ui.framework.base.composites.UiRootContainer.iterateOverChildren(UiRootContainer.java:40) at com.sap.ip.bi.webapplications.ui.framework.base.impl.CompositeBuildUrTreeTrigger.process(CompositeBuildUrTreeTrigger.java:36) at com.sap.ip.bi.webapplications.ui.framework.base.impl.CompositeBuildUrTreeTrigger.start(CompositeBuildUrTreeTrigger.java:59) at com.sap.ip.bi.webapplications.ui.framework.base.impl.ExtendedRenderManager.triggerComposites(ExtendedRenderManager.java:69) at com.sap.ip.bi.webapplications.ui.framework.base.impl.BICompositeManager.renderRoot(BICompositeManager.java:79) at com.sap.ip.bi.webapplications.ui.items.UiItem.render(UiItem.java:363) ... 46 more</b></i>

Thnks for your help!!!

Yolanda.

Former Member
Not what you were looking for? View more on this topic or Ask a question