message id pui0037 when attempting to launch program

Use this board to ask questions or have discussions with other Rich Displays users.
User avatar
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

Post 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.
esdaled
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

Post 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.  
User avatar
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

Post 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?
User avatar
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

Post by David »

See here:
Detail1.png
Detail1.png (51.52 KiB) Viewed 1069 times
And here:
Detail2.png
Detail2.png (55.1 KiB) Viewed 1069 times
esdaled
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

Post 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.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest