SortWork

[Eric Mintz]

From the team:

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.

When a user with incompatible access attempts to use the file (that is already open)  they will get  the message…  “insufficient privilege or file protection violation”

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)

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 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)

Thanks,
Eric


From: powerh-l <powerh-l-bounces at lists.sowder.com> On Behalf Of tadjodha at stlucianic.org
Sent: July 25, 2018 5:55 PM
To: powerh-l at lists.sowder.com
Subject: Re: SortWork




    Hi,
            Thanks for the response.

          1)The SortWork file is created automatically by the system and is also deleted automatically after usage by the system.

            This issue usually happens when more than one person runs a program. How do you point the Sortwork.tmp, also
             would creating other sortwork files help and how.

            Thanks in advance.



Terry
________________________________
step 3.: "Eric Mintz" <Eric.Mintz at freschesolutions.com<mailto:Eric.Mintz at freschesolutions.com>>
To: tadjodha at stlucianic.org<mailto:tadjodha at stlucianic.org>, powerh-l at lists.sowder.com<mailto:powerh-l at lists.sowder.com>
Sent: Wednesday, 25 July, 2018 4:58:42 PM
Subject: RE: SortWork
Hi Terry,

I’ve checked with our services team and have the following response:

The sortwork file changes privileges… There are 2 options…
1)Delete the sortwork regularly or change the permissions regularly…
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…
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…

Let us know if this works.
Thanks,
Eric Mintz
Fresche Solutions
www.freschesolutions.com<http://www.freschesolutions.com>


From: powerh-l <powerh-l-bounces at lists.sowder.com<mailto:powerh-l-bounces at lists.sowder.com>> On Behalf Of tadjodha at stlucianic.org<mailto:tadjodha at stlucianic.org>
Sent: July 25, 2018 3:47 PM
To: powerh-l at lists.sowder.com<mailto:powerh-l at lists.sowder.com>
Subject: SortWork


  OpenVMS (TM) Alpha Operating System, Version V8.3
   PowerHouse 8.40g


Hi

      The SORTWORK0.tmp and SORTWORK1.tmp files are created by the system by default.
      At certain times coworkers get a sortwork error  ;

 %SORT-E-OPENOUT error opening DATA_RAID:[NIS.SCL.840]<SORTWORK files 0 + 1>     insufficient privilege or file protection violation
 %SORT-I-USE-ALT   using alternate work file  SORTWORK.tmp

   The program is then cut off. When I reset the security on the SORTWORK files everything goes back to normal.

   How can I rectify this situation permanently. Thanks in advance.



Regards


Terry

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DISCLAIMER: 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).



-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DISCLAIMER: 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).

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20180725/10e2ab4e/attachment.html>