Vijay Siddha Umesh Kanade Jaideep Vinchurkar Samir Swapnil Pandhare

Hi Rakesh,

We have blown out all Employees from Symphony - Stage (Except one employee named GI Test). Can we load file on Symphony for HSPL copy and verify mentioned below 4 points?

• Not loading all the ppl
• Misaligning the demo info with the ee’s they are attached to
• Applying Auto-enroll coverages
• Having all the ee’s show in the site, not just from the reporting db

The name of the template is Employee Demographic". Import file is attached herewith this ticket.

Thanks & Regards,
Satya Prakash

Hi Jaideep Vinchurkar,

I have break file into 4 parts. My one file contains 1000 records.
File got loaded but immediately after loading it throws message of Import failed.

I can see employees into company but core plans are not allocated.
Can you please check this issue.

Company - Symphony for HSPL

Thanks,
Hrishikesh.

CC : Rakesh Roy Satya

Samir Vijayendra Shinde Vijay Siddha

Hi Jaideep,

I found below error log for this import:

ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData->CopyFileFromServer.CopyFileFromServer
ErrorMessage: Could not find file '\\192.168.30.13\Temp\Encrypt_109_15_2016 06_33_58 AM.txt'.
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput)
TargetSite: System.String SaveAndGetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

It will help troubleshoot issue quickly.

Thanks & Regards,
Satya Prakash

Rakesh Roy Samir Vijay Siddha Swapnil Pandhare

Hi Hrishikesh,

Below issue has been resolved with a workaround.
Service was removing the temp file before completing its processing. As of now, we have disabled this service.

Can you please check by importing file again. I have restored Symphony for HPSL again. We need to acknowledge Jennifer Fernandes soon as UHC is waiting to import these files on main company.

Thanks & Regards,,
Satya Prakash

Hi Satya,

CC:Rakesh RoyVijay SiddhaHrishikesh DeshpandeJaideep VinchurkarSamirSwapnil Pandhare

I have verified this on Symphony For HSPL.
Template:Employee Demographic
file is imported successfully cross verified some random employees through UI as per there eligibility they got core plan also.
Working fine

Thanks & Regards,
Rashmita

Rakesh Roy Hrishikesh Deshpande Rashmita Dudhe Umesh Kanade Swapnil Pandhare Vijay Siddha Samir Jaideep Vinchurkar

Hi Jennifer,

The files can be imported by splitting it in batch of 1000, we have verified this on HSPL copy and it completed successfully with all Core Plans allocation & import backend routines.

Thanks & Regards,
Satya Prakash

Thank you guys!

Will "Below issue has been resolved with a workaround.Service was removing the temp file before completing its processing. As of now, we have disabled this service." be an issue going forward? Is there a fix for this?

Jenni

Hi Jennifer,

Going forward this will not be an issue, since we will be fixing this & deploying patch for it. Jaideep Vinchurkar Will update you its status of permanent fix.

Thanks & Regards,
Satya Prakash

Hi Jaideep,

Please check the Import Timeout issue & core plans not allocated to employee, issue on priority today. Attached is mail communication for recent updates in this.

Thanks & Regards,
Satya Prakash

Deployed test patch on stage for additional logs

We Deleted all employees and Imported all four files having 1000 Employees each on HSPL copy on Stage. The issue was not reproduced.
We will try other scenario's tomorrow.

We are still not able to reproduce this. We will check this with QA team tomorrow and update accordingly.

Please help to repro this issue

Hi Suraj Sokasane

CC:Rakesh Roy,Hrishikesh Deshpande,Jaideep Vinchurkar,Satya

Tried this on Symphony for hspl company on Production
Use Employee Demographic Template
Import file with 4000K records for New hired employee.
Import file with synchronous type
Import failed and logout the site

After the verified on UI employee imported successfully but not got core plan verified more than 10 employee.

Thanks & Regards,
Rashmita

So, It’s reproduced…

From: Rashmita Dudhe (JIRA) jira@workterra.atlassian.net
Sent: Friday, September 30, 2016 3:30 PM
To: rakeshr@harbingergroup.com
Subject: [JIRA] Rashmita Dudhe mentioned you on WT-4845s (JIRA)

