Proxy Configuration and Trouble Installing Packages

Five Stars

Proxy Configuration and Trouble Installing Packages

Hello,

 

I recently installed Talend Open Studio for Data Quality 6.4.1.  I think proxy configuration may be causing me to have problems downloading packages and/or the Tableau repository locations are wrong. 

 

1) I configured the proxy because that's what my office uses to handle requests (see screenshot).  But it is saying the system property is not set.  What and where do I set the 'system property'?  As you can see the port I use is 8080.  The proxy name is greyed out.

config_1.PNG

 

!ENTRY org.eclipse.core.net 1 0 2018-01-11 15:27:15.236
!MESSAGE System property https.proxyPort is not set but should be 8080.

 

!ENTRY org.eclipse.core.net 1 0 2018-01-11 15:27:15.220
!MESSAGE System property http.proxyPort is not set but should be 8080.

 

 

 

 

 

 

2) Two errors in log (Full log is attached).  Main ones are below.  There are a ton of jar files that Talend cannot seem to fetch either from its own online repository. Most of them are located at the url mvnSmiley Surprisedrg.talend.libraries/automaton-1.11-8/........)

 

a) 2018-01-11 15:53:52,567 ERROR org.talend.dataprofiler.core.download.AbstractDQMissingJarsExtraUpdatesFactory  - failed to fetch missing third parties jars information for org.talend.dataprofiler.top.chart.jar

b) 2018-01-11 15:53:52,551 ERROR org.talend.commons.exception.CommonExceptionHandler  - Error on line 1 of document  : Content is not allowed in prolog. Nested exception: Content is not allowed in prolog.

org.dom4j.DocumentException: Error on line 1 of document  : Content is not allowed in prolog. Nested exception: Content is not allowed in prolog.
 at org.dom4j.io.SAXReader.read(SAXReader.java:482)
 at org.dom4j.io.SAXReader.read(SAXReader.java:343)
 at org.talend.core.nexus.NexusServerUtils.search(NexusServerUtils.java:192)
 at org.talend.core.nexus.NexusServerUtils.search(NexusServerUtils.java:162)
 at org.talend.core.nexus.TalendLibsServerManager.search(TalendLibsServerManager.java:294)
 at org.talend.librariesmanager.utils.RemoteModulesHelper.searchFromRemoteNexus(RemoteModulesHelper.java:246)
 at org.talend.librariesmanager.utils.RemoteModulesHelper.access$7(RemoteModulesHelper.java:208)
 at org.talend.librariesmanager.utils.RemoteModulesHelper$RemoteModulesFetchRunnable.run(RemoteModulesHelper.java:150)
 at org.talend.dataprofiler.core.download.AbstractDQMissingJarsExtraUpdatesFactory.runNotInstallModule(AbstractDQMissingJarsExtraUpdatesFactory.java:206)
 at org.talend.dataprofiler.core.download.AbstractDQMissingJarsExtraUpdatesFactory.retrieveUninstalledExtraFeatures(AbstractDQMissingJarsExtraUpdatesFactory.java:99)
 at org.talend.updates.runtime.engine.ExtraFeaturesUpdatesFactory.retrieveUninstalledExtraFeatures(ExtraFeaturesUpdatesFactory.java:49)
 at org.talend.updates.runtime.ui.CheckExtraFeaturesToInstallJob.run(CheckExtraFeaturesToInstallJob.java:68)
 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Nested exception:
org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
 at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
 at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown Source)
 at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
 at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
 at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(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.XMLNSDocumentScannerImpl.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.AbstractSAXParser.parse(Unknown Source)
 at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
 at org.dom4j.io.SAXReader.read(SAXReader.java:465)
 at org.dom4j.io.SAXReader.read(SAXReader.java:343)
 at org.talend.core.nexus.NexusServerUtils.search(NexusServerUtils.java:192)
 at org.talend.core.nexus.NexusServerUtils.search(NexusServerUtils.java:162)
 at org.talend.core.nexus.TalendLibsServerManager.search(TalendLibsServerManager.java:294)
 at org.talend.librariesmanager.utils.RemoteModulesHelper.searchFromRemoteNexus(RemoteModulesHelper.java:246)
 at org.talend.librariesmanager.utils.RemoteModulesHelper.access$7(RemoteModulesHelper.java:208)
 at org.talend.librariesmanager.utils.RemoteModulesHelper$RemoteModulesFetchRunnable.run(RemoteModulesHelper.java:150)
 at org.talend.dataprofiler.core.download.AbstractDQMissingJarsExtraUpdatesFactory.runNotInstallModule(AbstractDQMissingJarsExtraUpdatesFactory.java:206)
 at org.talend.dataprofiler.core.download.AbstractDQMissingJarsExtraUpdatesFactory.retrieveUninstalledExtraFeatures(AbstractDQMissingJarsExtraUpdatesFactory.java:99)
 at org.talend.updates.runtime.engine.ExtraFeaturesUpdatesFactory.retrieveUninstalledExtraFeatures(ExtraFeaturesUpdatesFactory.java:49)
 at org.talend.updates.runtime.ui.CheckExtraFeaturesToInstallJob.run(CheckExtraFeaturesToInstallJob.java:68)
 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

 

Moderator

Re: Proxy Configuration and Trouble Installing Packages

Hello,

Did you set up your proxy correctly? Have you already add the web site http://talend-update.talend.com and the port 443 to your whitelist?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Proxy Configuration and Trouble Installing Packages

Are you referring to adding that to the proxy bypass? Is that what you mean by whitelist?  Thank you

 

Proxy_settings.PNG

 

 

Highlighted
Moderator

Re: Proxy Configuration and Trouble Installing Packages

Hello,

We don't find anything wrong with your setting from  screenshot.

Here is an article about: Proxy entries under Network Connections. Hope it will help.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Two Stars

Re: Proxy Configuration and Trouble Installing Packages

I have the same problem. Try all that configuration and the link that you suggested but still didn't work.

 

@whoknows do you get it to work? If so can you share it with me?

 

Thanks!

Five Stars

Re: Proxy Configuration and Trouble Installing Packages

I added the SOCKS configuration and it worked.  However, the db connection only works with the http and https configured.  Otherwise I get a network error. 

 

@xdshi, is there a way to do an analysis off of custom sql query.  While you can configure rules, it only allows where clause rules.  What if I want to have the analysis select distinct column1, column2 so I do not get duplicate rows?

 

I found this question on the topic.  Have there been any updates since then on this capability?

 

https://www.talendforge.org/forum/viewtopic.php?id=55046

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch