<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic AAAR Installation Issue in Alfresco Forum</title>
    <link>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13011#M5743</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi &lt;A _jive_internal="true" data-containerid="-1" data-containertype="-1" data-objectid="87041" data-objecttype="3" href="https://community.alfresco.com/people/fcorti" rel="nofollow noopener noreferrer"&gt;Francesco Corti&lt;/A&gt;&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am trying to setup AAAR with Alfresco and facing issues.&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The current setup is&lt;/P&gt;&lt;P&gt;Centos7&lt;/P&gt;&lt;P&gt;Alfresco CE 201701GA / 5.2&lt;CODE&gt; &lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;AAAR 4.5&lt;/P&gt;&lt;P&gt;Pentaho DI 7&lt;/P&gt;&lt;P&gt;Pentaho BA 7&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;During the AAAR installation phase I faced issues&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The error shown was the following in catalina.out&lt;/P&gt;&lt;P&gt;2017/02/13 17:04:17 - Restore AAAR_Kettle - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : We can not find file [file:///opt/pentaho-server/pentaho-solutions/system/AAAR/endpoints/kettle/src/Alfresco_5_2/PostgreSql/AAAR_Kettle_v6.sql]!&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;There is no "AAAR_Kettle_v6.sql" in that directory but "AAAR_Kettle_v7.sql" is present&lt;/P&gt;&lt;P&gt;I believe this is due to the setting in the following file "kettleVersion"&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Also I noticed that inspite of me saving the settings from the pentaho console, during the AAAR installation my settings were getting changed to the default values like FTP port 1121 etc. When I monitored the file, when I skipped from "Alfresco" to "AAAR DataMart" to Pentaho Data Integration (kettle)" tabs in "Configure" section the file values were getting reverted back and finally when I installed the AAAR the values were not what I had provided.&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I entered the values manually in the below file and it was taken by the install&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Finally to get the install script working I had to create a symlink between "AAAR_Kettle_v6.sql" and "AAAR_Kettle_v7.sql"&amp;nbsp;&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I hope that doesn't mess the installation - but you need to definitely have a look at the mentioned issues&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;[root@N-alfresco pentaho-server]# cat /opt/pentaho-server/pentaho-solutions/system/AAAR/endpoints/kettle/conf/AAARConfiguration.xml&lt;BR /&gt;&amp;lt;?xml version='1.0' encoding='UTF-8'?&amp;gt;&lt;BR /&gt;&amp;lt;AAAR&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="AAARGetAudit" value="true" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="AAARGetNodes" value="true" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="AAARGetWorkflows" value="true" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoAuditLimit" value="50000" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoNodeLimit" value="50000" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoFtpPath" value="alfresco" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoFtpPort" value="21" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoHost" value="10.20.102.56" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoLogin" value="admin" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoPassword" value="Alfresco!@#$" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoProtocol" value="http" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoPort" value="8080" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="alfrescoType" value="Alfresco_5_2" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="databaseBin" value="/usr/bin" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="databaseType" value="PostgreSql" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="databaseHost" value="localhost" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="databaseLogin" value="postgres" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="databasePassword" value="Alfresco!@#$" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="databasePort" value="5432" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="databaseSchemaAAAR" value="AAAR_DataMart" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="databaseSchemaKettle" value="AAAR_Kettle" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="databaseSchemaMain" value="postgres" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="kettlePath" value="/opt/data-integration" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="kettleVersion" value="6" /&amp;gt;&lt;BR /&gt;&amp;lt;parameter name="pentahoAAARPath" value="/public/AAAR" /&amp;gt;&lt;BR /&gt;&amp;lt;/AAAR&amp;gt;&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;So once the AAAR installation is done I am currently facing issues with the AAAR_Extract.sh script&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Before that could you please confirm if everything looks ok to you till now?!!!&lt;/P&gt;&lt;P style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have attached the catalina.out logs produced during the AAAR installation for your perusal.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 15 Feb 2017 06:53:34 GMT</pubDate>
    <dc:creator>bushniel</dc:creator>
    <dc:date>2017-02-15T06:53:34Z</dc:date>
    <item>
      <title>AAAR Installation Issue</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13011#M5743</link>
      <description>Hi Francesco Corti&amp;nbsp;I am trying to setup AAAR with Alfresco and facing issues.&amp;nbsp;The current setup isCentos7Alfresco CE 201701GA / 5.2 AAAR 4.5Pentaho DI 7Pentaho BA 7&amp;nbsp;During the AAAR installation phase I faced issues&amp;nbsp;The error shown was the following in catalina.out2017/02/13 17:04:17 - Restore AAAR_K</description>
      <pubDate>Wed, 15 Feb 2017 06:53:34 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13011#M5743</guid>
      <dc:creator>bushniel</dc:creator>
      <dc:date>2017-02-15T06:53:34Z</dc:date>
    </item>
    <item>
      <title>Re: AAAR Installation Issue</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13012#M5744</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi &lt;B&gt;Bushniel Ashraf&lt;/B&gt;‌,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Mmmm, this seems to be a bug into the installation dashboards.&lt;/P&gt;&lt;P&gt;My suggestion is to rename&amp;nbsp;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;"AAAR_Kettle_v7.sql" into&amp;nbsp;&lt;SPAN&gt;"AAAR_Kettle_v6.sql" and you issue will disappear.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;&lt;SPAN&gt;The issue affects the installation task only and not the correct setup of the environment.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #727174; background-color: #ffffff;"&gt;&lt;SPAN&gt;I hope this will help you.&lt;BR /&gt;&lt;BR /&gt;PS: I'm completing the Alflytics 5.0 (Alflytics is the new name of the AAAR module) and this kind of error will be naturally solved with a different (and easier) approach, so I don't plan to open an issue on github for this.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 16 Feb 2017 09:53:37 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13012#M5744</guid>
      <dc:creator>fcorti</dc:creator>
      <dc:date>2017-02-16T09:53:37Z</dc:date>
    </item>
    <item>
      <title>Re: AAAR Installation Issue</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13013#M5745</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Got the same issue and did the same thing. Issue solved. Installation went well with no apparent errors. But now I am trying to solve Extraction issues...&lt;img id="smileysad" class="emoticon emoticon-smileysad" src="https://connect.hyland.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 27 Apr 2017 08:29:54 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13013#M5745</guid>
      <dc:creator>jsimonet</dc:creator>
      <dc:date>2017-04-27T08:29:54Z</dc:date>
    </item>
    <item>
      <title>Re: AAAR Installation Issue</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13014#M5746</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Jeremie,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Feel free to share the log messages with the error, if needed. &lt;span class="lia-unicode-emoji" title=":winking_face:"&gt;😉&lt;/span&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 02 May 2017 07:46:27 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13014#M5746</guid>
      <dc:creator>fcorti</dc:creator>
      <dc:date>2017-05-02T07:46:27Z</dc:date>
    </item>
    <item>
      <title>Re: AAAR Installation Issue</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13015#M5747</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I just messed up the connections. Trying to get myself out. I used Spoon to troubleshoot. Now I'm having Source ID 0 error on Retrieving Source ID task. Need to find out what I setup wrong. Its fun to find the answer yourself. If I'm really really stuck I'll call for help hehe, thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 08 May 2017 18:58:34 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13015#M5747</guid>
      <dc:creator>jsimonet</dc:creator>
      <dc:date>2017-05-08T18:58:34Z</dc:date>
    </item>
    <item>
      <title>Re: AAAR Installation Issue</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13016#M5748</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Was using my home connection and forgot to add the address to the mysql database of Alfresco duh...issue solved...next&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 08 May 2017 19:05:24 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13016#M5748</guid>
      <dc:creator>jsimonet</dc:creator>
      <dc:date>2017-05-08T19:05:24Z</dc:date>
    </item>
    <item>
      <title>Re: AAAR Installation Issue</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13017#M5749</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Good job, nice to hear it.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 10 May 2017 11:00:19 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/aaar-installation-issue/m-p/13017#M5749</guid>
      <dc:creator>fcorti</dc:creator>
      <dc:date>2017-05-10T11:00:19Z</dc:date>
    </item>
  </channel>
</rss>

