topic Re: SAS Metadata Services SAS 9.4 in Administration and Deployment

SAS Metadata Services SAS 9.4

woo — Thu, 22 Jun 2017 20:12:46 GMT

I am not able to restarting sas services,

./sas.servers start

Starting SAS servers
SAS Web Infrastructure Data Server is already UP
SAS Advanced Analytics Common Data Server is already UP
Starting SAS Decision Manager Common Data Server
Starting SAS Data Remediation Data Server
Starting SAS Job Monitor Data Server
SAS Metadata Server 1 is NOT up
The remaining SAS servers will NOT be started as a result.

more detail error saying -> error occured while attempting to initialize journal file journal/date_time_journal.dat.

Also, tried to start metadata server only but it fails as well

./MetadataServer.sh start

Waiting up to 600 seconds for Metadata Server to listen to port XXXXX.

Server is started (pid #...)

Server is stopped

Log files are located at: .../MetadataServer/Logs

Metadata server failed to start, check the log for errors.

Log files are located at: .../MetadataServer/Logs

Re: SAS Metadata Services SAS 9.4

dpage — Thu, 22 Jun 2017 20:55:05 GMT

Anything incriminating in the Metadata Server logs? I'd be suspect of an expired license.

Re: SAS Metadata Services SAS 9.4

woo — Fri, 23 Jun 2017 14:36:15 GMT

metadata server log says,

ERROR: Resource is write-locked by another user. File =Journal/date_time_Journal.dat. System Error Code = 0.
ERROR: The file is already locked by another user.
ERROR: Resource is write-locked by another user. File =Journal/date_time_Journal.dat. System Error Code = 0.
ERROR: The file is already locked by another user.
ERROR: The server will not be able to initialize until the above error(s) are corrected. Locate details in the server log by searching for 'ALERT EMAIL' for each of the problems noted above.
ERROR: The SAS Metadata Supervisor failed to initialize properly because of the errors noted above. Contact Technical Support for assistance if these messages do not indicate a solution to the problem.
ERROR: The SAS Metadata Supervisor failed to load due to the errors noted above. Contact Technical Support for assistance if these messages do not indicate a solution to the problem.
ERROR: CLASSFACTORY cannot be instantiated.

Re: SAS Metadata Services SAS 9.4

alexal — Fri, 23 Jun 2017 16:19:28 GMT

@woo,

Find out who is holding this file and kill that process:

lsof /<SASConfig>/Lev<X>/SASMeta/MetadataServer/Journal/date_time_Journal.dat
kill -9 <PID>

Re: SAS Metadata Services SAS 9.4

Kurt_Bremser — Mon, 26 Jun 2017 06:14:42 GMT

@woo wrote:
metadata server log says,

ERROR: Resource is write-locked by another user. File =Journal/date_time_Journal.dat. System Error Code = 0.
ERROR: The file is already locked by another user.
ERROR: Resource is write-locked by another user. File =Journal/date_time_Journal.dat. System Error Code = 0.
ERROR: The file is already locked by another user.
ERROR: The server will not be able to initialize until the above error(s) are corrected. Locate details in the server log by searching for 'ALERT EMAIL' for each of the problems noted above.
ERROR: The SAS Metadata Supervisor failed to initialize properly because of the errors noted above. Contact Technical Support for assistance if these messages do not indicate a solution to the problem.
ERROR: The SAS Metadata Supervisor failed to load due to the errors noted above. Contact Technical Support for assistance if these messages do not indicate a solution to the problem.
ERROR: CLASSFACTORY cannot be instantiated.

You could have a hanging instance of the Metadata server running that does not work anymore, but has the file(s) locked. Which means you have to find the offending process from the process list and kill it.

In addition to the lsof suggested by @alexal, use

ps -ef|less

to display all running processes on a UNIX system. This might give you a bigger picture of what's going on.

Re: SAS Metadata Services SAS 9.4

anja — Mon, 26 Jun 2017 13:34:25 GMT

Hi,

are you attempting to restart the services/SAS servers just as maintenance task, or, are there any

processes that ran beforehand, which caused the metadata server to stop?

I am asking because there are certain tasks that could place locks on a journal file, such as a backup.

If you'd provide the entire metadata server log (attach the file), we could maybe find some other

indications that would explain the error.

Also, as as Kurt suggested, do a ps, but add "Foundation" please:

ps -ef | grep SASFoundation

The error has been seen in some cases when the environment is running on a

EMC OneFS (I don't know what you are running on, so I am really just throwing out

things/ideas here.) The problems were related to locks caused by an

autoexec file/config files that were not stored locally.

You could take a look at filelocks:

http://support.sas.com/documentation/cdl/en/hostunx/69602/PDF/default/hostunx.pdf

Page 41. Take a look at the settings for that option.

Thanks

Anja

Re: SAS Metadata Services SAS 9.4

Jwcris — Tue, 15 May 2018 18:14:27 GMT

@woo - Did you ever resolve this issue?

Re: SAS Metadata Services SAS 9.4

Stephane — Mon, 28 Jan 2019 10:09:01 GMT

To archive a solution :

ssh sasmeta-machine
sudo bash
lsof /sasconfig/meta/Lev1/SASMeta/MetadataServer/Journal/<datetime>_Journal.dat
kill -9 <PID> found

ssh sasmeta-machine
cd /sasconfig/meta/Lev1/SASMeta/
tar -cvf <datetime>MetadataServer.tar /sasconfig/meta/Lev1/SASMeta/MetadataServer
cd /sasconfig/meta/Lev1/SASMeta/MetadataServer
./MetadataServer.sh -recover
./MetadataServer.sh -status
-> started

Re: SAS Metadata Services SAS 9.4

PWC2018_1 — Mon, 17 Feb 2020 14:53:56 GMT

I got this message when I try to start all SAS services but when I forgot to do: "Update SID File in Metadata" with the SAS Deployment Manager when I install the new licence.

Claude