search

fcorti / Alflytics

The Open Source Business Intelligence solution over the Alfresco platform.
http://fcorti.com
GNU Lesser General Public License v2.1
16 stars 11 forks source link

No extraction activity #14

Open jjrabadan opened 6 years ago

jjrabadan commented 6 years ago

Hi:

I've installed Pentaho and Alflytics successfully, but when I try to push the Extract button, Catalina does not show me any REST call.... This is what I see: (I use HSQL)

2018/08/09 18:28:19 - readConfiguration - Spedizione iniziata per la trasformazione [readConfiguration] 2018/08/09 18:28:19 - DWH_ALF_DIM_INSTANCES.0 - Finished reading query, closing connection. 2018/08/09 18:28:19 - DWH_ALF_DIM_INSTANCES.0 - Elaborazione terminata (I=9, O=0, R=0, W=9, U=0, E=0) 2018/08/09 18:28:19 - OUTPUT.0 - Elaborazione terminata (I=0, O=0, R=9, W=9, U=0, E=0) 2018/08/09 18:28:28 - alflyticsExtract - Spedizione iniziata per la trasformazione [alflyticsExtract] 2018/08/09 18:28:28 - Data Grid.0 - Elaborazione terminata (I=0, O=0, R=0, W=1, U=0, E=0) 2018/08/09 18:28:28 - Variable substitution.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 18:28:28,345 ERROR [RepositoryResource] Repository file [:public:Alflytics:ETL:Get all.kjb] not found 2018/08/09 18:28:28 - HTTP Client.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 2018/08/09 18:28:28 - OUTPUT.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 2018/08/09 18:29:36 - readConfiguration - Spedizione iniziata per la trasformazione [readConfiguration] 2018/08/09 18:29:36 - DWH_ALF_DIM_INSTANCES.0 - Finished reading query, closing connection. 2018/08/09 18:29:36 - DWH_ALF_DIM_INSTANCES.0 - Elaborazione terminata (I=9, O=0, R=0, W=9, U=0, E=0) 2018/08/09 18:29:36 - OUTPUT.0 - Elaborazione terminata (I=0, O=0, R=9, W=9, U=0, E=0) 2018/08/09 18:30:01 - writeConfiguration - Inizio dell'esecuzione del job 2018/08/09 18:30:01 - writeConfiguration - Inizio entry [SQL] 2018/08/09 18:30:01 - writeConfiguration - Inizio entry [Success] 2018/08/09 18:30:01 - writeConfiguration - Terminata jobentry [Success] (risultato=[true]) 2018/08/09 18:30:01 - writeConfiguration - Terminata jobentry [SQL] (risultato=[true]) 2018/08/09 18:30:01 - writeConfiguration - L'esecuzione del job è terminata 2018/08/09 18:31:04 - alflyticsExtract - Spedizione iniziata per la trasformazione [alflyticsExtract] 2018/08/09 18:31:04 - Data Grid.0 - Elaborazione terminata (I=0, O=0, R=0, W=1, U=0, E=0) 2018/08/09 18:31:04 - Variable substitution.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 18:31:04,132 ERROR [RepositoryResource] Repository file [:public:Alflytics:ETL:Get all.kjb] not found 2018/08/09 18:31:04 - HTTP Client.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 2018/08/09 18:31:04 - OUTPUT.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 18:31:34,645 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/saikuplugin.properties_supported_languages.properties not found in plugin saiku 18:31:34,663 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/saikuplugin.properties.properties not found in plugin saiku 18:31:34,684 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/saikuplugin.properties_it.properties not found in plugin saiku 18:31:34,726 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/saikuplugin.properties_it_IT.properties not found in plugin saiku 2018/08/09 18:46:38 - readConfiguration - Spedizione iniziata per la trasformazione [readConfiguration] 2018/08/09 18:46:38 - DWH_ALF_DIM_INSTANCES.0 - Finished reading query, closing connection. 2018/08/09 18:46:38 - DWH_ALF_DIM_INSTANCES.0 - Elaborazione terminata (I=9, O=0, R=0, W=9, U=0, E=0) 2018/08/09 18:46:38 - OUTPUT.0 - Elaborazione terminata (I=0, O=0, R=9, W=9, U=0, E=0) 2018/08/09 18:47:02 - writeConfiguration - Inizio dell'esecuzione del job 2018/08/09 18:47:02 - writeConfiguration - Inizio entry [SQL] 2018/08/09 18:47:02 - writeConfiguration - Inizio entry [Success] 2018/08/09 18:47:02 - writeConfiguration - Terminata jobentry [Success] (risultato=[true]) 2018/08/09 18:47:02 - writeConfiguration - Terminata jobentry [SQL] (risultato=[true]) 2018/08/09 18:47:02 - writeConfiguration - L'esecuzione del job è terminata 2018/08/09 18:47:46 - alflyticsExtract - Spedizione iniziata per la trasformazione [alflyticsExtract] 2018/08/09 18:47:46 - Data Grid.0 - Elaborazione terminata (I=0, O=0, R=0, W=1, U=0, E=0) 2018/08/09 18:47:46 - Variable substitution.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 18:47:46,456 ERROR [RepositoryResource] Repository file [:public:Alflytics:ETL:Get all.kjb] not found 2018/08/09 18:47:46 - HTTP Client.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 2018/08/09 18:47:46 - OUTPUT.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0)

