Forum Discussion

Griplock's avatar
Griplock
New Member
8 years ago

Adobe Analytics Connector

I am able to use segments in Workspace. However, when using the same segements in the Adobe Connector, there is an error stating that the "table is empty"

8 Replies

    • jeffshieldsdev's avatar
      jeffshieldsdev
      Solution Sage

      This is happening for me too.

       

      I turned on tracing, and looked through the logs.

       

      The Report.Queue method is being POSTed to the Adobe Analytics API, and then Report.Get called repeatedly to see if the report is ready--but it's still being prepared.  Adobe's API returns a 400 error in this case.

       

      After so many attempts, it gives up and simply returns "This table is empty".

       

      According to the AdobeAnalytics.Cube() Power Query M documentation, "RetryInterval" can be changed from the default 1 second to longer--but looking at the trace log, this parameter appears to be ignored.

       

      Here's how you would increase the RetryInterval to 20 seconds:

       

      AdobeAnalytics.Cubes([RetryInterval = #duration(0, 0, 0, 20)])

       

      But as I said, this parameter is ignored.

       

      EDIT: I've submitted a support ticket with Microsoft on this issue.

      EDIT2: I've confirmed two bugs have been fixed by Microsoft: the parameteres "MaxRetryCount" and "RetryInterval" are no longer ignored.  The connector still returns an error-less empty result set if the request eventually times out though.  I'm going to submit another ticket on this.

      • jeffshieldsdev's avatar
        jeffshieldsdev
        Solution Sage

        UPDATE:

        From Microsoft Support in regards to my support ticket:

        "We have identified this as a bug. This fix will be deployed and will be available in (Aug, 2019) release."