{"id":1176,"date":"2017-12-23T12:50:24","date_gmt":"2017-12-23T11:50:24","guid":{"rendered":"http:\/\/blog.systemconnect.dk\/?p=1176"},"modified":"2017-12-23T12:50:24","modified_gmt":"2017-12-23T11:50:24","slug":"sql-mystik-med-nav-2018-opgradering","status":"publish","type":"post","link":"https:\/\/scblog.lynge.org\/?p=1176","title":{"rendered":"SQL mystik med NAV 2018 opgradering"},"content":{"rendered":"<p>Her p\u00e5 fallerebet til Julen 2017 og det nye \u00e5r, lige en heads up omkring en mulig fejl og workaround til Dynamics NAV 2018.<\/p>\n<p>&nbsp;<\/p>\n<p>Dynamics NAV 2018 blev frigivet 1. december 2017 og som altid er der &#8220;skarpe kanter der skal files&#8221; i et sprit nyt system.<\/p>\n<p>Under en teknisk opgradering af en NAV 2013R2 CU5 er vi st\u00f8dt p\u00e5 f\u00f8lgende fejl:<\/p>\n<p><div id=\"attachment_1177\" style=\"width: 495px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.systemconnect.dk\/wp-content\/uploads\/2017\/12\/a.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1177\" class=\"size-full wp-image-1177\" src=\"http:\/\/blog.systemconnect.dk\/wp-content\/uploads\/2017\/12\/a.png\" alt=\"The following SQL Server error or errors occurred when accessing the Add-in table: 15333,&quot;42000&quot;,[Microsoft][SQL Server Native Client 11.0][SQL Server]Error: the qualified @oldname references a database (x) other than the current database. SQL: {CALL [sp_rename](?,?,?)\" width=\"485\" height=\"277\" srcset=\"https:\/\/scblog.lynge.org\/wp-content\/uploads\/2017\/12\/a.png 485w, https:\/\/scblog.lynge.org\/wp-content\/uploads\/2017\/12\/a-300x171.png 300w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><\/a><p id=\"caption-attachment-1177\" class=\"wp-caption-text\">The following SQL Server error or errors occurred when accessing the Add-in table:<br \/>15333,&#8221;42000&#8243;,[Microsoft][SQL Server Native Client 11.0][SQL Server]Error: the qualified @oldname references a database (x) other than the current database.<br \/>SQL:<br \/>{CALL [sp_rename](?,?,?)<\/p><\/div>Det er n\u00e6sten med sikkerhed en lille fejl i Dynamics NAV 2018 RTM og vi har sendt den ind til gutterne i Kgs. Lyngby (Microsoft Development Center Copenhagen).<\/p>\n<p>I mellemtiden kan man lige lave en teknisk opgradering af databasen til Dynamics NAV 2017, inden man smutter p\u00e5 Dynamics NAV 2018. Det lader til at g\u00f8re tricket (husk dog at connecte en server til databasen og k\u00f8re en sync. ifm. opgraderingen til Dynamics NAV 2017).<\/p>\n<p>Gl\u00e6delig Jul og Godt Nyt\u00e5r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Her p\u00e5 fallerebet til Julen 2017 og det nye \u00e5r, lige en heads up omkring en mulig fejl og workaround til Dynamics NAV 2018. &nbsp; Dynamics NAV 2018 blev frigivet 1. december 2017 og som altid er der &#8220;skarpe kanter &hellip; <a href=\"https:\/\/scblog.lynge.org\/?p=1176\">L\u00e6s resten <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,35,36],"tags":[30,15,22,11,52,29,23,14,42,44,31,28,7],"class_list":["post-1176","post","type-post","status-publish","format-standard","hentry","category-dynamics-nav","category-nav-support","category-nav-teknik","tag-bug","tag-business-solutions","tag-database","tag-dynamics","tag-dynamics-nav","tag-fejl","tag-hint","tag-microsoft","tag-nav","tag-navigator","tag-navision","tag-sql","tag-versioner"],"_links":{"self":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/1176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1176"}],"version-history":[{"count":1,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/1176\/revisions"}],"predecessor-version":[{"id":1178,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/1176\/revisions\/1178"}],"wp:attachment":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}