Today, I got a rude shock when our Oracle Apex workspace display this error ORA-20001. Thankfully, this seems to be a common occurrence when setting up REST.
ORA-20001: You have exceeded the maximum number of web service requests per workspace.
There are actually two solutions to tackle this issue. Interestingly, the solution are applied differently. The first solution is to login Apex Instance with admin. You can select administration services link below the standard workspace login.
Go to Workspace > Security settings > Workspace Isolation > Maximum Web Service Requests
Increase the number for maximum web service requests. That will solve this issue. However, you may not find this option in the UI. If this is the case, you will need to amend this parameter with SQL apex_instance_admin functions. Start your database console for your apex autonomous database.
To view the parameters, you can run below SQL command.
(‘MAX_WEBSERVICE_REQUESTS’) as max_service_requests from dual;
To amend the parameters, you can run below SQL.
(‘MAX_WEBSERVICE_REQUESTS’, ‘500000’); — increase to 500000
To our relief, this works and I wonder why is this necessary. REST is a common requests and perhaps this is good from a security standpoint. However, the error is too technical in nature to be solved by standard user. Another error to clear and we are good to go.