message id pui0037 when attempting to launch program

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

[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!

[chris_rover]

Hi Scott. that was the problem. I received the same response from David at the same time you responded.

thanks again.

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

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

[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?

[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?

[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

[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?

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