When I logging to DIS suite using Administrator/Administrator, I got Java Null Pointer Error
Log files under Tomcat directory shows
java.sql.SQLException: Timeout of 30000ms encountered waiting for connection.
Pool
ERROR - Exception Occured in encryptEnvPasswords method
java.sql.SQLException: ORA-04063: view "ERWIN.ACTIVE_SYS_CON_ENVIRONMENTS" has errors
Solution:
ERWIN.ACTIVE_SYS_CON_ENVIRONMENTS is a view that is used in the BUP. the error shows the VIEW did not compile properly and so the BUP is throwing the error and not starting.
Please rerun the DDL and confirm if the view shows as compiled correctly, or please go into SQL Developer/TOAD and right click on this specific view and recompile the view so the error goes away.
Restart tomcat after the view is recompiled or DDL is re-run.
