Nelson
9/6/2017 - 1:57 PM

OOS Report Validation

Log validation
content_copyfile_download
### Procedure


1. Access to app servers
2. Open ReportingRole log
3. Search the following text in log files: RFID_OOS_Report_LOC_AS_DY

Example:

2017-09-07 16:00:07,857 [43] INFO  Creativesystems.Modules.OOSReport.Jobs.CreateReportFileJob [(null)] - Create report file C:\CreativeRetail\storage\local\reports\RFID_OOS_Report_LOC_AS_DY_1_05_01_20170907160007.csv ... OK
2017-09-07 16:00:07,858 [43] INFO  Creativesystems.Modules.OOSReport.Jobs.CreateReportFileJob [(null)] - Compress file C:\CreativeRetail\storage\local\reports\RFID_OOS_Report_LOC_AS_DY_1_05_01_20170907160007.zip ...
2017-09-07 16:00:08,118 [43] INFO  Creativesystems.Modules.OOSReport.Jobs.CreateReportFileJob [(null)] - Compress file RFID_OOS_Report_LOC_AS_DY_1_05_01_20170907160007.zip ... OK
2017-09-07 16:00:08,375 [43] INFO  Creativesystems.Modules.OOSReport.Jobs.CreateReportFileJob [(null)] - Delete report [site::102][date::20170907160000][uri::reporting-files/3754e84a2d604abba3a80421d21412f8] ... OK
2017-09-07 16:00:08,387 [43] INFO  Creativesystems.Modules.OOSReport.Jobs.CreateReportFileJob [(null)] - Delete report [site::130][date::20170907160000][uri::reporting-files/76ca20e221624a8b88c9057d9961d0a5] ... OK
2017-09-07 16:00:08,399 [43] INFO  Creativesystems.Modules.OOSReport.Jobs.CreateReportFileJob [(null)] - Delete report [site::173][date::20170907160000][uri::reporting-files/40c062c309dd4ee3b675c6e0db76d208] ... OK
2017-09-07 16:00:08,415 [43] INFO  Creativesystems.Modules.OOSReport.Jobs.CreateReportFileJob [(null)] - Delete report [site::204][date::20170907160000][uri::reporting-files/9635ffcbe7b145d2aa96f32ffecfb09d] ... OK
2017-09-07 16:00:08,415 [43] INFO  Creativesystems.Modules.OOSReport.Jobs.CreateReportFileJob [(null)] - Delete report file C:\CreativeRetail\storage\local\reports\RFID_OOS_Report_LOC_AS_DY_1_05_01_20170907160007.csv ... ok
2017-09-07 16:00:08,420 [43] INFO  Creativesystems.Modules.OOSReport.Jobs.CreateReportFileJob [(null)] - CreateReportFileJob ... END
SQL validation
content_copyfile_download
select count(*)
from master.oos_report
where report_date > '2017/09/05' and oos_report_type = 1

select count(*)
from master.oos_report
where report_date > '2017/09/05 16:00' and oos_report_type = 2

select count(*)
from master.oos_report
where report_date > '2017/09/05' and oos_report_type = 3

--nova qry para validar oos_reports 
--(report 1 and 3 report_date is local time and report 2 report_date is server time)
select * from master.oos_report_header 
 where report_date > '2018/07/11' 
   and oos_report_type = 1