[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 
Error while executing my Talend job  XML
Forum Index » Technical Help - SpagoBI Server - ETL
Author Message
bash.spw

Newby

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

Hi !

First of all, I'm using SpagoBI 2.6 with Talend 4.0.2

I've deployed my Talend job successfuly (I guess) and I get my .item, .properties and .jar files in the folders under resources/talend/RuntimeRepository/... . I also have the XML file which looks like this :

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

It seems to be ok.

When I login on SpagoBI as admin, I try to execute my job but I get an error. The log file shows the following error message :

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.Http11Processor.process(Http11Processor.java:857)
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:619)

If anyone has an idea about the problem it would be nice to reply.

Thanks

This message was edited 1 time. Last update was at 05/08/2010 14:49:15

shineangelic.spw

Newby
[Avatar]

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


Does the TalendDriver logfile contain some useful information?

I'm new to SpagoBI, too, so I'm probably wrong, but it seems like your Talend job started because the error comes from java.lang.Thread


Can you execute successfully other Talend jobs? (the demo one, or just an "hello world")
bash.spw

Newby

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

Hi,

thanks for you reply.

A simple "Hello world" job doesn't work either.

In fact I've just tried to use Talend v3.2 instead of Talend v4 and now I have a new problem :

SpagoBI shows me the message "etl.process.started". Nevertheless, the log file now displays the following Exception :

ERROR it.eng.spagobi.services.dataset.service.DataSetSupplier.getDataSet:76 - Dataset is not configured neither for document nor for its engine.
[http-8082-1] 05 août 2010 16:08:35,233 ERROR it.eng.spagobi.engines.drivers.talend.TalendRolesHandler.calculateRoles:71 - Malformed BIObject id: null
java.lang.NumberFormatException: For input string: "null"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:4
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.<init>(Integer.java:620)
at it.eng.spagobi.engines.drivers.talend.TalendRolesHandler.calculateRoles(TalendRolesHandler.java:69)
at it.eng.spagobi.services.event.service.EventServiceImpl.fireEvent(EventServiceImpl.java:77)
at it.eng.spagobi.services.event.service.EventServiceImpl.fireEvent(EventServiceImpl.java:57)
at it.eng.spagobi.services.event.stub.EventServiceSoapBindingImpl.fireEvent(EventServiceSoapBindingImpl.java:15)
at it.eng.spagobi.services.event.stub.EventServiceSoapBindingSkeleton.fireEvent(EventServiceSoapBindingSkeleton.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:11
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
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 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:857)
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:619)
[http-8082-1] 05 août 2010 16:08:35,235 ERROR it.eng.spagobi.services.event.service.EventServiceImpl.fireEvent:86 - TalendRolesHandler not found
it.eng.spago.error.EMFInternalError: severity [ERROR] description [Malformed BIObject id: null]
at it.eng.spagobi.engines.drivers.talend.TalendRolesHandler.calculateRoles(TalendRolesHandler.java:72)
at it.eng.spagobi.services.event.service.EventServiceImpl.fireEvent(EventServiceImpl.java:77)
at it.eng.spagobi.services.event.service.EventServiceImpl.fireEvent(EventServiceImpl.java:57)
at it.eng.spagobi.services.event.stub.EventServiceSoapBindingImpl.fireEvent(EventServiceSoapBindingImpl.java:15)
at it.eng.spagobi.services.event.stub.EventServiceSoapBindingSkeleton.fireEvent(EventServiceSoapBindingSkeleton.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:11
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
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 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:857)
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:61

any idea ? :o
shineangelic.spw

Newby
[Avatar]

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



The " - Malformed BIObject id: null " reminds me the same kind of error I get, I posted it two or three days ago in this section. It seems that both the objectId and the job label aren't passed to Talend Driver, anyway this is only my opinion. BTW, your stack trace is far longer.

I think we should wait for official support...
bash.spw

Newby

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

According to https://projects.savoirfairelinux.com/issues/show/3592, I guess the job should be working :o

It's weird ^^
bash.spw

Newby

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

Concerning my problem it was due to my contexts so the log was displaying a "false" exception.
rjusher.spw

Newby

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

I am getting the same error, but i dont understand how you solved it, what do you mean it was due to your contexts, can you help me by explaining what you did in order to solve this problem.
bash.spw

Newby

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

Hi !
In fact this error seems to be a generic error.
In my case, I've just defined new contexts (other than default) and checked the boxes of my jobs to allow my subjobs to use the same context than my main job.
I don't know if your problem is the same but anyway you won't find your problem using the log file.
Like I said previously, it's a fake exception.

I hope it will be helpful for you.

Bash
rjusher.spw

Newby

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

Hi!

I tried what you explained to me in here, and it didn't work. So i tried to run my Talend jobs in the Demo of spago 2.6 and they worked so i am guessing that i am missing some configuration of talend.

Is there any configuration i need to do in order to work with talend?

Thank you!
 
Forum Index » Technical Help - SpagoBI Server - ETL
Go to:   
Powered by JForum 2.1.9 © JForum Team