Unable to display chart from olap into Design Studio.

[manjula_muniveerappa]

  Hi All,

W are trying to create chart in Design Studio by using the Data source created in Analysis for OLAP by connecting to Hana model.

While I am trying to connect to Hana model directly its working fine. but we do have some dynamic calculation which is done in Analysis for OLAP . and we brought that and into Design studio we have two application by doing this and one is working fine and another one is having an issue.

Here is the steps what I have done.

1) Created the OLAP application with Dynamic calculation.

2) Saved the OLAP application as Design studio application.

3) Copy the HANA Data source created by OLAP application in Design Studio to another Design Studio application.

4) Assign the Data source to chart.

and I am getting an error saying

ERROR [7f71e9e9-9d55-4e9c-b190-55f1368e3bfa]: Invalid program status: Incompatible Variables

com.sap.ip.bi.base.application.exceptions.ApplicationProgramErrorException: Invalid program status: Incompatible Variables

at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.variableprocessor.CharacteristicMemberVariable.setValue(CharacteristicMemberVariable.java:332)

at com.sap.ip.bi.base.application.variableprocessor.impl.ProcessorVariable.setValue(ProcessorVariable.java:268)

at com.sap.ip.bi.base.application.variableprocessor.impl.VariableContainer.readStateFromDom(VariableContainer.java:730)

at com.sap.ip.bi.base.application.service.base.BaseServiceAlpha.postInitialization(BaseServiceAlpha.java:302)

at com.sap.ip.bi.base.application.impl.ServiceManagement.registerService(ServiceManagement.java:777)

at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:397)

at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:365)

at com.sap.ip.bi.base.application.impl.Application.createService(Application.java:491)

at com.sap.ip.bi.base.application.service.base.BaseServiceDescription.createService(BaseServiceDe

BI exception with class "ApplicationProgramErrorException" and message "Invalid program status: Incompatible Variables". See default trace for log ID "7f71e9e9-9d55-4e9c-b190-55f1368e3bfa".

Event was started, but not completed: 1121 ms: Initialize data provider (13100)

"DATAPROVIDER" of type "QUERY_DATA_SOURCE" could not be generated

Very critical requirement. Any help is appreciated

Thanks

Manju

[TammyPowlas]

I am not using HANA; perhaps others are.  Would you please specify the BI4x version you are using for Analysis OLAP?  Perhaps or might have some ideas.

[manjula_muniveerappa]

HI Tammy,

Thanks for the replay. we are using .

BI 4.1 SP3.

Thanks,

Manju

[manjula_muniveerappa]

HI all ,

Does it mean it requires some variables and values are going as null to the Data source and its now able to initiate it.

Pls clarify.

Here is the log details which I have it in log.bak file.

ENTRY com.sap.ip.bi.base.application 4 0 2014-05-09 10:17:07.662
!MESSAGE Message: No message was provided.
Stack trace: java.lang.NullPointerException
at com.sap.ip.bi.base.application.variableprocessor.impl.VariableContainer.removeProcessor(VariableContainer.java:572)
at com.sap.ip.bi.base.application.variableprocessor.impl.VariableContainer.removeProcessor(VariableContainer.java:555)
at com.sap.ip.bi.base.application.service.base.BaseServiceAlpha.destroy(BaseServiceAlpha.java:198)
at com.sap.ip.bi.base.application.service.base.BaseService.destroy(BaseService.java:111)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.destroy(SelectionObject.java:1081)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.QueryView.destroy(QueryView.java:221)
at com.sap.ip.bi.base.application.impl.ServiceManagement.destroy(ServiceManagement.java:137)
at com.sap.ip.bi.base.application.impl.Application.destroy(Application.java:340)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.destroyApplication(Page.java:2124)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page._destroy(Page.java:494)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.destroy(Page.java:2069)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller._destroyPage(Controller.java:749)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller.destroyPage(Controller.java:698)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller.destroyInternal(Controller.java:1238)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller.destroy(Controller.java:1335)
at com.sap.ip.bi.webapplications.runtime.impl.controller.ControllerCollector.destroyController(ControllerCollector.java:319)
at com.sap.ip.bi.webapplications.runtime.controller.RuntimeControllerFactory.destroyController(RuntimeControllerFactory.java:34)
at com.sap.ip.bi.server.runtime.sevice.impl.BIRuntimeServerService.destroyController(BIRuntimeServerService.java:869)
at com.sap.ip.bi.server.runtime.sevice.impl.BIRuntimeServerService._handleRequest(BIRuntimeServerService.java:424)
at com.sap.ip.bi.server.runtime.sevice.impl.BIRuntimeServerService.handleRequest(BIRuntimeServerService.java:907)
at com.sap.ip.bi.server.execution.engine.runtime.BIExecutionEngineRuntime.executeRequest(BIExecutionEngineRuntime.java:48)
at com.sap.ip.bi.framework.base.execution.impl.BIExecutionService.executeRequest(BIExecutionService.java:54)
at com.sap.ip.bi.client.execution.AbstractExecutionServlet.handleRequest(AbstractExecutionServlet.java:151)
at com.sap.ip.bi.client.servlet.BIPrivateServlet.handleRequest(BIPrivateServlet.java:32)
at com.sap.ip.bi.client.execution.AbstractExecutionServlet.doPost(AbstractExecutionServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at org.eclipse.equinox.http.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:38)
at com.sap.ip.bi.zen.webserver.internal.ZenSessionFilter.doFilter(ZenSessionFilter.java:42)
at org.eclipse.equinox.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:81)
at org.eclipse.equinox.http.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:35)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:132)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:386)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:457)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:276)
at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:103)
at org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:30)
at com.sap.ip.bi.client.service.BIClientService.logoff(BIClientService.java:651)
at com.sap.ip.bi.client.servlet.BIServiceServlet.handleRequest(BIServiceServlet.java:19)
at com.sap.ip.bi.client.execution.AbstractExecutionServlet.doPost(AbstractExecutionServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:386)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:457)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:368)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)
at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
at java.lang.Thread.run(Unknown Source)

