{"id":105,"date":"2019-04-01T19:22:24","date_gmt":"2019-04-01T19:22:24","guid":{"rendered":"https:\/\/stoneedge.com\/kb\/?post_type=ht_kb&#038;p=105"},"modified":"2021-09-21T14:00:45","modified_gmt":"2021-09-21T14:00:45","slug":"stone-edge-hangs-during-upgrade","status":"publish","type":"ht_kb","link":"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/","title":{"rendered":"Stone Edge Hangs during Upgrade"},"content":{"rendered":"<h2>Problem<\/h2>\n<p>The upgrade script runs for quite sometime before the program seems to hang and issues various error messages.<\/p>\n<h2>Symptom<\/h2>\n<p><span class=\"dropspot\">The program may issue the<\/span>\u00a0following errors:<\/p>\n<ul>\n<li>At pass through: Error = 3146 Application-define or object-defined error<\/li>\n<\/ul>\n<p>followed by:<\/p>\n<ul>\n<li>Error in ErrorTrap code! Error = 3127: The INSERT INTO statement contains the following unknown field name&#8221; &#8216;USER&#8217;. Make sure you have typed the name correctly, and try the operation again.<\/li>\n<\/ul>\n<p>or:<\/p>\n<ul>\n<li>At Startup: Error = 3146: ODBC &#8211; call failed<\/li>\n<\/ul>\n<p>The user is asked to login to\u00a0<span style=\"font-size: small;\">SEOM<\/span>, the process will run for a while and the same messages may appear repetitively.<\/p>\n<p>There is no confirmation of successful completion, but the Log-In screen may appear.<\/p>\n<p>When attempting to login, the Error in ErrorTrap message described above may be issued, or &#8220;At CheckTables: Error = 91: Object variable of With block variable not set&#8221; may be encountered.<\/p>\n<h2>Cause<\/h2>\n<p>ODBC Timeout errors are occurring during the upgrade process, preventing the upgrade script from successfully completing the conversion of the data file.<\/p>\n<h2>Solution<\/h2>\n<p>Set system parameter\u00a0SQLServerODBCTimeout\u00a0to a number significantly higher than the default value of 60.<\/p>\n<h2>Component and Versions Affected<\/h2>\n<ul>\n<li class=\"BulletedList\">Any Enterprise Edition, when using an SQL store data file.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Problem The upgrade script runs for quite sometime before the program seems to hang and issues various error messages. Symptom The program may issue the\u00a0following errors: At pass through: Error = 3146 Application-define or object-defined error followed by: Error in ErrorTrap code! Error = 3127: The INSERT INTO statement contains&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[23],"ht-kb-tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Stone Edge Hangs during Upgrade - Stone Edge Order Manager<\/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:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Stone Edge Hangs during Upgrade - Stone Edge Order Manager\" \/>\n<meta property=\"og:description\" content=\"Problem The upgrade script runs for quite sometime before the program seems to hang and issues various error messages. Symptom The program may issue the\u00a0following errors: At pass through: Error = 3146 Application-define or object-defined error followed by: Error in ErrorTrap code! Error = 3127: The INSERT INTO statement contains...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/\" \/>\n<meta property=\"og:site_name\" content=\"Stone Edge Order Manager\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-21T14:00:45+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/\",\"url\":\"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/\",\"name\":\"Stone Edge Hangs during Upgrade - Stone Edge Order Manager\",\"isPartOf\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\"},\"datePublished\":\"2019-04-01T19:22:24+00:00\",\"dateModified\":\"2021-09-21T14:00:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stoneedge.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stone Edge Hangs during Upgrade\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\",\"url\":\"https:\/\/stoneedge.com\/kb\/\",\"name\":\"Stone Edge Order Manager\",\"description\":\"Documentation for the Stone Edge Order Manager\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stoneedge.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Stone Edge Hangs during Upgrade - Stone Edge Order Manager","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:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/","og_locale":"en_US","og_type":"article","og_title":"Stone Edge Hangs during Upgrade - Stone Edge Order Manager","og_description":"Problem The upgrade script runs for quite sometime before the program seems to hang and issues various error messages. Symptom The program may issue the\u00a0following errors: At pass through: Error = 3146 Application-define or object-defined error followed by: Error in ErrorTrap code! Error = 3127: The INSERT INTO statement contains...","og_url":"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/","og_site_name":"Stone Edge Order Manager","article_modified_time":"2021-09-21T14:00:45+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/","url":"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/","name":"Stone Edge Hangs during Upgrade - Stone Edge Order Manager","isPartOf":{"@id":"https:\/\/stoneedge.com\/kb\/#website"},"datePublished":"2019-04-01T19:22:24+00:00","dateModified":"2021-09-21T14:00:45+00:00","breadcrumb":{"@id":"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/stoneedge.com\/kb\/articles\/stone-edge-hangs-during-upgrade\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stoneedge.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Stone Edge Hangs during Upgrade"}]},{"@type":"WebSite","@id":"https:\/\/stoneedge.com\/kb\/#website","url":"https:\/\/stoneedge.com\/kb\/","name":"Stone Edge Order Manager","description":"Documentation for the Stone Edge Order Manager","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stoneedge.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/105"}],"collection":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/comments?post=105"}],"version-history":[{"count":2,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/105\/revisions"}],"predecessor-version":[{"id":1998,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/105\/revisions\/1998"}],"wp:attachment":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/media?parent=105"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=105"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}