Bug 1005091

Summary: mismatch in systems count reported by dashboard for all orgs and by Splice report
Product: [Retired] Subscription Asset Manager Reporter: Jan Hutař <jhutar>
Component: SpliceAssignee: Splice Developers <splice-devel>
Status: CLOSED NOTABUG QA Contact: mkovacik
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 1.3CC: cduryee
Target Milestone: rc   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-09-06 12:58:52 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Jan Hutař 2013-09-06 08:21:01 UTC
Description of problem:
There is a mismatch in systems count reported by dashboard for all orgs and by Splice report.


Version-Release number of selected component (if applicable):
SAM 1.3 snapshot #4


How reproducible:
always on mine installation


Steps to Reproduce:
1. Setup SAM with Splice and sync data from big Satellite 5.6.0 instalce
2. Compare sum of systems displayed for all synced organizations on Dashborad
   to count mentioned in Splice report (Administer -> Reports -> Red Hat
   Default Report -> Run Report)


Actual results:
Dashboards for:
  Org1: Total Systems:  359
  Org2: Total Systems:  206
  Org3: Total Systems:   13
  Org4: Total Systems: 1301
  Org5: Total Systems:    0
  Org6: Total Systems:    0
  -------------------------
                       1879
Enhanced Entitlement Report
  Subscribed Systems: 2500


Expected results:
Numbers should match.


Additional info:
Importing data into SAM might have been affected by bug 1004954 which happened and was reported before I have noted this.

Comment 2 Chris Duryee 2013-09-06 12:58:52 UTC
If you do a katello-configure to reset your db, you have to clear your mongodb as well. If you run the following, you should get correct data in the report:

 # mongo checkin-service
  > db.marketing_product_usage.drop()
  > exit
 # sudo su - splice -s /bin/bash
 $ spacewalk-splice-checkin --splice-sync 

Closing as notabug, but please re-open if the above doesn't fix the issue.

Comment 3 Chris Duryee 2013-09-06 13:30:05 UTC
Sorry, I misread your comment in 1004954.

What I believe happened is that you have duplicate entries due to #1004954. Running the same steps as above should clean them out.