01-04-2017 04:32 PM
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.
I tried the app from sourceforge but it would give me errors.
01-09-2017 04:43 AM
nice question. And I understand the confussion. Let me see if I can help a bit.
I am going to understand pre-requisites for CPM and Oracle are set properly and in the correct order, as mentioned in the SAS documentation. If not, I would really start from there. Success on any SAS installation depends 50% if pre-requisites are properly in place before the SAS installation starts. The other 50% is about the proper configuration and to understand the architecture.
That being said:
What I would ask you to provide us, and let's see if we can help you: