No announcement yet.

Error in Open OTM Screens

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error in Open OTM Screens


    We are able to login to OTM. But not able to open any of the screens (shipment,
    Invoice, Business Process etc) This prevents us from shipping products. This also prevents us from processing the invoices.

    When we are trying to open error came as below

    call vpd.set_user_r(?,?,?,?)=null}; inParams=[UPS.ADMIN, ADMIN, null, STATIC]
    java.sql.SQLException: OALL8 is in an inconsistent state.

    Sometimes its working fine sometimes this issue came.

    We have created a new independent domain called 'UPS'.
    Associated setup: given grants on the location from other domain
    Created new service provider, new locations,rate offering, rate record, automation agents, saved queries, new screen sets for shipments and

    Please provode the solution for this.

    With Regards
    Nishant Jain

  • #2
    Re: Error in Open OTM Screens


    Have your DBA check the database and make sure you can SQLplus from the application server to the DB. Also check the weblogic console.log and glog.exception.log for more information. You may also have a networking issue. Is the application server connection to the database going through a firewall? We have seen alot of issues in the past with this setup.
    If my post was helpful please click on the Thanks! button

    MavenWire Hosting Admin
    15 years of OTM experience