Dynamics CRM HTTP 500 Internal Server Error

[Anonymous]

We are new to Talend and are using Talend studios to connect to dynamics crm online. It worked the first time, but ever since then we keep getting internal 500 errors. Need help please. 

Starting job testCrm at 10:27 07/05/2018.

[statistics] connecting to socket on port 3425

[statistics] connected

[pool-2-thread-1] INFO com.microsoft.aad.adal4j.UserDiscoveryRequest - [Correlation ID: null] Sent (null) Correlation Id is not same as received (null).

[pool-2-thread-1] INFO com.microsoft.aad.adal4j.AuthenticationAuthority - [Correlation ID: <ID HERE>] Instance discovery was successful

[pool-3-thread-1] INFO com.microsoft.aad.adal4j.UserDiscoveryRequest - [Correlation ID: null] Sent (null) Correlation Id is not same as received (null).

[pool-3-thread-1] INFO com.microsoft.aad.adal4j.AuthenticationAuthority - [Correlation ID: <ID HERE>] Instance discovery was successful

Exception in component tMicrosoftCrmInput_1 (testCrm)

org.apache.olingo.client.api.communication.ODataServerErrorException: HTTP/1.1 500 Internal Server Error

      at org.apache.olingo.client.core.communication.header.ODataErrorResponseChecker.checkResponse(ODataErrorResponseChecker.java:73)

      at org.apache.olingo.client.core.communication.request.AbstractRequest.checkResponse(AbstractRequest.java:54)

      at org.apache.olingo.client.core.communication.request.AbstractODataRequest.doExecute(AbstractODataRequest.java:310)

      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:61)

      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:39)

      at testproj.testcrm_0_1.testCrm.tMicrosoftCrmInput_1Process(testCrm.java:1986)

      at testproj.testcrm_0_1.testCrm.runJobInTOS(testCrm.java:3673)

      at testproj.testcrm_0_1.testCrm.main(testCrm.java:3499)

[FATAL]: testproj.testcrm_0_1.testCrm - tMicrosoftCrmInput_1 HTTP/1.1 500 Internal Server Error

org.apache.olingo.client.api.communication.ODataServerErrorException: HTTP/1.1 500 Internal Server Error

      at org.apache.olingo.client.core.communication.header.ODataErrorResponseChecker.checkResponse(ODataErrorResponseChecker.java:73)

      at org.apache.olingo.client.core.communication.request.AbstractRequest.checkResponse(AbstractRequest.java:54)

      at org.apache.olingo.client.core.communication.request.AbstractODataRequest.doExecute(AbstractODataRequest.java:310)

      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:61)

      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:39)

      at testproj.testcrm_0_1.testCrm.tMicrosoftCrmInput_1Process(testCrm.java:1986)

      at testproj.testcrm_0_1.testCrm.runJobInTOS(testCrm.java:3673)

      at testproj.testcrm_0_1.testCrm.main(testCrm.java:3499)

[statistics] disconnected

Job testCrm ended at 10:27 07/05/2018. [exit code=1]

[Anonymous]

I’ve spent quite some time now banging my head off the desk to figure out what was causing an issue with one of our PowerObjects solutions after we’d attempted to migrate to CRM 2016 from CRM 2013 and have finally found the cause.

Quite a few solutions in the market use custom parameters on the end of address’s to pass data which if you look at a network trace in any browser will display .

 also notice this

[plikhi]

Can you provide more information on how this issue was resolved as we are having same problem. We are extracting huge data from CRM but after 5000 rows we start getting error:

xception in component tMicrosoftCrmInput_1 (job_crm_crmdatamart_004400_contact_ext)
org.apache.olingo.client.api.communication.ODataServerErrorException: HTTP/1.1 500 Internal Server Error
at org.apache.olingo.client.core.communication.header.ODataErrorResponseChecker.checkResponse(ODataErrorResponseChecker.java:73)
at org.apache.olingo.client.core.communication.request.AbstractRequest.checkResponse(AbstractRequest.java:54)
at org.apache.olingo.client.core.communication.request.AbstractODataRequest.doExecute(AbstractODataRequest.java:310)
at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:61)
at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:39)
at talenddi.job_crm_crmdatamart_004400_contact_ext_0_1.job_crm_crmdatamart_004400_contact_ext.tMicrosoftCrmInput_1Process(job_crm_crmdatamart_004400_contact_ext.java:5974)
at talenddi.job_crm_crmdatamart_004400_contact_ext_0_1.job_crm_crmdatamart_004400_contact_ext.tSetProxy_1Process(job_crm_crmdatamart_004400_contact_ext.java:8720)
at talenddi.job_crm_crmdatamart_004400_contact_ext_0_1.job_crm_crmdatamart_004400_contact_ext.runJobInTOS(job_crm_crmdatamart_004400_contact_ext.java:8977)
at talenddi.job_crm_crmdatamart_004400_contact_ext_0_1.job_crm_crmdatamart_004400_contact_ext.main(job_crm_crmdatamart_004400_contact_ext.java:8803)
[statistics] disconnected

---

@asingh wrote:

I’ve spent quite some time now banging my head off the desk to figure out what was causing an issue with one of our PowerObjects solutions after we’d attempted to migrate to CRM 2016 from CRM 2013 and have finally found the cause.

Quite a few solutions in the market use custom parameters on the end of address’s to pass data which if you look at a network trace in any browser will display .

 also notice this

---