{"id":24307,"date":"2020-07-01T09:29:37","date_gmt":"2020-07-01T09:29:37","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=24307"},"modified":"2020-07-01T09:29:39","modified_gmt":"2020-07-01T09:29:39","slug":"troubleshooting-tomcat-issues-part-2","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/","title":{"rendered":"Troubleshooting Tomcat Issues \u2013 Part 2"},"content":{"rendered":"\n

Everyone who has worked with Sage CRM<\/a> must be aware of Tomcat service installed with it and the various features of CRM such as Dashboards, Calendar, Mail merge, Documents upload or Export to excel that are dependent on this single service. However, many of us must have encountered issues with these functionalities at least once because of some or the other issue with Tomcat. In this blog, I will be sharing one of my experiences of troubleshooting tomcat issue.<\/p>\n\n\n\n

Related Post:<\/strong><\/em> Troubleshooting Tomcat Issues<\/a><\/p>\n\n\n\n

Recently, I had installed Sage CRM 2020 R1. After successful installation when I logged in CRM I found that dashboard as well as other features which are dependent on Tomcat is not working even though tomcat service is running. <\/p>\n\n\n\n

After debugging the issue I found that the Connector Port<\/strong> which is defined in the server.xml <\/strong>file in the Tomcat directory is different than the port which is defined in the sdata Action URL<\/strong> in URL Rewrite. You can refer below screen shots for your better understanding.<\/p>\n\n\n\n

\"sdata<\/a>\n\n
sdata Action URL port<\/i><\/center><\/font><\/p><\/figure>\n\n\n\n
\"Connector<\/a>\n\n
Connector port in Server.xml file<\/i><\/center><\/font><\/p><\/figure>\n\n\n\n

\nAs\nyou can clearly see from above images, that the port set in sdata\nAction URL is 10005<\/strong>\nand connector port in server.xml file is 10007.<\/strong>\nHowever, for proper functioning of Tomcat service and its related\nSage CRM features, both the port numbers should match.<\/p>\n\n\n\n

Just follow the below steps to rectify the tomcat issue:<\/p>\n\n\n\n

  1. To find out the connector port number. Navigate to below path and open the server.xml file. Copy the connector port number-
    [CRM install directory]:\\Program Files (x86)\\Sage\\CRM[CRM instance]\\tomcat\\conf<\/li>
  2. To update the Connector port in Database (port number captured from step#1), just execute below query in SQL Studio Management-
    UPDATE Custom_SysParams SET Parm_Value=’connector port ‘ WHERE Parm_Name like ‘CRMTomcatPort’<\/li>
  3. Now go to the IIS and from SData, click on URL Rewrite. You can see the list of URL rewriter. Open all URL Rewrite one by one and replace the port number in the Action URL with the connector port number which you will get from first step. Just refer below screen shot. Once replaced just save the URL Rewrite.<\/li><\/ol>\n\n\n\n
    \"Replacing<\/a>\n\n
    Replacing the port number in Action URL<\/i><\/center><\/font><\/p><\/figure>\n\n\n\n

    4. Now execute IIS reset, restart tomcat service and login into CRM and check the features. <\/p>\n\n\n\n

    In this way, you can troubleshoot the Tomcat issue related to ports.<\/p>\n\n\n\n

    About Us<\/strong><\/span><\/p>\n\n\n\n

    Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n

    Greytrix\u00a0has some unique integration solutions developed for Sage CRM with Sage ERPs namely\u00a0Sage X3,\u00a0Sage Intacct,\u00a0Sage 100,\u00a0Sage 500,\u00a0and\u00a0Sage 300. We also offer best-in-class\u00a0Sage ERP\u00a0and\u00a0Sage CRM\u00a0customization and development services\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users, and Sage PSG worldwide. Greytrix\u00a0helps in\u00a0the migration of Sage CRM from\u00a0Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes\u00a0add-ons like\u00a0 Greytrix Business Manager,\u00a0Sage CRM Project Manager,\u00a0Sage CRM Resource Planner,\u00a0Sage CRM Contract Manager,\u00a0Sage CRM Event Manager,\u00a0Sage CRM Budget Planner,\u00a0Gmail Integration,\u00a0Sage CRM Mobile Service Signature,\u00a0Sage CRM CTI Framework.<\/gwmw><\/gwmw><\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n

    Greytrix is a recognized\u00a0Sage Champion Partner\u00a0for GUMU™ Sage X3 \u2013 Sage CRM integration listed on\u00a0Sage Marketplace and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/gwmw><\/gwmw><\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n

    For more information on our integration solutions, please contact us at sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Everyone who has worked with Sage CRM must be aware of Tomcat service installed with it and the various features of CRM such as Dashboards, Calendar, Mail merge, Documents upload or Export to excel that are dependent on this single service. However, many of us must have encountered issues with these functionalities at least once\u2026 Read More »<\/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":[19,99,102,138,332,333,334,335,3986,3985,405],"tags":[556,2727,4161,4162,2452,4160,4159,2519,3722],"class_list":["post-24307","post","type-post","status-publish","format-standard","hentry","category-administrator","category-dashboard-sage-crm","category-database-sage-crm","category-error","category-sage-crm","category-sage-crm-2017","category-sage-crm-2018","category-sage-crm-2018-crm72","category-sage-crm-2019-r1-sage-crm-2018-crm72","category-sage-crm-2019-r1","category-tomcat-server","tag-apache-tomcat","tag-apache-tomcat-and-url-rewrite","tag-connector-port-in-server-xml-file","tag-replacing-the-port-number-in-action-url","tag-tomcat","tag-troubleshooting-tomcat-issues","tag-troubleshooting-tomcat-issues-part-2","tag-url-rewrite","tag-url-rewrite-for-notifications"],"yoast_head":"\nTroubleshooting Tomcat Issues \u2013 Part 2 - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Troubleshooting Tomcat Issues \u2013 Part 2 - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Everyone who has worked with Sage CRM must be aware of Tomcat service installed with it and the various features of CRM such as Dashboards, Calendar, Mail merge, Documents upload or Export to excel that are dependent on this single service. However, many of us must have encountered issues with these functionalities at least once\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-01T09:29:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-01T09:29:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/07\/01_URL-Rewrite-Port-1024x247.jpg\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/\",\"name\":\"Troubleshooting Tomcat Issues \u2013 Part 2 - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/07\/01_URL-Rewrite-Port-1024x247.jpg\",\"datePublished\":\"2020-07-01T09:29:37+00:00\",\"dateModified\":\"2020-07-01T09:29:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/07\/01_URL-Rewrite-Port-1024x247.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/07\/01_URL-Rewrite-Port-1024x247.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Troubleshooting Tomcat Issues \u2013 Part 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Troubleshooting Tomcat Issues \u2013 Part 2 - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/","og_locale":"en_US","og_type":"article","og_title":"Troubleshooting Tomcat Issues \u2013 Part 2 - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Everyone who has worked with Sage CRM must be aware of Tomcat service installed with it and the various features of CRM such as Dashboards, Calendar, Mail merge, Documents upload or Export to excel that are dependent on this single service. However, many of us must have encountered issues with these functionalities at least once\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2020-07-01T09:29:37+00:00","article_modified_time":"2020-07-01T09:29:39+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/07\/01_URL-Rewrite-Port-1024x247.jpg","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/","name":"Troubleshooting Tomcat Issues \u2013 Part 2 - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/07\/01_URL-Rewrite-Port-1024x247.jpg","datePublished":"2020-07-01T09:29:37+00:00","dateModified":"2020-07-01T09:29:39+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/07\/01_URL-Rewrite-Port-1024x247.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/07\/01_URL-Rewrite-Port-1024x247.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/07\/01\/troubleshooting-tomcat-issues-part-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Troubleshooting Tomcat Issues \u2013 Part 2"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/24307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=24307"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/24307\/revisions"}],"predecessor-version":[{"id":24313,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/24307\/revisions\/24313"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=24307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=24307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=24307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}