{"id":2248,"date":"2012-06-26T04:11:50","date_gmt":"2012-06-26T04:11:50","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=2248"},"modified":"2022-02-25T10:06:29","modified_gmt":"2022-02-25T10:06:29","slug":"error-exporting-reports-to-excel-in-crm-part-2","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/","title":{"rendered":"Error exporting reports to excel in CRM part 2"},"content":{"rendered":"<p>In the current versions of Sage CRM we come across this error very often. There are several reasons why this error may occur. I had discussed couple of issues in my earlier blog posts on this particular website (Links below).<br \/>\nError exporting reports to excel<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/22\/error-exporting-reports-to-excel-in-crm\/\">https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/22\/error-exporting-reports-to-excel-in-crm\/<\/a><br \/>\nDesktop Size Limitation<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/12\/06\/desktop-size-limitation\/\">https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/12\/06\/desktop-size-limitation\/<\/a><br \/>\nSometimes even if we follow all the settings and configurations correctly as mentioned in guide as well as do all standard practices, this thing refuses to work. If you are done with trying above mentioned two suggestions you can try playing around with Tomcat settings. To check whether file export is working properly through the tomcat server you can follow below mentioned steps.<br \/>\n1. Check whether temporary file of your report excel is getting generated under <em><strong>WWWRoot\/Temp<\/strong><\/em> folder. If it is not getting generated, just try giving proper security access rights on this directory to ASPNET and user being used for authentication.<br \/>\n2. If temporary file is not getting generated, next thing you could check is whether Interactive Dashboards are working.<br \/>\n3. If Interactive Dashboards are not working, first check whether Tomcat service is running. If not, go to Services console (Run | Services.msc) and Start Apache Tomcat service.<br \/>\n4. If your tomcat service appears to be running and then also Reports are not you may need to check JDBC properties for Tomcat. For that you have to go to \u201c<strong><em>C:\\Program Files\\sage\\crm\\CRM\\tomcat\\webapps\\crmj\\WEB-INF<\/em><\/strong>\u201d and open <em><strong>JDBC.Properties<\/strong><\/em> files. In this you can check whether the Database server credentials are correct. If not, Stop Apache tomcat service, modify this file, Save and Start the service again.<br \/>\n5. Even after setting up Tomcat correctly excel reports don\u2019t work sometimes. In that case you can check the <em><strong>CRMRewriter<\/strong><\/em> settings. For doing the same you can go to \u201c<em><strong>C:\\Program Files\\sage\\crm\\Services\\IISUtils\\CRMRewriter<\/strong><\/em>\u201d and open <em><strong>CRM.Rewriter.rules<\/strong><\/em> file in text editor. Check which port is being used for redirection. This port has to be similar to the port mentioned under <em><strong>Connector port<\/strong><\/em> tag of Tomcat server configuration. To check Tomcat server configuration you can go to \u201c<em><strong>C:\\Program Files\\sage\\crm\\CRM\\tomcat\\conf<\/strong><\/em>\u201d and open <em><strong>Server.xml<\/strong><\/em> file. In this file you will find Tag named Connector port. Check the value of the port which should match with the port under redirector settings as mentioned above.<br \/>\n6. There are tips given in CRM installation guide to check whether Redirector is working. Below is the extract of the same.<br \/>\nhttp:\/\/[servername]\/sdata\/default.aspx?r=\/sdata\/test.html<br \/>\nThis URL should redirect to Test.html page properly as per the rules written in Redirector rules file as mentioned above. Another way to check this would be to try Spellchecker on email screen. If that doesn\u2019t work redirector is not working.<br \/>\n7. As CRMRewriter is being used for exporting reports to excel it is necessary that the user set on <em><strong>CRMJ<\/strong><\/em> directory in IIS must be able to access all the files under library folder. This way impersonation works and files are loaded without problem.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the current versions of Sage CRM we come across this error very often. There are several reasons why this error may occur. I had discussed couple of issues in my earlier blog posts on this particular website (Links below). Error exporting reports to excel https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/22\/error-exporting-reports-to-excel-in-crm\/ Desktop Size Limitation https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/12\/06\/desktop-size-limitation\/ Sometimes even if we follow\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146,332,405],"tags":[],"class_list":["post-2248","post","type-post","status-publish","format-standard","hentry","category-export-to-excel","category-sage-crm","category-tomcat-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Error exporting reports to excel in CRM 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\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error exporting reports to excel in CRM part 2 - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In the current versions of Sage CRM we come across this error very often. There are several reasons why this error may occur. I had discussed couple of issues in my earlier blog posts on this particular website (Links below). Error exporting reports to excel https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/22\/error-exporting-reports-to-excel-in-crm\/ Desktop Size Limitation https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/12\/06\/desktop-size-limitation\/ Sometimes even if we follow\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-26T04:11:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-25T10:06:29+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/\",\"name\":\"Error exporting reports to excel in CRM part 2 - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2012-06-26T04:11:50+00:00\",\"dateModified\":\"2022-02-25T10:06:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error exporting reports to excel in CRM 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 &amp; 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\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Error exporting reports to excel in CRM 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\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/","og_locale":"en_US","og_type":"article","og_title":"Error exporting reports to excel in CRM part 2 - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In the current versions of Sage CRM we come across this error very often. There are several reasons why this error may occur. I had discussed couple of issues in my earlier blog posts on this particular website (Links below). Error exporting reports to excel https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/22\/error-exporting-reports-to-excel-in-crm\/ Desktop Size Limitation https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/12\/06\/desktop-size-limitation\/ Sometimes even if we follow\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2012-06-26T04:11:50+00:00","article_modified_time":"2022-02-25T10:06:29+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/","name":"Error exporting reports to excel in CRM part 2 - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2012-06-26T04:11:50+00:00","dateModified":"2022-02-25T10:06:29+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/26\/error-exporting-reports-to-excel-in-crm-part-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Error exporting reports to excel in CRM 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 &amp; 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\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/2248","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=2248"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/2248\/revisions"}],"predecessor-version":[{"id":26236,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/2248\/revisions\/26236"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=2248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=2248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=2248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}