I need to make a connection with D365, I have provided all the required details but still getting is

Deeksha
Deeksha
edited February 17 in Support

I am trying to establish a connection to Dynamics 365. I have provided the Client ID, Client Secret, and Access Code, but the connection is still not working.

Unfortunately, I cannot upload a screenshot due to permission restrictions.

Any guidance or suggestions on what I might be missing would be greatly appreciated.

Tagged:

Answers

  • Josh Boxer
    Josh Boxer Administrator

    Check the Aperture logs for more detail on why the connection is not being established. By default you will find the logs at C:\ApertureDataStudio\data\log\datastudio.log

  • Deeksha
    Deeksha

    unable to paste log file as i have limited access but error i got is at com.experian.aperturedatastudio.jdbc.dynamics365.pxodata.adapter.af.a(Unknown Source) ~[?:?]

    at com.experian.aperturedatastudio.jdbc.dynamics365.pxodata.adapter.aj.getEdm(Unknown Source) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.adapter.Dynamics365Session.getEdm(|Dynamics365|6.0.0.3198|:303) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.pxodata.adapter.z.initializeOData4(Unknown Source) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.pxodata.adapter.z.initialize(Unknown Source) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.pxodata.adapter.t.initializeNativeMetaData(Unknown Source) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.adapter.Dynamics365MetaData.initializeNativeMetaData(|Dynamics365|6.0.0.3198|:28) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.api.metadata.n.a(|Dynamics365|6.0.0.3198|:1057) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.api.metadata.n.a(|Dynamics365|6.0.0.3198|:1011) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.api.metadata.n.a(|Dynamics365|6.0.0.3198|:756) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.sql.j.nu(|Dynamics365|6.0.0.3198|:346) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.sql.j.open(|Dynamics365|6.0.0.3198|:277) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.sql.k.a(|Dynamics365|6.0.0.3198|:291) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.sql.k.a(|Dynamics365|6.0.0.3198|:170) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.sql.bx.a(|Dynamics365|6.0.0.3198|:3003) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.api.core.aw$c.connect(|Dynamics365|6.0.0.3198|:276) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.api.core.aw.<init>(|Dynamics365|6.0.0.3198|:477) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.api.core.aw.a(|Dynamics365|6.0.0.3198|:191) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.jdbc.r.a(|Dynamics365|6.0.0.3198|:706) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.jdbc.r.a(|Dynamics365|6.0.0.3198|:575) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.api.b.open(|Dynamics365|6.0.0.3198|:336) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.base.BaseConnection.b(|Dynamics365|6.0.0.3198|:5095) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.base.BaseConnection.connect(|Dynamics365|6.0.0.3198|:1571) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.base.ah.run(|Dynamics365|6.0.0.3198|:247) ~[?:?]

    Caused by: com.experian.aperturedatastudio.jdbc.dynamics365.externals.com.fasterxml.aalto.WFCException: Unexpected character '>' (code 62) expected '='
    at [row,col {unknown-source}]: [13,73]
    at com.experian.aperturedatastudio.jdbc.dynamics365.externals.com.fasterxml.aalto.in.XmlScanner.reportInputProblem(|Dynamics365|6.0.0.3198|:1333) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.externals.com.fasterxml.aalto.in.XmlScanner.throwUnexpectedChar(|Dynamics365|6.0.0.3198|:1519) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.externals.com.fasterxml.aalto.in.Utf8Scanner.handleStartElement(|Dynamics365|6.0.0.3198|:209) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.externals.com.fasterxml.aalto.in.StreamScanner.nextFromTree(|Dynamics365|6.0.0.3198|:269) ~[?:?]
    at com.experian.aperturedatastudio.jdbc.dynamics365.externals.com.fasterxml.aalto.stax.StreamReaderImpl.next(|Dynamics365|6.0.0.3198|:760) ~[?:?]

  • Josh Boxer
    Josh Boxer Administrator

    Searched the error:

    Common Causes

    • Invalid Connection String: Incorrect URL parameters (e.g., AuthScheme, OrganizationUrl, Token).
    • Authentication/Authorization Failures: Issues with OAuth tokens, client secrets, or user permissions.
    • Driver Version Incompatibility: Using an outdated driver with a newer Dynamics 365 API version.
    • Network/Socket Issues: Intermittent connection loss, firewall, or proxy issues.
    • Query Timeouts: Complex queries or large datasets causing the adapter to fail.
  • Josh Boxer
    Josh Boxer Administrator
    edited March 2

    If you can share the full log file with our Support team they might be able to help further as it sounds like something malformed in the stream coming from Dynamics. Once they have reviewed the logs they can help you perform a snoop trace to understand what Dynamics is sending over.
    https://docs.experianaperture.io/more/contact-us/

  • Deeksha
    Deeksha

    Thanks Josh, i have shared log file with support team and waiting for their response.

Categories