| Subject: | TNA Import Log Screen - Times out |
| Summary: | Tappoos has advised that the "TNA Import Log Screen" times out. Timeout Image:  Event Log Error: - Exception of type 'System.Web.HttpUnhandledException' was thrown.
- Object reference is not set to an instance of an object.
Client Information: - Client Name: Tappoo Group of Companies
- Server: XXXXX
- Version: 13
- Database: Linksoft
They are not willing to share their database and requested to look at this on site. |
| Audit Notes: | Edited by sanjay on 19/07/22 12:02. Edited by sanjay on 19/07/22 08:54. Edited by sanjay on 19/07/22 08:54. Edited by sanjay on 12/07/22 17:57. Edited by aarti on 30/05/22 11:11. |
| 30 May 2022 | 10:43AM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-05-2022 04:42 PM Time Taken: 1.00 |
| Hi Aarti, can you please update the case with version, server and database information ?. Please read the helpdesk guidelines as I cannot help unless I am given sufficient information. Once the case has the details, assign the case to me for a quote to diagnose the issue on-site and the reason why we cannot get the database here in our environment. |
|
| 31 May 2022 | 10:26AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-05-2022 04:22 PM Time Taken: 1.00 Notes: Edited by sanjay on 31/05/22 10:29. |
| Hi Vineet, we can do the diagnostics on their TEST Server. - Give them a days work - 8 hrs. Please add your effort as well as I will need you on the call as well.
- We will need the following access details;
- RDP access to the SQL and Web Servers. Please provide server details with local admin access
- Profiler and SSMS access on the SQL server
- Add details of form names and site details including server specs
|
|
| 09 Jun 2022 | 07:05AM Comment 3 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 10-06-2022 01:00 PM Time Taken: 0.50 Notes: Edited by vineet on 10/06/22 08:49. |
| Hi Sanjay Tappoo has accepted our quote. Please let us know when is it convenient for you to look into this. Server Details:
Unattended Anydesk Detail sent on Skype
Server IP: 192.168.1.101 Server Name: ESSTEST Database Name: LINKSOFT-Tappoo-Training V: 13
Regards |
|
| 12 Jun 2022 | 08:49AM Comment 4 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 16-06-2022 02:46 PM Time Taken: 1.00 Notes: ETC extended from: 24/05/2022 to 16/06/2022 |
| Hi Aarti, please see comment 2. For remote diagnostics, I need RDP/VPN access. We do not use Anydesk. |
|
| 14 Jun 2022 | 03:12PM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 14-06-2022 09:12 PM Time Taken: 2.00 |
| Hi Aarti, I had a discussion with Vineet and he is saying the client is not willing to provide RDP or VPN Access. Without this, diagnostics is very difficult. Please note that you only need to create a development case once work is ready to go ahead. Until then, just have the customer case so there's just one place for discussions. Important Note: - Timeout issues are happening because they are trying to place all companies into one database. Suggest they move sensitive corporate payroll to a separate database so we can quickly address issues in TNA systems.
- Timeout issues will also happen if the DB is not properly tuned especially when you have so many companies and employees in one DB.
- We require RDP or VPN access in order to do performance monitoring using our licenced tools. If an NDA is signed, the client needs to trust their payroll provider. If they do not want to trust, then use option 1 above.
Figure 1 - Skype discussion with Vineet
Vineet, 7:51 AM ok I did not log that. Let me do that now
7:51 AM On a separate note, Tappoo is not willing to set up VPN. As per Prageeth, it is the same as giving you a copy of the database. Are you in a position to respond to him, please. Vineet, Today at 7:18 AM Let's discuss this in a Teams session and do a response together I will close this case for now. We can open once we have all the relevant details and are ready to proceed. You may copy these comments into the customer case and explain/discuss with them. |
|
| 12 Jul 2022 | 05:57PM Comment 6 by Sanjay (Link Technologies) Case L12736 added to project 14.00 |
| 12 Jul 2022 | 05:59PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 12-07-2022 11:57 PM Time Taken: 8.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 14.00 and Patch 13.40.0712 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Added use of Temporary table instead of Table variable to allow Indexing of Filename in the procedure
3. Affected Areas: - Timesheet Import Log Form in LinkSOFT
4. The issue was caused by: - Programming performance Improvement
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 12 Jul 2022 | 06:03PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 12-07-2022 11:59 PM Time Taken: 1.00 |
| 4 hours billing added to licence portal |
|
| 12 Jul 2022 | 06:17PM Comment 9 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-07-2022 12:03 AM Time Taken: 2.00 |
| A patch is available for LinkSOFT 13.40 at this link. |
|
| 19 Jul 2022 | 03:43PM Comment 10 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 19-07-2022 09:34 PM Time Taken: 4.00 |
| Issue verified on client site. Object changes were verified in the test environment and form tested. Closing case. |
|