hello,
We recently configured SAS CPM 8.1 in our production environment and we are not able to make it work properly. We also opened a SAS track # 7611982049 for this issue. At a very basic level, I am not able to verify if SAS CPM 8.1 is able to use the JDBC connection to the oracle database we use for maintaining the models.
When I sent the logs under middletier config\lev1\web\webappserver\SASServer9_1, SAS support pointed out the following error -
2017-01-03 15:50:46,498 ERROR (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASCostAndProfitabilityManagementSurveys]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'beanQueryExecutor' defined in class path resource [com/sas/solutions/abm/surveytool/integration/db/spring-config/DataAccess-AST-Config.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'dataSource' threw exception; nested exception is com.sas.solutions.abm.server.common.exceptions.QgDalException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
My oracle dba can check the JDBC connection using oracle weblogic but SAS CPM 8.1/SAS 9.4 do not use weblogic any longer. I believe they use their own propreitary web server. How do I check if
1. JDBC connection on the middle-tier server is working correctly and
2. SAS CPM 8.1 is able to use the JDBC connection to send data to oracle.
I looked up these links but I am not a very technical person.
http://www.orafaq.com/wiki/JDBC
https://docs.oracle.com/cd/F49540_01/DOC/java.815/a64685/getsta3.htm
http://jdbctester.sourceforge.net/
I tried the app from sourceforge but it would give me errors.
Thanks,
saspert
Thanks,
saspert