PRODUCT IOTS » product-uem 6.2.0 GA

Bug #11443

Updated by Arshana Atapattu 5 months ago

*Description* 

 In ultimate.com tenant there were installations with different types of action status. 
 But when try to see them in installation details, it shows device count is 350, but there are no or less devices [1]. 

 There should have been this many data - > -> 
 mysql> select count(*) from AP_DEVICE_SUBSCRIPTION where TENANT_ID=46 AND STATUS='COMPLETED'; 
 +----------+ 
 | count(*) | 
 +----------+ 
 |        127 | 
 +----------+ 


 mysql> select count(*) from AP_DEVICE_SUBSCRIPTION where TENANT_ID=46 AND STATUS='PENDING'; 
 +----------+ 
 | count(*) | 
 +----------+ 
 |        179 | 
 +----------+ 


 mysql> select count(*) from AP_DEVICE_SUBSCRIPTION where TENANT_ID=46 AND STATUS='ERROR'; 
 +----------+ 
 | count(*) | 
 +----------+ 
 |         44 | 
 +----------+ 


 Full data set for above numbers. 
 DB data: [2]

Back