{"id":11062,"date":"2015-10-09T10:57:32","date_gmt":"2015-10-09T10:57:32","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=11062"},"modified":"2015-10-09T10:57:32","modified_gmt":"2015-10-09T10:57:32","slug":"troubleshooting-sage-crms-customized-data-upload-routine-issue","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/","title":{"rendered":"Troubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue"},"content":{"rendered":"

As we all are familiar, Sage CRM<\/a> has provided the facility to create multiple Primary and\u00a0Secondary entities to maintain data in system either by making data entries manually or by \u00a0uploading large number of records at a time. Sage CRM<\/a>\u2019s flexibility has helped the users to not only use the data upload routine for standard primary entities but also design and incorporate customized routine within CRM which would work for secondary entities. In below article, I will share one of my experience where the customized upload routine threw unpredicted issues.<\/p>\n

New Stuff:\u00a0<\/strong><\/em>Working with integrated Quotes and Orders screen<\/a><\/span><\/span><\/p>\n

Recently for one of our clients, I had designed a custom data upload routine with the help of .NET API, Microsoft interop DLL etc. It worked well on the development machine however threw issues on another machine as listed below –<\/p>\n

1. System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType)<\/em><\/strong>
\n 2. Microsoft.Office.Interop.Excel.Workbooks.Open exception<\/em><\/strong><\/p>\n

On analyzing above issue we came to know that, these issues were related to the application rights and other related configurations. On troubleshooting, we were able to resolve these issues by following below given steps.<\/p>\n

1. Go To Start<\/strong> | RUN<\/strong>
\n2. Enter Dcomcnfg<\/strong> and click ok button
\n3. From the left panel select Computer | My Computer | DCOM Config<\/strong><\/p>\n

\"image1\"<\/a><\/p>\n

4. Right click on Microsoft excel application<\/strong> option.
\n5. Select Properties option from list
\n6. Go to Security<\/strong> tab, click on Customize option and provide user access rights to System, Interactive user, Network, and Everyone users as shown below.<\/p>\n

\u00a0\"image2\"<\/a>
\n7. Test if the excel is working properly. “Run…” type “excel.exe \/safe” – Enter, and “excel.exe \/automation” – Enter … if both open the excel, the application should work
\n8. Create directory C:\\Windows\\SysWOW64\\config\\systemprofile\\Desktop<\/strong> (for 64 bit Windows) or C:\\Windows\\System32\\config\\systemprofile\\Desktop<\/strong> (for 32 bit Windows)
\n9. Set Full control permissions for directory Desktop (for example, in Win7 and IIS 7 and DefaultAppPool set permissions for user “IIS AppPool\\DefaultAppPool”)
\n10. Open Inetmgr<\/strong> and Go to Application pool
\n11. Select Sage CRM<\/strong> application pool
\n12. Click on Advance setting button
\n13. Set Local System<\/strong> option in identity field.
\n14. Perform IISRESET<\/strong>
\nAlso Read:<\/strong><\/em><\/span>
\n1.<\/strong> Data Upload using Deduplication \u2013 Part 2<\/a>
\n2.<\/strong> Sage CRM File Upload Limitation setting<\/a>
\n3.<\/strong> Data Upload using Deduplication<\/a>
\n4.<\/strong> Document Upload Notification in Sage CRM<\/a>
\n5.<\/strong> Document upload link from other entity lists<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

As we all are familiar, Sage CRM has provided the facility to create multiple Primary and\u00a0Secondary entities to maintain data in system either by making data entries manually or by \u00a0uploading large number of records at a time. Sage CRM\u2019s flexibility has helped the users to not only use the data upload routine for standard\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,5,42,73,92,98,101,106,138,152,182,184,284,332,356,1,413],"tags":[899,929,930,1443,1444,1948,2515],"class_list":["post-11062","post","type-post","status-publish","format-standard","hentry","category-32-bit","category-64-bit","category-bulk","category-configuration","category-custom-entity","category-customization","category-data-upload","category-dcom","category-error","category-feature","category-iisreset","category-import-sage-crm","category-permissions","category-sage-crm","category-security","category-uncategorized","category-upload","tag-customized-data-upload-issue","tag-dcom-2","tag-dcom-config","tag-interop-dll","tag-interop-dll-issue","tag-rights","tag-upload-issue"],"yoast_head":"\nTroubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue - 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\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Troubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As we all are familiar, Sage CRM has provided the facility to create multiple Primary and\u00a0Secondary entities to maintain data in system either by making data entries manually or by \u00a0uploading large number of records at a time. Sage CRM\u2019s flexibility has helped the users to not only use the data upload routine for standard\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-09T10:57:32+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/10\/image1.jpg\" \/>\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=\"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\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/\",\"name\":\"Troubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/10\/image1.jpg\",\"datePublished\":\"2015-10-09T10:57:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/10\/image1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/10\/image1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Troubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue\"}]},{\"@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\/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":"Troubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue - 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\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/","og_locale":"en_US","og_type":"article","og_title":"Troubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue - Sage CRM \u2013 Tips, Tricks and Components","og_description":"As we all are familiar, Sage CRM has provided the facility to create multiple Primary and\u00a0Secondary entities to maintain data in system either by making data entries manually or by \u00a0uploading large number of records at a time. Sage CRM\u2019s flexibility has helped the users to not only use the data upload routine for standard\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2015-10-09T10:57:32+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/10\/image1.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/","name":"Troubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/10\/image1.jpg","datePublished":"2015-10-09T10:57:32+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/10\/image1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/10\/image1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/10\/09\/troubleshooting-sage-crms-customized-data-upload-routine-issue\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Troubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue"}]},{"@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\/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\/11062","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=11062"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11062\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=11062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=11062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=11062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}