========================CORE PLAN ALLOCATION========================== CompanyID: 12013 TemplateID: 39 DateTimeStamp: 8/1/2016 6:16:56 PM Core Plan Allocation Start Time: 6:16:40 PM Core Plan Allocation End Time: Credit Calculation Start Time: Credit Calculation End Time: ========================CORE PLAN ALLOCATION========================== ErrorLogPath: D:\Temp\OnlineEnrollmentErrorLog\, File Name : 81201661656PM_-19_12013.txt Error At CorePlanAllocation->LogRaisedError : Parent Message Company ID: 12013 Template : 39 ----------------Error : Import Back End Routines - Core Plan Allocation Routine---------- Error Message : Conversion from type 'DBNull' to type 'Integer' is not valid. Error Source : CorePlanAllocation.ActualCorePlanAllocation->EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk_CorePlan->EnrollmentBulkInsert.ProcessDataForEnrollmentCoverage->EnrollmentBulkInsert.TerminatingDuplicateEntryRelatedToEnrollment Stack Trace : at WORKTERRA.EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk_CorePlan(String strEmployeeList, String EffectiveDate, ArrayList EnrollmentArray, Int64 I_UserID, Int64 I_CompanyID, Int32 IsCompanyUser, Int32 BenefitTypeID, Boolean AllowMultipleEnrollment, Boolean includeCoverage, Boolean TerminateDuplicateEnrollment, Boolean DeleteIntermediateForRetro, String& strTerminatedPlanDesignID, Boolean IsCalledByCoreAllocation, Boolean calculateRates) at WORKTERRA.CorePlanAllocation.ActualCorePlanAllocation(String EmployeeIDs, String PlanDesignIDs, Int64 UserID, Int64 CompanyID, Boolean IsForService, Boolean IsEffectiveDate, Boolean IsCallFromPlanDesign, Int32 IsCompanyUser, String inputCoverageString, String EmployeeStatusID) Routine Failed for EmployeeID | PlandesignID : 1878,1881,1882,1883,1884,1886,1890,1891,1895,1896,1897,1898,1899,1901,1902,1903,1904,1905,1907,1909,1910,1911,1912,1913,1914,1916,1918,1921,1922,1923,1926,1927,1928,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1946,1947,1949,1950,1951,1952,1954,1955,1956,1957,1958,1959,1960,1961,1963,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1977,1978,1979,1980,1982,1983,1984,1985,1988,1989,1990,1991,1992,1993,1994,1995,1996,1998,1999,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2020,2023,2024,2025,2027,2028,2029,2030,2031,2032,2034,2035,2037,2038,2039,2040,2041,2042,2043,2044,2046,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2063,2064,2065,2066,2069,2070,2071,2072,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2088,2089,2090,2116,2117,2118,2121,2123,2125,2126,2127,2128,2129,2131,2132,2133,2134,2135,2137,2138,2139,2140,2141,2142,2143,2144,2145,2147,2148,2149,2150,2151,2152,2153,2154,2155,2157 | 29 -------------------------------------------------------------------------------- , Exception Message : Could not find a part of the path 'D:\Temp\OnlineEnrollmentErrorLog\81201661656PM_-19_12013.txt'. ====================== Election Eligibility Check ====================== ErrorLogPath: D:\Temp\OnlineEnrollmentErrorLog\, File Name : 81201663805PM_-19_12013.txt Error At CorePlanAllocation->LogRaisedError : Parent Message Company ID: 12013 Template : 39 ----------------Error : Import Back End Routines - Update on Salary Change Routine---------- Error Message : Conversion from type 'DBNull' to type 'Integer' is not valid. Error Source : UpdateOnSalaryChanges.InsertUpdateEnrollmentTable->EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk->EnrollmentBulkInsert.ProcessDataForEnrollmentCoverage->EnrollmentBulkInsert.TerminatingDuplicateEntryRelatedToEnrollment Stack Trace : at WORKTERRA.EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk(String strEmployeeList, String EffectiveDate, ArrayList EnrollmentArray, Int64 I_UserID, Int64 I_CompanyID, Int32 IsCompanyUser, Boolean includeCoverage, Boolean TerminateDuplicateEnrollment, Boolean DeleteIntermediateForRetro, Int32 I_BenefitTypeID, String& strTerminatedPlanDesignID, Boolean calculateRates, ArrayList arrReductionScheduleArray, Boolean IsRelationshipChanged, Int64 MemberID, Int64 MemberTypeID) at WORKTERRA.UpdateOnSalaryChanges.InsertUpdateEnrollmentTable() Routine Failed for Employee : 1914 -------------------------------------------------------------------------------- ----------------Error : Import Back End Routines - Update on Salary Change Routine---------- Error Message : Conversion from type 'DBNull' to type 'Integer' is not valid. Error Source : UpdateOnSalaryChanges.InsertUpdateEnrollmentTable->EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk->EnrollmentBulkInsert.ProcessDataForEnrollmentCoverage->EnrollmentBulkInsert.TerminatingDuplicateEntryRelatedToEnrollment Stack Trace : at WORKTERRA.EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk(String strEmployeeList, String EffectiveDate, ArrayList EnrollmentArray, Int64 I_UserID, Int64 I_CompanyID, Int32 IsCompanyUser, Boolean includeCoverage, Boolean TerminateDuplicateEnrollment, Boolean DeleteIntermediateForRetro, Int32 I_BenefitTypeID, String& strTerminatedPlanDesignID, Boolean calculateRates, ArrayList arrReductionScheduleArray, Boolean IsRelationshipChanged, Int64 MemberID, Int64 MemberTypeID) at WORKTERRA.UpdateOnSalaryChanges.InsertUpdateEnrollmentTable() Routine Failed for Employee : 1965 -------------------------------------------------------------------------------- ----------------Error : Import Back End Routines - Update on Age Change Routine---------- Error Message : Item has already been added. Key in dictionary: '1978' Key being added: '1978' Error Source : UpdateOnAgeChanges.ApplyRuleOnAgeChange_Import->RatesCalculation.GetCostForHealthBenefitType_ForEmployeeDataChange->RatesCalculation.GetCostForLifeAndLTDBenefitType_EmployeeDataChange->RatesCalculation.GetTeminationDateApplyingTerminationDatePolicy_EDC Stack Trace : at WORKTERRA.RatesCalculation.GetCostForHealthBenefitType_ForEmployeeDataChange(String I_EmployeeIDs, String I_PlanDesignID, DateTime I_EffectiveDate, Hashtable I_EnrollmentHash, Boolean I_IsFuture, Int64 pCompanyid, Int64 pUserID, Boolean IsFromService, Boolean bFromEnrollNow, Boolean bFromUpdateOnSalaryChange) at WORKTERRA.UpdateOnAgeChanges.ApplyRuleOnAgeChange_Import(Int64 CompanyID, Int64 UserID, String EmployeeID, DateTime EffectiveDate, String MasterEnrollmentIDs, String IntermediateEnrollmentIDs, Hashtable& AgeBandedCreditTerminationDateHash) Routine Failed for Employee : 978,1232,1151,1853,1517,1832,1049,1346,958,2155,1183,1750,2025,1033,1361,1608,1529,1761,2188,1340,1065,1965,2152,1755,1255,968,1614,970,1638,1179,1565,1956,1464,948,2074,2246,1580,1169,977,1257,1294,1224,1584,1847,1688,936,2153,1897,1120,1490,1018,1119,1247,2116,1610,2195,1895,1180,1386,1402,2039,2178,1646,1995,1093,1678,1447,1596,1969,1339,1592,1067,1414,1295,2213,2014,1350,1098,1016,1271,1439,1671,1302,1966,1045,1329,2245,1429,1091,1159,1082,1921,938,1211,1633,2004,1304,1134,1369,1175,1292,2030,2236,1377,1278,1277,1545,1613,1213,1508,2048,1803,1466,1753,1587,1781,1280,1072,1344,1844,1472,1916,1086,1203,1856,1060,1513,1162,1874,1233,1110,1316,1666,1085,2125,2137,2034,1588,1205,1800,1705,1834,1419,2086,1561,1389,1620,2121,1218,2163,1780,1057,1322,997,1450,1922,1001,1207,1066,991,2201,2051,1358,1114,2002,1234,1782,1107,1978,1704,1131,2088,1534,2216,1388,1029,1333,981,1489,1307,1751,1412,2007,1835,1656,1539,1495,1142,2192,1223,1793,1694,1693,2133,1108,999,1336,1152,1148 -------------------------------------------------------------------------------- ----------------Error : Import Back End Routines - Update on Salary Change Routine---------- Error Message : Conversion from type 'DBNull' to type 'Integer' is not valid. Error Source : UpdateOnSalaryChanges.InsertUpdateEnrollmentTable->EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk->EnrollmentBulkInsert.ProcessDataForEnrollmentCoverage->EnrollmentBulkInsert.TerminatingDuplicateEntryRelatedToEnrollment Stack Trace : at WORKTERRA.EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk(String strEmployeeList, String EffectiveDate, ArrayList EnrollmentArray, Int64 I_UserID, Int64 I_CompanyID, Int32 IsCompanyUser, Boolean includeCoverage, Boolean TerminateDuplicateEnrollment, Boolean DeleteIntermediateForRetro, Int32 I_BenefitTypeID, String& strTerminatedPlanDesignID, Boolean calculateRates, ArrayList arrReductionScheduleArray, Boolean IsRelationshipChanged, Int64 MemberID, Int64 MemberTypeID) at WORKTERRA.UpdateOnSalaryChanges.InsertUpdateEnrollmentTable() Routine Failed for Employee : 1930 -------------------------------------------------------------------------------- ----------------Error : Import Back End Routines - Update on Salary Change Routine---------- Error Message : Conversion from type 'DBNull' to type 'Integer' is not valid. Error Source : UpdateOnSalaryChanges.InsertUpdateEnrollmentTable->EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk->EnrollmentBulkInsert.ProcessDataForEnrollmentCoverage->EnrollmentBulkInsert.TerminatingDuplicateEntryRelatedToEnrollment Stack Trace : at WORKTERRA.EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk(String strEmployeeList, String EffectiveDate, ArrayList EnrollmentArray, Int64 I_UserID, Int64 I_CompanyID, Int32 IsCompanyUser, Boolean includeCoverage, Boolean TerminateDuplicateEnrollment, Boolean DeleteIntermediateForRetro, Int32 I_BenefitTypeID, String& strTerminatedPlanDesignID, Boolean calculateRates, ArrayList arrReductionScheduleArray, Boolean IsRelationshipChanged, Int64 MemberID, Int64 MemberTypeID) at WORKTERRA.UpdateOnSalaryChanges.InsertUpdateEnrollmentTable() Routine Failed for Employee : 1910 -------------------------------------------------------------------------------- ----------------Error : Import Back End Routines - Update on Salary Change Routine---------- Error Message : Conversion from type 'DBNull' to type 'Integer' is not valid. Error Source : UpdateOnSalaryChanges.InsertUpdateEnrollmentTable->EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk->EnrollmentBulkInsert.ProcessDataForEnrollmentCoverage->EnrollmentBulkInsert.TerminatingDuplicateEntryRelatedToEnrollment Stack Trace : at WORKTERRA.EnrollmentBulkInsert.InsertUpdateEnrollmentInBulk(String strEmployeeList, String EffectiveDate, ArrayList EnrollmentArray, Int64 I_UserID, Int64 I_CompanyID, Int32 IsCompanyUser, Boolean includeCoverage, Boolean TerminateDuplicateEnrollment, Boolean DeleteIntermediateForRetro, Int32 I_BenefitTypeID, String& strTerminatedPlanDesignID, Boolean calculateRates, ArrayList arrReductionScheduleArray, Boolean IsRelationshipChanged, Int64 MemberID, Int64 MemberTypeID) at WORKTERRA.UpdateOnSalaryChanges.InsertUpdateEnrollmentTable() Routine Failed for Employee : 1905 -------------------------------------------------------------------------------- ----------------Error : Import Back End Routines - Update on Age Change Routine---------- Error Message : Item has already been added. Key in dictionary: '1926' Key being added: '1926' Error Source : UpdateOnAgeChanges.ApplyRuleOnAgeChange_Import->RatesCalculation.GetCostForHealthBenefitType_ForEmployeeDataChange->RatesCalculation.GetCostForLifeAndLTDBenefitType_EmployeeDataChange->RatesCalculation.GetTeminationDateApplyingTerminationDatePolicy_EDC Stack Trace : at WORKTERRA.RatesCalculation.GetCostForHealthBenefitType_ForEmployeeDataChange(String I_EmployeeIDs, String I_PlanDesignID, DateTime I_EffectiveDate, Hashtable I_EnrollmentHash, Boolean I_IsFuture, Int64 pCompanyid, Int64 pUserID, Boolean IsFromService, Boolean bFromEnrollNow, Boolean bFromUpdateOnSalaryChange) at WORKTERRA.UpdateOnAgeChanges.ApplyRuleOnAgeChange_Import(Int64 CompanyID, Int64 UserID, String EmployeeID, DateTime EffectiveDate, String MasterEnrollmentIDs, String IntermediateEnrollmentIDs, Hashtable& AgeBandedCreditTerminationDateHash) Routine Failed for Employee : 1903,1544,1422,1809,1855,1972,1695,1846,1157,2008,1308,1967,1416,2003,1138,1831,1409,1837,2187,1598,1845,1036,2027,1697,973,1679,2141,1821,1279,1790,1186,1455,1160,1371,953,1222,1363,2162,1078,1269,1687,1813,1478,1890,1766,935,1367,2218,1191,1445,1594,1792,1436,963,2129,2127,1714,1272,1681,1209,1398,943,1926,2206,1197,2015,1625 -------------------------------------------------------------------------------- , Exception Message : Could not find a part of the path 'D:\Temp\OnlineEnrollmentErrorLog\81201663805PM_-19_12013.txt'.