Hi,
During the installation of middle tier server, I ran into an issue with configuring SAS Web Application Server Configuration.
Error Message:
Application Server has started, however web applications with the following contexts failed to start. Please refer to
Application Server logs for more details.
SASLogon
SASWIPServices
SASStoredProcess
SASWIPClientAccess
SASContentServer
SASAuthorizationServices
SASWorkflowWebServices
SASSharedApps
SASBIWS
SASTemplateEditor
SASIdentityServices
SASAdmin
SASWorkflowServices
SASWIPSoapServices
SASPermissionManager
SASThemeDesignerForFlex
SASDeploymentBackup
SASBackupManager
SASPrincipalServices
SASPreferences
SASPackageViewer
SASPortal
SASBIDashboard
SASBIDashboardEventGen
SASJSR168RemotePortlet
SASBIPortlets
Configuration script:
/opt/sas/sashome/SASDeploymentManager/9.4/products/cfgwizard__94494__prt__xx__sp0__1/Utilities/AppServer/Source/Ant/appserver_config
.xml For more information, see the log file located at /opt/sas/config/Lev1/Logs/Configure/vfabrictcsvr_startMidtierServers_2018-03-12-21.22.53.log
The logs did mention to refer Application Server Logs but not sure which AS logs I'm supposed to check. However, I did come across logs from SASconfig/Lev1/WebInfrastructurePlatformDataServer/Logs/ on AS and figured that it says that "vdbadm" database does not exists. I just verified that this database does not exist.
But when I check the server.xml file for WebAppServer12_1, it is referring to VDBService database while using the user vdbadm. If vdbadm is supposed to be an user, why are the logs telling me that vdbadm as database?
<Resource auth="Container" driverClassName="org.postgresql.Driver" factory="com.sas.vfabrictcsvr.atomikos.BeanFactory" maxPoolSize="100" minPoolSize="10" name="sas/jdbc/VDBService" password="${pw.sas.jdbc.VDBService}" testQuery="select 1" type="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean" uniqueResourceName="sas/jdbc/VDBService" url="jdbc:postgresql://sas-compute-pr1.scholastic.net:9432/VDBService" user="vdbadm"/>
Looking forward to the solution
Thanks,
Vivek