[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Talend job fails  XML
Forum Index » Technical Help - SpagoBI Server - ETL
Author Message
mk.spw

Newby

Joined: 09/08/2010 10:41:36
Messages: 12
Offline

Hi,
I am using Spago2.5 + Talend 4.0.2
I exported Talend job properly but can't execute it: an.unpredicted.error.occured

Logs:
10 Aug 2010 00:07:56,603 ERROR it.eng.spagobi.utilities.engines.AbstractEngineStartServlet.handleException:91 - Service execution failed
java.lang.NullPointerException
at it.eng.spagobi.utilities.engines.EngineStartServletIOManager.getTemplate(EngineStartServletIOManager.java:193)
at it.eng.spagobi.utilities.engines.EngineStartServletIOManager.getTemplateAsString(EngineStartServletIOManager.java:183)
at it.eng.spagobi.utilities.engines.EngineStartServletIOManager.getTemplateAsSourceBean(EngineStartServletIOManager.java:171)
at it.eng.spagobi.utilities.engines.AbstractEngineStartServlet.doService(AbstractEngineStartServlet.java:86)
at it.eng.spagobi.engines.talend.services.JobRunService.doService(JobRunService.java:67)
at it.eng.spagobi.utilities.engines.AbstractEngineStartServlet.doService(AbstractEngineStartServlet.java:74)
at it.eng.spagobi.utilities.service.AbstractBaseServlet.service(AbstractBaseServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:211)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilter(AbstractTicketValidationFilter.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jasig.cas.client.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:121)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:29
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:58
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:636)

Can you help me?
bash.spw

Newby

Joined: 05/08/2010 11:38:03
Messages: 12
Offline

Hi,

I'm new with SpagoBI but have you tried to deploy your job with an older version of Talend ? I mean I don't know if SpagoBI (even 2.6) is compatible with Talend 4.
shineangelic.spw

Newby
[Avatar]

Joined: 23/07/2010 14:44:20
Messages: 15
Location: Bologna, IT
Offline


I got the same error.

I solved exporting manually from Talend via "export job scripts" and then copying the generated zip's content inside resources/RunTimeRepo folder.
mk.spw

Newby

Joined: 09/08/2010 10:41:36
Messages: 12
Offline

Hi shineangelic,
thanks for that. Could you let me know what checkboxes you ticked to export Talend job, please?
I understand you exported it as autonomous job with shell scripts, correct?
shineangelic.spw

Newby
[Avatar]

Joined: 23/07/2010 14:44:20
Messages: 15
Location: Bologna, IT
Offline

Yes, correct. I'm using Talend 4.0.2 on SpagoBI 2.6.0

on the Talend's export Script window everything is checked, a part of "Extract the zip file" and "Source files".

After having copied the job inside RunTimeRepository folder, you should be able to create an analytical document and upload the template XML. Mine is as follow:

<etl>
<job context="Default" project="monitoraggio" jobName="testLoad" version="0.1" language="java" />
</etl>


be warned that everything is case sensitive.

This message was edited 1 time. Last update was at 11/08/2010 14:37:38

rjusher.spw

Newby

Joined: 25/08/2010 03:50:17
Messages: 12
Offline

Ok, i did everything as i understand i should be doing it:

First i create my job in talend Open Studio
Second i right click on the job, and click Export Job Scripts, after that it opens a wizard where it asks me the export settings.
Once i click finish, it creates a zip file; I extract that zip file in resources path so it will create something like these:

resources/talend/RuntimeRepository/[Project name]
resources/talend/RuntimeRepository/[Project name]/[Job name]
resources/talend/RuntimeRepository/[Project name]/[Job name]/[All the files from the job]
resources/talend/RuntimeRepository/[Project name]/lib

So far so good, after that i need to create a xml template definition in a text editor, it should look something like this:
This one is the one that comes in the demo version of SpagoBI 2.6

<?xml version="1.0" encoding="UTF-8"?>
<etl>
<job context="Default" jobName="Clean_Audit" language="java" project="ProvaCorso"/>
</etl>

Save this document, then in the document creation wizard in SpagoBI, i create a new document with this document as a template.

Then i execute it, but it gives me an error, so i go to check the logs and it says the following:

04 Sep 2010 20:44:31,546 ERROR it.eng.spagobi.utilities.engines.AbstractEngineStartServlet.handleException:91 - Service execution failed
it.eng.spagobi.utilities.engines.SpagoBIEngineException: Job execution error
at it.eng.spagobi.engines.talend.services.JobRunService.doService(JobRunService.java:89)
at it.eng.spagobi.utilities.engines.AbstractEngineStartServlet.doService(AbstractEngineStartServlet.java:74)
at it.eng.spagobi.utilities.service.AbstractBaseServlet.service(AbstractBaseServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:221)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:29
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
at java.lang.Thread.run(Thread.java:619)

So i get the following questions:

What is the correct format of the template.xml definition document the one that has the <etl></etl> tags
1. The project name must be the same that the folder names, or it can be diferent, etc.
2. The same question but with the job name.
3. Was checking the demo and it puts the sample job under a folder named java, is this necesary
4.Can i connect to datasources that are not defined in spago datasources, in my talend jobs


d.synchronized@gmail.com.spw

SpagoBI supporter

Joined: 14/12/2012 05:15:51
Messages: 140
Offline

can u help me ,i also got the same error while deploying it manually,

thanks
Dishant
d.synchronized@gmail.com.spw

SpagoBI supporter

Joined: 14/12/2012 05:15:51
Messages: 140
Offline

solved .!!

the problem was in the etl document,
now i can deploy the job,it's working
chinthakasuse.spw



Joined: 15/01/2013 01:11:44
Messages: 1
Offline

yes. thanks a lot for ur wonderful comments. it really helped me a lot.
 
Forum Index » Technical Help - SpagoBI Server - ETL
Go to:   
Powered by JForum 2.1.9 © JForum Team