2012-10-09 22:26:00,201  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:85) - Executing job[ MAIL_JOB_5115275 ]
2012-10-09 22:26:00,202  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:131) - MapScheduler_Worker-9 program object 20121009 Full Volume List Test
2012-10-09 22:26:00,202  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:133) - Running Program Name 20121009 Full Volume List Test
2012-10-09 22:26:00,207  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:150) - Trying to get the organization properties
2012-10-09 22:26:00,207  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:153) - Have the organization properties with ID: 43
2012-10-09 22:26:00,250  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:162) - GOING TO ITERATE OVER THE CELLS FOR THE LISTS.
2012-10-09 22:26:00,251  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:168) - 20121009 Inactive Exclusion Cell Name and Cell ID 5170152
2012-10-09 22:26:00,251  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:172) - 5252901 IS THE List ID
2012-10-09 22:26:00,262  INFO [MapScheduler_Worker-9] (ListDAOConnector.java:274) - RETURNING CONNECTION STRING [ jdbc:jtds:sqlserver://10.100.100.53:1433/RLL_CDM;user=workb
ench;password=******** ]
2012-10-09 22:26:00,265  INFO [MapScheduler_Worker-9] (MailerFacade.java:120) - List query [ SELECT e.EMAIL_ADDR as EMAIL_ADDR,
e.RUELALA_ID as RUELALAID,
e.EMAIL_DIM_ID as EMAIL_DIM_ID,
e.CUSTOMER_DIM_ID as CUSTOMER_DIM_ID,
'<<Workbench.cell.cellCd>>' as CPCELLCD,
'<<Workbench.cell.cellCodeOne>>' as CPSEGMENTCD,
'<<Workbench.cell.cellCodeTwo>>' as VERSIONCD,
--'<<Workbench.cell.cellCodeThree>>' as CORESEGMENTCD,
'abcd1234' as CORESEGMENTCD,
-- DATES are adjusted bc we are sending the 11am audience file 1 day before the mailing
case when e.DAYS_AS_MEMBER + 1 = 2 then 4157 when e.DAYS_AS_MEMBER + 1 in (3, 4) then 4158 else 1023 end as AID,
e.PURL as PERSONALINVITELINK,
e.FIRST_NM as FIRSTNAME,
e.LAST_NM as LASTNAME,
e.ACCOUNT_BALANCE as CREDITBALANCE,
case when e.DAYS_REMAINING>1 then e.DAYS_REMAINING  - 1 else 0 end DAYSLEFT,
case when e.DAYS_REMAINING>1 then 'Y' else 'N' end as DAYSFLAG,
case when e.DAYS_REMAINING>1 then e.SHOPPER_PROGRAM_ID else 0 end  as PROGRAMID,
e.SHOPPER_PROGRAM_FLG as PROGRAMFLAG,
e.LOCAL_REGION_ID as LOCALREGIONID,
case when e.DAYS_AS_MEMBER <=98 then e.DAYS_AS_MEMBER + 1
         else 0 end as EVERGREENBOUTIQUEFLAG
from dbo.VW_Emailable_MEMBERS e
where e.STATUS_ID=3
and exists (select 1 from EDIALOG_INACTIVE_20121009 i where e.RUELALA_ID=i.RUELALAID)
and not exists (select 1 from F_ORDER_HEADER o inner join D_DATE d on o.order_Date_DIM_ID=d.date_DIM_ID
                                where e.rue_account_DIM_ID=o.rue_account_DIM_ID
                                and the_date >='10/1/2012')
 ]
