× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. SYSTEM21
  3. January 2011

Re: Aurora - Advanced Orders - Record Locks

Suzanne -

What version of Aurora are you trying to use?

Are any of the programs in the AO process modified, or are any of your AO programs calling custom programs? If so, make sure they are also compiled using the activation group AULSTD. And if do you have a modified AO program or custom program that is SQLRPGLE, check that you compile it with COMMIT(*NONE). I've seen weird things happen if you don't turn commitment control off.

If you have no modifications, then I would ask your Infor project manager (if you are using one) or Infor support to help you.

Let us know what you find.

Randy Rasp
AER Manufacturing





On Wed, Jan 19, 2011 at 12:30 PM, Suzanne Selvey wrote:

Thanks Barbara.
Unfortunately, all of the files are open with file locks.
COYPOF
INP57L04
ACSUMMAR
OEP56L01
INP40L01
OEP55A
OEP40A
ORDLNORD
ORDHDORD
PARTS
CUSNAMES
STKBAL -> Several More, Too Many to List
All of them. Including AO002FT, AO011FT, AO023FT.
It is like the *INLR is never being turned on in AO002, AO011 and AO023.
This is after you get back to the intial order screen and hitting an F3 to get completely out.
In JBA, I see the files open and all of them are closed on the F3.


Date: Wed, 19 Jan 2011 13:18:37 -0500
From: bbyrne@xxxxxxxxxxx
To: system21@xxxxxxxxxxxx
Subject: Re: [SYSTEM21] Aurora - Advanced Orders - Record Locks

we went on Aurora Aug 2009 and did have a locking problem.
A change was made to AO005
2 lines added
Else UnLock OEPWBL00

right after line
Update OERWB

______________________


Thanks

Barbara Byrne

IT Manager
Greatex Mills Inc.

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Suzanne Selvey
Sent: Wednesday, January 19, 2011 11:35 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Aurora - Advanced Orders - Record Locks


We are currently in the middle of upgrading to Aurora. Infor has said that they are not familiar with this issue and have been
unable to provide immediate assistance.
Has anyone else run into this issue with Advanced Order Entry/Amend?
The Aurora code has been converted to RPGLE and now runs under the
AULSTD activation group.
The initial driver program AO001CLP overrides the commonly used
databases and leaves the data paths open to improve file processing
between the multiple AO programs. For example: OVRDBF FILE(PARTS) SECURE(*YES) OVRSCOPE(*CALLLVL) SHARE(*YES) OPNDBF FILE(PARTS) OPTION(*ALL)
The *INLR is still parameterized in the AO RPGLE programs, as it was in
JBA. I did see a specific line of code to turn on *INLR only in AO001.
The problem is....
When completing the Order normally, either through Entry or Amend the
files are left open and records are locked.
I have put several programs through debug and saw AO001CLP close each
file and run the Reclaim Resource Command.
But the files are actually still open and locking records, so that Order
Allocation, etc. blow up on record locks. We can't have the users sign off and back on every time they put in an
order.
The system programs XA000CL, etc. programs are running in AULAM
activation group. It appears that all of the AO programs are running in the AULSTD
activation group. I noticed that some of the service programs/modules???? are running in
*DFTACTGRP. Could this be causing the problem?
AO005 QUAMODSP4 AULSTD QRNXIO QSYS AULSTD QWSGET QSYS *DFTACTGRP QT3REQIO QSYS *DFTACTGRP

I am not sure if it is an issue with the *INLR parameters or an issue
related to using activation groups.
I tried using the Reclaim Activation Group command in AO001CLP, but it
just dumped all over the place.
Has anyone else run into this is with Aurora? How do the *INLR parameters get turned on in AO005, AO009, AO013, etc?
Any suggestions???
Thanks, Suzanne Selvey _______________________________________________
This is the System 21 Users (SYSTEM21) mailing list To post a message
email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/system21.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.