Application hang and crash on search

[mayank2k2]

if we search student as first name the Oxford math prod site goes hang and below message appears.

[manasghosh81]

I have tried basic search with Firstname "mayank". it gives me result within 5 sec.Please see the screenshot.

I have also tried with Firstname as "manas","student","teacher" etc. All the cases it gives me result or shows be message that there "No data Found".

Is there any particular keyword that you have used.if that please let me know.

Whether you have typed the keyword of firstname before the page load .

Is it a single instance where there there may be some network issue as my network bandwidth. is 1gbps.

[mayank2k2]

@manasghosh81 we are facing the issues on using student as first name in basic search , i also cross check in sumit's laptop.

[manasghosh81]

This is happening using the "student" as firstname containing 10098,where as total no of user is 26073.

When try to fetch this amount of data from db itself there is no time taken as you can view from the attached screenshot.

So there is no time is taking in fetching the data,the time is taking the binding the data to grid and binding 10000 records.

Is this a valid scenario done by OUP admin user.This should not be happened in case of school admin who is searching a firstname .If in case of this is valid scenario in future where this type school appear where a particular school has 10000 records with a singlename,then we need to change the implementation

Suggested solution is serverside paging,AWS elasctic cache,storing data in any non SQL Database like SOLR ,MongoDB ,then search data as the you it has been done.

Please let me know your though on this.

[mayank2k2]

@manasghosh81 , @pankaj44 , This is not the way that systems can't load 10000 records and for this you need to change the implementation. First you send the wrong query result is application is querying for count or actual data.

If we search for first name as test then also it takes time. Please check the code and let me issue.

[manasghosh81]

as discussed with @mayank2k2 ,TCS support team will the discuss different option to implement the sbasic and advance search in terms of restricts and messages and display no of records.The both OUPI and TCS will finalize a requirement after that.The actual implementation will be done after that

[manasghosh81]

@sumitmago ,@mayank2k2 Please let us know the business requirement .TCS team suggestion as follows

For OUP ADMIN The basic search functionality should be hided as there is no business value added to functionality to OUP admin if OUP admin tries to search a user based on firstname or lastname.

If this functionality is needed in terms of business then there should be restriction to fetch the record 200 only.If it founds more that 200 records it should display a message "Please use the advance search since it returns large set of records." Advance search The first parameter should be schoolname(mandatory),Schoolcode-(at least 2 character) FirstName,Username -minimum 3 character Last name-min character needs be decided Roll Number only be given if user selects class and section only

For School admin

Basic search should be there but restricted to 200 users only.If it founds more that 200 records it should display a message "Please use the advance search since it returns large set of records."

Advance search

FirstName,Username -minimum 3 character Last name-min character needs be decided Roll Number only be given if user selects class and section only

[sumitmago]

Dear Mayank, We discussed the design at length in our previous discussion so could you please document that and run it past me again. post that you can share it with Team TCS as a change request.

Thanks & Regards Sumit Mago Head (Digital Solutions) – Learning & Assessment Oxford University Press 2nd Floor, Tower-1, Stellar Crest Business Center, IT Park, C-25 Sector 62, Noida (D) - 0120-6718900 Extn - 214, (M) +91-9873299973

The ABC of Innovation: Conceive Believe Achieve

From: manasghosh81 [mailto:notifications@github.com] Sent: Wednesday, May 11, 2016 6:58 PM To: manasghosh81/OxfrodMaths_Prod Cc: MAGO, Sumit; Mention Subject: Re: [manasghosh81/OxfrodMaths_Prod] Application hang and crash on search (#29)

@sumitmagohttps://github.com/sumitmago ,@mayank2k2https://github.com/mayank2k2 Please let us know the business requirement .TCS team suggestion as follows

For OUP ADMIN The basic search functionality should be hided as there is no business value added to functionality to OUP admin if OUP admin tries to search a user based on firstname or lastname.

If this functionality is needed in terms of business then there should be restriction to fetch the record 200 only.If it founds more that 200 records it should display a message "Please use the advance search since it returns large set of records." Advance search The first parameter should be schoolname(mandatory),Schoolcode-(at least 2 character) FirstName,Username -minimum 3 character Last name-min character needs be decided Roll Number only be given if user selects class and section only

For School admin

Basic search should be there but restricted to 200 users only.If it founds more that 200 records it should display a message "Please use the advance search since it returns large set of records."

Advance search

FirstName,Username -minimum 3 character Last name-min character needs be decided Roll Number only be given if user selects class and section only

— You are receiving this because you were mentioned. Reply to this email directly or view it on GitHubhttps://github.com/manasghosh81/OxfrodMaths_Prod/issues/29#issuecomment-218458613

[mayank2k2]

@manasghosh81 we are working on design.

[mayank2k2]

@manasghosh81 please review the attached design and let me know if you have any question. Application hang and crash on search.docx

[pankaj44]

We are looking into it and let you know if we have any queries.

[mayank2k2]

@pankaj44 , Please update me on this Thanks, mayank.

[pankaj44]

Hi Mayank, I have moved this changes in UAT. Could you please check it and let me know.

[mayank2k2]

not completely fix as send mail to you.

[pankaj44]

I am working on that items.

[pankaj44]

I have done the changes and deployed in QA. Could you please check and let me know.

[mayank2k2]

Nothing is working, if i go to 2 page no data display? sort is also not working

[pankaj44]

Hi Mayank, Could you please let me know the school name so that i can check it from from end. Also What sorting you have done like roll number,user name etc.

[mayank2k2]

Use teacher login.

Thanks, Mayank Mishra

From: pankaj44 [mailto:notifications@github.com] Sent: Friday, August 26, 2016 12:15 PM To: OUPMATH/OxfrodMaths_Prod OxfrodMaths_Prod@noreply.github.com Cc: MISHRA, Mayank Mayank.Mishra@oup.com; Assign assign@noreply.github.com Subject: Re: [OUPMATH/OxfrodMaths_Prod] Application hang and crash on search (#29)

Hi Mayank, Could you please let me know the school name so that i can check it from from end. Also What sorting you have done like roll number,user name etc.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHubhttps://github.com/OUPMATH/OxfrodMaths_Prod/issues/29#issuecomment-242643834, or mute the threadhttps://github.com/notifications/unsubscribe-auth/APfLWheDdsfVI9VAGA2cOK8VZJ0_eGfaks5qjotngaJpZM4IXxyw.

[pankaj44]

Hi Mayank, Could you please check with OUPadmin login.

[mayank2k2]

Pankaj, Have you tested properly, I have ask to test the things properly it is very embracing to get this type of feedback from team.

1. Why button are coming in center now?
2. Why next button clickable and on click it hang.
3. Why the changes are not made in utility search?
4. Why same set of navigation button are showing?
5. Why teachers grid is visible if I search for student ?

[pankaj44]

Hi Mayank, I have tested properly. Could you please refresh you browser and clear the cache and try again.

1. Why button are coming in center now?

It is implemented in that way that you are getting it in center align.Because if page size is greater than 5 than it is left align automatically. All other defect I have checked but did not replicate in my system. Hence it would be better to join Webex and show me.

[pankaj44]

Hi Mayank, Production deployment has been completed. Following entry has been done in web config file

[mayank2k2]

why grid is going out of screen in firefox

[mayank2k2]

working fine in production, so closing the issue