Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extraction and integration

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.
Labels (5)
1 Reply
vboppudi
Partner - Creator III
Partner - Creator III

If possible can you please share job screen shot.

 

Regards,