OTM Access Excpetions

bscyadav · #1 (**permalink**) December 14th, 2009, 14:42

Hi,
How do I resolve the below exceptions
1. Generic_Remote_Exception
oracle.oc4j.rmi.OracleRemoteException: system is not allowed to call this EJB method, check your security settings (method-permission in ejb-jar.xml and security-role-mapping in orion-application.xml).
2. java.lang.reflect.InvocationTargetException
Caused by: java.sql.SQLException: ORA-00904: "U"."BI_ROLE_GID": invalid identifier

Log files attached.

Regards,
Yadav

josephliang · #2 (**permalink**) December 15th, 2009, 02:44

Your issue is identical to http://www.otmfaq.com/forums/f23/sol...2589/#post8245 ([SOLVED] otmapp55 not starting)

bscyadav · #3 (**permalink**) January 10th, 2010, 11:13

Hi,
Resolved the issue and system working fine.
It looks like while installing the OTM most of the scripts need to be debugged as they don't run as intended.
or is it only I had problem!!

After 3 months of long learning of SQL and Sys admin I was able to install the OTM by self.
Atleast the hard way out

Thanks to this site otherwise i could lost my world!!!