Subject: | "String or binary data would be truncated" error in payroll upload template. |
Summary: | 1. Problem Details While uploading data for a new payroll client, when uploading employee profile, the following error was received "String or binary data would be truncated" The position tagged to the employee getting this error, gets marked as "Active" in the database.
2. Error Message (Include screenshot of error) "String or binary data would be truncated"
|
Audit Notes: | |
16 Nov 2016 | 08:16AM Comment 1 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 16-11-2016 08:16 AM |
| Hi Aarti, There isn't much in this case for me to investigate. Can you upload the excel template used? |
|
16 Nov 2016 | 08:28AM Comment 2 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 16-11-2016 08:28 AM Time Taken: 0.75 |
| Dear Alvis, Please find attached excel. |
|
16 Nov 2016 | 10:50AM Comment 3 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 16-11-2016 10:50 AM |
| Hi Aarti, the problem is to do with Address line 1. Can you limit the address to 50 characters long. |
|
18 Nov 2016 | 08:49AM Comment 4 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 18-11-2016 08:49 AM Time Taken: 1.00 |
| Dear Alvis, After fixing the address field, I was able to upload data successfully, however, when the excel gives this error “String or binary data would be truncated", the position gets tagged as “active” in the database. When the position audit report is generated, this active position does not have any corresponding employee entry. Refer to image below:
Regards Aarti
|
|
18 Nov 2016 | 10:13AM Comment 5 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 18-11-2016 10:13 AM |
| Hi Aarti, I will change the template to separate residential and postal address, this will resolve the "binary string error". Can you log a separate case for the customer to data fix the position status? |
|
21 Nov 2016 | 02:08PM Comment 6 by Alvis (Link Technologies) Case 8119 added to project 8.07.24 |
22 Nov 2016 | 11:08AM Comment 7 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 22-11-2016 11:08 AM Time Taken: 2.00 |
| Development work for this case has been completed. Please note the following: The change will be available in version: 8.07.024 Documentation update required: No QA required: Yes Additional details: The employee sheet only has address 1, address 2 and address3. This address was being populated on the residential and postal address in the database. We have renamed the sheet to display residential address1/2/3 and will be populated to residential address. Residential address allows upto 255 characters on each field to be uploaded. |
|
08 Dec 2016 | 03:24PM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 08-12-2016 03:24 PM Time Taken: 3.00 |
| 1. Was this test completed using Demo / New / Other database? DEMO 2. Did the test pass or fail? Pass 3. Tab order, spelling, alignment, font size consistency, screen size etc checked? NA 4. Data verified, saved, edit, delete/void? Yes 5. Documentation update required? No
Additional Details (Risks, issues, special conditions required for this test to pass etc): |
|