× 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.



It has to be something silly and stupid, right? I will check.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian May
Sent: Thursday, June 06, 2013 9:03 AM
To: Midrange Systems Technical Discussion
Subject: RE: Brainstorming

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.



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




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.