Hi.
This is APEX 4.2.2.00.11.
We exported an application from instance A that included four saved subscriptions, then imported it to a test environment B.
We received the emailed IR subscriptions from instance B, as expected. Then clicked the Unsubscribe link in the emails, were directed to the proper page 4155:200 on instance B, clicked the Unsubscribe button, and APEX presented the green check mark confirmation.
Tha problem is the emails continue.
Looking at two closely, both are from Primary Reports. One was daily and the other weekly frequency. The attached Report.htm files are 0K bytes. Given the nature of the queries, they were expected not to find data in the test environment.
Although there were two email recipients on the subscriptions, when I unsubscribed, it removed the subscription for both of us, which would be a problem if you have wide subscription distribution. You wouldn't want one recipient in the group to blow away the subscription for everyone.
- The one that was to be weekly email is sent 5 times every half hour, two with a complete and proper unsubscribe URL, and 3 that don't only have the request path, starting at f?p.
- The other that was to be daily email is sent 8 times every half hour. Some half hours have 6 on the 00 or 30 minute mark, and then the remaining 2 at 05 or 35 minutes after the hour. 2 of the 8 have the proper URL, the other 6 only have the request path.
APEX Listener is configured to support multiple databases, with a path prefix identifying instance B. We see this in the Unsubscribe URL in the emails, which is what leads me to suspect instance B is where the problem is coming from.
The ORACLE_APEX_WS_NOTIFICATIONS job runs minutely at 0,30. the ORACLE_APEX_MAIL_QUEUE job runs minutely every 5 minutes.
Since this is happening at a customer site, where I have limited access to the APEX environment, I don't have a lot of information about how they have configured APEX mail support. I have verified you cannot see any IR subscriptions in the workspace, and have verified that the APEX notifications job is running periodically and there are no records in wwv_flow_worksheet_notify.
I'm looking for ideas:
- How do we stop them?
- How do we identify the process sending the emails and the subscription from/to/report title data that's driving the process?
Thanks.
Skip