-
Type:
Bug
-
Status: Done
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: Enhancements - Fall
-
Labels:None
-
Company:All Clients/Multiple Clients
Environment: Preprod
Login: Admin
Browser: FF and Chrome
Steps:
1. Admin lofin
2. Send Forms
3. PDF Template > Next
4. Update details > Preview
5. Error
Expected: Admin should able to preview PDF document.
Refer screen capture.
Sachin Hingole Hrishikesh Deshpande Rohan J Khandave Narendra Kumar
Hi Harshveer Singh,
As communicated earlier over slack - SELECT ColumnName, TRIM(GROUP_CONCAT(ColumnValue SEPARATOR ' ')) ColumnValue, RightsID from FinalOutPutValues GROUP BY ColumnName; in DMS_SP_GetTemplateFormMappedDetails is causing issue while previewing if Signature is present.
If above line is replaced with SELECT ColumnName, ColumnValue, RightsID from FinalOutPutValues; then Preview and submit works successfully.
Please verify this scenario.
CC: Ganesh Sadawarte,Rohan J Khandave,Samir
Ramya Tantry (Inactive)
added a comment - Hi Harshveer Singh ,
As communicated earlier over slack - SELECT ColumnName, TRIM(GROUP_CONCAT(ColumnValue SEPARATOR ' ')) ColumnValue, RightsID from FinalOutPutValues GROUP BY ColumnName; in DMS_SP_GetTemplateFormMappedDetails is causing issue while previewing if Signature is present.
If above line is replaced with SELECT ColumnName, ColumnValue, RightsID from FinalOutPutValues; then Preview and submit works successfully.
Please verify this scenario.
CC: Ganesh Sadawarte , Rohan J Khandave , Samir
Cause for this issue was that on MySql server configuration, for group_concat function, max length was set to 1024, which was truncating signature field value.
On server this limit is now increased to 65535 to fix this issue.
Harshveer Singh (Inactive)
added a comment - Cause for this issue was that on MySql server configuration, for group_concat function, max length was set to 1024, which was truncating signature field value.
On server this limit is now increased to 65535 to fix this issue. Verified on Preproduction.
Login - Admin
Verified Preview for PDF document.
Able to preview and Send the document
Also able to sign and submit the document through candidate login.
PFA - 
Closing this ticket
Thanks,
Jayshree
Jayshree Nagpure (Inactive)
added a comment - Verified on Preproduction.
Login - Admin
Verified Preview for PDF document.
Able to preview and Send the document
Also able to sign and submit the document through candidate login.
PFA -
Closing this ticket
Thanks,
Jayshree
Priya Dhamande Hrishikesh Deshpande Sachin Hingole 
Mohd Belal