3 Replies Latest reply on Mar 14, 2013 3:45 PM by 995865

    DB setup in OTM

    925395
      Hi,
      We've installed OTM in a server but we are not using default XE DB. We've configured OTM to connect to the DB thru DB conf wizard that comes with OTM.

      Though we are able to login and check details of projects in the DB, problem comes when running the scripts. When we go to Tools- > systems, it's showing error: Exception Occurred !

      An Unknown Exception Occurred !

      Fortunately, our OTM server and scripts are in the same location. So if we point to the repository, the link is happening. But while running the scripts through otm, (test execution->execute test set), it's not showing anything in the pop up.
      Does anyone have any idea why this error is occurring?

      Following is the error in wls_orats.log file when I click on execute test set:
      2013-02-14 00:27:30,969 ERROR [OracleActionBase] error while populating workstations th.message=EJB Exception: : Local Exception Stack:
      Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T1"."OS_TYPE": invalid identifier

      Error Code: 904
      Call: SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))
           bind => [eMEWorkstation, 1]
      Query: ReadAllQuery(name="WorkstationDb.queryWorkstationsByType" referenceClass=WorkstationDb sql="SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))")
           at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:683)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
           at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:263)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:644)
           at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2537)
           at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2496)
           at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:407)
           at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1076)
           at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:740)
           at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1036)
           at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:380)
           at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1122)
           at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2910)
           at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
           at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
           at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1247)
           at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:479)
           at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:714)
           at oracle.oats.configuration.ConfigurationManagerBean.queryWorkstations(ConfigurationManagerBean.java:442)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
           at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
           at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
           at $Proxy111.queryWorkstations(Unknown Source)
           at oracle.oats.configuration.ConfigurationManagerBean_9wsou3_ConfigurationManagerLocalImpl.__WL_invoke(Unknown Source)
           at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
           at oracle.oats.configuration.ConfigurationManagerBean_9wsou3_ConfigurationManagerLocalImpl.queryWorkstations(Unknown Source)
           at oracle.oats.otm.web.TestResultStepsAction.showProductVersion(TestResultStepsAction.java:201)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.oats.otm.web.OracleActionBase.execute(OracleActionBase.java:140)
           at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
           at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
           at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
           at oracle.oats.otm.web.ActionServlet.process(ActionServlet.java:120)
           at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:122)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
           at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:523)
           at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)
           at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
           at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
           at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
           at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
           at oracle.oats.otm.web.ActionServlet.process(ActionServlet.java:120)
           at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:122)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.oats.otm.reports.utils.GZIPFilter.doFilter(GZIPFilter.java:64)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.oats.otm.util.BusinessSessionFilter.doFilter(BusinessSessionFilter.java:139)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.oats.otm.reports.utils.AlwaysRevalidateCacheFilter.doFilter(AlwaysRevalidateCacheFilter.java:67)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.oats.otm.util.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:49)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "T1"."OS_TYPE": invalid identifier

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
           at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:862)
           at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
           at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:888)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:598)
           ... 98 more
      ; nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T1"."OS_TYPE": invalid identifier

      Error Code: 904
      Call: SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))
           bind => [eMEWorkstation, 1]
      Query: ReadAllQuery(name="WorkstationDb.queryWorkstationsByType" referenceClass=WorkstationDb sql="SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))")
      javax.ejb.EJBException: EJB Exception: : Local Exception Stack:
      Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T1"."OS_TYPE": invalid identifier

      Error Code: 904
      Call: SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))
           bind => [eMEWorkstation, 1]
      Query: ReadAllQuery(name="WorkstationDb.queryWorkstationsByType" referenceClass=WorkstationDb sql="SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))")
           at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:683)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
           at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:263)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:644)
           at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2537)
           at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2496)
           at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:407)
           at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1076)
           at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:740)
           at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1036)
           at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:380)
           at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1122)
           at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2910)
           at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
           at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
           at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1247)
           at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:479)
           at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:714)
           at oracle.oats.configuration.ConfigurationManagerBean.queryWorkstations(ConfigurationManagerBean.java:442)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
           at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
           at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
           at $Proxy111.queryWorkstations(Unknown Source)
           at oracle.oats.configuration.ConfigurationManagerBean_9wsou3_ConfigurationManagerLocalImpl.__WL_invoke(Unknown Source)
           at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
           at oracle.oats.configuration.ConfigurationManagerBean_9wsou3_ConfigurationManagerLocalImpl.queryWorkstations(Unknown Source)
           at oracle.oats.otm.web.TestResultStepsAction.showProductVersion(TestResultStepsAction.java:201)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.oats.otm.web.OracleActionBase.execute(OracleActionBase.java:140)
           at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
           at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
           at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
           at oracle.oats.otm.web.ActionServlet.process(ActionServlet.java:120)
           at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:122)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
           at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:523)
           at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)
           at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
           at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
           at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
           at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
           at oracle.oats.otm.web.ActionServlet.process(ActionServlet.java:120)
           at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:122)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.oats.otm.reports.utils.GZIPFilter.doFilter(GZIPFilter.java:64)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.oats.otm.util.BusinessSessionFilter.doFilter(BusinessSessionFilter.java:139)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.oats.otm.reports.utils.AlwaysRevalidateCacheFilter.doFilter(AlwaysRevalidateCacheFilter.java:67)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.oats.otm.util.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:49)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "T1"."OS_TYPE": invalid identifier

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
           at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:862)
           at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
           at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:888)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:598)
           ... 98 more
      ; nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T1"."OS_TYPE": invalid identifier

      Error Code: 904
      Call: SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))
           bind => [eMEWorkstation, 1]
      Query: ReadAllQuery(name="WorkstationDb.queryWorkstationsByType" referenceClass=WorkstationDb sql="SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))")
      Local Exception Stack:
      Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T1"."OS_TYPE": invalid identifier

      Error Code: 904
      Call: SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))
           bind => [eMEWorkstation, 1]
      Query: ReadAllQuery(name="WorkstationDb.queryWorkstationsByType" referenceClass=WorkstationDb sql="SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))")
           at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:683)
           at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
           at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:263)
           at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:644)
           at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2537)
           at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2496)
           at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:407)
           at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1076)
           at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:740)
           at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1036)
           at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:380)
           at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1122)
           at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2910)
           at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
           at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
           at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1247)
           at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:479)
           at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:71