Now if the check box is checked then Save > server error appears again.

So, need to cancel previous Invoice and create new one.

Hi Priya Dhamande,

Following are the 3C's:
Concern:
Server error on saving Invoice Template.

Cause:
There was an issue in script to check duplicate template.

Correction:
We have corrected the script. Will get deployed in tomorrow's Stage patch.
As of now script is executed on City of Walnut Creek.

cc: Vijay Siddha, Satya, Rakesh Roy

Tested on WT Stage - TIBCO - 14th Dec 2016

We kept Benefit Wise Billing Report checked and unchecked - saved the template - fetched out invoices and exported in excel - everything worked well
[testing Invoice with Benefit Wise Billing Report unchecked does not cover any data / functionality verification]

Ready for Stage

CC - Deepali Tidke Hrishikesh Deshpande Rakesh Roy Venkatesh PujariPrasanna Karlekar

This was deployed on 9th Dec 2016 on Stage and Production as it was blocking issue. Templates could not be created.

Tested on Stage (long for hspl) and Production (asml for hspl) - 19th Dec 2016

When tried to download the invoice excel -

Server Error - Stage
Input Output Error - Production

CC - Deepali Tidke Rakesh Roy Venkatesh Pujari Hrishikesh Deshpande

Hi Alankar Chavan,

The recent issue mentioned is for Export to Excel and fix given is for error appearing on Template creation.
Both are not related. If issue still persist, please create different ticket for excel scenario.

Tested on Stage
Worked well on few companies

Giving server error on TIBCO for HSPL (when a template made with Benefit Wise Billing Report un-ticked- invoice fetched and clicked on Export to Excel control. I had selected Dental and Vision types in the template)

Error Log -

Exception : Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.
App Error Log : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->InvoiceDetails.SaveAndGetData->InvoiceDataSet.InvoiceCreateExcelFile->InvoiceDataSet.CreateFileAndExportInvoiceInExcel
Employee ID : 0
Action Name : CreateInvoiceFile
Model : System.Web.Mvc.HandleErrorInfo
Controller : Report
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.SaveAndGetData(ObjectType I_objectType, Object objInputObject, Object I_context, Hashtable I_criteria, Boolean I_mode, Boolean I_needCollection)
at WORKTERRA.BenAdmin.Areas.Report.Models.InvoiceManagement.ViewInvoiceModel.CreateInvoiceFile(String FilePath, String FileName, String IsExcel, String DownloadInvoiceListID)

CC - Prasanna Karlekar Venkatesh Pujari Rakesh Roy Hrishikesh Deshpande

Hi Rakesh Roy,

This issue was initially mentioned for server error coming on customization screen. But this issue is always getting reopened for different reasons which are no where related to the fix done.

cc: Alankar Chavan, Venkatesh Pujari, Sachin Hingole, Satya

Venkatesh -
Assigning this JIRA to you. Issue for which JIRA was created is already fixed. It is reopen for different reason.
Please do the needful.

cc: Sachin Hingole

Tested on Stage - AFI For Hspl company - 27th Feb 2017
We kept Benefit Wise Billing Report checked and unchecked - saved the template

Ready for Production

Tested on Production - AFI For Hspl company - 16th March 2017
We kept Benefit Wise Billing Report checked and unchecked - saved the template

Prasanna Karlekar,Priya Dhamande

Thanks,
Venkatesh