topic Dynamics CRM HTTP 500 Internal Server Error in Data Quality

topic Dynamics CRM HTTP 500 Internal Server Error in Data Quality https://community.qlik.com/t5/Data-Quality/Dynamics-CRM-HTTP-500-Internal-Server-Error/m-p/2196826#M143 <P>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. </P> <P><EM>Starting job testCrm at 10:27 07/05/2018.</EM></P> <P> </P> <P>[statistics] connecting to socket on port 3425</P> <P>[statistics] connected</P> <P>[pool-2-thread-1] INFO com.microsoft.aad.adal4j.UserDiscoveryRequest - [Correlation ID: null] Sent (null) Correlation Id is not same as received (null).</P> <P>[pool-2-thread-1] INFO com.microsoft.aad.adal4j.AuthenticationAuthority - [Correlation ID: <ID HERE>] Instance discovery was successful</P> <P>[pool-3-thread-1] INFO com.microsoft.aad.adal4j.UserDiscoveryRequest - [Correlation ID: null] Sent (null) Correlation Id is not same as received (null).</P> <P>[pool-3-thread-1] INFO com.microsoft.aad.adal4j.AuthenticationAuthority - [Correlation ID: <SPAN><</SPAN><SPAN>ID HERE></SPAN>] Instance discovery was successful</P> <P>Exception in component tMicrosoftCrmInput_1 (testCrm)</P> <P>org.apache.olingo.client.api.communication.ODataServerErrorException: HTTP/1.1 500 Internal Server Error</P> <P>      at org.apache.olingo.client.core.communication.header.ODataErrorResponseChecker.checkResponse(ODataErrorResponseChecker.java:73)</P> <P>      at org.apache.olingo.client.core.communication.request.AbstractRequest.checkResponse(AbstractRequest.java:54)</P> <P>      at org.apache.olingo.client.core.communication.request.AbstractODataRequest.doExecute(AbstractODataRequest.java:310)</P> <P>      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:61)</P> <P>      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:39)</P> <P>      at testproj.testcrm_0_1.testCrm.tMicrosoftCrmInput_1Process(testCrm.java:1986)</P> <P>      at testproj.testcrm_0_1.testCrm.runJobInTOS(testCrm.java:3673)</P> <P>      at testproj.testcrm_0_1.testCrm.main(testCrm.java:3499)</P> <P>[FATAL]: testproj.testcrm_0_1.testCrm - tMicrosoftCrmInput_1 HTTP/1.1 500 Internal Server Error</P> <P>org.apache.olingo.client.api.communication.ODataServerErrorException: HTTP/1.1 500 Internal Server Error</P> <P>      at org.apache.olingo.client.core.communication.header.ODataErrorResponseChecker.checkResponse(ODataErrorResponseChecker.java:73)</P> <P>      at org.apache.olingo.client.core.communication.request.AbstractRequest.checkResponse(AbstractRequest.java:54)</P> <P>      at org.apache.olingo.client.core.communication.request.AbstractODataRequest.doExecute(AbstractODataRequest.java:310)</P> <P>      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:61)</P> <P>      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:39)</P> <P>      at testproj.testcrm_0_1.testCrm.tMicrosoftCrmInput_1Process(testCrm.java:1986)</P> <P>      at testproj.testcrm_0_1.testCrm.runJobInTOS(testCrm.java:3673)</P> <P>      at testproj.testcrm_0_1.testCrm.main(testCrm.java:3499)</P> <P>[statistics] disconnected</P> <P><EM>Job testCrm ended at 10:27 07/05/2018. [exit code=1]</EM></P> Sat, 16 Nov 2024 08:17:59 GMT Anonymous 2024-11-16T08:17:59Z Dynamics CRM HTTP 500 Internal Server Error https://community.qlik.com/t5/Data-Quality/Dynamics-CRM-HTTP-500-Internal-Server-Error/m-p/2196826#M143 <P>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. </P> <P><EM>Starting job testCrm at 10:27 07/05/2018.</EM></P> <P> </P> <P>[statistics] connecting to socket on port 3425</P> <P>[statistics] connected</P> <P>[pool-2-thread-1] INFO com.microsoft.aad.adal4j.UserDiscoveryRequest - [Correlation ID: null] Sent (null) Correlation Id is not same as received (null).</P> <P>[pool-2-thread-1] INFO com.microsoft.aad.adal4j.AuthenticationAuthority - [Correlation ID: <ID HERE>] Instance discovery was successful</P> <P>[pool-3-thread-1] INFO com.microsoft.aad.adal4j.UserDiscoveryRequest - [Correlation ID: null] Sent (null) Correlation Id is not same as received (null).</P> <P>[pool-3-thread-1] INFO com.microsoft.aad.adal4j.AuthenticationAuthority - [Correlation ID: <SPAN><</SPAN><SPAN>ID HERE></SPAN>] Instance discovery was successful</P> <P>Exception in component tMicrosoftCrmInput_1 (testCrm)</P> <P>org.apache.olingo.client.api.communication.ODataServerErrorException: HTTP/1.1 500 Internal Server Error</P> <P>      at org.apache.olingo.client.core.communication.header.ODataErrorResponseChecker.checkResponse(ODataErrorResponseChecker.java:73)</P> <P>      at org.apache.olingo.client.core.communication.request.AbstractRequest.checkResponse(AbstractRequest.java:54)</P> <P>      at org.apache.olingo.client.core.communication.request.AbstractODataRequest.doExecute(AbstractODataRequest.java:310)</P> <P>      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:61)</P> <P>      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:39)</P> <P>      at testproj.testcrm_0_1.testCrm.tMicrosoftCrmInput_1Process(testCrm.java:1986)</P> <P>      at testproj.testcrm_0_1.testCrm.runJobInTOS(testCrm.java:3673)</P> <P>      at testproj.testcrm_0_1.testCrm.main(testCrm.java:3499)</P> <P>[FATAL]: testproj.testcrm_0_1.testCrm - tMicrosoftCrmInput_1 HTTP/1.1 500 Internal Server Error</P> <P>org.apache.olingo.client.api.communication.ODataServerErrorException: HTTP/1.1 500 Internal Server Error</P> <P>      at org.apache.olingo.client.core.communication.header.ODataErrorResponseChecker.checkResponse(ODataErrorResponseChecker.java:73)</P> <P>      at org.apache.olingo.client.core.communication.request.AbstractRequest.checkResponse(AbstractRequest.java:54)</P> <P>      at org.apache.olingo.client.core.communication.request.AbstractODataRequest.doExecute(AbstractODataRequest.java:310)</P> <P>      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:61)</P> <P>      at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:39)</P> <P>      at testproj.testcrm_0_1.testCrm.tMicrosoftCrmInput_1Process(testCrm.java:1986)</P> <P>      at testproj.testcrm_0_1.testCrm.runJobInTOS(testCrm.java:3673)</P> <P>      at testproj.testcrm_0_1.testCrm.main(testCrm.java:3499)</P> <P>[statistics] disconnected</P> <P><EM>Job testCrm ended at 10:27 07/05/2018. [exit code=1]</EM></P> Sat, 16 Nov 2024 08:17:59 GMT https://community.qlik.com/t5/Data-Quality/Dynamics-CRM-HTTP-500-Internal-Server-Error/m-p/2196826#M143 Anonymous 2024-11-16T08:17:59Z Re: Dynamics CRM HTTP 500 Internal Server Error https://community.qlik.com/t5/Data-Quality/Dynamics-CRM-HTTP-500-Internal-Server-Error/m-p/2196827#M144 <P>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.</P> <P>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 .</P> <P> also notice this</P> <P> </P> Sat, 12 May 2018 12:57:44 GMT https://community.qlik.com/t5/Data-Quality/Dynamics-CRM-HTTP-500-Internal-Server-Error/m-p/2196827#M144 Anonymous 2018-05-12T12:57:44Z Re: Dynamics CRM HTTP 500 Internal Server Error https://community.qlik.com/t5/Data-Quality/Dynamics-CRM-HTTP-500-Internal-Server-Error/m-p/2196828#M145 <P>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:</P> <P> </P> <P>xception in component tMicrosoftCrmInput_1 (job_crm_crmdatamart_004400_contact_ext)<BR />org.apache.olingo.client.api.communication.ODataServerErrorException: HTTP/1.1 500 Internal Server Error<BR />at org.apache.olingo.client.core.communication.header.ODataErrorResponseChecker.checkResponse(ODataErrorResponseChecker.java:73)<BR />at org.apache.olingo.client.core.communication.request.AbstractRequest.checkResponse(AbstractRequest.java:54)<BR />at org.apache.olingo.client.core.communication.request.AbstractODataRequest.doExecute(AbstractODataRequest.java:310)<BR />at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:61)<BR />at org.apache.olingo.client.core.communication.request.retrieve.ODataEntitySetRequestImpl.execute(ODataEntitySetRequestImpl.java:39)<BR />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)<BR />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)<BR />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)<BR />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)<BR />[statistics] disconnected</P> <BLOCKQUOTE> <HR /> <A href="https://community.qlik.com/s/profile/0053p000007LOOMAA4">@asingh</A> wrote: <BR /> <P>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.</P> <P>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 .</P> <P> also notice this</P> <P> </P> <HR /> </BLOCKQUOTE> <P><BR /><BR /></P> <P> </P> <P> </P> Wed, 28 Aug 2019 20:10:35 GMT https://community.qlik.com/t5/Data-Quality/Dynamics-CRM-HTTP-500-Internal-Server-Error/m-p/2196828#M145 plikhi 2019-08-28T20:10:35Z