In Strategy Platform Analytics 11.0 and above, failed mobile subscriptions have no SubscriptionID, ScheduleID, RecipientID, SubscriptionDevice, etc populated in IsReportStats while there is data in IsMessageStats.
In Tutorial:
1. Create a new mobile subscription for the project "Consolidated Education Project" > "Demo Report" and ensure it will fail.
'
2. Check "Run Subscription Immediately" to generate data
3. Check the PA warehouse, notice the transaction is inserted into access_transaction and the session source = 7 'scheduler'. However, there is no SubscriptionID, ScheduleID, RecipientID, SubscriptionDevice, etc populated. They displayed “Not Applicable” or “Unknown” as shown below:
4. Check the topic Mstr.PlatformAnalytics.IsMessageStats, it has a "SCHEDULEJOBID":162; Check the topic Mstr.PlatformAnalytics.IsReportStats, there is no corresponding JOBID = 162
This is a known issue with Strategy 11.0 and above.
Strategy will continue to investigate and post updates as soon as they are available.
Article Reference Number: KB442605
