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

[chrisplough]

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.

java.rmi.AccessException: [EJB:010160]Security Violation: User: 'DBA.ADMIN' has insufficient permission to access EJB

The stack trace is as below:

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

[chrisplough]

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

[Manohar]

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

[chrisplough]

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.

http://www.otmfaq.com/forums/f26/resolution-strange-ui-issues-v5-5-cu2-134/

Hope this helps!

--Chris

[Manohar]

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