message id pui0037 when attempting to launch program

[David]

Yes, I don't think it would have to do with http server configuration at all; it seems like an authority problem somehow. At least this is what the error message indicates -- it doesn't seem to make sense, though, that it's mentioning replacing an object in QTEMP that does not even exist.

What is the message id and text for the "SQL System Error" that also shows up? I just noticed that. I've not seen that before, either.

[esdaled]

Code: Select all

Message ID . . . . . . :   SQL0901                                           
Date sent  . . . . . . :   01/02/13      Time sent  . . . . . . :   18:57:51 
                                                                             
Message . . . . :   SQL system error.                                        
                                                                             
Cause . . . . . :   An SQL system error has occurred.  The current SQL       
  statement cannot be completed successfully.  The error will not prevent    
  other SQL statements from being processed. Previous messages may indicate  
  that there is a problem with the SQL statement and SQL did not correctly   
  diagnose the error. The previous message identifier was CPF0620. Internal  
  error type 4054 has occurred. If precompiling, processing will not continue
  beyond this statement.  

[David]

Ok, I think I found what can cause QTMHHTP1 to be unable to write into his own QTEMP! Go to the Edit Authority screen for the QTMHHTP1 *USRPRF object.

Normally, a user profile has Object Operational, Object Management, and all Data authorities to his own profile.

In testing, if I removed the user's Add data authority to his own profile, he is then unable to create objects in his own QTEMP! And then Genie gives the same exact message you are seeing when you attempt to sign on.

I bet your QTMHHTP1 is setup like this. You can see these detail authorities by pressing F11 on the Edit Authority screen.

Is this it?

[David]

See here:

Detail1.png (51.52 KiB) Viewed 1078 times

And here:

Detail2.png (55.1 KiB) Viewed 1078 times

[esdaled]

After some email correspondence with David, we have resolved the issue.

The problem was with user profile QDBSHR.

QTMHHTP1 needs *CHANGE authority to QDBSHR. This authority had been removed from the user profile object.

Thanks.