<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=rashmita.dudhe>Rashmita Dudhe mentioned you on<https://workterra.atlassian.net/browse/WT-4845> Support ActivityWT-4845 <https://workterra.atlassian.net/browse/WT-4845> Re: UHC - Symphony - Issuewith Data Load - Need resolution ASAP - StageHi<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=suraj.sokasane> Suraj SokasaneCC: <https://workterra.atlassian.net/secure/ViewProfile.jspa?name=rakeshr>Rakesh Roy,<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=hrishikesh.deshpande> Hrishikesh Deshpande,<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=jaideep.vinchurkar> Jaideep Vinchurkar,<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=satyap> SatyaTried this on Symphony for hspl company on ProductionUse Employee Demographic TemplateImport file with 4000K records for New hired employee.Import file with synchronous typeImport failed and logout the site <https://workterra.atlassian.net/secure/attachment/28307/28307_image_vY.png>After the verified on UI employee imported successfully but not got coreplan verified more than 10 employee.Thanks & Regards,Rashmita <https://workterra.atlassian.net/browse/WT-4845#add-comment> Add Comment <https://workterra.atlassian.net/browse/WT-4845#add-comment> Add CommentThis message was sent by Atlassian JIRA (v1000.383.2#100014-sha1:783d425)Atlassian logo

There are two issues in synchronous import right now:

1. We give three calls for different routines from web. For large files, Import takes too much time and sometimes session is logged out before giving call to second routine i.e Core plan allocation.

2. Which routine to be called next is saved in a session. Again in case of large files, the routine number is not incremented. and same routine is called two times. Either Core plan or Import Data is called two times. when Import Data is called two times, second time file does not exist on web and hence import is failed and next routines are cancelled.

In both above scenario's core plans does not get executed. This issue rarely gets reproduced and not always. We already have logs on App and above conclusions are derived from those.

We will push logs on web tomorrow. This will help us to find the root cause of the issue and we will take the necessary action as soon as possible.

Note : There isn't any problem with Asynchronous import. Jaideep has already mentioned in mail. until we resolve the issue please use asynchronous import for large files.

Sorry for the Inconvenience caused.

Verfied on production on Symphony for hspl company tried synchronous import by using file
1]500 records :Import Getting failed
2]1000 records: Import Getting failed
3]1500 records :import done successfully and core plan allocated successfully.
4]2000 records:Import Getting failed

please check

Verified after Lb Environment
1]500 records :import done successfully and core plan allocated successfully.
2]1000 records: import done successfully and core plan allocated successfully.
3]1500 records :Import Getting failed
4]2500 records:Import Getting failed

Below is error log:

ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->CopyFileFromServer.CopyFileFromServer
ErrorMessage: Could not find file '\\10.0.2.125\Temp\Encrypt_Symphony_300010_06_2016 12_06_27 PM.txt'.

We need your expertise on this. Could you please help?

Hi All -

UHC is having the same issue with a different client - can you look at WT-5315

Jenni

Hi Jennifer Johnson WT-5315 is a different issue.

This issue is about data imported successfully but core plans not allotted, or some times import failed. Saurabh Sablaka was working on this and a fix is deployed on local environment. We will push this to Stage and Prod on priority.

Where as WT-5315 is about demographics import where Employees are imported successfully but users are not created.

Verified on LB environment:
Verified after Lb Environment
1]500 records :import done successfully and core plan allocated successfully.
2]1000 records: import done successfully and core plan allocated successfully.
3]1500 records : import done successfully and core plan allocated successfully.
4]2500 records: import done successfully and core plan allocated successfully.
5]3000 records only eligibility failed
6]3500 records import failed

see below error-log:
Error_Log:

ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->CopyFileFromServer.CopyFileFromServer
ErrorMessage: Could not find file '\\10.0.2.125\Temp\Encrypt_SYMP-350010_09_2016 03_50_37 PM.txt'.

===============================================
Process Name : ImportData
Template Name : _Wheaton_Weekly_Employee_Census
Company ID : 12059
Error Source : WTIsolatedRoutines.Main
Error Message : Object reference not set to an instance of an object.
===============================================

CC:Jaideep Vinchurkar,Suraj Sokasane

Rashmita Dudhe Jaideep Vinchurkar

Please recheck this issue, I tried with 3k & 5k file load on same company on LB, I did not get any exception.

Hi Saurabh Sablaka,
I have gain tried this on LB on

but getting same issue Import Failed only for 1000 records showing below error
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->CopyFileFromServer.CopyFileFromServer
ErrorMessage: Could not find file '\\10.0.2.120\Temp\Encrypt_Symphony_100010_11_2016 05_39_14 PM.txt'.

Thanks,
Rashmita

On hold for discussion with Saurabh Sablaka.

As per discussion with Saurabh, we need to start this from Repro. My action item here is create a scenario and reproduce the issue on local environment. Saurabh will then help in finding the solution.

Due to short bandwidth we have not picked this.

Looking at efforts put on this and not getting reproduced, closing this ticket.

Will create new ticket or re-open this in case it occurred again.

Regards,
Satya Prakash

Cc: Jaideep Vinchurkar Rakesh Roy Suraj Sokasane Vijay Siddha