Pentaho 7 Upgrade Causing Performance Degradation
Gary Chen
Pedro Alves
--
You received this message because you are subscribed to the Google Groups "Pentaho Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-community+unsubscribe@googlegroups.com.
To post to this group, send email to pentaho-community@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/f59f185c-e04a-4cdc-b191-cba4c46a6f4d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Gary Chen
Thanks Pedro. Here are more details about performance degradation.
1. After we installed Saiku analytics，I use it to create a query and save as example.saiku. When I double click the example.saiku, it will load a long time (about 2 min) to show the screen while displaying loading sign.(Notice: in the database, there is no data in the table).
The logs are following:
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,215 INFO [OSGIObjectFactory] OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,297 WARN [PentahoAwareCharacterEncodingFilter] Could not find encoding. Using default encoding: UTF-8
03:52:07,297 WARN [GenericServlet] GenericServlet is deprecated and should no longer be handling requests. More detail below...
| You have issued a GET request to http://104.154.27.7/reporting/content/saiku-ui/js/saiku/plugins/I18n/po/cn.json from referer http://104.154.27.7/reporting/content/saiku-ui/index.html?biplugin5=true&dimension_prefetch=false
| Please consider using one of the following REST services instead:
| * GET /api/repos/<pluginId>/<path> to read files from a plugin public dir
| * POST|GET /api/repos/<pathId>/generatedContent to create content resulting from execution of a repo file
| * POST|GET /api/repos/<pluginId>/<contentGeneratorId> to execute a content generator by name (RPC compatibility service)
\ To turn this message off, set init-param showDeprecationMessage to false in the GenericServlet declaration
03:52:07,298 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,298 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPluginManager
03:52:07,298 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,298 INFO [OSGIObjectFactory] OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,298 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,298 INFO [OSGIObjectFactory] OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,298 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,298 INFO [OSGIObjectFactory] OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,298 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,298 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPluginResourceLoader
03:52:07,298 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,298 INFO [OSGIObjectFactory] OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:52:07,344 WARN [PentahoAwareCharacterEncodingFilter] Could not find encoding. Using default encoding: UTF-8
03:52:07,344 WARN [GenericServlet] GenericServlet is deprecated and should no longer be handling requests. More detail below...
| You have issued a GET request to http://104.154.27.7/reporting/content/saiku-ui/js/saiku/plugins/CCC_Chart/cdo.js from referer http://104.154.27.7/reporting/content/saiku-ui/index.html?biplugin5=true&dimension_prefetch=false
| Please consider using one of the following REST services instead:
| * GET /api/repos/<pluginId>/<path> to read files from a plugin public dir
| * POST|GET /api/repos/<pathId>/generatedContent to create content resulting from execution of a repo file
| * POST|GET /api/repos/<pluginId>/<contentGeneratorId> to execute a content generator by name (RPC compatibility service)
\ To turn this message off, set init-param showDeprecationMessage to false in the GenericServlet declaration
2. We use pentaho to create interactive dashboard, when I login with a user, the screen turn to the dashboard, it cost a long time to show. And the logs display as follows: ( please refer to the attachment for detail)
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,189 INFO [OSGIObjectFactory] OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,189 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,189 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.repository2.unified.IUnifiedRepository
03:47:43,189 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,190 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.repository2.unified.IUnifiedRepository
03:47:43,190 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,190 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.repository2.unified.IUnifiedRepository
03:47:43,190 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,190 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.repository2.unified.IUnifiedRepository
03:47:43,190 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,190 INFO [OSGIObjectFactory] OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,191 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,191 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IAuditEntry
03:47:43,191 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:43,191 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IAuditEntry
2017/05/17 03:47:44 - sitebased_line_ds_kettle.0 - Finished reading query, closing connection.
2017/05/17 03:47:44 - sitebased_line_ds_kettle.0 - Finished processing (I=272, O=0, R=0, W=272, U=0, E=0)
03:47:44,613 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IPentahoObjectReference
03:47:44,613 INFO [OSGIObjectFactory]
OSGI: did not find object: org.pentaho.platform.api.engine.IAuditEntry
Thanks,
On Tuesday, May 16, 2017 at 4:40:55 PM UTC-7, Pedro Alves wrote:
We need more details. Where, when, logs, type of things you're executing, what kind of performance you're referring to...
On May 16, 2017 17:09, "Gary Chen" <gary.g...@gmail.com> wrote:
Hi Pentaho Experts,--After we upgraded Pentaho from from 5.4 to 7.0, we noticed significant performance degradation. Has anybody noticed this change? Any insights on how to fix this or optimize it for performance?Thanks,Gary
You received this message because you are subscribed to the Google Groups "Pentaho Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.