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-W1GZM/[email protected]
>> To: system21-Zwy7GipZuJhWk0Htik3J/[email protected]
>> 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-Zwy7GipZuJhWk0Htik3J/[email protected]
>> [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Suzanne Selvey
>> Sent: Wednesday, January 19, 2011 11:35 AM
>> To: system21-Zwy7GipZuJhWk0Htik3J/[email protected]
>> 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change 
>> list
>> options,
>> visit: http://lists.midrange.com/mailman/listinfo/system21
>> or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
>> 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-Zwy7GipZuJhWk0Htik3J/[email protected]
>> To subscribe, unsubscribe, or change list options,
>> visit: http://lists.midrange.com/mailman/listinfo/system21
>> or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
>> 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-Zwy7GipZuJhWk0Htik3J/[email protected]
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/system21
> or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
> 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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.