Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to extract data from Microsoft CRM365 which resides in the cloud. All of my extracts work fine except for this one. I can put 10000 rows through it and it runs fine. When I try and run everything through it I get this message after it processes for about 45 minutes writing data out. Any help would be appreciated.
2019-09-23 08:05:30
2019-09-23 08:05:30 QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 401 (Unauthorized):
2019-09-23 08:05:30
2019-09-23 08:05:30 'Bearer' authentication schema provided by the web-service is not supported or your credentials are not valid.
2019-09-23 08:05:30 Error: QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 401 (Unauthorized):
2019-09-23 08:05:30
2019-09-23 08:05:30 'Bearer' authentication schema provided by the web-service is not supported or your credentials are not valid.
2019-09-23 08:06:43 QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 401 (Unauthorized):
2019-09-23 08:06:43
2019-09-23 08:06:43 'Bearer' authentication schema provided by the web-service is not supported or your credentials are not valid.
2019-09-23 08:06:44 Execution Failed
2019-09-23 08:06:44 Execution finished.
Hey Thom, I think I would surf Microsoft CRM365 support on this one, as I am betting it is something on that side that is timing you out here. Either that or they are imposing a limit on the number of rows extracted etc.
The Web Connector package I gave you for the SFTP does have a premium connector for Microsoft Dynamics CRM, but I am not sure if this is specific to the 365 version or what. Have a look at the Help on that, it may give you something, sorry I do not have anything better:
Regards,
Brett