Skip to main content
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.