Dynamics CRM HTTP 500 Internal Server Error

Highlighted
One Star

Dynamics CRM HTTP 500 Internal Server Error

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]

Tags (1)

Re: Dynamics CRM HTTP 500 Internal Server Error

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

 

Four Stars

Re: Dynamics CRM HTTP 500 Internal Server Error

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


@soniyasingh9877 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

 




 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog