Error when using Talend example

[hanu]

Hi,

I have installed Talend Open Studio3.1.3, and I run the etlconnector sample job, its giving some exception. Please find the exception below.
I am using alfresco community edition 3.2V

Exception in component tAlfrescoOutput_1
fr.openwide.talendalfresco.rest.client.RestClientException: Unspecified error
   at fr.openwide.talendalfresco.rest.client.AlfrescoRestClient.execute(AlfrescoRestClient.java:136)
   at test1.firstjob_0_1.FirstJob.tFileInputDelimited_1Process(FirstJob.java:610)
   at test1.firstjob_0_1.FirstJob.runJobInTOS(FirstJob.java:832)
   at test1.firstjob_0_1.FirstJob.main(FirstJob.java:735)
Caused by: fr.openwide.talendalfresco.rest.client.RestClientException: org.alfresco.error.AlfrescoRuntimeException07080006 Error during command servlet processing: org.alfresco.repo.importer.view.NodeContext.addProperty(Lorg/alfresco/service/namespace/QName;Ljava/lang/StringV
   org.alfresco.web.app.servlet.CommandServlet.service(CommandServlet.java:197)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   fr.openwide.talendalfresco.rest.server.CommandAuthenticationFilter.doFilter(CommandAuthenticationFilter.java:118)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:74)
   sun.reflect.GeneratedMethodAccessor397.invoke(Unknown Source)
   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   java.lang.reflect.Method.invoke(Method.java:597)
   org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:122)
   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   $Proxy188.doFilter(Unknown Source)
   org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:88)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   java.lang.Thread.run(Thread.java:619)

Caused by :java.lang.NoSuchMethodErrororg.alfresco.repo.importer.view.NodeContext.addProperty(Lorg/alfresco/service/namespace/QName;Ljava/lang/StringV
   fr.openwide.talendalfresco.alfresco.importer.ViewParserBase.processProperty(ViewParserBase.java:678)
   fr.openwide.talendalfresco.alfresco.importer.ViewParserBase.processStartElement(ViewParserBase.java:301)
   fr.openwide.talendalfresco.alfresco.importer.ViewParserBase.parse(ViewParserBase.java:187)
   fr.openwide.talendalfresco.alfresco.importer.ContentImporterComponent.parserImport(ContentImporterComponent.java:257)
   fr.openwide.talendalfresco.alfresco.importer.ContentImporterComponentBase.importView(ContentImporterComponentBase.java:234)
   fr.openwide.talendalfresco.rest.server.command.ImportCommand.executeImpl(ImportCommand.java:133)
   fr.openwide.talendalfresco.rest.server.processor.RestCommandBase.executeRest(RestCommandBase.java:205)
   fr.openwide.talendalfresco.rest.server.processor.RestCommandProcessor.process(RestCommandProcessor.java:96)
   org.alfresco.web.app.servlet.CommandServlet.service(CommandServlet.java:155)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   fr.openwide.talendalfresco.rest.server.CommandAuthenticationFilter.doFilter(CommandAuthenticationFilter.java:118)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:74)
   sun.reflect.GeneratedMethodAccessor397.invoke(Unknown Source)
   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   java.lang.reflect.Method.invoke(Method.java:597)
   org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:122)
   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   $Proxy188.doFilter(Unknown Source)
   org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:88)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   java.lang.Thread.run(Thread.java:619)

   at fr.openwide.talendalfresco.rest.client.AlfrescoRestClient.execute(AlfrescoRestClient.java:137)
   … 3 more

[vince20]

I got the same issue with same versions.

It looks like latest talend jars (in fact 1.0 version…) are not compatibles with Alfresco 3.2

[hanu]

try with the Alfresco Enterprise edition 3.1

[thaspesl]

try with the Alfresco Enterprise edition 3.1

even with enterprise 3.1 edition I receive following error output. Any idea what should be modified to successfully run the demo project?

Thanks,
T

Starting job IMPORT_QUITUS_ALFRESCO at 17:21 25/08/2009.
Exception in component tAlfrescoOutput_1
fr.openwide.talendalfresco.rest.client.RestClientException: Error initing client
   at import_quitus.import_quitus_alfresco_0_1.IMPORT_QUITUS_ALFRESCO.tFileInputExcel_1Process(IMPORT_QUITUS_ALFRESCO.java:2434)
   at import_quitus.import_quitus_alfresco_0_1.IMPORT_QUITUS_ALFRESCO.runJobInTOS(IMPORT_QUITUS_ALFRESCO.java:4511)
   at import_quitus.import_quitus_alfresco_0_1.IMPORT_QUITUS_ALFRESCO.main(IMPORT_QUITUS_ALFRESCO.java:4423)
Caused by: fr.openwide.talendalfresco.rest.client.RestClientException: Bad HTTP Status : 500
   at fr.openwide.talendalfresco.rest.client.AlfrescoRestClient.execute(AlfrescoRestClient.java:121)
   at fr.openwide.talendalfresco.rest.client.AlfrescoRestClient.login(AlfrescoRestClient.java:179)
   at import_quitus.import_quitus_alfresco_0_1.IMPORT_QUITUS_ALFRESCO.tFileInputExcel_1Process(IMPORT_QUITUS_ALFRESCO.java:2432)
   … 2 more
Job IMPORT_QUITUS_ALFRESCO ended at 17:21 25/08/2009. [exit code=1]

[mdutoo]

Try with the Alfresco ETL connector for Alfresco 3.2, which has been released one year ago (there are also releases for 3.1 and 4.1), as said in the README :

<a href="http://github.com/OpenWide-SI/alfresco-etl-connector">http://github.com/OpenWide-SI/alfresco-etl-connector</a>

Otherwise, look up in Alfresco server-side logs to see the real error, when the error code is 500 (internal server error) as here.

Regards