1 Reply Latest reply: Mar 6, 2007 6:29 PM by 428652 RSS

    Getting ORA-29881 in iStore

    108876
      We are on Oracle Apps 11.5.5 on Solaris 2.8 and are facing the following problem:

      In speciality store,during checkout process, on clicking the "continue button" after the shipping information page,the following error message appears.

      Error Message:
      -------------

      Could not process request. Please try back later.

      Message: The following SQL error occurred:
      ORA-29881: failed to validate indextype.
      Stack:
      oracle.apps.jtf.base.resources.FrameworkException: The following SQL error occurred:
      ORA-29881: failed to validate indextype.
      at oracle.apps.ibe.shoppingcart.quote.Quote.save(Quote.java)
      at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.saveShippingInformation(ShoppingCart.java:2408)
      at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.saveHeaderShipmentDetails(ShoppingCart.java:2285)
      at oa_html._ibeCCkpHdrShip._jspService(_ibeCCkpHdrShip.java:1075)
      at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java)
      at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
      at oracle.jsp.JspServlet.doDispatch(JspServlet.java)
      at oracle.jsp.JspServlet.internalService(JspServlet.java)
      at oracle.jsp.JspServlet.service(JspServlet.java)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      at org.apache.jserv.JServConnection.processRequest(JServConnection.java:314)
      at org.apache.jserv.JServConnection.run(JServConnection.java:188)
      at java.lang.Thread.run(Thread.java:484)
      The following SQL error occurred:
      ORA-29881: failed to validate indextype


      Why does this error occur?

      Also, there are no invalid indextype objects in the database. Am I missing something?

      Any help would be greatly appreciated.

      Thanks In Advance

      Praveen