HTTP Status 500 - Reporting and Analytics (Fresh Install w Simphony 2.8)

[etokatli]

Hi all,
Does anyone have experience with this subject?
When the fresh install Simphony 2.8 Oracle 11g on Windows 2008 R2 after finish install, open internet explorer and http:\\localhost (or http:\\servername) it's showing HTTP Status 500 and exception area is showing below message

After installation, I'm trying the manuel upgrade with DbInstall.exe, I'm writing the connection string and other information and click to install, upgrade is starting after a while showing error message ; ORA-00942: table or view does not exist - See log for full details
I looked the log files but i cant find to detail which table or view does not exist. You can find to log files attachment.


exception
org.apache.jasper.JasperException: javax.servlet.ServletException: com.micros.common.data.PersistenceException: java.sql.SQLException: ORA-00942: table or view does not exist

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:515)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:322)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:249)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.micros.portal.servletFilter.PentahoSSOFilter.doFilter(PentahoSSOFilter.java:42)
com.micros.portal.servletFilter.BaseFilter.doFilter(BaseFilter.java:77)
com.micros.portal.servletFilter.BaseFilter.doFilter(BaseFilter.java:82)
com.micros.portal.servletFilter.BaseFilter.doFilter(BaseFilter.java:82)
com.micros.portal.servletFilter.BaseFilter.doFilter(BaseFilter.java:82)
com.micros.portal.servletFilter.BaseFilter.doFilter(BaseFilter.java:77)
com.micros.portal.servletFilter.BaseFilter.doFilter(BaseFilter.java:77)
com.micros.portal.servletFilter.BaseFilter.doFilter(BaseFilter.java:77)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

 

[hosehead78]

I've got a fresh install of v2.8.2, but haven't gotten that far yet. I can get to the login page, but haven't tried to log in.

Have a look here for the Java issues you are having. Looks like it

http://stackoverflow.com/questions/...able-or-view-does-not-exist-when-inserting-in

I'll login to mine and let you know if I have any issues.

 

[etokatli]

Thank you for your response @hosehead78

I think it's Oracle user's permission problem. When the user haven't got a grant connect another to user, same error message is showing. But i checked to all reporting dabatase user but i can't find anymore. I tried several times to install, when i installed on Windwos 2008 R2 it's working fine. If I installed to Windows 2012 R2, it's showing same error. If I find to more detail or solution, I will let you know.

Thank you.

 

[hosehead78]

Did you check to see if any of the SQL Logins are disabled?

How was Java installed? Admin or user?
Did the user that installed it have admin rights?

Also, its a long shot, but check the Security Tab with-in the Java Configuration (Programs > Java > Configuration Java, it's the Java Control Panel) for Exception Site List. Add your location to this when trying to connect. By location, I mean

http://MicrosServerName.