SAS Mid config install ERROR

sathya66 — Wed, 12 Oct 2022 13:26:15 GMT

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
:

Re: SAS Mid config install ERROR

Sajid01 — Fri, 14 Oct 2022 01:00:40 GMT

I suggest that a ticket be created with SAS Tech Support.

Re: SAS Mid config install ERROR

sathya66 — Fri, 14 Oct 2022 10:25:12 GMT

I have restored all configs and binaries of succefull build,reconfigured and it worked.

topic Re: SAS Mid config install ERROR in Administration and Deployment

SAS Mid config install ERROR

Re: SAS Mid config install ERROR

Re: SAS Mid config install ERROR