|
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.
As an Amazon Associate we earn from qualifying purchases.
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.