Lumira Desktop Server Error

[Former Member]

Hey,

currently I´m getting a "Server Error" in Lumira 1.30 when I try to download a BW Query into Lumira. There is no other text within the message.

Any ideas?

Kind regards

Andre

[Former Member]

Hi,

I have created a trace-log file with the following error:

2016/04/06 17:09:07.766000|<<|S| | 7164|  42| |||||||||||||||[com.sap.hilo.engine.common.BaseDBHelper]Query[1] : Execution success. Elapsed Time : 7 ms.
2016/04/06 17:09:07.938000|>>|S| | 7164|  44| |||||||||||||||[com.sap.hilo.desktop.embeddedserver.DispatcherServlet]Call to service 'acquireData' failed
java.lang.RuntimeException: Setting data source property with an unsupported type
  at com.sap.hilo.model.internal.datasource.DataSourceInfoImpl.setProperty(DataSourceInfoImpl.java:233)
  at com.sap.hilo.model.datasource.AbstractDataSourceInfoBuilder.setProperty(AbstractDataSourceInfoBuilder.java:63)
  at com.sap.hilo.desktop.h5v2.service.serializer.DataSourceInfoSerializer.read(DataSourceInfoSerializer.java:71)
  at com.sap.hilo.desktop.h5v2.service.serializer.AcquireDataReqResSerializer.read(AcquireDataReqResSerializer.java:59)
  at com.sap.hilo.desktop.embeddedserver.httpservice.HTTPAdapter.readRequest(HTTPAdapter.java:177)
  at com.sap.hilo.desktop.embeddedserver.httpservice.HTTPAdapter.execute(HTTPAdapter.java:74)
  at com.sap.hilo.desktop.embeddedserver.DispatcherServlet.handleRequest(DispatcherServlet.java:107)
  at com.sap.hilo.desktop.embeddedserver.DispatcherServlet.doPost(DispatcherServlet.java:87)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
  at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:598)
  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1367)
  at com.sap.hilo.desktop.embeddedserver.JsonPaddingFilter.doFilter(JsonPaddingFilter.java:80)
  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1338)
  at com.sap.hilo.desktop.embeddedserver.configurator.internal.SecurityFilter.doFilter(SecurityFilter.java:59)
  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1338)
  at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:484)
  at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
  at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1065)
  at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:413)
  at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)
  at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:999)
  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)
  at org.eclipse.jetty.server.Server.handle(Server.java:350)
  at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:454)
  at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:900)
  at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:954)
  at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:851)
  at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
  at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:77)
  at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:606)
  at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:46)
  at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:603)
  at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:538)
  at java.lang.Thread.run(Thread.java:812)

[former_member207736]

Requirements for Connecting SAP Lumira to SAP BW

There are two 2 different ways of connecting to an SAP BW System.

• Local SAP BW System, which needs an saplogon.ini file; or
• An OLAP Connection to an SAP BW System stored on the BI Platform.

To connect to SAP BW locally, SAP Logon must be installed, and SAP BW System must be defined in the SAP Logon.

To connect to SAP BW Connection on an SAP BusinessObjects BI Platform, an OLAP Connection to SAP BW must be defined on the SAP BI Platform server."

Reference SCN: Message List - SAP Lumira

[Former Member]

As a note, SAPGui needs to be at 7.30 or higher.

[TammyPowlas]

Did you install the BW Query extension for Lumira?

[Former Member]

Hi Tammy,

yes I installed the BW Query extension! I think this works fine with 1.29 except the problem that I can´t save the files to the BIP 4.2. But the error occur if I use a direct BW connection.

Kind regards

André

[former_member183750]

There is a number of KBAs relating to connections from Lumira to BW. None of them have precisely the same error you mention, but they still may be worth consulting. The first thing I would do though is uninstall Lumire 1.3. If you have had any previous versions of Lumira installed go to Add | Remove and remove those, then reinstall Lumira 1.3. If that does not help, see the following KBAs:

2109326 - In SAP Lumira Desktop, the dropdown box for selecting a server is empty, although there are entries available the saplogon.ini file

2185347 - Lumira Error: Could not load the details for the SAP Business Warehouse connections

2202292 - Error: Connect to message server host failed, when attempting to connect to SAP BW from Lumira

2129519 - Unknown error when attempting to connect to SAP BW from Lumira

2041075 - Lumira Desktop gives Unknown Error when connecting to BW

- Ludek

Senior Support Engineer Product Support, Global Support Center Canada

Join us for Lumira Social Hour April 14, 2016

Follow us on Twitter (#SAPLumira)

Got Enhancement ideas? Use the SAP Idea Place 

[Former Member]

Hi Ludek,

we tried to re-install the fresh Lumira Desktop 1.30 client without success (error message is still the same). And yes, I saw and check the mentioned KBA´s. Think I must raise an OSS call to solve this issue.

Kind regards

Andre

[former_member183750]

Sorry I was not able to help more Andre (I did look at the log, but it does not tell me much either). If you do get a solution, it would be great if you'd post it here.

_ Ludek