2012-10-09 22:26:00,265  INFO [MapScheduler_Worker-9] (MailerFacade.java:1407) -  Constructed List Query with Workbench Parameters : [SELECT e.EMAIL_ADDR as EMAIL_ADDR,
e.RUELALA_ID as RUELALAID,
e.EMAIL_DIM_ID as EMAIL_DIM_ID,
e.CUSTOMER_DIM_ID as CUSTOMER_DIM_ID,
'TEST_Inactive' as CPCELLCD,
'2' as CPSEGMENTCD,
'1' as VERSIONCD,
--'<<Workbench.cell.cellCodeThree>>' as CORESEGMENTCD,
'abcd1234' as CORESEGMENTCD,
-- DATES are adjusted bc we are sending the 11am audience file 1 day before the mailing
case when e.DAYS_AS_MEMBER + 1 = 2 then 4157 when e.DAYS_AS_MEMBER + 1 in (3, 4) then 4158 else 1023 end as AID,
e.PURL as PERSONALINVITELINK,
e.FIRST_NM as FIRSTNAME,
e.LAST_NM as LASTNAME,
e.ACCOUNT_BALANCE as CREDITBALANCE,
case when e.DAYS_REMAINING>1 then e.DAYS_REMAINING  - 1 else 0 end DAYSLEFT,
case when e.DAYS_REMAINING>1 then 'Y' else 'N' end as DAYSFLAG,
case when e.DAYS_REMAINING>1 then e.SHOPPER_PROGRAM_ID else 0 end  as PROGRAMID,
e.SHOPPER_PROGRAM_FLG as PROGRAMFLAG,
e.LOCAL_REGION_ID as LOCALREGIONID,
case when e.DAYS_AS_MEMBER <=98 then e.DAYS_AS_MEMBER + 1
         else 0 end as EVERGREENBOUTIQUEFLAG
from dbo.VW_Emailable_MEMBERS e
where e.STATUS_ID=3
and exists (select 1 from EDIALOG_INACTIVE_20121009 i where e.RUELALA_ID=i.RUELALAID)
and not exists (select 1 from F_ORDER_HEADER o inner join D_DATE d on o.order_Date_DIM_ID=d.date_DIM_ID
                                where e.rue_account_DIM_ID=o.rue_account_DIM_ID
                                and the_date >='10/1/2012')
]
2012-10-09 22:26:00,265  INFO [MapScheduler_Worker-9] (MailerFacade.java:123) - List query with WB Parameters [ SELECT e.EMAIL_ADDR as EMAIL_ADDR,
e.RUELALA_ID as RUELALAID,
e.EMAIL_DIM_ID as EMAIL_DIM_ID,
e.CUSTOMER_DIM_ID as CUSTOMER_DIM_ID,
'TEST_Inactive' as CPCELLCD,
'2' as CPSEGMENTCD,
'1' as VERSIONCD,
--'<<Workbench.cell.cellCodeThree>>' as CORESEGMENTCD,
'abcd1234' as CORESEGMENTCD,
-- DATES are adjusted bc we are sending the 11am audience file 1 day before the mailing
case when e.DAYS_AS_MEMBER + 1 = 2 then 4157 when e.DAYS_AS_MEMBER + 1 in (3, 4) then 4158 else 1023 end as AID,
e.PURL as PERSONALINVITELINK,
e.FIRST_NM as FIRSTNAME,
e.LAST_NM as LASTNAME,
e.ACCOUNT_BALANCE as CREDITBALANCE,
case when e.DAYS_REMAINING>1 then e.DAYS_REMAINING  - 1 else 0 end DAYSLEFT,
case when e.DAYS_REMAINING>1 then 'Y' else 'N' end as DAYSFLAG,
case when e.DAYS_REMAINING>1 then e.SHOPPER_PROGRAM_ID else 0 end  as PROGRAMID,
e.SHOPPER_PROGRAM_FLG as PROGRAMFLAG,
e.LOCAL_REGION_ID as LOCALREGIONID,
case when e.DAYS_AS_MEMBER <=98 then e.DAYS_AS_MEMBER + 1
         else 0 end as EVERGREENBOUTIQUEFLAG
from dbo.VW_Emailable_MEMBERS e
where e.STATUS_ID=3
and exists (select 1 from EDIALOG_INACTIVE_20121009 i where e.RUELALA_ID=i.RUELALAID)
and not exists (select 1 from F_ORDER_HEADER o inner join D_DATE d on o.order_Date_DIM_ID=d.date_DIM_ID
                                where e.rue_account_DIM_ID=o.rue_account_DIM_ID
                                and the_date >='10/1/2012')
 ]
