APEX IMAGE ISSUE (503 Unavailable Error raising while access or load the images through Apex user).

APEX IMAGE ISSUE (503 Unavailable Error raising while access or load the images through Apex user).

Requirements:
————–
Apex 5.1.3
ORDS 3.0.9
Glassfish 3.0

Error:
======
1.It will raised in ORDS with Apex only.
2.The developer got 503 Unavailable Error while accessing or load the image through apex link.
3.Applications are working fine , but the icons(buttons , labels etc) are not showing in the application front end.

Solution:
=========

1.Check the Apex users account status and ensure all the apex users are open status.

SQL> SELECT USERNAME , ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME LIKE ‘%APEX%’;

2.APEX_REST_PUBLIC_USER is the user can have the privileges to access all the componenets in APEX with ORDS GLASSFISH.

3.Grant the privilege to WORKSPACE SCHEMA (Application Schema) connect through APEX_REST_PUBLIC_USER.

SYNTAX :
ALTER USER <USERNAME> GRANT CONNECT THROUGH APEX_REST_PUBLIC_USER.

Example:

Workspace schema = FMS
Workspace        = FMS

ALTER USER FMS GRANT CONNECT THROUGH APEX_REST_PUBLIC_USER.

Now we can see all the images are working fine.

  • January 23, 2019 | 23 views
  • Comments