In SAS^® Drug Development 4, users with membership in more than 1,000 groups or subgroups might see errors when attempting to log on, administer users, or use a workflow. This is caused by a limitation in how the SAS^® Web Infrastructure Platform and associated SAS^® Workflow Server handle information requests from Oracle^®. Oracle^® databases have a known limit in the number of objects that can be requested through an explicit IN clause, which is limited to 1,000 objects.

The user with this problem might see this error:

Could not access HTTP invoker remote service at [http://<Instance>/SASWorkflowWebServices/remote/WorkflowTaskQueryService?ticket=ST-7074-jKK7g7bbGAuW3uuGEkbx-cas]; nested exception is java.io.IOException: Did not receive successful HTTP response: status code = 500, status message = [Internal Server Error]

For additional details and links to Hot Fixes, see these notes:

• Problem Note 58773: Workflow queries fail for users that belong to more than 1,000 groups

  http://support.sas.com/kb/58/773.html

• Problem Note 58774: SAS® Web Infrastructure Platform Unable to log on as a user with membership in over a 1,000 groups

  http://support.sas.com/kb/58/774.html

• Problem Note 58768: SAS® Drug Development 4.5 - Post installation configuration instructions for M92008 and M93007 hot fixes

  http://support.sas.com/kb/58/768.html

  Note, this additional step is required after installing the hot fixes above:

Operating System and Release Information

A fix for this issue for SAS Middle Tier 9.4_M1 is available at:

A fix for this issue for SAS Management Console 9.4_M1 is available at: