{"id":6037,"date":"2013-12-12T08:41:08","date_gmt":"2013-12-12T08:41:08","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=6037"},"modified":"2018-09-14T12:50:38","modified_gmt":"2018-09-14T12:50:38","slug":"you-may-need-to-recreate-views-manually-ii","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/","title":{"rendered":"You may need to recreate views manually – II"},"content":{"rendered":"

Sage CRM was installed 3 months back on our server for internal use and was working fine. Now our network administrators had changed password for SA account for security purpose and trying to logon to Sage CRM and get You May Need to Recreate Views Manually<\/a>. (He was simply not aware that Sage CRM had used SA account for connecting to Sage CRM database.)
\n\"ErrorMsgImg1\"<\/a>New Stuff:<\/i><\/strong><\/span>\u00a0<\/span>Adding new fields on Web Order Item Entry screen<\/a><\/p>\n

There are several reasons for this error message to be appearing. I will consolidate all of them with Cause and their Resolutions in this post.\u00a0<\/span><\/p>\n

Cause 1:\u00a0<\/strong>Sage CRM database user password has been changed
\n<\/b>Resolution:
\n<\/b>If Sage CRM database password is changed in Microsoft SQL server and not in Sage CRM then resetting the password in Sage CRM resolves an issue by navigating to Administration | System | Database.
\nIf you are unable to login to Sage CRM, user can change it from registry by navigating to below path and changing the <\/span>DatabasePassword<\/b> node.<\/span><\/p>\n

For 32-bit server:<\/i><\/strong>
\n<\/i>In Registry Editor n<\/i>avigate to HKEY_LOCAL_MACHINE | SOFTWARE | eWare | Config | <<CRM Instance>>
\nFor 64-bit server:<\/i><\/strong>
\n<\/i>In Registry Editor n<\/i>avigate to HKEY_LOCAL_MACHINE | SOFTWARE | Wow6432Node | eWare | Config | <<CRM Instance>><\/p>\n

Note:
\n<\/i><\/b>1.\u00a0<\/i>Make sure you have backed up registry before making any changes.
\n<\/i>2.\u00a0<\/i>When password is changed from registry, it doesn\u2019t remains encrypted. To encrypt it, you need to change it by navigating to <\/i>Administration | System | Database, once you are able to login in Sage CRM.<\/i>\u00a0<\/span><\/p>\n

Cause 2:\u00a0<\/strong>Configuration on <\/strong>Sage CRM database server
\n<\/strong>Resolution:
\n<\/b>On Sage CRM database server
\n1) If TCP\/IP protocol is disabled.
\n2) Microsoft SQL server Browser is not running.\u00a0<\/strong><\/p>\n

Cause 3:\u00a0<\/strong>vSentinel View Needs to be dropped
\n<\/strong>Resolution:
\n<\/b>Dropping of vSentinel view recreates all views based on its definition stored in metadata.<\/p>\n

Cause 4:\u00a0<\/strong>Existence of <\/strong>vGroupEntities and vGroupLookup views
\n<\/strong>Resolution:
\n<\/b>Kindly check if the views vGroupEntities and vGroupLookup exists in your CRM database. We have documented the same here<\/a>.<\/p>\n

Cause 5:\u00a0<\/strong>Sage CRM is trying to connect wrong database
\n<\/strong>Resolution:
\n<\/b>Kindly check if Sage CRM is pointing to the correct database. User can check the same from registry by navigating to path mentioned in Cause 1 and checking the DefaultDatabase <\/strong>node.<\/strong>\u00a0<\/strong><\/p>\n

Cause 6:\u00a0<\/strong>Mismatch between Sage CRM Versions
\n<\/strong>Resolution:
\n<\/b>It can also happen when there is a mismatch between Sage CRM version and its database<\/a>.
\nIf you do not find your solution in the above listed, just don\u2019t get panic and check both SQL and System logs which gets created in Sage CRM logs folder. It will probably point you to the origin of an error. Sage CRM logs are located under below path on Sage CRM server.
\n<\/span>C:\\Program Files\\Sage\\CRM\\<<CRM Instance>>\\Logs\\<\/i><\/b><\/p>\n

