- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
Throttle message displayed on Login page but the seconds value does not count down remaining seconds
I wonder if anyone might be able to help with this?
I am having a problem with my login page when incorrect credentials are entered the throttling message "Invalid Login Credentials Please wait 5 seconds to login again." Is being displayed as expected BUT the numeric seconds value in the warning message does not count down the remaining seconds until the user can login again.
E.G: It says 5 seconds as rendered and stays at that value forever when it should say 5…4, 3, 2, 1.
I found a couple of similar threads where it was identified that the relevant JS has not been rendered on the page but no solution was discussed:
So to give some more detail of the problem and what I have found, I have an app which uses two step login process which I have split across two public pages.
- P9999 - Login Step 1 - Collect some credentials, verify against an external webservice and branch to Step 2
- P9998 - Login Step 2 - Collect more credentials and then Calls apex_authentication.login like any other apex login page
The login page setting under App Builder > Application Properties is set to P9998 Login Step 1 as this is to be the initial landing page for new / expired / logged out sessions.
The actual login functionality is all working fine.
So I tried to dig more in to the underlying cause of the missing JS.
It seems like the reason for the missing JS in the page rendering is coming from the PAGE_FUNCTION on the view APEX_APPLICATION_PAGES:
9998 Dynamic HTML
That view is sourcing this data from PAGE_COMPONENT_MAP on WWV_FLOW_STEPS:
ID FLOW_ID COMPONENT_MAP
9999 200 12
9998 200 10
(10 = Dynamic HTML, 12 = LOGIN)
I think to be able to solve my problem and get the JS rendered on the login page to count down seconds as expected, I need to have both login pages (9999 and 9998) set to WWV_FLOW_STEPS.COMPONENT_MAP = 12 and by extension APEX_APPLICATION_PAGES.PAGE_FUNCTION = 'Login'.
Does that seem right?
I can’t get much further than this to see what is setting the Component Map and what criteria it is based on because the package bodies are wrapped and so do not show up in the source tables. Unwrapping them will be very time consuming and possibly a license violation too.
I think I can solve this problem in two ways:
- Hopefully someone might know how to get the component map set to 12 for both of my login pages rather than just step 1?
- Or does anyone know how to add the necessary JS to my Step 2 page manually to allow the throttle message to count down the remaining seconds?
Thanks for reading and I hope I've explained the problem clearly enough.
Oracle Apex Version 20.1.0.00.13
Oracle Database 126.96.36.199.0
Oracle REST Data Services 19.2.0.r1991647