With this task you get the A.A.A.R. Application into your Pentaho environment.
Below the description of the tasks to develop.
Access to Pentaho User Console as administrator (otherwise you will not have permits to access to the marketplace). Click on Home -> Marketplace.
Click on the ‘Install’ button of the Saiku Analytics plugin.
Click on the ‘Install’ button of the Pivot4j Analytics plugin (see the image below).
Click on the ‘Install’ button of the Alfresco Audit Analysis and Reporting plugin (see the image below).
Stop the Pentaho BIServer using the ‘stop-pentaho’ script (you can find it in the ‘biserver-ce’ folder).
Edit ‘<bi-server>/pentaho-solutions/system/importExport.xml’ adding the lines below.
... <bean id="IRepositoryContentConverterHandler" ... > <constructor-arg> <util:map id="convertersMap"> <entry key="mondrian.xml" value-ref="streamConverter"/> <entry key="jpeg" value-ref="streamConverter"/> <!-- Add the line below here!--> <entry key="saiku" value-ref="streamConverter"/> </util:map> </constructor-arg> </bean> ... <bean id="DefaultExportHandler" ... > <property name="repository" ref="unifiedRepository" /> <property name="localeExportList"> <list> <value>.xanalyzer</value> ... <!-- Add the lines below here! --> <value>.saiku</value> <value>.pivot4j</value> </list> </property> </bean> ... <bean class="org.pentaho.platform.plugin.services.importer.LocaleImportHandler"> <constructor-arg> <list> <value>xaction</value> ... <!-- Add the lines below here! --> <value>saiku</value> <value>pivot4j</value> </list> ...
Edit ‘<bi-server>/pentaho-solutions/system/ImportHandlerMimeTypeDefinitions.xml’ adding the lines below.
... <ImportHandler class="org.pentaho.platform.plugin.services.importer.RepositoryFileImportFileHandler"> <MimeTypeDefinitions> ... <MimeTypeDefinition mimeType="text/xml"> <extension>cda</extension> ... <!-- Add the line below here! --> <extension>pivot4j</extension> </MimeTypeDefinition> <!-- Add the lines below here! --> <MimeTypeDefinition mimeType="application/json"> <extension>saiku</extension> </MimeTypeDefinition> </MimeTypeDefinitions> </ImportHandler>
Start the Pentaho BIServer using the ‘start-pentaho’ script (you can find them in the ‘biserver-ce’ folder).
ATTENTION: After the installation, if your AAAR is not showing Configure/Install/Use buttons, please update “Community Graphics Generator” and “Community Dashboards Framework”. Thank you to jservajean and kossel for the solution described here.
<< Alfresco AMP | Up to How-to install | Install A.A.A.R. >>
What to do if both “All plugins” and “Installed plugins” tables are empty?
I’ve tried to make this http://forums.pentaho.com/archive/index.php/t-146132.html?s=10800f2d975e26f4d738d8a2bed377b6 but got no result.
Hi Douglas,
For sure is a problem of the internet connection but I don’t have any other suggestion. I’m sorry.
Hi Douglas,
Did you find the solution? I have the same issue…
Thanks,
Patrick
Yes, I’ve found the solution.
The problem was the firewall was blocking the access for some pentaho urls.
What I did was to allow the access of those urls, and then everything worked ok.
don’t really know how to do that. But I see error meeages appear when I go to the Mrketplace:
13:22:37,028 ERROR [GenericServlet] GenericServlet.ERROR_0004 – Resource /jpivot
/jpivot/messages_supported_languages.properties not found in plugin jpivot
[Fatal Error] :1:1: Content is not allowed in prolog.
org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at org.pentaho.marketplace.MarketplaceService.loadPluginsFromSite(MarketplaceService.java:528)
at org.pentaho.marketplace.MarketplaceService.getPlugins(MarketplaceService.java:102)
at org.pentaho.marketplace.MarketplaceService.getPluginsJson(MarketplaceService.java:389)
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:601)…
Hi Patrick,
Try here:
http://forums.pentaho.com/showthread.php?154103-ctools-install-on-5-0-1
Hi Francesco,
I can not see the plugin “Alfresco Audit Analysis and Reporting” in the list of all plugins. You know that may be happening?
Greetings,
Pablo.
Hi Pablo,
Which version of Pentaho are you using?
During the past days I limited the AAAR v2.0 version to Pentaho 5 and AAAR v2.1 to Pentaho v5.1.
Probably something happens…
Please, let me know so I can check and solve it.
Thank you in advance.
Hi Franceso,
Today I can see the plugin in the list. I don’t know why I could not see the plugin the other day.
Thanks for your reply.
Greetings,
Pablo.
Great!
It depends on the upgrade I requested to the Pentaho guys about the marketplace here: https://github.com/pentaho/marketplace-metadata.
So… many thanks to them, as usual. 😉
I understand :D.
Other question: the zip file in https://addons.alfresco.com/addons/alfresco-audit-analysis-and-reporting-aaar is the same of this plugin?. I install the plugin in pentaho, but in Alfresco I can’t see the AAAR tool. And with respect the data, Exist data example for test the plugin? I open the analytics, but I only can see “No data found”.
Thanks for the help.
Greetings,
Pablo.
Yes, the zip file here (https://sourceforge.net/projects/aaar/files/?source=navbar) are exactly the same zip files downloaded from the marketplace.
No, I don’t have sample data in the AAAR_DataMart. You have to execute the ‘AAAR_Extract’ before.
Cheers.
After following your directions, using Pentaho Community 5.2.0.0.209, I am getting a strange behavior when clicking “Tools -> AAAR”. I get the HTML code view of the resulting page, not a rendered view. I am seeing the HTML code rather than the actual rendered HTML, if that makes sense. I am also seeing lots of errors in my logs about saiku, although I think I’ve fixed most/all of those.
Hi David,
This is unusual and strange and I suppose it is a problem during Pentaho’s installation and setup.
Please, if you don’t find the solution, open an issue at the link below with further details (environment details, etc.).
https://github.com/fcorti/alfresco-audit-analysis-reporting/issues
In any case, let us know.
Is it possible the problem is related to Kettle? I’ve had trouble installing Kettle b/c I’m on a headless (no GUI) linux server. I have also noticed that Sparkl fails completely to work (“error processing component (pluginsList)”). I’m thinking of going back to a previous version of Pentaho if possible.
Hi David,
About Kettle: I don’t think because kettle is involved only in the ETL processes, not the presentations. I suppose Pentaho BI server instead.
About Sparkl: this is an existing issue that does not affect AAAR.
About noGUIServer: I often install Pentaho+AAAR in that way.
I thing the problem is elsewhere… permits?
Hello, is AAAR compatible with Alfresco Enterprise 5.0 version? Everything was fine when I downloaded the plugins.
But after inserting the codes in ‘/pentaho-solutions/system/importExport.xml’ AND ‘/pentaho-solutions/system/ImportHandlerMimeTypeDefinitions.xml’ I can no longer access http://localhost:8080/pentaho.
Any suggestion on how to troubleshoot? Would greatly appreciate the help
Hi Migs,
Yes, AAAR 3.1 has been tested with Alfresco EE 5.
Your issue is probably caused by the wrong set of the xml files.
What you describe is compliance with this syntax problem.
Please check the Catalina.out log file of the pentaho tomcat and let me know how it goes.
Cheers,
F
Sorry my mistake. I copied the entire thing haha.. I figured it out now. Moving on to the next steps!
Hi Francesco,
I was able to make AAAR work. After extracting my first report, I noticed that only the Login portion has data.
How can I enable the other reports included in AAAR? i.e. Document logs, File logs, Workflow logs.
Thank you in advance!
Hi Migs,
I think you are having errors during the extraction regarding the file structure and workflows (they are two different jobs).
Please take a look at catalina.out log file (in Pentaho) and then you’ll probably find the errors.
Please let me know how it goes (with an email privately to fcorti at gmail dot com) and I can support you to solve the problems.
Cheers.
Hi Mr Corti,
I tried to install AAAR many times, but i always fail with this error :
“ERROR [RepositoryResource] Repository file [:public:AAAR:main.wcdf] not found”
I tried also to reinstall many times all the plugins, but with the same result.
Can you, please, help me find the source of the problem.
I used pentaho BI 5.4 and 5.3 with AAAR 3.1.
Thanx a lot by advance.
Hi Mehdi,
Please confirm you accessed to the Sparkl dashboard and installed the AAAR, before accessing to the AAAR main dashboard.
I suggest you to follow what is written in the page below:
http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/aaar-install/
If you cannot solve it, write me privately at fcorti at gmail dot com and I’ll give you support.
Cheers.
Hi Francesco, with version 5.0.1 i don’t have ImportHandlerMimeTypeDefinitions.xml.
Can you help me?
Thanks!
Hi Riccardo,
Yes, correct but the goal of this task is simply installing Saiku Analytics and JPivot. Googling a little bit you should find the correct installation process but I suggest to install them from the marketplace and go ahead with the installation.
Of course, could be preferrable if you could upgrade to Pentaho 6. 😉
I cannot see Alfresco Audit Analysis and Reporting plugin in the Pentaho Marketplace. I am using 5.0.1. Does this still exist?
Hi Brett,
Pentaho 5.0.1 is out from AAAR support, as you can read here:
http://fcorti.com/alfresco-audit-analysis-reporting/aaar-description-of-the-solution/aaar-alfresco-pentaho/
The suggestion is to move to the latest Pentaho version.
If you cannot upgrade, you can try with the 3.1 version you can download at the link below.
https://github.com/fcorti/alfresco-audit-analysis-reporting/tree/master/build
To include AAAR into Pentaho, simply unzip the AAAR_…zip file into biserver/pentaho-solutions/system. THen you can follow the installation documentation below:
http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/
I hope this will help you.
Hi Francesco!
I believe I already told you about that batch script I was working on to automate the modification for the XML files.
I uploaded it to : https://gist.github.com/yregaieg/d5e066645d0ab1f5d8927b741fb66b04
Please feel free to suggest any enhancement, link the gist or include it to the AAAR install process.
Regards,
Younes
Hi Francesco,
Unfortunately I am experiencing an error with the A.A.A.R Install step. Saiku & Pivot have installed, but I getting error with install of AAAR plugin. I am running Pentaho 7 on Windows 10. The error I receive is:
Can not copy file/folder [zip:D:\pentaho\pentaho-server\pentaho-solutions\system/plugin-cache/downloads/AAAR-4.5_1488772669977.zip] to [D:\pentaho\pentaho-server\pentaho-solutions\system/plugin-cache/staging]
The next error is that the file D:\pentaho\pentaho-server\pentaho-solutions\system/plugin-cache/downloads/AAAR-4.5_1488772669977.zip cannot be opened.
I’ve also noted that in the D:\pentaho\pentaho-server\pentaho-solutions\system\plugin-cache\downloads share the AAAR-4.5 zip files have size of 0 kb
Thanks so much for your assistance.
Hi David,
Sourceforge link was broken due to some issues with Pentaho Marketplace.
Now the issue should be fixed.
Please try again.
(Sorry for my delay in reply but I was in a trip)
I believe we should mention to install Saiku Analytics which is not Enterprise Edition. I believe the EE causes errors.
Correct! Thank you for pointing us on this.
hello Francesco,
I am not able to see the market place as shown in the above screenshots what should I do for that.
thanks and regards