Skip to Content

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

HANA Online Expert Analytics error:

Just upgraded to PA 2.2; we are on HANA revision 95, APL functions were working under PA 2.1.  Auto-Classification and the HANA Model Statistics and HANA Model Compare algorithms all give the following error:

SAP DBTech JDBC 260 invalid column name: Applyln: line 25 col 316

Questions:

1.) I see SAP note 2128915 that says they recommend version 96, but the supported platforms PAM only lists SPS9 (which we are on with version 95) as the APL compatibility.  Is only version 96 compatible?  Or is 95 still compatible?

2.) are the Model Statistics and Model Compare modules part of the APL library?

3.) Is there any resolution for this error?

This is a portion of error in the Log Details:

2015/06/24 12:18:57.535000|>>|E| | 3168|  38| |||||||||||||||[com.sap.pa.service.hilo.impl.ServerExecuteComponent]Error executing using connection:SAP DBTech JDBC: [259] (at 474): invalid table name:  Could not find table/view AUT_PAS22_2_RV in schema HILLARYBLISS: line 1 col 475 (at pos 474)

2015/06/24 12:18:57.535000|>>|S| | 3168|  38|}|||||||||||||||execute: 05.833

2015/06/24 12:18:57.535000|==|S| | 3168|  38| |||||||||||||||[com.sap.hilo.pa.backend.PATransformCommandProcessor]Clearing QueryResult and ResultSet cache as the component results may have changed

2015/06/24 12:18:57.536000|>>|E| | 3168|  38| |||||||||||||||[Error while executing the chain]

java.lang.reflect.UndeclaredThrowableException

  at com.sun.proxy.$Proxy0.buildDataSetFoundation(Unknown Source)

  at com.sap.hilo.service.datamanipulation.internal.DataManipulationServiceImpl.buildDataSetFoundation(DataManipulationServiceImpl.java:185)

  at com.sap.hilo.desktop.predict.services.ExecuteChainService.execute(ExecuteChainService.java:95)

  at com.sap.hilo.desktop.predict.services.PAService.execute(PAService.java:55)

  at com.sap.hilo.desktop.embeddedserver.httpservice.HTTPAdapter.execute(HTTPAdapter.java:89)

  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)

Caused by: java.lang.reflect.InvocationTargetException

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:606)

  at com.sap.hilo.service.datamanipulation.internal.ControllersToolkit$TransformEngineProxyHandler.invoke(ControllersToolkit.java:128)

  ... 35 more

Caused by: An error occurred while executing the query. (null)

  at com.sap.pa.service.hilo.impl.ServerExecuteComponent.execute(ServerExecuteComponent.java:234)

  at com.sap.pa.service.hilo.impl.TransformComponentManagerImpl.processComponent(TransformComponentManagerImpl.java:66)

  at com.sap.hilo.pa.backend.PATransformCommandProcessor.processOnlineCalculationNode(PATransformCommandProcessor.java:143)

  at com.sap.hilo.pa.backend.PATransformCommandProcessor.processCalculationNode(PATransformCommandProcessor.java:69)

  at com.sap.hilo.engine.hana.online.internal.HanaOnlineCalcEngineImpl.createDataContext(HanaOnlineCalcEngineImpl.java:286)

  at com.sap.hilo.service.datamanipulation.internal.engines.TransformEngineImpl.prepareForQuery(TransformEngineImpl.java:1289)

  at com.sap.hilo.service.datamanipulation.internal.engines.TransformEngineImpl.prepareForQuery(TransformEngineImpl.java:1223)

  at com.sap.hilo.service.datamanipulation.internal.engines.TransformEngineImpl.buildDataSetFoundation(TransformEngineImpl.java:1236)

  ... 40 more

2015/06/24 12:18:57.545000|>>|E| | 3168|  38| |||||||||||||||ERROR From PAES Server: An error occurred while executing the query.

Tags:
replied

Hillary,

For this to work, you must install APL 2.2 on top of your HANA installation.

Expert Analytics 2.2 requires APL 2.2 for use of model compare, model statistics or HANA Auto * algorithms in the case of HANA online mode.

Can you please confirm the different components that compose your installation?

As I said, the recommended mix for productive use is Predictive Analytics 2.2 (de facto includes Expert) + SAP HANA revision 96 + APL 2.2.

Best regards

Antoine

0 View this answer in context

Helpful Answer

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