Connecting Azure Data factory to Oracle ADW

Priya Chary 0

Hi,

While trying to connect to Oracle ADW using Wallet file, facing the below error, how to resolve ?

Tried: https://learn.microsoft.com/en-ca/azure/data-factory/connector-oracle-service-cloud?tabs=data-factory#linked-service-properties

ERROR [HY000] [Microsoft][OSvC] (100) Error parsing JSON: Invalid value. while parsing string <!DOCTYPE html>

<head>

<style>

  body { margin: 0 }

  .big-top-banner {

    background-color: #253D2C;

    width: 100%;

    height: 58px;

  }

  .small-top-banner {

    background-color: #86B596;

    width: 100%;

    height: 4px;

  }

  .oracle-logo {

    padding-top: 20px;

    padding-left: 20px;

  }

  .content {

    position: absolute;

    font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif;

    font-weight: 400;

    top: 50%;

    left: 50%;

    margin-top: -66px;

    margin-left: -223px;

    width: 447px;

    height: 133px;

  }

  .error-text {

    line-height: 17px;

    font-size: 14px;

  }

  .error-code {

    color: #000000;

    margin-bottom: 6px;

  }

  .error-title-group {

    height: 40px;

  }

  .error-title {

    font-siz...

ERROR [HY000] [Microsoft][OSvC] (100) Error parsing JSON: Invalid value. while parsing string <!DOCTYPE html>

<head>

<style>

  body { margin: 0 }

  .big-top-banner {

    background-color: #253D2C;

    width: 100%;

    height: 58px;

  }

  .small-top-banner {

    background-color: #86B596;

    width: 100%;

    height: 4px;

  }

  .oracle-logo {

    padding-top: 20px;

    padding-left: 20px;

  }

  .content {

    position: absolute;

    font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif;

    font-weight: 400;

    top: 50%;

    left: 50%;

    margin-top: -66px;

    margin-left: -223px;

    width: 447px;

    height: 133px;

  }

  .error-text {

    line-height: 17px;

    font-size: 14px;

  }

  .error-code {

    color: #000000;

    margin-bottom: 6px;

  }

  .error-title-group {

    height: 40px;

  }

  .error-title {

    font-siz...

AnnuKumari-MSFT 32,991 Reputation points Microsoft Employee

2024-10-03T05:55:19.9733333+00:00

@Priya Chary ,

Just checking if you got a chance to look at the below response. Kindly do let us know if it helped to resolve your issue by accepting the answer. Thankyou

1 answer

AnnuKumari-MSFT 32,991 Reputation points Microsoft Employee

2024-09-20T12:06:52.2266667+00:00

Hi Priya Chary ,

Welcome to Microsoft Q&A platform and thanks for posting your query here.

As I understand your query, it seems you are trying to connect to Oracle ADW using Wallet file via ADF pipeline. However, you are facing this error: "ERROR [HY000] [Microsoft][OSvC] (100) Error parsing JSON: Invalid value. while parsing string"

Improper escape characters or incorrect encoding (non-UTF-8) can cause JSON parsing errors. Kindly Make sure the JSON string is correctly formatted and UTF-8 encoded. Check the dataset property for the same.

Hope it helps. Kindly let us know how it goes. Thankyou
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Connecting Azure Data factory to Oracle ADW

1 answer

Your answer