it4biz / pentaho-ce-audit Goto Github PK
View Code? Open in Web Editor NEWPentaho CE Audit plugin by IT4biz.
Pentaho CE Audit plugin by IT4biz.
Hi,
I am trying to use the pluging but I am getting this error:
2018/01/14 17:55:43 - get_metadata - Dispatching started for transformation [get_metadata]
org.pentaho.di.core.exception.KettleDatabaseException:
An error occurred executing SQL:
SELECT ^M
"LAST_UPDATE",^M
"NUMBER_ROWS",^M
"USER" ^M
FROM "PENTAHO_CE_AUDIT_METADATA"^M
^M
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"PENTAHO_CE_AUDIT_METADATA"' at line 5
at org.pentaho.di.core.database.Database.openQuery(Database.java:1768)
at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:236)
at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:140)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"PENTAHO_CE_AUDIT_METADATA"' at line 5
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1757)
add support for Oracle database.
Installation is ok but on execution the dashboard shows an error because mondrian catalogue cannot be access in CDA file.
Pentaho Community 5.0.1 (tomcat) on Windows Server.
Hi Team,
We are using Pentaho enterprise edition. We want to get the the audit log from pentaho. So we installed Pentaho-CE-audit in the BA server (Pentaho Solutions/System).Now we can see the audit tab also present in pentaho user console.But when we refresh it it is not giving any audit logs.Could you please help us to get this.?Please write to us if you need more details.
Thanks & Regards
Vishnu
Hi ,
I have tried to install that Pentaho CE plugin in Pentaho 7..But getting below mentioned error..Please have a look...
download_and_install_plugin - exec(2, 0, Unzip.0)
Unzip - Starting job entry
Unzip - Starting ...
Unzip - Processing row source File/folder source : [zip:${downloadDestination}] ... destination file/folder : [${stagingDestination}]... wildcard : [null]
Unzip - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Can not copy file/folder [zip:G:\shared\p7.0\pentaho-server\pentaho-solutions\system/plugin-cache/downloads/pentaho-ce-a
Unzip -
Unzip - Unable to get VFS File object for filename 'zip:G:\shared\p7.0\pentaho-server\pentaho-solutions\system/plugin-cache/downloads/pentaho-ce-audit-2016.05.19_1486905133100.zip' : Could not open Zip f
Unzip -
Unzip - ]
Unzip - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleFileException:
Unzip -
Unzip - Unable to get VFS File object for filename 'zip:G:\shared\p7.0\pentaho-server\pentaho-solutions\system/plugin-cache/downloads/pentaho-ce-audit-2016.05.19_1486905133100.zip' : Could not open Zip f
Unzip -
Unzip -
Unzip - at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:159)
Unzip - at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:106)
Unzip - at org.pentaho.di.job.entries.copyfiles.JobEntryCopyFiles.ProcessFileFolder(JobEntryCopyFiles.java:427)
Unzip - at org.pentaho.di.job.entries.copyfiles.JobEntryCopyFiles.execute(JobEntryCopyFiles.java:382)
Unzip - at org.pentaho.di.job.Job.execute(Job.java:724)
Unzip - at org.pentaho.di.job.Job.execute(Job.java:865)
Unzip - at org.pentaho.di.job.Job.execute(Job.java:865)
Unzip - at org.pentaho.di.job.Job.execute(Job.java:546)
Unzip - at org.pentaho.di.job.Job.run(Job.java:436)
download_and_install_plugin - Starting entry [Unzipped Plugin Exists]
download_and_install_plugin - exec(3, 0, Unzipped Plugin Exists.0)
Unzipped Plugin Exists - Starting job entry
Unzipped Plugin Exists - File [G:\shared\p7.0\pentaho-server\pentaho-solutions\system/plugin-cache/staging/pentaho-ce-audit] does not exist!
download_and_install_plugin - Starting entry [Cleanup Staging]
download_and_install_plugin - exec(4, 0, Cleanup Staging.0)
Cleanup Staging - Starting job entry
Cleanup Staging - Processing folder [G:\shared\p7.0\pentaho-server\pentaho-solutions\system/plugin-cache/staging/]
Cleanup Staging - Folder G:\shared\p7.0\pentaho-server\pentaho-solutions\system/plugin-cache/staging/ was deleted. Total deleted files = 1
Cleanup Staging - =======================================
Cleanup Staging - Number of errors : 0
Cleanup Staging - Number of deleted folders : 1
Cleanup Staging - =======================================
download_and_install_plugin - Starting entry [Abort job]
download_and_install_plugin - exec(5, 0, Abort job.0)
I've installed pentaho-ce-audit 2014.11.17 through pentaho marketplace.
When I try to activate it throgh Tools -> Pentaho CE audit, I obtain a 403 error:
Request URL:http://mv0073:8080/pentaho/plugin/pentaho-ce-audit/api/home
Request Method:GET
Status Code:403 Prohibido
Good morning everyone,
I work on pentaho in version 6.1.0.1.196
When I try to update the "pentaho ce audit" the page stays loading and nothing happens, indeed after I refresh it a few times there is really no more data.
The steps I take are "Tools/Pentaho Ce Audit/ and then I click the wheel to update"
I also tried using this command
http://your_server:yourPort/pentaho/plugin/pentaho-ce-audit/api/job_refresh
But unfortunately I get the following response
"The connection has timed out
The server at ...* is taking too long to respond."
Could anyone help me?
Thank you
I can't install plugin from marketplace. The error from catalina.out:
2015/04/07 10:34:09 - START - Starting job entry
2015/04/07 10:34:09 - download_and_install_plugin - Starting entry [Download Plugin]
2015/04/07 10:34:09 - download_and_install_plugin - exec(1, 0, Download Plugin.0)
2015/04/07 10:34:09 - Download Plugin - Starting job entry
2015/04/07 10:34:09 - Download Plugin - Start of HTTP job entry.
2015/04/07 10:34:09 - Download Plugin - Connecting to URL:
2015/04/07 10:34:09 - Download Plugin - http://sourceforge.net/projects/pentahoceaudit/files/2.0/pentaho-ce-audit-2.0-stable.zip/download
2015/04/07 10:34:09 - Download Plugin -
2015/04/07 10:34:09 - Download Plugin - Start reading reply from webserver.
2015/04/07 10:34:10 - Download Plugin - Resource type: text/html; charset=UTF-8, last modified on: Thu Jan 01 01:00:00 CET 1970.
2015/04/07 10:34:10 - Download Plugin - Finished writing 1005 bytes to result file [/oracle/perf_tool/biserver-ce/pentaho-solutions/system/plugin-cache/downloads/pentah
o-ce-audit-2015.02.03_1428395649788.zip]
2015/04/07 10:34:10 - download_and_install_plugin - Starting entry [Unzip]
2015/04/07 10:34:10 - download_and_install_plugin - exec(2, 0, Unzip.0)
2015/04/07 10:34:10 - Unzip - Starting job entry
2015/04/07 10:34:10 - Unzip - Starting ...
2015/04/07 10:34:10 - Unzip - Processing row source File/folder source : [zip:${downloadDestination}] ... destination file/folder : [${stagingDestination}]... wildcard
: [null]
2015/04/07 10:34:10 - Unzip - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Can not copy file/folder [zip:/oracle/perf_tool/biserver-ce/pentah
o-solutions/system/plugin-cache/downloads/pentaho-ce-audit-2015.02.03_1428395649788.zip] to [/oracle/perf_tool/biserver-ce/pentaho-solutions/system/plugin-cache/staging
]. Exception : [
2015/04/07 10:34:10 - Unzip -
2015/04/07 10:34:10 - Unzip - Unable to get VFS File object for filename 'zip:/oracle/perf_tool/biserver-ce/pentaho-solutions/system/plugin-cache/downloads/pentaho-ce-a
udit-2015.02.03_1428395649788.zip' : Could not open Zip file "/oracle/perf_tool/biserver-ce/pentaho-solutions/system/plugin-cache/downloads/pentaho-ce-audit-2015.02.03_1428395649788.zip".
2015/04/07 10:34:10 - Unzip -
2015/04/07 10:34:10 - Unzip - ]
2015/04/07 10:34:10 - Unzip - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.pentaho.di.core.exception.KettleFileException:
2015/04/07 10:34:10 - Unzip -
2015/04/07 10:34:10 - Unzip - Unable to get VFS File object for filename 'zip:/oracle/perf_tool/biserver-ce/pentaho-solutions/system/plugin-cache/downloads/pentaho-ce-audit-2015.02.03_1428395649788.zip' : Could not open Zip file "/oracle/perf_tool/biserver-ce/pentaho-solutions/system/plugin-cache/downloads/pentaho-ce-audit-2015.02.03_1428395649788.zip".
2015/04/07 10:34:10 - Unzip -
2015/04/07 10:34:10 - Unzip -
2015/04/07 10:34:10 - Unzip - at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:154)
2015/04/07 10:34:10 - Unzip - at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:102)
2015/04/07 10:34:10 - Unzip - at org.pentaho.di.job.entries.copyfiles.JobEntryCopyFiles.ProcessFileFolder(JobEntryCopyFiles.java:362)
2015/04/07 10:34:10 - Unzip - at org.pentaho.di.job.entries.copyfiles.JobEntryCopyFiles.execute(JobEntryCopyFiles.java:315)
2015/04/07 10:34:10 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:716)
2015/04/07 10:34:10 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:859)
2015/04/07 10:34:10 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:859)
2015/04/07 10:34:10 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:532)
2015/04/07 10:34:10 - Unzip - at org.pentaho.di.job.Job.run(Job.java:424)
Downloaded file content (pentaho-solutions/system/plugin-cache/downloads/):
`
<title>Access Controlled</title> <noframes>You have been blocked by Websense.You must have a frames capable browser to view the remainder of this document correctly.</noframes> `
Hi,
I'm having an issue when installing Pentaho CE Audit on Pentaho BI Server CE 6.1.
I tried istalling it from marketplace and told me that cannot install because there was an error. So, then I download the plugin and put it in pentaho-solutions/system folder. When I visualize for the first time the dashboard, it ask me for some information and when I click on submit it tell me that there is an error.
Can you tell me if there is a problem related to this plugin in pentaho 6.1?
How can I successfully install the plugin?
Thanks in advance.
Greetings.
Like a manager, i would like to see reports and dashboards that is not accessing by users in last 30, 60 and 90 days.
As an admin, my wanna check audit data in DB directly, is that possible? and if so, how to set up?
Thanks
Claire
also one problem on case sensitiv systems (also DB) once the name is in UPPERCASE then again in lowercase of the table names…
uninstall does not reset the spring file to go from SQL to File again
I tested the Pentaho CE Audit Plugin with Pentaho BI Server 5.0.1-stable and Hibernate database with PostgreSQL 9 and I've got the error message below:
org.saiku.service.util.exception.SaikuServiceException: runId:2 Can't execute query: 4262542F-9940-08FB-AFDC-AFC043ADF655
at org.saiku.service.olap.OlapQueryService.execute(OlapQueryService.java:307)
at org.saiku.service.olap.OlapQueryService.execute(OlapQueryService.java:225)
at org.saiku.web.rest.resources.QueryResource.execute(QueryResource.java:780)
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.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:62)
at org.saiku.plugin.resources.ExtendedJAXRSPluginServlet.service(ExtendedJAXRSPluginServlet.java:65)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:67)
at org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:161)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:88)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:265)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:744)
Caused by: org.olap4j.OlapException: mondrian gave exception while executing query
at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:840)
at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:423)
at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:347)
at org.saiku.olap.query.OlapQuery.execute(OlapQuery.java:293)
at org.saiku.service.olap.OlapQueryService.execute(OlapQueryService.java:251)
... 80 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {Hierarchize({[Measures].[Quantidade de Acessos]})} ON COLUMNS,
NON EMPTY {Hierarchize({[Usuario].[Usuario].Members})} ON ROWS
from [Pentaho CE Audit Portuguese-BR]
]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972)
at mondrian.olap.Util.newInternal(Util.java:2403)
at mondrian.olap.Util.newError(Util.java:2419)
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:706)
at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
... 1 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Populating member cache with members for [[Usuario].[Usuario]]; sql=[select "PENTAHO_CE_AUDIT"."USUARIO" as "c0" from "PUBLIC"."PENTAHO_CE_AUDIT" as "PENTAHO_CE_AUDIT" group by "PENTAHO_CE_AUDIT"."USUARIO" order by "PENTAHO_CE_AUDIT"."USUARIO" ASC NULLS LAST]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972)
at mondrian.olap.Util.newInternal(Util.java:2403)
at mondrian.olap.Util.newError(Util.java:2419)
at mondrian.rolap.SqlStatement.handle(SqlStatement.java:353)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:253)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:334)
at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:395)
at mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:506)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:527)
at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:146)
at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMembersInLevel(RolapCubeHierarchy.java:727)
at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:566)
at mondrian.olap.DelegatingSchemaReader.getLevelMembers(DelegatingSchemaReader.java:242)
at mondrian.olap.fun.FunUtil.getNonEmptyLevelMembers(FunUtil.java:2195)
at mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2209)
at mondrian.olap.fun.LevelMembersFunDef$1.evaluateList(LevelMembersFunDef.java:37)
at mondrian.olap.fun.HierarchizeFunDef$1.evaluateList(HierarchizeFunDef.java:46)
at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71)
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:875)
at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:700)
at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:656)
at mondrian.rolap.RolapResult.(RolapResult.java:288)
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671)
... 7 more
Caused by: org.postgresql.util.PSQLException: ERROR: schema "PUBLIC" does not exist
Posição: 50
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:200)
... 25 more
Hello,
Server : Windows Server 2008 R2 Standard
Pentaho Version : CE v5.4.0.1
Pentaho configuration:
When trying to install from MarketPlace, I get the following error:
2016-03-03 09:51:14,481 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Start of job execution
2016-03-03 09:51:14,489 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - exec(0, 0, START.0)
2016-03-03 09:51:14,491 INFO [org.pentaho.di] 2016/03/03 09:51:14 - START - Starting job entry
2016-03-03 09:51:14,493 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Starting entry [Download Plugin]
2016-03-03 09:51:14,493 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - exec(1, 0, Download Plugin.0)
2016-03-03 09:51:14,495 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Download Plugin - Starting job entry
2016-03-03 09:51:14,497 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Download Plugin - Start of HTTP job entry.
2016-03-03 09:51:14,514 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Download Plugin - Connecting to URL:
http://sourceforge.net/projects/pentahoceaudit/files/2.0/pentaho-ce-audit-2.0-stable.zip/download
2016-03-03 09:51:14,523 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Download Plugin - Start reading reply from webserver.
2016-03-03 09:51:14,903 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Download Plugin - Resource type: text/html; charset=UTF-8, last modified on: Thu Jan 01 01:00:00 CET 1970.
2016-03-03 09:51:14,905 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Download Plugin - Finished writing 408 bytes to result file [C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system/plugin-cache/downloads/pentaho-ce-audit-2015.02.03_1456995074080.zip]
2016-03-03 09:51:14,912 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Starting entry [Unzip]
2016-03-03 09:51:14,913 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - exec(2, 0, Unzip.0)
2016-03-03 09:51:14,915 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Unzip - Starting job entry
2016-03-03 09:51:14,918 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Unzip - Starting ...
2016-03-03 09:51:14,918 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Unzip - Processing row source File/folder source : [zip:${downloadDestination}] ... destination file/folder : [${stagingDestination}]... wildcard : [null]
2016-03-03 09:51:14,938 ERROR [org.pentaho.di] 2016/03/03 09:51:14 - Unzip - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Can not copy file/folder [zip:C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system/plugin-cache/downloads/pentaho-ce-audit-2015.02.03_1456995074080.zip] to [C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system/plugin-cache/staging]. Exception : [
2016/03/03 09:51:14 - Unzip -
2016/03/03 09:51:14 - Unzip - Unable to get VFS File object for filename 'zip:C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system/plugin-cache/downloads/pentaho-ce-audit-2015.02.03_1456995074080.zip' : Could not open Zip file "C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system\plugin-cache\downloads\pentaho-ce-audit-2015.02.03_1456995074080.zip".
2016/03/03 09:51:14 - Unzip -
2016/03/03 09:51:14 - Unzip - ]
2016-03-03 09:51:14,939 ERROR [org.pentaho.di] 2016/03/03 09:51:14 - Unzip - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleFileException:
2016/03/03 09:51:14 - Unzip -
2016/03/03 09:51:14 - Unzip - Unable to get VFS File object for filename 'zip:C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system/plugin-cache/downloads/pentaho-ce-audit-2015.02.03_1456995074080.zip' : Could not open Zip file "C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system\plugin-cache\downloads\pentaho-ce-audit-2015.02.03_1456995074080.zip".
2016/03/03 09:51:14 - Unzip -
2016/03/03 09:51:14 - Unzip -
2016/03/03 09:51:14 - Unzip - at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:154)
2016/03/03 09:51:14 - Unzip - at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:102)
2016/03/03 09:51:14 - Unzip - at org.pentaho.di.job.entries.copyfiles.JobEntryCopyFiles.ProcessFileFolder(JobEntryCopyFiles.java:420)
2016/03/03 09:51:14 - Unzip - at org.pentaho.di.job.entries.copyfiles.JobEntryCopyFiles.execute(JobEntryCopyFiles.java:375)
2016/03/03 09:51:14 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:716)
2016/03/03 09:51:14 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:859)
2016/03/03 09:51:14 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:859)
2016/03/03 09:51:14 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:532)
2016/03/03 09:51:14 - Unzip - at org.pentaho.di.job.Job.run(Job.java:424)
2016-03-03 09:51:14,941 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Starting entry [Unzipped Plugin Exists]
2016-03-03 09:51:14,941 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - exec(3, 0, Unzipped Plugin Exists.0)
2016-03-03 09:51:14,943 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Unzipped Plugin Exists - Starting job entry
2016-03-03 09:51:14,946 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Unzipped Plugin Exists - File [C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system/plugin-cache/staging/pentaho-ce-audit] does not exist!
2016-03-03 09:51:14,947 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Starting entry [Cleanup Staging]
2016-03-03 09:51:14,947 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - exec(4, 0, Cleanup Staging.0)
2016-03-03 09:51:14,949 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Cleanup Staging - Starting job entry
2016-03-03 09:51:14,951 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Cleanup Staging - Processing folder [C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system/plugin-cache/staging]
2016-03-03 09:51:14,956 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Cleanup Staging - Folder C:\pentaho_5.4.0.1\biserver-ce\pentaho-solutions\system/plugin-cache/staging was deleted. Total deleted files = 1
2016-03-03 09:51:14,956 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Cleanup Staging - =======================================
2016-03-03 09:51:14,957 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Cleanup Staging - Number of errors : 0
2016-03-03 09:51:14,957 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Cleanup Staging - Number of deleted folders : 1
2016-03-03 09:51:14,958 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Cleanup Staging - =======================================
2016-03-03 09:51:14,959 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Starting entry [Abort job]
2016-03-03 09:51:14,959 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - exec(5, 0, Abort job.0)
2016-03-03 09:51:14,961 INFO [org.pentaho.di] 2016/03/03 09:51:14 - Abort job - Starting job entry
2016-03-03 09:51:14,961 ERROR [org.pentaho.di] 2016/03/03 09:51:14 - Abort job - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Plugin did not contain ID
2016-03-03 09:51:14,962 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Finished job entry Abort job
2016-03-03 09:51:14,963 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Finished job entry Cleanup Staging
2016-03-03 09:51:14,963 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Finished job entry Unzipped Plugin Exists
2016-03-03 09:51:14,964 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Finished job entry Unzip
2016-03-03 09:51:14,964 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Finished job entry Download Plugin
2016-03-03 09:51:14,965 INFO [org.pentaho.di] 2016/03/03 09:51:14 - download_and_install_plugin - Job execution finished
Could you please help me on this ?
Best regards,
Julien
We should use this solution http://fcorti.com/2014/12/11/uploading-mondrian-to-pentaho-using-pdi/
I tried to uninstall the Pentaho CE Audit and then install again by Pentaho MarketPlace in my machine and it occurs a error.
It does not appears the refresh button.
And also:
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Quantidade de Acessos]} ON COLUMNS,
NON EMPTY {([Ano].[Todos], [Mes].[Todos], [Dia].[Todos], [Hora].[Todos], [Usuario].[Todos], [Job].[Todos], [Arquivo].[Todos], [Diretorio].[Todos])} ON ROWS
from [Pentaho CE Audit Portuguese-BR]
]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)
at mondrian.olap.Util.newInternal(Util.java:2404)
at mondrian.olap.Util.newError(Util.java:2420)
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:707)
at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
... 1 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL
at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:240)
at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:51)
at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:166)
at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:140)
... 4 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL
at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:643)
at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:195)
... 7 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select count("PENTAHO_CE_AUDIT"."JOB") as "m0" from "PUBLIC"."PENTAHO_CE_AUDIT" as "PENTAHO_CE_AUDIT"]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)
at mondrian.olap.Util.newInternal(Util.java:2404)
at mondrian.olap.Util.newError(Util.java:2420)
at mondrian.rolap.SqlStatement.handle(SqlStatement.java:352)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:252)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350)
at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:625)
... 8 more
Caused by: java.sql.SQLException: Column not found: PENTAHO_CE_AUDIT.JOB in statement [select count("PENTAHO_CE_AUDIT"."JOB") as "m0" from "PUBLIC"."PENTAHO_CE_AUDIT" as "PENTAHO_CE_AUDIT"]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:199)
... 10 more
Pentaho version : v5.0.1-stable
I recently installed Pentaho CE Audit using extracting the zip file (pentaho-ce-audit) and add it to biserver-ce/pentaho-solutions/system/ directory.
(Has a different problem when installing from Marketplace, it says "Plugin did not contain ID" so I tried to install it manually.)
I successfully finished the registration upon installing the plugin, but after I restarted the server, when I am now trying to load the data from its refresh button, it says:
"Error processing component" from each of the boxes that were displayed.
Upon viewing the logs, it says:
2016-05-02 15:38:46:858 INFO Loading configuration from input stream [OServerConfigurationLoaderXml]
2016-05-02 15:38:46:925 INFO OrientDB Server v1.5.0 is starting up... [OServer]
2016-05-02 15:38:48:969 INFO -> Loaded memory database 'temp' [OServer]
2016-05-02 15:38:49:157 WARN Sun Unsafe direct memory implementation is going to be used, this implementation is not stable so please use JNA version instead. [Class]
2016-05-02 15:38:49:399 INFO -> Loaded local database 'webdetails' [OServer]
2016-05-02 15:38:49:407 WARN [OVariableParser.resolveVariables] Error on resolving property: ORIENTDB_HOME [orientechnologies]
2016-05-02 15:38:49:449 INFO Listening binary connections on 0.0.0.0:2424 (protocol v.17) [OServerNetworkListener]
2016-05-02 15:38:49:449 INFO Listening http connections on 127.0.0.1:2480 (protocol v.10) [OServerNetworkListener]
2016-05-02 15:38:49:521 INFO OrientDB Server v1.5.0 is active. [OServer]2016/05/02 15:38:53 - job_verify_installation - ジョブを開始しました。
2016/05/02 15:38:53 - job_verify_installation - 登録が開始されました [Table pro_audit exists?]
2016/05/02 15:38:53 - job_verify_installation - 登録が開始されました [Table pentaho_ce_audit exists?]
2016/05/02 15:38:53 - job_verify_installation - 登録が開始されました [Table pentaho_ce_audit_metadata]
2016/05/02 15:38:53 - job_verify_installation - 登録が開始されました [OUTPUT]
2016/05/02 15:38:53 - job_verify_installation - ジョブ登録が終了しました OUTPUT
2016/05/02 15:38:53 - job_verify_installation - ジョブ登録が終了しました Table pentaho_ce_audit_metadata
2016/05/02 15:38:53 - job_verify_installation - ジョブ登録が終了しました Table pentaho_ce_audit exists?
2016/05/02 15:38:53 - job_verify_installation - ジョブ登録が終了しました Table pro_audit exists?
2016/05/02 15:38:53 - job_verify_installation - ジョブが終了しました。
2016/05/02 15:38:53 - get_metadata - Dispatching started for transformation [get_metadata]
2016/05/02 15:38:53 - TINP Get Metadata.0 - Finished reading query, closing connection.
2016/05/02 15:38:53 - TINP Get Metadata.0 - 処理を終了 (IBaseStep.TypeTooltipDesc.PGBulkLoader=PostgreSQL Bulk Loader
2016/05/02 15:38:53 - TINP Get Metadata.0 - PostgreSQLバルクロード
2016/05/02 15:38:53 - Select values.0 - 処理を終了 (IBaseStep.TypeTooltipDesc.PGBulkLoader=PostgreSQL Bulk Loader
2016/05/02 15:38:53 - Select values.0 - PostgreSQLバルクロード
2016/05/02 15:38:53 - OUTPUT.0 - 処理を終了 (IBaseStep.TypeTooltipDesc.PGBulkLoader=PostgreSQL Bulk Loader
2016/05/02 15:38:53 - OUTPUT.0 - PostgreSQLバルクロード
Mapped exception to response: 501
pt.webdetails.cda.dataaccess.QueryException: Mondrian Error:Internal error: Virtual file is not readable: mondrian:/Pentaho+CE+Audit
-> pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:183)
-> pt.webdetails.cda.CdaUtils.doQueryPost(CdaUtils.java:131)
-> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
-> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
-> java.lang.reflect.Method.invoke(Method.java:606)
-> com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
-> com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
-> com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
-> com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
-> com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
-> com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
-> com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
-> com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
-> com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
-> com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
-> com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
-> com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
-> com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
-> com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
-> com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
-> org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:62)
-> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
-> org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:67)
-> pt.webdetails.cpf.JAXRSCLPluginServlet.service(JAXRSCLPluginServlet.java:37)
-> org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:89)
-> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
-> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
-> org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:161)
-> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
-> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
-> org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:83)
-> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
-> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
-> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
-> org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
-> org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
-> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
-> org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
-> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
-> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
-> org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
-> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
-> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
-> org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
-> org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:88)
-> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
-> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
-> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
-> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
-> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
-> org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:265)
-> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
-> org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
-> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
-> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
-> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
-> org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
-> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
-> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
-> org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:59)
-> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
-> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
-> org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
-> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
-> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
-> org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:66)
-> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
-> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
-> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
-> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
-> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
-> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
-> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
-> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
-> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
-> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
-> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
-> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
-> java.lang.Thread.run(Thread.java:745)
Can you please help me to work on this?
Thanks
Support for plugin executions CE Type
Jpivot, pivot4j, OpenI
Support for plugin executions EE type
Dashboard designer, Analyser
After giving my personal details and pressing submit button i got error saying unable to publish.
After re-starting the server i went to Pentaho CE Audit in tools menu and got errors in all the components.
I checked the logs and getting bellow error.
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: mondrian:/Pentaho+CE+Audit
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:989)
at mondrian.olap.Util.newInternal(Util.java:2403)
at mondrian.olap.Util.newError(Util.java:2418)
at mondrian.olap.Util.readVirtualFile(Util.java:3356)
at mondrian.olap.Util.readVirtualFileAsString(Util.java:3377)
at mondrian.rolap.RolapSchemaPool.getSchemaContent(RolapSchemaPool.java:366)
at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:136)
at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:86)
at mondrian.rolap.RolapConnection.(RolapConnection.java:168)
at mondrian.rolap.RolapConnection.(RolapConnection.java:91)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DefaultMondrianConnectionProvider.createConnection(DefaultMondrianConnectionProvider.java:67)
at org.pentaho.reporting.platform.plugin.connection.PentahoMondrianConnectionProvider.createConnection(PentahoMondrianConnectionProvider.java:54)
at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:385)
at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:132)
at pt.webdetails.cda.utils.mondrian.CompactBandedMDXDataFactory.queryData(CompactBandedMDXDataFactory.java:48)
at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:172)
at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:154)
at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:67)
at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:411)
at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:299)
at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:127)
... 105 more
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.