{"id":6077,"date":"2021-03-17T06:09:23","date_gmt":"2021-03-17T06:09:23","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=6077"},"modified":"2024-10-16T05:58:47","modified_gmt":"2024-10-16T05:58:47","slug":"troubleshooting-error-http-503-encountered-while-accessing-sdata-for-sage-100-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2021\/03\/17\/troubleshooting-error-http-503-encountered-while-accessing-sdata-for-sage-100-erp\/","title":{"rendered":"Troubleshooting error HTTP 503 encountered while accessing SData for Sage 100 ERP"},"content":{"rendered":"\n<p>As you all know the current version of <a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/product\/gumu\/salesforce-sage-erp-integration\" target=\"_blank\">GUMU&#x2122; integration<\/a> utilizes SData for synchronization of records from Sage 100 ERP to Salesforce and vice-a-versa. Generally SData is installed on the Sage 100 Server and needs IIS Manager through which user can access the SData. When SData is installed on the server a pool termed as <strong><em>SDataAppPool<\/em><\/strong> is created under Application Pools of IIS Manager, where all the pools associated and running on the server are listed. The Application Pool displays the number of pools along with their Name, Status, .NET CLR Version, Managed Pipeline Mode, Identity and Applications. You can refer the below image for better understanding:<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/1.IIS-Application-Pools.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/1.IIS-Application-Pools.png\" alt=\"IIS Application Pools\"><\/a><\/center>\n<font size=\"2\"><center><i>IIS Application Pools<\/i><\/center><\/font>\n\n\n\n<p>In the above image you can see that the Applications present on the server currently have their Status as Started which means they are running and consuming certain services in order to provide output. In this blog we will understand the basic troubleshooting steps to perform on pool. These steps are specific to HTTP 503 error that occurs while accessing the SData URL over the web, as show in the below image:<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/2.HTTP-Error-503.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/2.HTTP-Error-503.png\" alt=\"HTTP Error 503\"><\/a><\/center>\n<font size=\"2\"><center><i>HTTP Error 503<\/i><\/center><\/font>\n\n\n\n<p>When such error is encountered while accessing SData from the IIS Manager, User should check the Event Viewer Application. This is provided by Microsoft which shows a log of application and system messages, including errors, information messages, and warnings. It\u2019s a useful tool for troubleshooting all kinds of different Windows problems. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><em><span style=\"text-decoration: underline;\">Identifying the Problem<\/span><\/em><\/strong><\/h4>\n\n\n\n<p>Now to understand why we have encountered the error, let\u2019s navigate to Event Viewer of Windows. To start Event Viewer on Windows, follow the below steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Firstly, click on Start and Type Event Viewer in the start menu.<\/li>\n\n\n\n<li>Click on Open.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/3.-Event-Viewer.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/3.-Event-Viewer.png\" alt=\"Event Viewer\"><\/a><\/center>\n<font size=\"2\"><center><i>Event Viewer<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Secondly, after Clicking on Open Event Viewer will display a screen stating the Overview and Summary of the system. Refer the Below Image:<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/4.Event-Viewer-OverView-and-Summary-Display.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/4.Event-Viewer-OverView-and-Summary-Display.png\" alt=\"Event Viewer overview and Summary Display\"><\/a><\/center>\n<font size=\"2\"><center><i>Event Viewer overview and Summary Display<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Finally, to view the Event Log expand Windows Logs Tree and click on System, this will allow us to understand what is causing the error. Meanwhile, refer the below image showing the Level and Source of the error along with the General Information which will help us in troubleshooting:<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/5.Error-Log-in-Event-Viewer.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/5.Error-Log-in-Event-Viewer.png\" alt=\"Error Log in Event Viewer\"><\/a><\/center>\n<font size=\"2\"><center><i>Error Log in Event Viewer<\/i><\/center><\/font>\n\n\n\n<p><strong><em>General Information of Event Logger: Application Pool SDataAppPool has been disabled. Windows process Activation Service (WAS) did not create a worker process to serve the application pool because the application pool identity is invalid.<\/em><\/strong><\/p>\n\n\n\n<p>In general terms, the above error is stating that the <strong><em>identity<\/em><\/strong> defined\/provided in the application pool are not valid. In other words, it means the credentials used in the application pool are not valid. This might have occurred to due change in credentials of Windows Domain User.<\/p>\n\n\n\n<p><em style=\"\"><b>Note: In order to access SData it is necessary for the user to always provide access to the <\/b><\/em><strong><em>SData path located on the system. Change in credentials will always become a barrier for the user to access the webservice.<\/em><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><em><span style=\"text-decoration: underline;\">Applying the Solution<\/span><\/em><\/strong><\/h4>\n\n\n\n<p>So let\u2019s update the credentials for the SDataAppPool present in the Application Pool for resolving the HTTP error 503. Follow the below steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Firstly, open IIS Manager and Click on Application Pool under Connection pane. Refer the below image:<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/6.Status-of-SdataApplicationPool.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/6.Status-of-SdataApplicationPool.png\" alt=\"Status of SData Application Pool\"><\/a><\/center>\n<font size=\"2\"><center><i>Status of SData Application Pool<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>As you can see in the above image, the status of SDataAppPool is stopped due to invalid identity i.e. <strong><em>the Windows Domain Username and Password defined to access the path is not valid<\/em><\/strong> since the credentials are updated for Windows System.<\/li>\n\n\n\n<li>In order to update the credentials, click on \u201c<strong><em>Advanced Settings<\/em><\/strong>\u201d present under Actions pane of the IIS Manager. As a result a window will pop-up as show in the below image:<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/7.Advance-Settings.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/7.Advance-Settings.png\" alt=\"Advanced Settings\"><\/a><\/center>\n<font size=\"2\"><center><i>Advanced Settings<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Finally, click on identity, which displays a small settings. In short this would allow the user to fill in the credentials as show in the below image and click on <strong><em>\u201cOK\u201d.<\/em><\/strong><\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/8.Identity-Custom-Account.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/8.Identity-Custom-Account.png\" alt=\"Identity-Custom Account\"><\/a><\/center>\n<font size=\"2\"><center><i>Identity-Custom Account<\/i><\/center><\/font>\n\n\n\n<p><strong><em>Note: User have to fill in the credentials under Custom Account by clicking on Set button. The credentials used should Windows Domain User which Administrative privileges.<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once the updated credentials are applied, it\u2019s time to restart the Application Pool and IIS Manager.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/9.-Restarting-Application-pool-and-IIS-Manager.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/9.-Restarting-Application-pool-and-IIS-Manager.png\" alt=\"Restarting Application pool and IIS Manager\"><\/a><\/center>\n<font size=\"2\"><center><i>Restarting Application pool and IIS Manager<\/i><\/center><\/font>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><em><span style=\"text-decoration: underline;\">Verification<\/span><\/em><\/strong><\/h4>\n\n\n\n<p>Let\u2019s try accessing the SData over the web, after the services is restarted. Follow the below steps to access the SData:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Firstly, open IIS, click on Application pool and expand the tree of Sites.<\/li>\n\n\n\n<li>Secondly, after expanding the Sites bar, expand the Default Website tree.<\/li>\n\n\n\n<li>Finally, under Default Website, there is SData folder which holds MasApp which allows the user to access the SData. Refer the below image for better understanding:<\/li>\n<\/ol>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/10.-MasApp.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/10.-MasApp.png\" alt=\"MasApp\"><\/a><\/center>\n<font size=\"2\"><center><i>MasApp<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In addition, to browse the SData locally on your machine click on <em><strong>&#8220;Browse *:80(http)<\/strong><\/em><strong><em>&#8220;<\/em><\/strong> present on the right hand right under Action pane. In short the below page will appear in your browser where you need to provide your Sage 100 ERP credentials:<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/11.Sdata_.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/11.Sdata_.png\" alt=\"SData URL Credentials\"><\/a><\/center>\n<font size=\"2\"><center><i>SData URL Credentials<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After providing the credentials you need to provide complete SData URL: http:\/\/localhost\/SData\/MasApp\/MasContract\/ABC\/AR_Customer<strong><em> <\/em><\/strong>(where <strong><em>ABX = your Sage company code <\/em><\/strong><em>and <\/em><strong><em>AR_Customer is the Entity <\/em><\/strong>for which you want view the data for) in order to access your Sage 100 ERP Company data. Refer the below image:<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/12.-Accessing-Customer-records-through-Sdata.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2021\/03\/12.-Accessing-Customer-records-through-Sdata.png\" alt=\"Accessing Customer records through SData\"><\/a><\/center>\n<font size=\"2\"><center><i>Accessing Customer records through SData<\/i><\/center><\/font>\n\n\n\n<p>Following the above steps user can easily fix the 503 error in the SData URL and can continue using the <a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\" target=\"_blank\">GUMU&#x2122;&nbsp;for Salesforce &#8211; Sage 100 ERP integration<\/a>.  <\/p>\n\n\n\n<p>We hope you may find this blog resourceful and helpful. If you still have concerns and need more help, please contact us at&nbsp;<a href=\"mailto:salesforce@greytrix.com\">salesforce@greytrix.com<\/a>.<\/p>\n\n\n\n<p style=\"text-align: justify\"><b>About Us<\/b><\/br>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> \u2013 a globally recognized and one of the oldest Sage Development Partner and a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.<br><br> Greytrix has some unique solutions for Cloud CRM such as <a href=\"\">Salesforce Sage integration<\/a> for <a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/integration\/\">Sage X3<\/a>, <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-100-integration\/\">Sage 100<\/a> and <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-300-integration\/\">Sage 300 (Sage Accpac)<\/a>. We also offer best-in-class Cloud CRM <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/crm-development\/\">Salesforce customization and development services<\/a> along with services such as Salesforce <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/data-migration-support\/\">Data Migration<\/a>, <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/crm-development\/\">Integrated App development<\/a>, Custom App development and Technical Support business partners and end users. Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU&#x2122; integration for Sage ERP \u2013 Salesforce is a 5-star rated app listed on <a href=\"https:\/\/appexchange.salesforce.com\/appxListingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<br> The GUMU&#x2122; Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.<br><br> For more information on our Salesforce products and services, contact us at <a href=\"mailto:salesforce@greytrix.com\">salesforce@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n\n\n\n<p><strong>Related Posts<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2021\/01\/20\/how-to-set-cookies-in-http-callout-apex-salesforce\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to set cookies in HTTP Callout (APEX Salesforce)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2020\/12\/29\/salesforce-webservice-patch-method-http-patch-verb-in-salesforce\/\" target=\"_blank\" rel=\"noreferrer noopener\">Salesforce Webservice Patch Method \u2013 HTTP PATCH verb in Salesforce<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2020\/06\/15\/gumu-features-pagination-for-import-logs-in-salesforce-lightning\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Features \u2013 Pagination for Import Logs in Salesforce Lightning<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>As you all know the current version of GUMU&#x2122; integration utilizes SData for synchronization of records from Sage 100 ERP to Salesforce and vice-a-versa. Generally SData is installed on the Sage 100 Server and needs IIS Manager through which user can access the SData. When SData is installed on the server a pool termed as\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2021\/03\/17\/troubleshooting-error-http-503-encountered-while-accessing-sdata-for-sage-100-erp\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[957,2],"tags":[1092,1103,1105,1104,1106,805,1095,638,162,163,678,1089,1102,1094,970,1097,184,188,803,1093,1107,969,1108,1090,745,739,359,360,361,377,744,738,743,401,679,681,680,716,424,430,438,1100,1091,1096,1098,1099,1101],"class_list":["post-6077","post","type-post","status-publish","format-standard","hentry","category-gumu-tricks-tips","category-gumu-salesforce","tag-net-clr-version","tag-advance-settings","tag-browse-80http","tag-custom-account","tag-default-website","tag-errors","tag-event-viewer-application","tag-gumu-integration","tag-gumusfsage100","tag-gumusfsage100erp","tag-gumulightninginterface","tag-http-503","tag-identity","tag-identity-and-applications","tag-iis-manager","tag-information-messages","tag-integrate-salesforce-with-sage-100","tag-integrate-sfdc-and-sage-100","tag-logs","tag-managed-pipelines-mode","tag-masapp","tag-mascontract","tag-mascontract-2","tag-name","tag-sage-100-connector-with-salesforce","tag-sage-erp-connector-with-salesforce","tag-sage100","tag-sage100-salesforce","tag-sage100-sf","tag-salesforce-and-sage-100-integration","tag-salesforce-connector-for-sage-100","tag-salesforce-connector-for-sage-erp","tag-salesforce-connector-with-sage-erp","tag-salesforce-integration-with-sage-100","tag-salesforce-lightning-and-sage-100-integration","tag-salesforce-lightning-integration-with-sage-100","tag-salesforce-lightning-sage100-integration","tag-salesforce-sage-integration","tag-salesforce-with-sage-100-integration","tag-salesforce-sage100","tag-sdata","tag-sdataapppool","tag-status","tag-system-message","tag-warnings","tag-windows-problems-windows-logs","tag-windows-process-activation-services"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/6077","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/comments?post=6077"}],"version-history":[{"count":5,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/6077\/revisions"}],"predecessor-version":[{"id":9639,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/6077\/revisions\/9639"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=6077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=6077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=6077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}