{"id":13270,"date":"2020-07-21T11:38:02","date_gmt":"2020-07-21T15:38:02","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=13270"},"modified":"2020-07-21T11:38:02","modified_gmt":"2020-07-21T15:38:02","slug":"unable-to-perform-query","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2020\/07\/21\/unable-to-perform-query\/","title":{"rendered":"Unable to Perform Query When Running Search and Replace in PITSS.CON"},"content":{"rendered":"<p>There is a known PITSS.CON issue when you run a Search and Replace. The issue is that after running either a search or a search and replace in PITSS.CON, the following error is produced:<\/p>\n<p>40505 &#8211; ORACLE error: unable to perform query<\/p>\n<p><a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2020\/07\/Unable-to-perform-query.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13271\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2020\/07\/Unable-to-perform-query.png\" alt=\"\" width=\"624\" height=\"411\" srcset=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2020\/07\/Unable-to-perform-query.png 624w, https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2020\/07\/Unable-to-perform-query-480x316.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 624px, 100vw\" \/><\/a><\/p>\n<p>After a few moments, the Search and Replace results will come up. However, the results are blank even though there is a count of objects which should have been returned.<\/p>\n<p><a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2020\/07\/Unable-to-perform-query-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13272\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2020\/07\/Unable-to-perform-query-2.png\" alt=\"\" width=\"624\" height=\"425\" srcset=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2020\/07\/Unable-to-perform-query-2.png 624w, https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2020\/07\/Unable-to-perform-query-2-480x327.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 624px, 100vw\" \/><\/a><\/p>\n<p>The reason for this is because there is an Oracle bug in the Oracle database hosting PITSS.CON. The solution is to run the following SQL command as a SYSDBA user such as SYS:<\/p>\n<p><b>alter system set optimizer_features_enable=&#8217;11.2.0.4&#8242;;<\/b><\/p>\n<p>Once this is run, the problem should disappear.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There is a known PITSS.CON issue when you run a Search and Replace. The issue is that after running either a search or a search and replace in PITSS.CON, the following error is produced: 40505 &#8211; ORACLE error: unable to perform query After a few moments, the Search and Replace results will come up. However, [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[6,14],"tags":[11,16,89,32,25,12,27,7],"class_list":["post-13270","post","type-post","status-publish","format-standard","hentry","category-pitss-con","category-resolve-issues","tag-11g","tag-11gr2","tag-12c","tag-bug","tag-customer-support-request","tag-error","tag-oracle-database","tag-pitss-con"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/13270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=13270"}],"version-history":[{"count":1,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/13270\/revisions"}],"predecessor-version":[{"id":13273,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/13270\/revisions\/13273"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=13270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=13270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=13270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}