Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dataflow refresh error - (400) Bad Request

Hi Community,

I need some help with debugging an dataflow error, please help.

 

I have a dataflow that was refreshing okay as per schedule until 17th April. It gave error on 18th April and then again refreshed okay 19th and 20th. Again, it started giving error for refresh since 21st. Below is the error details.

 

18th April - Error: Data Source Error : DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Bad Request) DataSourceKind = SharePoint DataSourcePath = https://XXXX.sharepoint.com/XXXX SPRequestGuid = XXXX Url = https://XXXX.sharepoint.com/XXXX/_api/Web/Lists(guid'XXXX')/Items(6255)/Scribe_Name0.. RootActivityId = XXXX.Param1 = DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Bad Request) DataSourceKind = SharePoint DataSourcePath = https://XXXX.sharepoint.com/XX SPRequestGuid = XXXX Url = https://XXXX.sharepoint.com/XXXX/_api/Web/Lists(guid'XXXX')/Items(6255)/Scribe_Name0 Request ID: XXXX

 

21st April - Error: Data Source Error : DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Bad Request) DataSourceKind = SharePoint DataSourcePath = https://XXXX.sharepoint.com/XXXX SPRequestGuid = XXXX Url = https://XXXX.sharepoint.com/XXXX/_api/Web/Lists(guid'XXXX')/Items(7667)/Author.. RootActivityId = XXXX.Param1 = DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Bad Request) DataSourceKind = SharePoint DataSourcePath = https://XXXX.sharepoint.com/XXXX SPRequestGuid = XXXX Url = https://XXXX.sharepoint.com/XXXX/_api/Web/Lists(guid'XXXX')/Items(7667)/Author Request ID: XXXX.

The differences between error codes of two dates are as follows: SPRequestGuid, RootActivityId, SPRequestGuid, and Request ID.


18th April - SPRequestGuid = AAAA1111
/Items(6255)/Scribe_Name0.. RootActivityId = BBBB1111.SPRequestGuid = CCCC1111
/Items(6255)/Scribe_Name0 Request ID: DDDD1111

 

21st April - SPRequestGuid = AAAA2222
/Items(7667)/Author.. RootActivityId = BBBB2222.SPRequestGuid = CCCC2222
/Items(7667)/Author Request ID: DDDD2222


I have exported the data to excel and checked the data, especially for two columns Scribe_Name0 and Author, but unable to find any discrepancy.

 

Can we debug this IDs in anyway to find the root cause?

Dataflow

5 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi Anonymous ,

     

    According to your bug report, I haven't reproduced your problem for the time being. You might as well try to delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect to see if it works. If it still doesn’t work, please provide a screenshot of the error message and I will answer you as soon as possible.

     

    Let me know the result immediately, looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      v-henryk-mstf 

       

      It is at the service level, giving failure on scheduled refresh.  There was some discrepancy at the data level in a date column, which we have corrected.  Now, we are getting the error as

       

       

      "DataFormat.Error: We couldn't parse the input provided as a Date value.

      Details
      2019-09-18T18:30:00Z

      "

       

      The dates are coming from a calculated column in a SharePoint list, which is a calculated column and type is "Date Only."

       

      I am currently examining the formula.  

       

      Can you provide some input for the date error please?