AnsweredAssumed Answered

Why not can import data in of alfresco to AAAR?

Question asked by jsalgado93 on Aug 11, 2017


Hi Everyone. I have published an question in forum of AAAR because I have a issue import data of alfresco to AAAR. Below my question publish in the forum. Thanks everyone.

 

I have a problem with extraction of data with file “AAAR_Extract.sh”.
After run file this process not extracts info to database (before yes extracts data to database.) .
I read the log file located in:
“/LOCAL_ROUTE/AAAR/pentaho-server/pentaho-solutions/system/AAAR/endpoints/kettle/logs/AAAR.log” and find next errors:

Error 1.
Abort.0 – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Row nr 1 causing abort : [null], [{INFORMATION TO MY DATABASE CONECTION}], [409]
Abort.0 – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Aborting after having seen 1 rows.
Abort.0 – Finished processing (I=0, O=0, R=1, W=1, U=0, E=1)
_pentahoAddDatasource – Transformation detected one or more steps with errors.
_pentahoAddDatasource – Transformation is killing the other steps!
_pentahoAddDatasource – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Errors detected!
Switch / Case.0 – Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
HTTP Post.0 – Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
_pentahoAddDatasource – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Errors detected!
_installFromConfiguration – Finished job entry [_pentahoAddDatasource] (result=[false])
_installFromConfiguration – Finished job entry [_installPostgreSql] (result=[false])
_installFromConfiguration – Finished job entry [Check databaseType = ‘PostgreSql’] (result=[false])
_installFromConfiguration – Finished job entry [_readConfigurationInVariables] (result=[false])
_installFromConfiguration – Finished job entry [Checks if files exist] (result=[false])
installFromConfiguration – Finished job entry [_installFromConfiguration] (result=[false])
installFromConfiguration – Job execution finished
Kitchen – Finished!
Kitchen – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Finished with errors

Error 2.
HTTP tasks – Start of HTTP job entry.
HTTP tasks – Start of HTTP job entry.
HTTP tasks – Connecting to URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$2687?includeTasks=true
HTTP tasks – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : I was unable to save the HTTP result to file because of a I/O error: Server returned HTTP response code: 500 for URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$2687?includeTasks=true
HTTP tasks – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : java.io.IOException: Server returned HTTP response code: 500 for URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$2687?includeTasks=true

Error 3.
HTTP tasks – Start of HTTP job entry.
HTTP tasks – Connecting to URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$2774?includeTasks=true
HTTP tasks – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : I was unable to save the HTTP result to file because of a I/O error: Server returned HTTP response code: 500 for URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$2774?includeTasks=true
HTTP tasks – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : java.io.IOException: Server returned HTTP response code: 500 for URL: http://HostToMySite:8080/alfresco/service/api/workflow-instances/activiti$2774?includeTasks=true

Error 4.
HTTP tasks – Start of HTTP job entry.
HTTP tasks – Connecting to URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$3570?includeTasks=true
HTTP tasks – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : I was unable to save the HTTP result to file because of a I/O error: Server returned HTTP response code: 500 for URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$3570?includeTasks=true
HTTP tasks – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : java.io.IOException: Server returned HTTP response code: 500 for URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$3570?includeTasks=true

Error 5.
HTTP tasks – Start of HTTP job entry.
HTTP tasks – Connecting to URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$3701?includeTasks=true
HTTP tasks – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : I was unable to save the HTTP result to file because of a I/O error: Server returned HTTP response code: 500 for URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$3701?includeTasks=true
HTTP tasks – ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : java.io.IOException: Server returned HTTP response code: 500 for URL: http://HostToMySite.com:8080/alfresco/service/api/workflow-instances/activiti$3701?includeTasks=true

The error with I have more problems ist the Error 1. I really not have idea What to do with this error

Thank for you help, Cheers.
Note: Im learning English and, if I have been clear with my question excuse me and tell me To clarify the doubt. Thank

Outcomes