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.
message id pui0037 when attempting to launch program
- David
- Profound Logic Staff Member
- Posts: 690
- Joined: Fri Jan 04, 2008 12:11 pm
- First Name: David
- Last Name: Russo
- Company Name: Profound Logic Software
- Contact:
-
- Profound User
- Posts: 72
- Joined: Fri May 08, 2009 2:43 pm
- First Name: David
- Last Name: Esdale
- Company Name: Guardian General Insurance
- City: Port of Spain
- State / Province: Outside Canada/USA
- Country: Trinidad and Tobago
- Location: Trinidad
- Contact:
Re: message id pui0037 when attempting to launch program
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
- Profound Logic Staff Member
- Posts: 690
- Joined: Fri Jan 04, 2008 12:11 pm
- First Name: David
- Last Name: Russo
- Company Name: Profound Logic Software
- Contact:
Re: message id pui0037 when attempting to launch program
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?
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
- Profound Logic Staff Member
- Posts: 690
- Joined: Fri Jan 04, 2008 12:11 pm
- First Name: David
- Last Name: Russo
- Company Name: Profound Logic Software
- Contact:
Re: message id pui0037 when attempting to launch program
See here:
And here:
And here:
-
- Profound User
- Posts: 72
- Joined: Fri May 08, 2009 2:43 pm
- First Name: David
- Last Name: Esdale
- Company Name: Guardian General Insurance
- City: Port of Spain
- State / Province: Outside Canada/USA
- Country: Trinidad and Tobago
- Location: Trinidad
- Contact:
Re: message id pui0037 when attempting to launch program
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.
The problem was with user profile QDBSHR.
QTMHHTP1 needs *CHANGE authority to QDBSHR. This authority had been removed from the user profile object.
Thanks.
Who is online
Users browsing this forum: No registered users and 1 guest