!STACK 0
java.lang.NullPointerException

[Former Member]

Hi Manju,

Regarding Step 3 from the top of this thread ("3) Copy the HANA Data source created by OLAP application in Design Studio to another Design Studio application"), could you check the properties fro the two copies of the connection, and ensure they are identical? 

Also, does your second Design Studio application work successfully if you set it up to use the first connection?

Regards,

Boris

[manjula_muniveerappa]

Hi Boris,

Thanks for the answer.

I checked the properties for both the connection and they are same.

The only difference between working model and not working model is that

Working model doesn't have any input parameters whereas not working model has input parameters.

Thanks,

Manju

[Former Member]

Hi Manju,

Thanks for the clarification.

Regarding "not working model has input parameters", does it mean it's based on a different BEx query? If yes, can you use the query directly in A-OLAP, and also manually create a Design Studio application directly in Design Studio (without exporting it from A-OLAP) against this query? 

Hopefully, this information helps us narrow down where the problem originates.

Regards,

Boris

[manjula_muniveerappa]

HI Boris,

thanks for the mail. I am connecting to HANA model not BW query.

when I try to create data source directly using HANA model it is working fine.

I am having an issue when we try to use OLAP application to save as a design studio application.

when I run the design studio application it works but when I try to copy the data source I am getting the error as above.

thanks,

manju

[Former Member]

Hi Manju,

Thank you pointing it out again that you are using HANA

I believe the issue is caused by the fact that the version Design Studio run-time components that are included with A-OLAP (so A-OLAP can dynamically export to Design Studio) do not support variables/input parameters.

I would suggest a couple of things:

1. try setting up a default value for the variable and making it optional (as a possible short term workaround)

2. Opening a CSS ticket against A-OLAP product (BI-RA-AWB component) to get updated to support variables/input parameters

Regards,

Boris