2012-10-09 22:34:43,389  INFO [MapScheduler_Worker-9] (MailerFacade.java:881) - Top of createListFile, trying to create program list file [ /ftp_home/workbench_lists_generat
ed/RUELALA_CP_20121009 Full Volume List Test_20121009223443.csv ]
2012-10-09 22:35:22,390  INFO [MapScheduler_Worker-9] (MailerFacade.java:1002) - CREATED HashMap outboundContacts FROM Cell: [ 20121009 Inactive Exclusion ] cell count: [ 16
29326 ] outboundContacts added: [ 1629324 ]
2012-10-09 22:35:22,391  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:168) - 20121009 Full Rue List - Testing Full Volume Send Cell Name and Cell ID 5167869
2012-10-09 22:35:22,391  INFO [MapScheduler_Worker-9] (CreateMasterListJob.java:172) - 5252775 IS THE List ID
2012-10-09 22:35:22,404  INFO [MapScheduler_Worker-9] (ListDAOConnector.java:274) - RETURNING CONNECTION STRING [ jdbc:jtds:sqlserver://10.100.100.53:1433/RLL_CDM;user=workb
ench;password=******** ]
2012-10-09 22:35:22,406  INFO [MapScheduler_Worker-9] (MailerFacade.java:120) - List query [ SELECT e.EMAIL_ADDR as EMAIL_ADDR,
e.RUELALA_ID as RUELALAID,
e.EMAIL_DIM_ID as EMAIL_DIM_ID,
e.CUSTOMER_DIM_ID as CUSTOMER_DIM_ID,
'<<Workbench.cell.cellCd>>' as CPCELLCD,
'<<Workbench.cell.cellCodeOne>>' as CPSEGMENTCD,
'<<Workbench.cell.cellCodeTwo>>' as VERSIONCD,
--'<<Workbench.cell.cellCodeThree>>' as CORESEGMENTCD,
'abcd1234' as CORESEGMENTCD,
-- DATES are adjusted bc we are sending the 11am audience file 1 day before the mailing
case when e.DAYS_AS_MEMBER + 1 = 2 then 4157 when e.DAYS_AS_MEMBER + 1 in (3, 4) then 4158 else 1023 end as AID,
e.PURL as PERSONALINVITELINK,
e.FIRST_NM as FIRSTNAME,
e.LAST_NM as LASTNAME,
e.ACCOUNT_BALANCE as CREDITBALANCE,
case when e.DAYS_REMAINING>1 then e.DAYS_REMAINING  - 1 else 0 end DAYSLEFT,
case when e.DAYS_REMAINING>1 then 'Y' else 'N' end as DAYSFLAG,
case when e.DAYS_REMAINING>1 then e.SHOPPER_PROGRAM_ID else 0 end  as PROGRAMID,
e.SHOPPER_PROGRAM_FLG as PROGRAMFLAG,
e.LOCAL_REGION_ID as LOCALREGIONID,
case when e.DAYS_AS_MEMBER <=98 then e.DAYS_AS_MEMBER + 1
         else 0 end as EVERGREENBOUTIQUEFLAG

from dbo.VW_Emailable_MEMBERS e

where e.STATUS_ID=3 -- Members

 ]
