Hi All,
I am trying to configure SAS Mid but I am getting below ERROR. It is a fresh install.
Step 12 of 28 for Stage 3 of 13: Configuring SAS Job Monitor Mid-Tier
Property "_act.name" has not been set Property "instructions.contents.warnings" has not been set Property "instructions.contents.warnings" has not been set [replace] Replacing in /opt/sasconfig/config/Lev1/Documents/Instructions.html: ${instructions.contents.warnings} --> <li><a href="#warnings">Warnings and Notices</a></li> Property "instructions.notices.head" has not been set Property "instructions.notices.head" has not been set [replace] Replacing in /opt/sasconfig/Lev1/Documents/Instructions.html: ${instructions.notices.head} --> <h2 id="warnings">Warnings and Notices</h2> [replace] <p>Review the Hot Fix Instructions document at <a href="/opt/sashome/InstallMisc/HotFixes/Documents/HotFixInstructions.html">/opt/sashome/InstallMisc/HotFixes/Documents/HotFixInstructions.html</a> for manual steps required to complete your deployment.</P> [replace] <p>The following issues occurred during the automated portion of your configuration and must be addressed before proceeding.</p><ul> Property "instructions.notices.tail" has not been set Property "instructions.notices.tail" has not been set
[replace] Replacing in /opt/sasconfig/Lev1/Documents/Instructions.html: ${instructions.notices.tail} --> </ul> Property "warning_jobmntrsvc_database_already_exists.txt" has not been set Property "instructions.notices.item" has not been set Property "warning_jobmntrsvc_database_already_exists.txt" has not been set Property "instructions.notices.item" has not been set Property "warning_jobmntrsvc_database_already_exists.txt" has not been set Property "instructions.notices.item" has not been set Property "instructions.notices.item" has not been set [replace] Replacing in /opt/sasconfig/Lev1/Documents/Instructions.html: ${instructions.notices.item} --> ${warning_jobmntrsvc_database_already_exists.txt}<BR>${instructions.notices.item} [available] Unable to find Applications/SASJobMonitor/JobMonitorServices/schemacreated.txt [propertyfile] Updating property file: /opt/sasconfig/Lev1/Logs/Configure/jobmntrsvc_config_status.properties [propertyfile] Updating property file: /opt/sasconfig/Lev1/Logs/Configure/jobmntrsvc_config_status.properties [sql] connecting to jdbc:postgresql://sas-grid.com:9452/JobMonitorDataServer [sql] Loading org.postgresql.Driver using a cached AntClassLoader. [sql] Executing resource: /opt/sashome/SASJobMonitorMidTierServices/2.2/Config/jobmntrdsvrc_postgres_ddl.sql [sql] SQL: create table SAS_JM_JOBS ( JOB_ID serial, JOB_NAME varchar(64) not null, JOB_PATH varchar(256) not null, JOB_TYPE varchar(32) not null, PLATFORM varchar(256) not null, LATEST_DEPLOYED_DATE timestamp not null, LATEST_DEPLOYED_VERSION integer not null, HQ_SERVICE_ID varchar(16), constraint JOB_PRIMARY_KEY primary key (JOB_ID) ) [sql] Failed to execute: create table SAS_JM_JOBS ( JOB_ID serial, JOB_NAME varchar(64) not null, JOB_PATH varchar(256) not null, JOB_TYPE varchar(32) not null, PLATFORM varchar(256) not null, LATEST_DEPLOYED_DATE timestamp not null, LATEST_DEPLOYED_VERSION integer not null, HQ_SERVICE_ID varchar(16), constraint JOB_PRIMARY_KEY primary key (JOB_ID) )
BUILD FAILED /opt/sashome/SASJobMonitorMidTierServices/2.2/Config/jobmntrsvc_config.xml:80: The following error occurred while executing this line: /opt/sashome/SASDeploymentManager/9.4/products/cfgwizard__94588__prt__xx__sp0__1/Utilities/contrib/templates/2.0/webapp_configuration_templates.xml:617: The following error occurred while executing this line: /opt/sashome/SASJobMonitorMidTierServices/2.2/Config/jobmntrsvc_config.xml:781: org.postgresql.util.PSQLException: ERROR: relation "sas_jm_jobs" already exists at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:541) at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:394) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329) at org.apache.tools.ant.Project.executeTarget(Project.java:1298) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1181) at org.apache.tools.ant.Main.runBuild(Main.java:698) at org.apache.tools.ant.Main.startAnt(Main.java:199) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) Caused by: /opt/sashome/SASDeploymentManager/9.4/products/cfgwizard__94588__prt__xx__sp0__1/Utilities/contrib/templates/2.0/webapp_configuration_templates.xml:617: The following error occurred while executing this line: /opt/sashome/SASJobMonitorMidTierServices/2.2/Config/jobmntrsvc_config.xml:781: org.postgresql.util.PSQLException: ERROR: relation "sas_jm_jobs" already exists :
... View more