RE: Problem using user profile QTMHHTP1

["Carl Galgano" <cgalgano2@xxxxxxxxxxxxxxxxx>]

Thanks for Mike and everyone else who has responded.  So far, none of these
solutions have worked.  I have, however, done a lot more research today and
have narrowed down the process.  It really has nothing to do with the fact
that the process runs across 2 systems.  I can duplicate the problem by
submitting the program as me (works fine), as user QTMHHTP1 (does not work),
and as HTTPDUP (which is an EXACT copy of the profile QTMHHTP1).

It appears from looking at job logs that the program that I submit starts a
java process using the QSH command.  The java process is doing a few things,
among them it attempts to issue a CRTPF command.  Each time I submit this
job, another job called QZRCSRVS is started that looks like it attempts to
connect the java process to some sort of server job to issue CL commands.
When I run the job as me, I see completion message CPIAD02 in the job log
(user CARL from client AS400.EDICONSULTING.COM (this is the local machine
name) connected.)  When I run as QTMHHTP1 I see error CPE3426 (A connection
with the remote socket was reset by that...).  So it appears that user
QTMHHTP1 can not connect to the socket program because it is looking for
some sort of authorization and the profile QTMHHTP1 does not have a pwd
associated with it.

I have tried to ADDSVRAUTE on both systems to no avail.

So, the easiest fix I see is to have my process, that begins on the web
server AS400 to supply a different user profile name to use on the system
that runs the process and creates the spool file.  I looked at the net.data
macros and don't really see even how it know to run the programs on the
REMOTE as400.  Is there a connect to database command or something like
that?  Perhaps I can code some way that it know to use the database on the
remote AS400 and use a different user  profile and pwd.

Anyone have any other ideas?
cjg

Carl J. Galgano
EDI Consulting Services, Inc.
600 Kennesaw Avenue, Suite 400
Marietta, GA  30060
(770) 422-2995 - voice
(419) 730-8212 - fax
mailto:cgalgano@xxxxxxxxxxxxxxxxx
http://www.ediconsulting.com
AS400 EDI, Networking, E-Commerce and Communications Consulting and
Implementation 
http://www.icecreamovernight.com
Premium Ice Cream Brands shipped Overnight

Visit our website to subscribe to our FREE AS/400 Timesharing Service

-----Original Message-----
From: meovino@xxxxxxxxxxxxxxxxx [mailto:meovino@xxxxxxxxxxxxxxxxx] 
Sent: Wednesday, June 30, 2004 12:02 PM
To: Midrange Systems Technical Discussion
Subject: Re: Problem using user profile QTMHHTP1


Carl,

We do something very similar, and it gives us fits.  Are the jobs on 
system B running with user profile QTMHHTP1?  With us, they run as QUSER, 
job name QRWTSRVR.  But the QRWTSRVR helper job swaps the user profile 
under the covers to the user profile we used to connect from system A to 
system B (we use dtw_sql functions to call RPG and CL programs on system 
B).  So any way you would normally grab the spool file doesn't work, 
because the user profile isn't right.

We put a unique identifier into the User Data of the spool file, then we 
use a TAATOOL utility to retrieve the spool file based upon that unique 
identifier.  Works pretty well (as long as your unique identifier is 
unique).  Be sure it starts with a letter, User Data doesn't like starting 
with a number.

Mike E.





"Carl Galgano" <cgalgano2@xxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
06/29/2004 06:04 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     "Midrange List" <MIDRANGE-L@xxxxxxxxxxxx>
        cc: 
        Subject:        Problem using user profile QTMHHTP1


This gets complicated, so I will try to make it simple.

1.  I have a net.data web macro that runs on AS400 A.
2.  It creates a spool file on system B, using data on system B. 3.  The
spool file is then converted to either RTF or PDF. 4.  The PDF process was
from this list server and is called CPYSPLFPDF. (written in java) 5.  The
PDF process works perfectly if I log on as ME on system B and run the
COMMAND CPYSPLFEML 6.  The process ONLY seems to fail when it comes as a
request from the website and runs under profile QTMHHTP1. 7.  If I submit a
job, running the command CPYSPLFEML on system B, submitting as user
QTMHHTP1, it fails. 8.  The failure message indicated that the java could
not created a temp file in QTEMP called SPOOL. 9.  The only thing I can
narrow down is that it has to do with user 
profile
QTMHHTP1.
10.  I can submit the command to run in batch as my profilem and can 
submit
with a profile called HTTPDUP that is an EXACT duplicate of QTMHHTP1.

I am out of ideas. 
HELP.
cjg


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