Error in running Talend job in Knowage CE

Question

Dear all,
i am trying to run Talend job via Knowage CE. Talend job is working in Talend and i have moved it in runnable JAR to proper location ...\resources\DEFAULT_TENANT\talend\RuntimeRepository\java. Also Generic Document looks configured properly.
when i run Generic document, i use to get this screen with message "etl.process.started".
in the logs i can see erorrs like:

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'USER_IN' at row 1

[http-bio-8080-exec-4] 11 Feb 2019 21:38:00,559 ERROR it.eng.spagobi.events.EventsManager.registerEvent:128 - Error while registering event generated by user 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoiYmlhZG1pbiIsImV4cCI6MTU0OTk1Mjg5OX0.GBc1iyPHFT2yPeTZ3hGF7iydcamPNyNu9jmNhP_1HR0' at 2019-02-11 21:38:00.544 with decription ${talend.execution.started}

<li>SBI_ENVIRONMENT = DOCBROWSER</li><li>CONTENT_SERVICE_PROXY =

......

</li><li>SBICONTEXT = /knowage</li><li>SBI_COUNTRY = US</li><li>SBI_EXECUTION_ROLE = admin</li><li>timereloadurl = 1549917479969</li></ul>]

java.lang.NullPointerException

[http-bio-8080-exec-5] 11 Feb 2019 21:38:00,794 ERROR it.eng.spagobi.commons.dao.AbstractHibernateDAO.logException:254 - org.hibernate.exception.DataException Could not execute JDBC batch update

org.hibernate.exception.DataException: Could not execute JDBC batch update

it.eng.spago.error.EMFUserError: severity [ERROR] description [Generic Error]

[http-bio-8080-exec-5] 11 Feb 2019 21:38:00,809 ERROR it.eng.spagobi.services.event.service.EventServiceImpl.fireEvent:84 - Impossible to fire event [${talend.execution.executionOk}<br/>${talend.execution.parameters}<br/><ul><li>SBI_LANGUAGE = en</li><li>SBI_ENVIRONMENT = DOCBROWSER</li><li>CONTENT_SERVICE_PROXY =

...........

it.eng.spagobi.services.proxy.EventServiceProxy@612660d9</li><li>DATASOURCE = it.eng.spagobi.tools.datasource.bo.DataSource@fc143a9f</li><li>DOCUMENT_ID = 40</li><li>SBICONTEXT = /knowage</li><li>SBI_COUNTRY = US</li><li>SBI_EXECUTION_ROLE = admin</li><li>timereloadurl = 1549917479969</li></ul>]
java.lang.NullPointerException

Is there any quick hint what to do to make it runable?

Answer 1

Greetings,

I checked in the profile session what is being saved, I found a similar problem in the cockpit ... the session saved the JWT string, when in fact it used the user id "for example".

Hugs

Answer 2

Hi all,

i have recreated talend document and it looks it is working.. at least data were successfully loaded to my DB. 

however, when i launch ETL document, i am able to see only this screen:

is it ok? 

Are there any statistics? Status and when was etl document executed? 

and last question, is there any step to step guide, how to schedule any ETL document in Knowage CE?

i know, a lots of questions and i will really appreciate any kind of help here :)

thanks

regards

Akm