My Oracle Support Banner

Error: "Failed To Save The Connection. Invalid Connect String / Url To External Source" When Entering A New Datasource Connection Within Visual Analyzer Over An SSL Protocol (Doc ID 2478219.1)

Last updated on MARCH 09, 2020

Applies to:

Primavera Analytics Cloud Service - Version 17.12.2.0 and later
Primavera Analytics - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to add a new connection to Analytics from within Visual Analyzer (**Not Data Visualization Desktop) r12.2.1.x, the following error occurs if the URL being entered using an SSL protocol with SSL termination at web server level:

ERROR
-----------------------
Failed to save the connection. Invalid connect string / url to external source

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Install OBIEE 12.2.1.2 using default setup
  2. Configure WebLogic Plug-In Enabled setting for OBIEE bi_server1:
      a. Login to WLS Admin Console
      b. Under domain structure, expand Environment and click Servers
      c. Click the link for bi_server1
      d. On Configuration > General, click Advanced link
      e. Click Lock & Edit in change center
      f. Set WebLogic Plug-In Enabled = yes
      g. Click Save
      h. Click Active Changes in change center
      i. Restart OBIEE domain and processes
  3. Install and configure OHS
  4. Setup OHS over SSL
  5. Setup OHS WLS plugin for OBIEE components:
      a. Open mod_wl_ohs.conf
      b. Add the following:
           <LocationMatch "^/(xmlpserver|analytics|analytics-ws|va|bi-security-login)">
              WLSRequest ON
              WebLogicHost $hostname   #<--replace with WLS hostname for OBIEE managed server
              WebLogicPort $port         #<--replace with non-ssl port number for OBIEE managed server
              WLProxySSL ON
              WLProxySSLPassThrough ON
           </LocationMatch>

      c. Save and close the file
      d. Restart OHS
  6. Reproduce issue in VA:
      a. Login to Visual Analyzer: https://hostname(ohs)/va
      b. Click Data Sources
      c. On Data Sources page, click Create New Dat Source
      d. On Create New Data Source window, click From Oracle Applications
      e. On the 'Add a New Connection' window enter:
      a. Anything user defined in 'New Connection Name'
      b. URL, enter: https://hostname(ohs)/analytics
      c. Username/Password, enter a value username/password
      d. Click Save
      e. Note the error which occurs: Failed to save the connection. Invalid connect string / url to external source




ADDITIONAL INFORMATION
-----------------------
The following error is written to the log file when issue occurs (this is an excerpt from an internal environment where issue was reproduced):
...
TIMESTAMP
<MALFORMED_URL_EXCEPTION Error Malformed URL: Failed to connect to URL: https://hostname/analytics
Cause - Malformed URL encountered
Action - Check the log
oracle.bi.datasource.bisoap.connector.BISOAPProvider.getObjectList(BISOAPProvider.java:105)
oracle.bi.datasource.service.DatasourceServiceProcessor.getObjectsList(DatasourceServiceProcessor.java:1057)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
TIMESTAMP
TIMESTAMP Cause - Error Malformed URL: Failed to connect to URL: https://hostname/analytics
java.util.concurrent.FutureTask.report(FutureTask.java:122)
java.util.concurrent.FutureTask.get(FutureTask.java:206)
oracle.bi.datasource.service.adf.server.DatasourceServlet.doGet(DatasourceServlet.java:442)
javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
>
TIMESTAMP

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.