Page 1 of 2
message id pui0037 when attempting to launch program
Posted: Wed Aug 29, 2012 9:32 am
by chris_rover
Hi guys, I am getting the above error message when I try to launch either a new session or an initial program.
I upgraded to the latest version this morning, and that's when this problem started. I have attached a screen-shot of the message.
please help urgently.
Also, Scott, welcome to the Profound scene. I know you will bring great value to us.
Re: message id pui0037 when attempting to launch program
Posted: Wed Aug 29, 2012 12:17 pm
by Scott Klement
Hi Chris,
In version 4.1.0, ProfoundUI is tracking some settings in a session database on the server. The error you cite states that an error occurred while accessing this session database, and that you should look in the job log for further errors.
Please do look in the job log.
If I had to guess, I'd say you're having an authority error. A bug was discovered this morning in the 4.1.0 installer where it was not setting the authorities correctly.
Try granting *PUBLIC *CHANGE authority to this session database (PUISSNP, PUISSNVP). The commands to do so would be:
Code: Select all
GRTOBJAUT OBJ(PROFOUNDUI/PUISSNP) OBJTYPE(*FILE) USER(*PUBLIC) AUT(*CHANGE)
GRTOBJAUT OBJ(PROFOUNDUI/PUISSNVP) OBJTYPE(*FILE) USER(*PUBLIC) AUT(*CHANGE)
If you installed 4.1.0 in a different library, change PROFOUNDUI to whichever library name you used.
Hope this helps, and thanks for the welcome!
Re: message id pui0037 when attempting to launch program
Posted: Wed Aug 29, 2012 1:24 pm
by chris_rover
Hi Scott. that was the problem. I received the same response from David at the same time you responded.
thanks again.
Re: message id pui0037 when attempting to launch program
Posted: Wed Aug 29, 2012 2:17 pm
by Scott Klement
Great! Yeah, I saw your e-mail and David's response while I was typing the forum post. But, I decided it wouldn't hurt to have it in the forum, too...
Re: message id pui0037 when attempting to launch program
Posted: Sat Dec 29, 2012 2:32 pm
by esdaled
I am having a similar problem starting a Genie session. Normally, we use Atrium Genie Macros to start a session (and this works fine) but I am trying to start a session directly with a URL (
http://10.0.240.31:8212/profoundui/geni ... =TDE20002c) and a specified workstation id.
Here is the message in the job log:
Code: Select all
Job 362165/QTMHHTTP/GGLDEV started on 12/29/12 at 11:03:38 in subsystem
QHTTPSVR in QHTTPSVR. Job entered system on 12/29/12 at 11:03:38.
This is a CGI job for IBM HTTP Server instance GGLDEV.
Not authorized to replace file PUISSNP in QTEMP.
File PUISSNP not created in library QTEMP.
SQL system error.
Unable to access session database.
*PUBLIC, QTMHHTP1 and QTMHHTTP have *CHANGE authority to PUISSNP file in the PROFOUNDUI library.
We are using version 4.1.7.
Re: message id pui0037 when attempting to launch program
Posted: Mon Dec 31, 2012 10:10 am
by David
It looks like the problem here actually has to do with the QTEMP library? The process is trying to run a CREATE ALIAS statement to create an alias of PROFOUNDUI/PUISSNP in QTEMP. Does QTMHHTP1 have authority to QTEMP?
Re: message id pui0037 when attempting to launch program
Posted: Mon Dec 31, 2012 11:19 am
by David
That might not be correct -- now that I think about it, I'm not sure that you can even set permissions on the QTEMP library.
Here is what it is trying to do:
1. It checks for existence of an SQL alias QTEMP/PUISSNP.
2. If this is not found, it creates it using an SQL statement like this:
CREATE ALIAS QTEMP/PUISSNP FOR PROFOUNDUI/PUISSNP
What is odd about the message is that it seems to indicate that the alias has already been created and it's trying to create it again?
That is very unusual, as the CREATE ALIAS statement won't replace an existing file, anyhow. If you were to take option 13 from the Work with Job screen after this happens and then take an Option 5 on the QTEMP library, do you see the "file" PUISSNP in there?
Re: message id pui0037 when attempting to launch program
Posted: Mon Dec 31, 2012 12:53 pm
by esdaled
QTEMP is empty for the job.
The library list for the job is:
Code: Select all
QSYS SYS
QSYS2 SYS
QHLPSYS SYS
QUSRSYS SYS
QHTTPSVR CUR
QGPL USR
QTEMP USR
Re: message id pui0037 when attempting to launch program
Posted: Mon Dec 31, 2012 1:01 pm
by David
Thanks. This is very strange -- we've tested a number of different situations and we haven't been able to determine what could cause the "cannot replace file in QTEMP" message.
The odd thing is that the CREATE ALIAS statement it's trying to run cannot even be used to replace the file, anyway. If it were existing already, you'd get a "file already exists" type of message.
When you sign on with /profoundui/genie, the job runs under user profile QTMHHTP1. If you were to copy this user profile so that you have one that is setup the same way, could you try signing on with it and running this SQL statement:
Code: Select all
CREATE ALIAS QTEMP/PUISSNP FOR PROFOUNDUI/PUISSNP
Does that work? Or does it fail with the same messsage?
Re: message id pui0037 when attempting to launch program
Posted: Mon Dec 31, 2012 1:50 pm
by esdaled
It worked under the copied user profile. Although, I did have to give the new user profile authority to the STRSQL command.
I have tried using the base profoundui HTTP server configuration file and IFS www folders instead of our customized versions but I have encountered the same problem.