Problem Statement:
One of the end-users is not able to see the DOCs which were assigned to her.
Ok, what is the bug here?
DOCs are not appearing to them.
How the problem was identified?
I had a discussion with that specific end-user who is unable to see her DOCs. I came to know that she is facing this problem recently after one incident, i.e. her name was slightly updated by HR department. Before that update, she has seen all her DOCs. First, I have verified the Database whether the DOCs are available to that person. Yes. DOCs are available to that person. Later, I have gone through the code to find out the origin of getting Employee names. Database is having the employee names in the format of Emp_Name(Emp_ID). When ever the end-user login the application, application is getting her Emp-Name and Emp-ID from two different webservices and making them in the format of Emp_Name(Emp_ID) and verifying the same with Database to identify the DOCs related to that person. By observing the log files, I came to know that the both names are mismatching in case of this end-user. Because, Database is having old name and web-service is giving updated name.
Solution provided:
Quick solution provided:
I have updated the Database with new name. Now, both names are matched and end-user able to see the DOCs.
Suggested solution:
SQL statements are updated slightly from Emp_Name(Emp_ID) to %(Emp_ID). Now, SQL statement is getting the DOCs by verifying Emp_ID instead of verifying the entire format Emp_Name(Emp_ID).