Thank you for your support.

fcorti commented 6 years ago

A couple iof things: 1) It's very strange the language is italian. It should not affect the success, but it's unusual. 2) The log trail is NOT related to extraction, but it is related to installation.

Please double check your pressing the Extraction button (not the installation button). If the previous check is positive, the issue is probably on the client side (the button does not work). Try to enable the browser console to see about errors or issues.

Let me know how it goes.

jjrabadan commented 6 years ago

Hi @fcorti : I've checked the button "Extract" on Firefox, Chrome and Safari. No errors. The console doesn't show any error. Here is the content from pentaho.log just after clicking "Extract":

2018-08-10 12:25:21,008 INFO [org.pentaho.di] 2018/08/10 12:25:21 - alflyticsExtract - Spedizione iniziata per la trasformazione [alflyticsExtract] 2018-08-10 12:25:21,012 INFO [org.pentaho.di] 2018/08/10 12:25:21 - Data Grid.0 - Elaborazione terminata (I=0, O=0, R=0, W=1, U=0, E=0) 2018-08-10 12:25:21,017 INFO [org.pentaho.di] 2018/08/10 12:25:21 - Variable substitution.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 2018-08-10 12:25:21,024 ERROR [org.pentaho.platform.web.http.api.resources.RepositoryResource] Repository file [:public:Alflytics:ETL:Get all.kjb] not found 2018-08-10 12:25:21,027 INFO [org.pentaho.di] 2018/08/10 12:25:21 - HTTP Client.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0) 2018-08-10 12:25:21,028 INFO [org.pentaho.di] 2018/08/10 12:25:21 - OUTPUT.0 - Elaborazione terminata (I=0, O=0, R=1, W=1, U=0, E=0)

I also verified on pentaho-solutions/system/Alflytics/data/hsqldb/alflytics.log that INSERT INTO DWH_ALF_DIM_INSTANCES is correct (Alfresco's endopoint).

What can I do to check/verify Extractions ?? When I do click on 4.Check, everything is empty.....

fcorti commented 6 years ago

The error is here:

2018-08-10 12:25:21,024 ERROR [org.pentaho.platform.web.http.api.resources.RepositoryResource] Repository file [:public:Alflytics:ETL:Get all.kjb] not found

Jobs and transformations are not installed. Please check the installation first.

aivdev commented 5 years ago

I've this problem... I receive the same message at catalina.out log file... But I follow the guide... I see that ETL files are zip with timestamp in default-content... could you say what I've to see in order to solve it?

fcorti commented 5 years ago

Hi, When you will start Pentaho, the ZIP file will be automatically extracted and imported into the Pentaho repository. If you use Pentaho Data Integration and access to the repository, you will see a collection of jobs and transformations.