Hello Apex experts,
I am attempting to send a push notification using the given page process. When checking the apex_push_notifications_queue view, all notifications have the following error message:
ORA-29260: network error: Connect failed because target host or object does not exist.
The PWA Reference (https://apex.oracle.com/pls/apex/r/apex_pm/apex-pwa-reference/push-notifications) states that the ORA-29260: network error: TNS:operation timed out
error occurs when using an firewall and sending the push notification outside the firewall. The solution is to set up a proxy server.
This could be the cause of the issue, however, the error message is not exactly the same, which leads me to question whether the error could have another cause. I am guessing from the description that one more cause behind this could be sending the notification to a user that does not exist (giving the wrong username in the parameter of the process), however I double-checked with the apex_appl_push_subscriptions view and the user that is opted in the push notification has the same user_name as given in the process.
I would appreciate it greatly if anyone could let me know if they have encountered this issue as well.
Thanks