Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Rest Connector Problems

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.

Labels (1)
1 Reply
Brett_Bleess
Former Employee
Former Employee

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:

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.