Page 2 of 2
Re: message id pui0037 when attempting to launch program
Posted: Wed Jan 02, 2013 11:31 am
by 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.
Re: message id pui0037 when attempting to launch program
Posted: Wed Jan 02, 2013 7:01 pm
by 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.
Re: message id pui0037 when attempting to launch program
Posted: Wed Jan 02, 2013 7:04 pm
by 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?
Re: message id pui0037 when attempting to launch program
Posted: Wed Jan 02, 2013 7:11 pm
by David
See here:
- Detail1.png (51.52 KiB) Viewed 1070 times
And here:
- Detail2.png (55.1 KiB) Viewed 1070 times
Re: message id pui0037 when attempting to launch program
Posted: Thu Jan 03, 2013 1:30 pm
by 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.