No extraction activity

[jjrabadan]

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]

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]

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]

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]

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]

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.