| Subject: | Report Email created from Report schedule process has incorrect username |
| Summary: | Report Email created from Report schedule process has the username as NULL. |
| Audit Notes: | |
| 28 Mar 2018 | 02:29PM Comment 1 by Alvis (Link Technologies) Case 9234 added to project 9.4 |
| 05 Apr 2018 | 02:56PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 05-04-2018 02:56 PM Time Taken: 2.00 |
| This has been resolved in 9.4. |
|
| 02 May 2018 | 04:05PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 02-05-2018 04:05 PM Time Taken: 1.00 |
| System test completed. Verified the following: - Created a report schedule for "SYS User access report"
- Verified the Trace and confirm that Username was correctly populated.
Regards
Alvis SQL Trace is shown below: 
|
|
| 03 May 2018 | 02:48PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 04-05-2018 12:00 AM Time Taken: 1.00 |
| Hi Sanjay, This case has been successfully tested. Documentation updated under BI -- Report Schedule Test Environment - Version 9400 Beta 1
- Database - LINKSOFT on QA1
- Application on QA1
- OS - Windows 7
Test Plan | Test No | Description | Status | | 1 | Schedule the 'SYS User Role Menu Access".Set the "Run Report as user" as Alvis. Report should be emailed without errors. | Pass | | 2 | Email Log should be updated with user created as "Alvis" | Pass | | 3 | Report Run user should be updated with user as "Alvis" | Pass |
Figure 1: Email Log 
Figure 2: Report Output 
|
|
| 07 May 2018 | 06:14PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-05-2018 06:14 PM |
| Thanks Rashna. |
|
| 09 Oct 2019 | 08:14AM Comment 6 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |