{"id":13491,"date":"2018-11-09T06:58:50","date_gmt":"2018-11-09T05:58:50","guid":{"rendered":"https:\/\/www.knowledgebase.info-bit.com\/?p=13491"},"modified":"2018-11-09T06:59:15","modified_gmt":"2018-11-09T05:59:15","slug":"errore-in-fase-di-aggiornamento-ring-con-databse-hana-ring","status":"publish","type":"post","link":"https:\/\/www.knowledgebase.info-bit.com\/?p=13491","title":{"rendered":"Errore in fase di aggiornamento RING con databse HANA &#8211; RING"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;margin-bottom: 0px;margin-top: 0px;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"margin-top:0px;margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-1\"><h3><b><strong style=\"font-style: inherit;\">SINTOMO<\/strong><\/b><\/h3>\n<p>Durante l\u2019avvio di Ring su database HANA, in fase di aggiornamento database, appare un messaggio simile a questo<\/p>\n<p><img class=\"aligncenter size-full wp-image-13492\" src=\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01.png\" alt=\"\" width=\"595\" height=\"249\" srcset=\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01-200x84.png 200w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01-300x126.png 300w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01-400x167.png 400w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01.png 595w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/p>\n<p style=\"font-weight: 400;\">Nelle versioni pi\u00f9 recenti di Ring il messaggio pu\u00f2 essere simile a questo:<\/p>\n<ul style=\"font-weight: 400;\">\n<li><em>1116 Unable to end sql transaction<\/em><\/li>\n<\/ul>\n<h3><b><strong style=\"font-style: inherit;\">WORKAROUND<\/strong><\/b><\/h3>\n<p style=\"font-weight: 400;\">Per ovviare al problema, si consiglia di:<\/p>\n<ul style=\"font-weight: 400;\">\n<li>\u00a0togliere temporaneamente la spunta dalla seguente casella:<\/li>\n<\/ul>\n<p><img class=\"aligncenter size-800 wp-image-13493\" src=\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_02-800x294.png\" alt=\"\" width=\"800\" height=\"294\" srcset=\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_02-200x73.png 200w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_02-300x110.png 300w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_02-400x147.png 400w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_02-600x220.png 600w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_02-768x282.png 768w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_02-800x294.png 800w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_02-1024x376.png 1024w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_02.png 1052w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li>Salvare la parametrizzazione<\/li>\n<li>Uscire e rientrare da SAP Business One<\/li>\n<li>Avviare nuovamente Ring<\/li>\n<\/ul>\n<p>Se l\u2019aggiornamento del database giunge al termine senza errori,\u00a0<b>riattivare nuovamente la notifica di transazione:<\/b><\/p>\n<p><img class=\"aligncenter size-full wp-image-13494\" src=\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_03.png\" alt=\"\" width=\"182\" height=\"23\" srcset=\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_03-177x23.png 177w, https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_03.png 182w\" sizes=\"(max-width: 182px) 100vw, 182px\" \/><\/p>\n<h3><b><strong style=\"font-style: inherit;\">RIFERIMENTI<\/strong><\/b><\/h3>\n<p style=\"font-weight: 400;\">Il problema sembra a volte legato al cambio di lunghezza del parametro\u00a0<em>object_type<\/em>\u00a0della stored procedure\u00a0<em>SBO_SP_TransactionNotification<\/em>.<\/p>\n<p style=\"font-weight: 400;\">Una possibile soluzione, non testata con questo sintomo, ma suggerita da SAP \u00e8 riportato nella seguente nota:<\/p>\n<p style=\"font-weight: 400;\"><a href=\"https:\/\/launchpad.support.sap.com\/#\/notes\/2228417\">https:\/\/launchpad.support.sap.com\/#\/notes\/2228417<\/a><\/p>\n<p style=\"font-weight: 400;\"><em>Option 2: Update stored procedure\u00a0SBO_SP_TransactionNotification\u00a0and\u00a0SBO_SP_PostTransactionNotice, then change data type of parameter\u00a0object_type\u00a0from nvarchar(20) to nvarchar(30).\u00a0<\/em><em>Verify that\u00a0these SPs run correctly after\u00a0the change.<\/em><\/p>\n<p style=\"font-weight: 400;\">Errore in fase di aggiornamento database, Unable to end sql transaction, -1116<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":12,"featured_media":13492,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[30],"tags":[81,89,88],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Errore in fase di aggiornamento RING con databse HANA - RING - Knowledgebase Info-Bit<\/title>\r\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<meta property=\"og:locale\" content=\"it_IT\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Errore in fase di aggiornamento RING con databse HANA - RING - Knowledgebase Info-Bit\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.knowledgebase.info-bit.com\/?p=13491\" \/>\r\n<meta property=\"og:site_name\" content=\"Knowledgebase Info-Bit\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-11-09T05:58:50+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2018-11-09T05:59:15+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"595\" \/>\r\n\t<meta property=\"og:image:height\" content=\"249\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Beatrice Mendiola\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuti\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#website\",\"url\":\"https:\/\/www.knowledgebase.info-bit.com\/\",\"name\":\"Knowledgebase Info-Bit\",\"description\":\"Soluzioni rapide alle richieste dei nostri clienti\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.knowledgebase.info-bit.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"it-IT\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#primaryimage\",\"inLanguage\":\"it-IT\",\"url\":\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01.png\",\"contentUrl\":\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01.png\",\"width\":595,\"height\":249},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#webpage\",\"url\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=13491\",\"name\":\"Errore in fase di aggiornamento RING con databse HANA - RING - Knowledgebase Info-Bit\",\"isPartOf\":{\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#primaryimage\"},\"datePublished\":\"2018-11-09T05:58:50+00:00\",\"dateModified\":\"2018-11-09T05:59:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#\/schema\/person\/f437e64f2b9538016531e4bd2cca8e51\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.knowledgebase.info-bit.com\/?p=13491\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Errore in fase di aggiornamento RING con databse HANA &#8211; RING\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#\/schema\/person\/f437e64f2b9538016531e4bd2cca8e51\",\"name\":\"Beatrice Mendiola\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#personlogo\",\"inLanguage\":\"it-IT\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b0c626f5f05cb16c439fc65139466d04?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b0c626f5f05cb16c439fc65139466d04?s=96&d=mm&r=g\",\"caption\":\"Beatrice Mendiola\"},\"url\":\"https:\/\/www.knowledgebase.info-bit.com\/?author=12\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Errore in fase di aggiornamento RING con databse HANA - RING - Knowledgebase Info-Bit","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"it_IT","og_type":"article","og_title":"Errore in fase di aggiornamento RING con databse HANA - RING - Knowledgebase Info-Bit","og_url":"https:\/\/www.knowledgebase.info-bit.com\/?p=13491","og_site_name":"Knowledgebase Info-Bit","article_published_time":"2018-11-09T05:58:50+00:00","article_modified_time":"2018-11-09T05:59:15+00:00","og_image":[{"width":595,"height":249,"url":"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Scritto da":"Beatrice Mendiola","Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.knowledgebase.info-bit.com\/#website","url":"https:\/\/www.knowledgebase.info-bit.com\/","name":"Knowledgebase Info-Bit","description":"Soluzioni rapide alle richieste dei nostri clienti","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knowledgebase.info-bit.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"it-IT"},{"@type":"ImageObject","@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#primaryimage","inLanguage":"it-IT","url":"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01.png","contentUrl":"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2018\/11\/ERRORE-IN-FASE-DI-AGGIORNAMENTO-RING-CON-DATABASE-HANA_01.png","width":595,"height":249},{"@type":"WebPage","@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#webpage","url":"https:\/\/www.knowledgebase.info-bit.com\/?p=13491","name":"Errore in fase di aggiornamento RING con databse HANA - RING - Knowledgebase Info-Bit","isPartOf":{"@id":"https:\/\/www.knowledgebase.info-bit.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#primaryimage"},"datePublished":"2018-11-09T05:58:50+00:00","dateModified":"2018-11-09T05:59:15+00:00","author":{"@id":"https:\/\/www.knowledgebase.info-bit.com\/#\/schema\/person\/f437e64f2b9538016531e4bd2cca8e51"},"breadcrumb":{"@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knowledgebase.info-bit.com\/?p=13491"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=13491#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Errore in fase di aggiornamento RING con databse HANA &#8211; RING"}]},{"@type":"Person","@id":"https:\/\/www.knowledgebase.info-bit.com\/#\/schema\/person\/f437e64f2b9538016531e4bd2cca8e51","name":"Beatrice Mendiola","image":{"@type":"ImageObject","@id":"https:\/\/www.knowledgebase.info-bit.com\/#personlogo","inLanguage":"it-IT","url":"https:\/\/secure.gravatar.com\/avatar\/b0c626f5f05cb16c439fc65139466d04?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b0c626f5f05cb16c439fc65139466d04?s=96&d=mm&r=g","caption":"Beatrice Mendiola"},"url":"https:\/\/www.knowledgebase.info-bit.com\/?author=12"}]}},"_links":{"self":[{"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/posts\/13491"}],"collection":[{"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13491"}],"version-history":[{"count":2,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/posts\/13491\/revisions"}],"predecessor-version":[{"id":13511,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/posts\/13491\/revisions\/13511"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/media\/13492"}],"wp:attachment":[{"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}