{"id":7005,"date":"2015-03-31T15:41:42","date_gmt":"2015-03-31T15:41:42","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=7005"},"modified":"2018-02-13T09:11:10","modified_gmt":"2018-02-13T14:11:10","slug":"pitss-con-error-ora-01422-when-running-dead-code-analyse-in-application-analysis","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2015\/03\/31\/pitss-con-error-ora-01422-when-running-dead-code-analyse-in-application-analysis\/","title":{"rendered":"PITSS.CON Error &ndash; ORA-01422 When Running Dead Code Analyse"},"content":{"rendered":"<p>In PITSS.CON 12.3.1 and older, there is a button in Application Analysis called \u201cCustom Reports\u201d which will take you to a page to do an analysis of dead code in your Forms application. This is a button which could be selected after parsing the application.<\/p>\n<p><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2015\/03\/image5.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border: 0px\" title=\"image\" src=\"https:\/\/pitss.org\/files\/2015\/03\/image_thumb5.png\" alt=\"image\" width=\"272\" height=\"392\" border=\"0\" \/><\/a><\/p>\n<p>Once the Custom Reports module (also shows as \u201cDead Code Analyse\u201d in PITSS.CON), if you click the \u201cRun Task\u201d button in this window, there is a possibility that the following error is produced:<\/p>\n<p>\u201cError: ORA-01422: exact fetch returns more than requested number of rows\u201d<\/p>\n<p>NOTE: This does not happen with all PITSS.CON installations.<\/p>\n<p>This was actually another method of performing an Unused Objects Analysis. To perform an Unused Objects Analysis (same as performing the dead code analysis), go to Application Engineering in the main menu and go to \u201cUnused Objects Analysis\u201d. Inside this module, you can perform the analysis to check for all of the unused objects in your application.<\/p>\n<p><strong>NOTE: Starting with PITSS.CON 15.1.1, the button in Application Analysis has been removed.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In PITSS.CON 12.3.1 and older, there is a button in Application Analysis called \u201cCustom Reports\u201d which will take you to a page to do an analysis of dead code in your Forms application. This is a button which could be selected after parsing the application. Once the Custom Reports module (also shows as \u201cDead Code [&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":[12,7],"class_list":["post-7005","post","type-post","status-publish","format-standard","hentry","category-pitss-con","category-resolve-issues","tag-error","tag-pitss-con"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/7005","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=7005"}],"version-history":[{"count":5,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/7005\/revisions"}],"predecessor-version":[{"id":10888,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/7005\/revisions\/10888"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=7005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=7005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=7005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}