Extraction and integration

Anonymous — Thu, 28 Jun 2018 15:46:25 GMT

Hello!
I am a beginner in Talend Open Studio
I was asked to extract and integrate the data from several different databases.
I started and then I created several jobs with bugs that I had to solve but there is the execution of a job that sends me a bug related to log4j.xml
I would like you to give me a hand.
Thank you!

Starting job Job04_Geography_Dim at 16:17 28/06/2018.

[statistics] connecting to socket on port 3890
[statistics] connected
log4j:ERROR Could not parse url [file:/D:/Master%202/Entrepôts%20de%20données/Talend%20Open%20Studio/ORION_PROJECT/poms/jobs/process/job04_geography_dim_0.1/src/main/ext-resources/log4j.xml].
com.sun.org.apache.xerces.internal.util.URI$MalformedURIException: Path contains invalid character: ô
	at com.sun.org.apache.xerces.internal.util.URI.initializePath(Unknown Source)
	at com.sun.org.apache.xerces.internal.util.URI.initialize(Unknown Source)
	at com.sun.org.apache.xerces.internal.util.URI.<init>(Unknown Source)
	at com.sun.org.apache.xerces.internal.util.URI.<init>(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.expandSystemIdStrictOff1(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.expandSystemId(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.resolveEntityAsPerStax(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$DTDDriver.dispatch(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$DTDDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
	at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
	at org.apache.log4j.xml.DOMConfigurator$2.parse(DOMConfigurator.java:690)
	at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:789)
	at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:696)
	at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:471)
	at org.apache.log4j.LogManager.<clinit>(LogManager.java:125)
	at org.apache.log4j.Logger.getLogger(Logger.java:105)
	at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:262)
	at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:108)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at org.apache.commons.logging.impl.LogFactoryImpl.createLogFromClass(LogFactoryImpl.java:1025)
	at org.apache.commons.logging.impl.LogFactoryImpl.discoverLogImplementation(LogFactoryImpl.java:844)
	at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:541)
	at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:292)
	at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:269)
	at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:657)
	at com.healthmarketscience.jackcess.impl.DatabaseImpl.<clinit>(DatabaseImpl.java:82)
	at com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:248)
	at org.talend.ucanaccess.encrypt.CryptCodecOpener.open(CryptCodecOpener.java:18)
	at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:158)
	at net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:57)
	at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:103)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at orion_project.job04_geography_dim_0_1.Job04_Geography_Dim.tDBInput_2Process(Job04_Geography_Dim.java:2748)
	at orion_project.job04_geography_dim_0_1.Job04_Geography_Dim.tDBInput_16Process(Job04_Geography_Dim.java:1440)
	at orion_project.job04_geography_dim_0_1.Job04_Geography_Dim.runJobInTOS(Job04_Geography_Dim.java:5309)
	at orion_project.job04_geography_dim_0_1.Job04_Geography_Dim.main(Job04_Geography_Dim.java:5158)
log4j:WARN No appenders could be found for logger (com.healthmarketscience.jackcess.Index).
log4j:WARN Please initialize the log4j system properly.

Re: Extraction and integration

vboppudi — Thu, 28 Jun 2018 18:27:09 GMT

If possible can you please share job screen shot.

Regards,

topic Extraction and integration in Talend Studio

Extraction and integration

Re: Extraction and integration