2012-10-09 22:35:22,406  INFO [MapScheduler_Worker-9] (MailerFacade.java:1407) -  Constructed List Query with Workbench Parameters : [SELECT e.EMAIL_ADDR as EMAIL_ADDR,
e.RUELALA_ID as RUELALAID,
e.EMAIL_DIM_ID as EMAIL_DIM_ID,
e.CUSTOMER_DIM_ID as CUSTOMER_DIM_ID,
'TEST_Full_Volume' as CPCELLCD,
'2' as CPSEGMENTCD,
'1' as VERSIONCD,
--'<<Workbench.cell.cellCodeThree>>' as CORESEGMENTCD,
'abcd1234' as CORESEGMENTCD,
-- DATES are adjusted bc we are sending the 11am audience file 1 day before the mailing
case when e.DAYS_AS_MEMBER + 1 = 2 then 4157 when e.DAYS_AS_MEMBER + 1 in (3, 4) then 4158 else 1023 end as AID,
e.PURL as PERSONALINVITELINK,
e.FIRST_NM as FIRSTNAME,
e.LAST_NM as LASTNAME,
e.ACCOUNT_BALANCE as CREDITBALANCE,
case when e.DAYS_REMAINING>1 then e.DAYS_REMAINING  - 1 else 0 end DAYSLEFT,
case when e.DAYS_REMAINING>1 then 'Y' else 'N' end as DAYSFLAG,
case when e.DAYS_REMAINING>1 then e.SHOPPER_PROGRAM_ID else 0 end  as PROGRAMID,
e.SHOPPER_PROGRAM_FLG as PROGRAMFLAG,
e.LOCAL_REGION_ID as LOCALREGIONID,
case when e.DAYS_AS_MEMBER <=98 then e.DAYS_AS_MEMBER + 1
         else 0 end as EVERGREENBOUTIQUEFLAG

from dbo.VW_Emailable_MEMBERS e

where e.STATUS_ID=3 -- Members

]
2012-10-09 22:35:22,406  INFO [MapScheduler_Worker-9] (MailerFacade.java:123) - List query with WB Parameters [ SELECT e.EMAIL_ADDR as EMAIL_ADDR,
e.RUELALA_ID as RUELALAID,
e.EMAIL_DIM_ID as EMAIL_DIM_ID,
e.CUSTOMER_DIM_ID as CUSTOMER_DIM_ID,
'TEST_Full_Volume' as CPCELLCD,
'2' as CPSEGMENTCD,
'1' as VERSIONCD,
--'<<Workbench.cell.cellCodeThree>>' as CORESEGMENTCD,
'abcd1234' as CORESEGMENTCD,
-- DATES are adjusted bc we are sending the 11am audience file 1 day before the mailing
case when e.DAYS_AS_MEMBER + 1 = 2 then 4157 when e.DAYS_AS_MEMBER + 1 in (3, 4) then 4158 else 1023 end as AID,
e.PURL as PERSONALINVITELINK,
e.FIRST_NM as FIRSTNAME,
e.LAST_NM as LASTNAME,
e.ACCOUNT_BALANCE as CREDITBALANCE,
case when e.DAYS_REMAINING>1 then e.DAYS_REMAINING  - 1 else 0 end DAYSLEFT,
case when e.DAYS_REMAINING>1 then 'Y' else 'N' end as DAYSFLAG,
case when e.DAYS_REMAINING>1 then e.SHOPPER_PROGRAM_ID else 0 end  as PROGRAMID,
e.SHOPPER_PROGRAM_FLG as PROGRAMFLAG,
e.LOCAL_REGION_ID as LOCALREGIONID,
case when e.DAYS_AS_MEMBER <=98 then e.DAYS_AS_MEMBER + 1
         else 0 end as EVERGREENBOUTIQUEFLAG

from dbo.VW_Emailable_MEMBERS e

where e.STATUS_ID=3 -- Members

 ]
2012-10-09 22:36:38,422  INFO [MapScheduler_Worker-9] (MailerFacade.java:881) - Top of createListFile, trying to create program list file [ /ftp_home/workbench_lists_generat
ed/RUELALA_CP_20121009 Full Volume List Test_20121009223638.csv ]
2012-10-09 22:51:43,962  INFO [MapScheduler_Worker-9] (MyExceptionHandler.java:17) -  ++++++++++++ Inside MyExceptionHandler +++++++++++
2012-10-09 22:51:43,980  INFO [MapScheduler_Worker-9] (MyExceptionHandler.java:21) - ++++++++++++ Inside MyExceptionHandler +++++++++++ Unexpected problem on thread MapSched
uler_Worker-9: Java heap space