It sounds simple and silly, but make sure they have not created a copy of the database tables in a library higher up in the library list.
Brian May
IBM i Modernization Specialist
Profound Logic Software
http://www.profoundlogic.com
937-439-7925 Phone
877-224-7768 Toll Free
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Thomas Garvey
Sent: Thursday, June 06, 2013 8:54 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Brainstorming
What's happening is that an interactive green screen program lists users.
Some of these users have special capabilities (not associated with i5
authorities) and an action code can be typed next to their record in the subfile list. This action code calls another program, providing the selected user ID. The other program should list in a subfile the programs that the selected user has authority to. Some users with less authority have their authorized programs listed properly. Other users with more authority have nothing listed.
Seems like a data problem, right? The only way we could duplicate the problem here was to mess with the data in a specific file. So, we had them send their data library to us. We also asked for the object library, just in case something had changed there.
We installed their object and data libraries and tested again on our system.
The problem doesn't happen. We tested using their object library and our data library. Problem doesn't happen. We tested using their data library and our object library, problem doesn't happen.
The programs are all RPG, not RPGLE, no embedded SQL, all native file access. We checked that all files used by all programs were transferred, including logicals.
We have tried sabotaging actual i5/OS file authorities (to see if they changed something there that got corrected when restored to our system) and hard halts occur. The user is not reporting hard halts. We changed object owners and adopt authority attributes and the expected failures also occurred, none of which the user experiences.
I think my only alternative is to send them program objects which can be put into debug mode on their system, and get a web conference going and put everything in debug to see what the heck is going on.
Thanks much, everyone, for suggestions.
Tom
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of franz400
Sent: Wednesday, June 05, 2013 11:08 PM
To: Midrange Systems Technical Discussion
Subject: Re: Brainstorming
Thomas,
I think you would have to be much more precise in your description for us to consider your issue.
The phrase "selected data does not appear as expected in a subfile program..."
what does this mean?
Some data appears, just not all or
No data appears or
Corrupted data appears
How are you selecting data - RPGLE read or chain. SQL, JDBC, ODBC, OLEDB, OPNQRYF, ???
Even though you brought the programs & data lib to your own system, there are many environment differences that might account for this.
Are there files on their system, in their library list, that are not part of your test environment?
Are their exceptions occurring that are covered up by monmsg or pssr routines, or ignoring sql codes?
Depending upon OS and cume differences, there have been several sql updates by IBM that can change expected results (documented in places like the V6R1 Memo to Users - to read before installing 6.1 (and there are others, but we're just guessing here...
more details please
Jim Franz
----- Original Message -----
From: "Thomas Garvey" <tgarvey@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, June 05, 2013 3:28 PM
Subject: Brainstorming
We have a program that is apparently failing at a user site, but not
on our test and development systems. The nature of the failure is
that selected data does not appear as expected in a subfile program.
To test it we had the object library and data library from the user
system saved and sent to our test system. We restored the objects and
tested the process here. It works just fine.
So, what could be different at the user site and our site that would
change whether records are displayed in a subfile?
My first (and only) thought was in regards to authority to either the
file and/or the program. We've tried all the permutations we could
think of (owner of program object, adopt authority yes/no, ownership
and authority to files, etc.) and it still works on our system.
Any other ideas that would make something work on one system and not
another? Remember, both the program object and data files libraries
from the user site were restored to the test system.
Thanks for any advice.
Tom Garvey
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
