Unable to configure “ACT AS” proxy feature

Multi Select Prompt Selection Window not Rendering Correctly after Migration from 10.1.3.2.1
June 8, 2009
Interesting discussion about IIS and OC4J
June 11, 2009

If you’re unable to configure proxy “Act as” feature maybe this can help you.

The customer had OID/SSO users in lowercase but had the users in the proxy table in upper case.

Also the string (‘VALUEOF(NQ_SESSION.RUNAS)’) was not in uppercase in both the proxyblock and proxylevel init blocks

Initially, on selecting ‘act as’ the following error was reported:
“This functionality has not been correctly configured by your administrator (Can’t retrieve the list of target users).”

The customer had OID/SSO users in lowercase but had the users in the proxy table in upper case. Advised the customer to add upper function to proxy related init block queries and in the XML template file queries as well. This resolved this error message and the customer was able to see the list of target users.

Then on selecting a particular user from the list of target users it failed. It gave the error message : “Not logged in”.

Since the customer had OID/SSO setup, the customer was advised to test with rpd users.

Even with rpd users the functionality still failed to work and reported the following error:
“Access for requested connection is refused. Failed to get the value of PROXY session variable”.

Finally, what seemed to resolved the problem for the customer was changing the string (‘VALUEOF(NQ_SESSION.RUNAS)’) in all uppercase in both the proxyblock and proxylevel init blocks.

1 Comment

  1. Prakash says:

    Thanks for the post !!
    I am encountering the following error when clicked on ACT AS. Instead of list of users it is showing please wait and the error.

    error : Assertion failure: populateParameterizedSQL(tSQLBuffer, sTemplate, tNamedParams) at line 435 of ./project/websubsystems/sssecurity.cpp The account entered does not exist or you do not have permission to view this account.

    Can you please throw some light ?

    Thanks
    Prakash

Leave a Reply