apex error - liamlamth/blog GitHub Wiki

SQL> begin  
       APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG;  
     end; 
     /
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 57
ORA-06512: at "SYS.UTL_SMTP", line 140
ORA-06512: at "SYS.UTL_SMTP", line 201
ORA-06512: at "APEX_200200.WWV_FLOW_MAIL", line 1026
ORA-06512: at "APEX_200200.WWV_FLOW_MAIL", line 2371
ORA-06512: at "APEX_200200.WWV_FLOW_INSTANCE_ADMIN", line 1611
ORA-06512: at line 2

solution:   
+ ACL: apex schema should have connect privilege to * host. or the using schema  
+ apex admin panel: change the smtp setting  
+ reset parameter smtp_out_server  

solution: disable vpd policy or change vpd authenticate function to use sys_content('APEX$SESSION','APP_USER')
cause: when apex_util.set_session_state is setup and apex_util.fetch_app_item is used as in vpd policy authenticate function

solution: process >> setting >> turn off "Return Primary Key(s) after Insert"
cause: remote table (db link) is used