CHAIN working for me BUT NOT working for a User

Hi All
My sincere apologies if posting this non-related JDE question. However I
believe most of you are RPG programmers and would help me.

I have code a in house program and it chain to a logical file to check if
a certain "key" exist. When I run the program it works fine, but when a
user runs it it does not work. That is the "key" does not exist but it
keeps on saying the key exist.

As any one who had similar experience and how they go about solving that
issue, would like to shed some light.




Cheers!
___________________
Marsh R Narewec
STC Computer Services

The situation you describe leads me to think that your user is chaining to a different file. Have you checked your library list against his?

We have the same Library List but different access levels.



Cheers!
___________________
Marsh R Narewec
STC Computer Services



dhashimura
<dhashimura@abinc
.com> To
Sent by: [email protected]
jdeworld-bounces@ cc
jdelist.com
Subject
Re: CHAIN working for me BUT NOT
06/06/06 13:09 working for a User


Please respond to
JD Edwards® World
<jdeworld@jdelist
.com>





The situation you describe leads me to think that your user is chaining to
a different file. Have you checked your library list against his?

Marsh,

Maybe this is a security issue, where user does not security to access the file? You may want to log on as the user and put the program in debug mode and see what values are in the fields for the key list at the point of the problem. Maybe for some reason they are not the expected values.

John Dickey
Accounting Systems Administrator
White-Rodgers, division of Emerson
8100 West Florissant Avenue
P.O. Box 36922
St. Louis, MO 63136-9022
314-553-3067

We had a similar experience and found the issue to be in the
user security setup. The user rightly could not look at the data and as
such got back an error indicating that there were no records to be
found. Have you looked into the branch plant security and other user
security. Maybe the issue is not the chain but the rights to see the
data.



THANKS,
Val Olds
Potlatch Forest Products Corporation
[email protected]
(208) 799-1059
(208) 799-1687 (FAX)

Thanks to your response. The user using a different program and a different
logical file over the same PF can update the PF. I have done the DSPFD over
both logical and they contain almost the same values except for one logical
file which has one extra key field. I have noticed I have created recently
the 'working' Logical File and deploy to the live environment. They both
have the same sets of first three keys but the "working one" has an extra
key.

This is what I plan to do today. Change the library list of the user to be
in the same sequence as mine. and test. If it doesn't work then I will have
to recompile both "not working" logical file and working logical file and
deploy to the live environment. I don't know what to do if this fails too ?





Cheers!
___________________
Marsh R Narewec
STC Computer Services



Val Olds
<val.olds@potlatc
hcorp.com> To
Sent by: [email protected]
jdeworld-bounces@ cc
jdelist.com
Subject
RE: CHAIN working for me BUT NOT
07/06/06 03:09 working for a User


Please respond to
JD Edwards® World
<jdeworld@jdelist
.com>





We had a similar experience and found the issue to be in the
user security setup. The user rightly could not look at the data and as
such got back an error indicating that there were no records to be
found. Have you looked into the branch plant security and other user
security. Maybe the issue is not the chain but the rights to see the
data.



THANKS,
Val Olds
Potlatch Forest Products Corporation
[email protected]
(208) 799-1059
(208) 799-1687 (FAX)

JDE World A7.3 cum 12

I've had this happen. You can check your code by using SETLL and READE to see if the key really does exist as you think it does. I also think that you have a lib list issue - the user isn't reading the same files you are when the program is running.

Thank you all for your response:

I follow Colin's advice below and it worked ok now:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Marsh,



I read your response but it is a “little light” on detail, to say the
least.  Based on what I understand of your note and attachment, here are my
comments as follows.





OK, so it seems that user authority to the file object is not an issue
contributing to your problem.



Seems you have two different LF’s - F56SSRLA and a newer one F56SSRLB.  I
have to assume that obviously the existing one in production (F56SSRLA)
probably needs to stay because I presume it is being used for something
(you need to find out what it is used by and for what reason)



Now you have to:-



a) resolve which logical is the correct one for the program to use (look at
the program source code etc)

b) make sure that the program definitely uses the correct logical

c) test everything yourself in a test environment and make sure it works

d) set up a user with an appropriate LIBL to test the process in the test
environment.



If everything tests OK both for you and the user, then you need to plan out
what you have to do to migrate the change to the production environment.  I
suggest that some steps might be:



Copy the modified source into the production source files

Compile the program(s) and new or modified logical (maybe F56SSRLB ??) in
production using the new source code in the production source library

Make any changes necessary to menus and/or DWV’s.

Make sure that F56SSRLB is not duplicated in any other libraries used for
normal user production processing

Sit with the user and monitor what happens when the user first uses the
“new” process




Cheers!
___________________
Marsh R Narewec
STC Computer Services



esolch
<esolch@mike-sell
s.com> To
Sent by: [email protected]
jdeworld-bounces@ cc
jdelist.com
Subject
Re: CHAIN working for me BUT NOT
13/06/06 02:41 working for a User


Please respond to
JD Edwards® World
<jdeworld@jdelist
.com>





I've had this happen. You can check your code by using SETLL and READE to
see if the key really does exist as you think it does. I also think that
you have a lib list issue - the user isn't reading the same files you are
when the program is running.

Ellen Solch Systems Analyst/Administrator Mike-Sell's Potato Chips, Inc.