About Us<\/strong><\/span>
\nGreytrix<\/a> a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n

Greytrix<\/a>\u00a0has some unique integration solutions for Sage CRM with Sage ERPs (Sage Enterprise Management (Sage X3<\/a>),\u00a0Sage Intacct<\/a>, Sage 100<\/a>,\u00a0Sage 500<\/a>\u00a0and\u00a0Sage 300<\/a>).We also offer best-in-class\u00a0Sage ERP<\/a> and Sage CRM<\/a> customization and development services\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users and Sage PSG worldwide. Greytrix\u00a0helps in\u00a0migrating of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer<\/a>. Our Sage CRM Product Suite includes Greytrix Business Manager<\/a>, Sage CRM Project Manager<\/a>, Sage CRM Resource Planner<\/a>, Sage CRM Contract Manager<\/a>, Sage CRM Event Manager<\/a>, Sage CRM Budget Planner<\/a>, Gmail Integration<\/a>, Sage CRM Mobile Service Signature<\/a> and Sage CRM CTI Framework<\/a>.<\/p>\n

Greytrix is a recognized Sage Rockstar ISV Partner<\/a> for GUMU™ Sage Enterprise Management \u2013 Sage CRM integration also listed on Sage Marketplace<\/a>.<\/p>\n

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

Sage CRM was installed 3 months back on our server for internal use and was working fine. Now our network administrators had changed password for SA account for security purpose and trying to logon to Sage CRM and get You May Need to Recreate Views Manually. (He was simply not aware that Sage CRM had\u2026 Read More »<\/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":[233,311,332,424],"tags":[833,1566,1885,2010,2030,2031,2033,2565],"class_list":["post-6037","post","type-post","status-publish","format-standard","hentry","category-manually","category-recreate","category-sage-crm","category-views","tag-crm7-0","tag-manually","tag-recreate","tag-sage-crm","tag-sage-crm-7-0","tag-sage-crm-7-1","tag-sage-crm-7-2","tag-views"],"yoast_head":"\nYou may need to recreate views manually - II - 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\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"You may need to recreate views manually - II - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage CRM was installed 3 months back on our server for internal use and was working fine. Now our network administrators had changed password for SA account for security purpose and trying to logon to Sage CRM and get You May Need to Recreate Views Manually. (He was simply not aware that Sage CRM had\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-12T08:41:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-14T12:50:38+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/ErrorMsgImg1.png\" \/>\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\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/\",\"name\":\"You may need to recreate views manually - II - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/ErrorMsgImg1.png\",\"datePublished\":\"2013-12-12T08:41:08+00:00\",\"dateModified\":\"2018-09-14T12:50:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/ErrorMsgImg1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/ErrorMsgImg1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"You may need to recreate views manually – II\"}]},{\"@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":"You may need to recreate views manually - II - 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\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/","og_locale":"en_US","og_type":"article","og_title":"You may need to recreate views manually - II - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Sage CRM was installed 3 months back on our server for internal use and was working fine. Now our network administrators had changed password for SA account for security purpose and trying to logon to Sage CRM and get You May Need to Recreate Views Manually. (He was simply not aware that Sage CRM had\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-12-12T08:41:08+00:00","article_modified_time":"2018-09-14T12:50:38+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/ErrorMsgImg1.png","type":"","width":"","height":""}],"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\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/","name":"You may need to recreate views manually - II - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/ErrorMsgImg1.png","datePublished":"2013-12-12T08:41:08+00:00","dateModified":"2018-09-14T12:50:38+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/ErrorMsgImg1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/ErrorMsgImg1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/12\/you-may-need-to-recreate-views-manually-ii\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"You may need to recreate views manually – II"}]},{"@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\/6037","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=6037"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/6037\/revisions"}],"predecessor-version":[{"id":20423,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/6037\/revisions\/20423"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=6037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=6037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=6037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}