{"id":6,"date":"2008-05-14T06:59:00","date_gmt":"2008-05-14T01:29:00","guid":{"rendered":"http:\/\/guganeshan.com\/blog\/?p=6"},"modified":"2009-12-18T14:03:19","modified_gmt":"2009-12-18T08:33:19","slug":"error-message-doesnt-make-sense-check-the-service-packs","status":"publish","type":"post","link":"https:\/\/guganeshan.com\/blog\/error-message-doesnt-make-sense-check-the-service-packs.html","title":{"rendered":"Error message doesn&#8217;t make sense? check the service packs"},"content":{"rendered":"<p>Just the other day, the guys told me &#8220;This is weird, the same form works in one PC and throws an exception in another&#8221;.<\/p>\n<p>We thought it is something to do with the default culture set in the PC (it was dutch). But the culprit seemed to be the SQL query used. But how come the same SQL query with the same database works in one PC + SQL server and throws an exception in another PC + SQL server? (the databases are identical)<!--more--><\/p>\n<p>Since there was no difference in the application, query, and database the only thing that was different is the SQL server. I tried the query in query analyzer and saw that the following exception was thrown against only one SQL server:<br \/>\n<span id=\"ctl00_ContentPlaceHolder1_MicrosoftKBArticle\"> <\/span><\/p>\n<blockquote><p>Server: Msg 8623, Level 16, State 1, Line 1 Internal Query Processor Error:<br \/>\nThe query processor could not produce a query plan. Contact your primary     support provider for more information.<\/p><\/blockquote>\n<p>Even though I found some Microsoft knowledge base results when Googled, unfortunately the KB articles are not showing up in either Firefox or IE (its like that recently, didn&#8217;t check on it yet). Finally found <a href=\"http:\/\/kbalertz.com\/816440\/Error-Raised-Server-Compiles-Complex-Query.aspx\">this article<\/a> in KBAlerts.com that shed some light on the problem&#8230; missing service pack!<\/p>\n<p>Moral of the experience? Google it first!  \ud83d\ude42<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Just the other day, the guys told me &#8220;This is weird, the same form works in one PC and throws an exception in another&#8221;. We thought it is something to do with the default culture set in the PC (it was dutch). But the culprit seemed to be the SQL query used. But how come [&#8230;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[29,68],"class_list":["post-6","post","type-post","status-publish","format-standard","hentry","category-troubleshooting","tag-tips","tag-troubleshooting"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/posts\/6","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/comments?post=6"}],"version-history":[{"count":4,"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/posts\/6\/revisions"}],"predecessor-version":[{"id":89,"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/posts\/6\/revisions\/89"}],"wp:attachment":[{"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/media?parent=6"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/categories?post=6"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guganeshan.com\/blog\/wp-json\/wp\/v2\/tags?post=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}