Announcement

Collapse
No announcement yet.

[SOLVED] Installation Error: Security Violation: User:'DBA.ADMIN' has insufficient p

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts

  • [SOLVED] Installation Error: Security Violation: User:'DBA.ADMIN' has insufficient p

    A member of the forums recently installed OTM and received the following error. I'm posting this here to track the issue and hopefully help others who later encounter this issue:

    HI Chris.

    Need a small help from you.

    we have installed OTM 5.5 CU3. Everything went sucessfully but we are getting an error while logging in. I am logging in using DBA.ADMIN user. It says some thing as below. Kindly help me if you have seen anything like this before.
    Code:
    java.rmi.AccessException: [EJB:010160]Security Violation: User: 'DBA.ADMIN' has insufficient permission to access EJB
    The stack trace is as below:
    Code:
    java.rmi.AccessException: [EJB:010160]Security Violation: User: 'DBA.ADMIN' has insufficient permission to access EJB: type=, application=GC3App, module=ProblemSession, ejb=ProblemSessionHome, method=getAllProbCount, methodInterface=Remote, signature={java.lang.String}. at weblogic.rjvm.BasicOutboundRequest.sendReceive(BasicOutboundRequest.java:108) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:290) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:247) at glog.server.problem.ProblemSessionHome_h2m0bh_EOImpl_814_WLStub.getAllProbCount(Unknown Source) at glog.webserver.problem.CheckProblemServlet.getDocument(CheckProblemServlet.java:42) at glog.webserver.util.AbstractServletProducer.process(AbstractServletProducer.java:81) at glog.webserver.util.BaseServlet.service(BaseServlet.java:614) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFil!
     ter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at glog.webserver.screenlayout.ClientSessionTracker.doFilter(ClientSessionTracker.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at glog.webserver.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves!
     .ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.cata
    lina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534)
    Thanks a lot for all your help.

    Regards,
    Manohar
    Last edited by chrisplough; July 3, 2007, 02:50.
    Chris Plough
    twitter.com/chrisplough
    MavenWire

  • #2
    Re: Installation Error: Security Violation: User:'DBA.ADMIN' has insufficient permis

    Manohar,

    Can you confirm that you ran the <otm_install_dir>/glog/oracle/insert_security_roles.sql script against your database after installation? If so, please confirm that you updated your database by running the <otm_install_dir>/glog/oracle/script8/dbpatch_55.sql script after the DB setup?

    Finally, if both have been done, can you verify what application server you're using with OTM (WebLogic, WebSphere, OAS) - as the security setups for each are quite different.

    Thanks!
    --Chris
    Chris Plough
    twitter.com/chrisplough
    MavenWire

    Comment


    • #3
      Re: Installation Error: Security Violation: User:'DBA.ADMIN' has insufficient permis

      Hi Chris,Thanks a lot for all the help.we had run all the scripts which you have mentioned in your mail.Finally we were able to somehow solve the error.The error was caused as for some reason the synonyms, triggers related to VPD table in the database became invalid and there were also some locks.we cleared that all and OTM started running fine.we started using it and saw some more issues. Many screens in order management module are not opening and giving an error. Rest all screens are working fine.Please do let us know if anyone has faced this issue and solved it.Thanks a lot,Manohar

      Comment


      • #4
        Re: Installation Error: Security Violation: User:'DBA.ADMIN' has insufficient permis

        Manohar,

        Take a look at the forum post below. I've seen some very strange OTM UI issues that were resolved by following the steps listed. Also, if you have a chance to list the steps you took to reset the VPD objects in the OTM database, I'm sure it would benefit other forum users at some point.

        This website is for sale! otmfaq.com is your first and best source for all of the information you’re looking for. From general topics to more of what you would expect to find here, otmfaq.com has it all. We hope you find what you are searching for!


        Hope this helps!

        --Chris
        Chris Plough
        twitter.com/chrisplough
        MavenWire

        Comment


        • #5
          Re: Installation Error: Security Violation: User:'DBA.ADMIN' has insufficient permis

          HI Chris,

          Thanks for the update.

          I subsequently solved that error yesterday. Its the same issue related with Work directory under tomcat. Thw work directory whichj we had didn't have read/write access and that was the reason of the UI issues.

          I gave the read write access and everything is working fine now. The JSP compile and other errors also got solved.

          Now i am working on configuring my report server, i configured everything but it still giving that IO exception error. Please let ne know if you have any tips to solve this.

          you are the best!

          Regards,
          Manohar

          Comment

          Working...
          X
          😀
          🥰
          🤢
          😎
          😡
          👍
          👎