| Subject: | Unable to generate the "Inventory Movement Report". Error relating to data truncation |
| Summary: | Section A - Describe what the issue is about. Include Error Message (Include screenshots) With reference to L12693, we tried to generate the "Inventory Movement Report" but faced an error: String or binary data would be truncated. Figure 1: Inventory Movement Report Filter 
Figure 2: Inventory Movement Report 
Table 1: Environment Details where this issue can be seen
| Server Name: | LINKQA8 | | Database name: | Dannys-LinkSOFT-UAT | | Application Hosted on: | QA8 | | Login User ID/Password: | admin, admin | | Client Operating System: | | | LinkSOFT Version: | 13.30 |
|
| Audit Notes: | Edited by sanjay on 24/03/22 14:27. Edited by sanjay on 24/03/22 14:04. Edited by sanjay on 18/03/22 11:34. Edited by aarti on 17/03/22 14:52. |
| 18 Mar 2022 | 11:34AM Comment 1 by Sanjay (Link Technologies) Case L12694 added to project 13.40 |
| 18 Mar 2022 | 12:11PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 18-03-2022 06:10 PM Time Taken: 6.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 13.40 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Increased the size of "ReferenceNo" as we add other notes into this field
3. Affected Areas: - Inventory Movement Report
4. The issue was caused by: - Programming Error
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT |
|
| 18 Mar 2022 | 02:10PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 18-03-2022 08:10 PM |
| Added to Patch 13.30.0318 |
|
| 24 Mar 2022 | 02:27PM Comment 4 by Sanjay (Link Technologies) ETC was changed from 18/03/2022 to 18/03/2022 |
| 05 Apr 2022 | 10:57AM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 05-04-2022 04:54 PM Time Taken: 2.00 |
|
The following tests were performed:
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Generate a report where the Reference number > 50 characters
| The report generates without errors
| Pass
|
|
Environment Details - OS version: Win10
- Application version: 13.40
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|