Thursday, 1 May 2025

ERROR IN ORA-20001: You have exceeded the maximum number of web service requests per workspace. Please contact your administrator.

 

Increase Maximum Web Service Requests in Oracle APEX 

1. UPDATE AT INSTANCE  LEVEL OR
2.UPDATE AT WORKSPACE LEVEL 
UPDATE AT INSTANCE LEVEL

Login to internal workspace 
    INTERNAL workspace as ADMIN
        select Manage Instance > Security > Workspace Isolation

        You can either increase the limit of MAX_WEBSERVICE_REQUESTS 
        or
        set the parameter MAX_WEBSERVICE_REQUESTS to NULL to prevent the check.

Can be Managed using SQL commands too, select apex_instance_admin.get_parameter('MAX_WEBSERVICE_REQUESTS') from dual;
begin
apex_instance_admin.set_parameter('MAX_WEBSERVICE_REQUESTS', '50000');
commit;
end;
/

select apex_instance_admin.get_parameter('MAX_WEBSERVICE_REQUESTS')  from dual;
UPDATE AT WORKSPACE LEVEL

Login to internal workspace 
INTERNAL workspace as ADMIN
    Managed Workspaces > Existing Workspaces > Select Workspace
        > Security > Workspace Isolation

    Increase the value of MAXIMUM WEB SERVICE REQUESTS



No comments:

Post a Comment