{"id":5256,"date":"2014-10-03T11:03:07","date_gmt":"2014-10-03T11:03:07","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=5256"},"modified":"2017-05-15T11:12:11","modified_gmt":"2017-05-15T15:12:11","slug":"unable-to-load-forms-and-reports-into-pitss-con-due-to-ora-29875","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2014\/10\/03\/unable-to-load-forms-and-reports-into-pitss-con-due-to-ora-29875\/","title":{"rendered":"Unable to load Forms and Reports into PITSS.CON Due to ORA-29875"},"content":{"rendered":"<p>If you are attempting to load forms or reports into PITSS.CON, and you are unable to load any form or report into PITSS.CON (including ones already been loaded into the PITSS.CON repository) due to the following errors:<\/p>\n<p>Forms:<\/p>\n<p>\u201cInsert code for [TRIGGER or PROGRAM UNIT] \u2013 ORA-29875: failed in the execution of the ODCIINDEXINSERT routineORA-\u201d<\/p>\n<p><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2014\/10\/image.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\/2014\/10\/image_thumb.png\" alt=\"image\" width=\"497\" height=\"339\" border=\"0\" \/><\/a><\/p>\n<p>Reports:<\/p>\n<p>No errors in the \u201cError List\u201d window, but the error \u201cORA-06502: PL\/SQL: numeric or value error\u201d appears in the bottom status bar.<\/p>\n<p><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2014\/10\/image1.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\/2014\/10\/image_thumb1.png\" alt=\"image\" width=\"538\" height=\"309\" border=\"0\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The indexes for the PITSS.CON user you are using will need to be re-indexed. The MIG user can do this within PITSS.CON:<\/p>\n<p><strong>NOTE: Please disconnect (log out of) all logins of the PITSS.CON user you are using whether it be in PITSS.CON or in any database program such as SQL*Plus, SQL Developer, or Toad before completing the steps below.<\/strong><\/p>\n<p>1. Log into PITSS.CON with the MIG user.<\/p>\n<p>2. Go to \u201cUser Administration\u201d.<\/p>\n<p><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2014\/10\/image2.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\/2014\/10\/image_thumb2.png\" alt=\"image\" width=\"520\" height=\"402\" border=\"0\" \/><\/a><\/p>\n<p>3. Expand the group the PITSS.CON user belongs to and select your PITSS.CON user. After that, click the \u201cAdd User to Task\u201d button.<\/p>\n<p><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2014\/10\/image3.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\/2014\/10\/image_thumb3.png\" alt=\"image\" width=\"526\" height=\"345\" border=\"0\" \/><\/a><\/p>\n<p>4. Select the check boxes \u201cCompile Invalid Objects\u201d and \u201cRebuild Indexes\u201d. After both of them are selected, click \u201cRun Task\u201d.<\/p>\n<p><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2014\/10\/image4.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\/2014\/10\/image_thumb4.png\" alt=\"image\" width=\"527\" height=\"348\" border=\"0\" \/><\/a><\/p>\n<p>5. Please wait until the task is completed. When finished, you will see a status in the status bar at the bottom saying, \u201cDone.\u201d<\/p>\n<p><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2014\/10\/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\/2014\/10\/image_thumb5.png\" alt=\"image\" width=\"528\" height=\"78\" border=\"0\" \/><\/a><\/p>\n<p>6. Log out of the MIG user and back into your PITSS.CON user.<\/p>\n<p>&nbsp;<\/p>\n<p>After completing the steps above, you should be able to resume loading your Forms and Reports modules into PITSS.CON.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are attempting to load forms or reports into PITSS.CON, and you are unable to load any form or report into PITSS.CON (including ones already been loaded into the PITSS.CON repository) due to the following errors: Forms: \u201cInsert code for [TRIGGER or PROGRAM UNIT] \u2013 ORA-29875: failed in the execution of the ODCIINDEXINSERT routineORA-\u201d [&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,23,7,37],"class_list":["post-5256","post","type-post","status-publish","format-standard","hentry","category-pitss-con","category-resolve-issues","tag-error","tag-forms","tag-pitss-con","tag-reports"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/5256","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=5256"}],"version-history":[{"count":3,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/5256\/revisions"}],"predecessor-version":[{"id":9090,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/5256\/revisions\/9090"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=5256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=5256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=5256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}