<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-CA" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">From the team:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Think about it this way there is one file descriptor but there are multiple files (one for each user) the file descriptor has the owner and permissions.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">When a user with incompatible access attempts to use the file (that is already open) they will get the message… “</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">insufficient
privilege or file protection violation”<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I suspect your sortwork is being created in a way that some users can’t access it (default permissions, perhaps).. And the last one in can’t delete it which then causes issues for the next users.
What are the permissions/owner when you “reset them”.. (I suspect it’s likely a job doing this)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">As for the sortwork.tmp.. That is a bigger question I believe it’s in the manuals.. But I don’t have access to them they should be on the CD you should be able to search for SORTWORK.tmp or
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">SORT-I-USE-ALT.. it’s probably in the defines when you start powerhouse (it probably defaults to SYSROOT which not everyone can access/control)</span><span style="mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Eric<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> powerh-l <powerh-l-bounces@lists.sowder.com>
<b>On Behalf Of </b>tadjodha@stlucianic.org<br>
<b>Sent:</b> July 25, 2018 5:55 PM<br>
<b>To:</b> powerh-l@lists.sowder.com<br>
<b>Subject:</b> Re: SortWork<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><br>
<br>
<br>
Hi,<br>
Thanks for the response.<br>
<br>
1)The SortWork file is created automatically by the system and is also deleted automatically after usage by the system.<br>
<br>
This issue usually happens when more than one person runs a program. How do you point the Sortwork.tmp, also<br>
would creating other sortwork files help and how.<br>
<br>
Thanks in advance.<br>
<br>
<br>
<br>
Terry<o:p></o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">
<hr size="2" width="100%" align="center" id="zwchr">
</span></div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:black">step 3.:
</span></b><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:black">"Eric Mintz" <<a href="mailto:Eric.Mintz@freschesolutions.com">Eric.Mintz@freschesolutions.com</a>><br>
<b>To: </b><a href="mailto:tadjodha@stlucianic.org">tadjodha@stlucianic.org</a>, <a href="mailto:powerh-l@lists.sowder.com">
powerh-l@lists.sowder.com</a><br>
<b>Sent: </b>Wednesday, 25 July, 2018 4:58:42 PM<br>
<b>Subject: </b>RE: SortWork<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Hi Terry,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">I’ve checked with our services team and have the following response:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">The sortwork file changes privileges… There are 2 options…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">1)Delete the sortwork regularly or change the permissions regularly…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2) Find out what’s changing the permissions they likely have a job that’s coming in with different permissions and maybe it can’t delete the file so it leaves it around and the regular users can’t use the file
as it’s owned differently… <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">The reason they can’t use the sortwork.tmp is configuration they need to point it to a location that the users can access. Right now it’s likely pointed to $SYS and they can’t write to it.. so the program has
no choice but to abort as they can’t sort…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Let us know if this works.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Eric Mintz<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Fresche Solutions<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><a href="http://www.freschesolutions.com" target="_blank">www.freschesolutions.com</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:-moz-use-text-color -moz-use-text-color">
<p class="MsoNormal"><b><span lang="EN-US" style="color:black">From:</span></b><span lang="EN-US" style="color:black"> powerh-l <<a href="mailto:powerh-l-bounces@lists.sowder.com">powerh-l-bounces@lists.sowder.com</a>>
<b>On Behalf Of </b><a href="mailto:tadjodha@stlucianic.org">tadjodha@stlucianic.org</a><br>
<b>Sent:</b> July 25, 2018 3:47 PM<br>
<b>To:</b> <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
<b>Subject:</b> SortWork</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><br>
OpenVMS (TM) Alpha Operating System, Version V8.3<br>
PowerHouse 8.40g<br>
<br>
<br>
Hi<br>
<br>
The SORTWORK0.tmp and SORTWORK1.tmp files are created by the system by default.
<br>
At certain times coworkers get a sortwork error ;<br>
<br>
%SORT-E-OPENOUT error opening DATA_RAID:[NIS.SCL.840]<SORTWORK files 0 + 1> insufficient privilege or file protection violation
<br>
%SORT-I-USE-ALT using alternate work file SORTWORK.tmp<br>
<br>
The program is then cut off. When I reset the security on the SORTWORK files everything goes back to normal.<br>
<br>
How can I rectify this situation permanently. Thanks in advance.<br>
<br>
<br>
<br>
Regards<br>
<br>
<br>
Terry</span><span style="color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
</span><strong><span style="font-family:"Calibri",sans-serif;color:red">DISCLAIMER:</span></strong><span style="color:black"> This transmission (including any attachments) may contain confidential information, privileged material (including material protected
by the solicitor-client or other applicable privileges), or constitute non-public information.Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to
the sender and delete this information from your system.Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. (Please note that it is your responsibility to scan this message
for ! viruses). <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
<strong><span style="font-family:"Calibri",sans-serif;color:red">DISCLAIMER:</span></strong> This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other
applicable privileges), or constitute non-public information.Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information
from your system.Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. (Please note that it is your responsibility to scan this message for ! viruses).
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>