Details
-
Type: Bug
-
Status: Closed
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: Rushmore
-
Fix Version/s: Mercury
-
Component/s: Database/Schema
-
Labels:None
-
Environment:
Rushmore Final builds
-
Story Points:5
-
Sprint:Sprint 17, Sprint 18, Sprint 19
Description
Listener logs incorrect data type error for 'content_editor_google' table on order deployment
The following error is seen on deploying an order in the listener log
2015-05-11 06:40:55.243 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.244 (4) [P2T1]: spike: SQL->[insert into `content_editor_google`.`tmp4` (`adGroupID`,`searchEngineIdentifier`,`destinationURL`,`exemptionRequest`,` isNegative`,`isPaused`,`keywordType`,`maxCPC`,`status`,`text`) values ("1","0","","","false","false","Exact","null","Active","a real estate agent"),("1","0","","","fal se","false","Phrase","null","Active","affordable real estate agent"),("1","0","","","true","false","Phrase","null","Active","appraisal"),("1","0","","","true","false", "Phrase","null","Active","appraiser"),("1","0","","","true","false","Phrase","null","Active","become"),("1","0","","","true","false","Phrase","null","Active","becoming "),("1","0","","","true","false","Phrase","null","Active","business"),("1","0","","","false","false","Exact","null","Active","buy and sell a home"),("1","0","","","fal se","false","Exact","null","Active","buy and sell a house"),("1","0","","","false","false","Exact","null","Active","buy and sell home"),("1","0","","","false","false", "Exact","null","Active","buy and sell homes"),("1","0","","","false","false","Exact","null","Active","buy and sell house"),("1","0","","","false","false","Exact","null ","Active","buy and sell houses"),("1","0","","","false","false","Exact","null","Active","buy sell a home"),("1","0","","","false","false","Exact","null","Active","buy sell a house"),("1","0","","","false","false","Exact","null","Active","buy sell home"),("1","0","","","false","false","Exact","null","Active","buy sell homes"),("1"," 0","","","false","false","Exact","null","Active","buy sell house"),("1","0","","","false","false","Exact","null","Active","buy sell houses"),("1","0","","","true","fal se","Phrase","null","Active","career"),("1","0","","","true","false","Phrase","null","Active","careers"),("1","0","","","true","false","Phrase","null","Active","certif ication"),("1","0","","","true","false","Phrase","null","Active","class"),("1","0","","","true","false","Phrase","null","Active","classes"),("1","0","","","false","fal se","Phrase","null","Active","commercial estate agents"),("1","0","","","false","false","Phrase","null","Active","commercial real estate agent"),("1","0","","","true", "false","Phrase","null","Active","course"),("1","0","","","true","false","Phrase","null","Active","courses"),("1","0","","","true","false","Phrase","null","Active","de gree"),("1","0","","","true","false","Phrase","null","Active","diploma"),("1","0","","","true","false","Phrase","null","Active","earnings"),("1","0","","","true","fals e","Phrase","null","Active","education"),("1","0","","","true","false","Phrase","null","Active","exam"),("1","0","","","false","false","Phrase","null","Active","find a real estate agent"),("1","0","","","false","false","Exact","null","Active","flat fee real estate listings"),("1","0","","","true","false","Phrase","null","Active","fr om home"),("1","0","","","true","false","Phrase","null","Active","furniture"),("1","0","","","true","false","Phrase","null","Active","google homes"),("1","0","","","tr ue","false","Phrase","null","Active","haiti"),("1","0","","","true","false","Phrase","null","Active","how can"),("1","0","","","true","false","Phrase","null","Active", "how do"),("1","0","","","true","false","Phrase","null","Active","how to"),("1","0","","","true","false","Phrase","null","Active","investment"),("1","0","","","true"," false","Phrase","null","Active","jamaica"),("1","0","","","true","false","Phrase","null","Active","japan"),("1","0","","","true","false","Phrase","null","Active","job" ),("1","0","","","true","false","Phrase","null","Active","jobs"),("1","0","","","true","false","Phrase","null","Active","license"),("1","0","","","false","false","Phra se","null","Active","licensed real estate agent"),("1","0","","","true","false","Phrase","null","Active","licensing"),("1","0","","","false","false","Phrase","null","A ctive","list of estate agents"),("1","0","","","false","false","Phrase","null","Active","local real estate agent"),("1","0","","","true","false","Phrase","null","Activ e","mobile"),("1","0","","","true","false","Phrase","null","Active","pay"),("1","0","","","false","false","Exact","null","Active","property agent"),("1","0","","","fal se","false","Exact","null","Active","property agents"),("1","0","","","false","false","Phrase","null","Active","property agents"),("1","0","","","false","false","Phras e","null","Active","property estate agents"),("1","0","","","false","false","Exact","null","Active","real estate agencies"),("1","0","","","false","false","Phrase","nu ll","Active","real estate agencies"),("1","0","","","false","false","Exact","null","Active","real estate agency"),("1","0","","","false","false","Exact","null","Active ","real estate agent"),("1","0","","","false","false","Phrase","null","Active","real estate agent fees"),("1","0","","","false","false","Phrase","null","Active","real estate agent for rentals"),("1","0","","","false","false","Phrase","null","Active","real estate agent near me"),("1","0","","","false","false","Phrase","null","Active" ,"real estate agent services"),("1","0","","","false","false","Exact","null","Active","real estate agents"),("1","0","","","false","false","Phrase","null","Active","re al estate agents"),("1","0","","","false","false","Exact","null","Active","real estate broker"),("1","0","","","false","false","Exact","null","Active","real estate bro kers"),("1","0","","","false","false","Phrase","null","Active","real estate brokers"),("1","0","","","false","false","Exact","null","Active","real estate companies"),( "1","0","","","false","false","Phrase","null","Active","real estate companies"),("1","0","","","false","false","Exact","null","Active","real estate company"),("1","0", "","","false","false","Exact","null","Active","real estate listing agent"),("1","0","","","false","false","Exact","null","Active","real estate office"),("1","0","","", "false","false","Exact","null","Active","real estate offices"),("1","0","","","false","false","Phrase","null","Active","real estate offices"),("1","0","","","false","f alse","Exact","null","Active","realestate agents"),("1","0","","","false","false","Phrase","null","Active","realestate agents"),("1","0","","","true","false","Phrase", "null","Active","salary"),("1","0","","","true","false","Phrase","null","Active","school"),("1","0","","","true","false","Phrase","null","Active","schools"),("1","0"," ","","true","false","Phrase","null","Active","software"),("1","0","","","true","false","Phrase","null","Active","tax"),("1","0","","","false","false","Phrase","null"," Active","top real estate agents"),("1","0","","","true","false","Phrase","null","Active","training"),("1","0","","","true","false","Phrase","null","Active","trulia"),( "1","0","","","true","false","Phrase","null","Active","university"),("1","0","","","true","false","Phrase","null","Active","used"),("1","0","","","true","false","Phras e","null","Active","what are"),("1","0","","","true","false","Phrase","null","Active","what do"),("1","0","","","true","false","Phrase","null","Active","what is"),("1" ,"0","","","true","false","Phrase","null","Active","zillow"),("1","0","","","true","false","Phrase","null","Active","zoopla"),("2","0","","","false","false","Broad","n ull","Active","+a +real +estate +agent +Kissimmee +FL "),("2","0","","","true","false","Phrase","null","Active","appraisal"),("2","0","","","true","false","Phrase","nu ll","Active","appraiser"),("2","0","","","true","false","Phrase","null","Active","become"),("2","0","","","true","false","Phrase","null","Active","becoming"),("2","0", "","","true","false","Phrase","null","Active","business"),("2","0","","","false","false","Broad","null","Active","+buy +and +sell +a +home +Kissimmee +FL "),("2","0"," ","","false","false","Broad","null","Active","+buy +and +sell +a +house +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +and +sell +home +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +and +sell +homes +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Acti ve","+buy +and +sell +house +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +and +sell +houses +Kissimmee +FL "),("2","0","","","false", "false","Broad","null","Active","+buy +sell +a +home +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +sell +a +house +Kissimmee +FL "),( "2","0","","","false","false","Broad","null","Active","+buy +sell +home +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +sell +homes +Ki ssimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +sell +house +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +sell +houses +Kissimmee +FL "),("2","0","","","true","false","Phrase","null","Active","career"),("2","0","","","true","false","Phrase","null","Active","careers"),("2 ","0","","","true","false","Phrase","null","Active","certification"),("2","0","","","true","false","Phrase","null","Active","class"),("2","0","","","true","false","Phr ase","null","Active","classes"),("2","0","","","true","false","Phrase","null","Active","course"),("2","0","","","true","false","Phrase","null","Active","courses"),("2" ,"0","","","true","false","Phrase","null","Active","degree"),("2","0","","","true","false","Phrase","null","Active","diploma"),("2","0","","","true","false","Phrase"," null","Active","earnings"),("2","0","","","true","false","Phrase","null","Active","education"),("2","0","","","true","false","Phrase","null","Active","exam"),("2","0", "","","false","false","Broad","null","Active","+flat +fee +real +estate +listings +Kissimmee +FL "),("2","0","","","true","false","Phrase","null","Active","from home") ,("2","0","","","true","false","Phrase","null","Active","furniture"),("2","0","","","true","false","Phrase","null","Active","google homes"),("2","0","","","true","fals e","Phrase","null","Active","haiti"),("2","0","","","true","false","Phrase","null","Active","how can"),("2","0","","","true","false","Phrase","null","Active","how do") ,("2","0","","","true","false","Phrase","null","Active","how to"),("2","0","","","true","false","Phrase","null","Active","investment"),("2","0","","","true","false","P hrase","null","Active","jamaica"),("2","0","","","true","false","Phrase","null","Active","japan"),("2","0","","","true","false","Phrase","null","Active","job"),("2","0 ","","","true","false","Phrase","null","Active","jobs"),("2","0","","","true","false","Phrase","null","Active","license"),("2","0","","","true","false","Phrase","null" ,"Active","licensing"),("2","0","","","true","false","Phrase","null","Active","mobile"),("2","0","","","true","false","Phrase","null","Active","pay"),("2","0","","","f alse","false","Broad","null","Active","+property +agent +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+property +agents +Kissimmee +FL "),( "2","0","","","false","false","Broad","null","Active","+real +estate +agencies +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +agency +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +agent +Kissimmee +FL "),("2","0","","","false","false","Broad","null", "Active","+real +estate +agents +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +broker +Kissimmee +FL "),("2","0","","","false ","false","Broad","null","Active","+real +estate +brokers +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +companies +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +company +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +listing +agent +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +office +Kissimmee +FL "),("2","0","","","false","false ","Broad","null","Active","+real +estate +offices +Kissimmee +FL "),("2","0","","","true","false","Phrase","null","Active","salary"),("2","0","","","true","false","Phr ase","null","Active","school"),("2","0","","","true","false","Phrase","null","Active","schools"),("2","0","","","true","false","Phrase","null","Active","software"),("2 ","0","","","true","false","Phrase","null","Active","tax"),("2","0","","","true","false","Phrase","null","Active","training"),("2","0","","","true","false","Phrase","n ull","Active","trulia"),("2","0","","","true","false","Phrase","null","Active","university"),("2","0","","","true","false","Phrase","null","Active","used"),("2","0","" ,"","true","false","Phrase","null","Active","what are"),("2","0","","","true","false","Phrase","null","Active","what do"),("2","0","","","true","false","Phrase","null" ,"Active","what is"),("2","0","","","true","false","Phrase","null","Active","zillow"),("2","0","","","true","false","Phrase","null","Active","zoopla"),("3","0","",""," false","false","Broad","null","Active","+a +real +estate +agent +Kissimmee +Florida "),("3","0","","","true","false","Phrase","null","Active","appraisal"),("3","0","", "","true","false","Phrase","null","Active","appraiser"),("3","0","","","true","false","Phrase","null","Active","become"),("3","0","","","true","false","Phrase","null", "Active","becoming"),("3","0","","","true","false","Phrase","null","Active","business"),("3","0","","","false","false","Broad","null","Active","+buy +and +sell +a +hom e +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +and +sell +a +house +Kissimmee +Florida "),("3","0","","","false","false","Broad ","null","Active","+buy +and +sell +home +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +and +sell +homes +Kissimmee +Florida "),( "3","0","","","false","false","Broad","null","Active","+buy +and +sell +house +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +and +sell +houses +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +sell +a +home +Kissimmee +Florida "),("3","0","","","false","false", "Broad","null","Active","+buy +sell +a +house +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +sell +home +Kissimmee +Florida "),(" 3","0","","","false","false","Broad","null","Active","+buy +sell +homes +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +sell +hous e +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +sell +houses +Kissimmee +Florida "),("3","0","","","true","false","Phrase","null ","Active","career"),("3","0","","","true","false","Phrase","null","Active","careers"),("3","0","","","true","false","Phrase","null","Active","certification"),("3","0" ,"","","true","false","Phrase","null","Active","class"),("3","0","","","true","false","Phrase","null","Active","classes"),("3","0","","","true","false","Phrase","null" ,"Active","course"),("3","0","","","true","false","Phrase","null","Active","courses"),("3","0","","","true","false","Phrase","null","Active","degree"),("3","0","",""," true","false","Phrase","null","Active","diploma"),("3","0","","","true","false","Phrase","null","Active","earnings"),("3","0","","","true","false","Phrase","null","Act ive","education"),("3","0","","","true","false","Phrase","null","Active","exam"),("3","0","","","false","false","Broad","null","Active","+flat +fee +real +estate +list ings +Kissimmee +Florida "),("3","0","","","true","false","Phrase","null","Active","from home"),("3","0","","","true","false","Phrase","null","Active","furniture"),("3 ","0","","","true","false","Phrase","null","Active","google homes"),("3","0","","","true","false","Phrase","null","Active","haiti"),("3","0","","","true","false","Phra se","null","Active","how can"),("3","0","","","true","false","Phrase","null","Active","how do"),("3","0","","","true","false","Phrase","null","Active","how to"),("3"," 0","","","true","false","Phrase","null","Active","investment"),("3","0","","","true","false","Phrase","null","Active","jamaica"),("3","0","","","true","false","Phrase" ,"null","Active","japan"),("3","0","","","true","false","Phrase","null","Active","job"),("3","0","","","true","false","Phrase","null","Active","jobs"),("3","0","",""," true","false","Phrase","null","Active","license"),("3","0","","","true","false","Phrase","null","Active","licensing"),("3","0","","","true","false","Phrase","null","Ac tive","mobile"),("3","0","","","true","false","Phrase","null","Active","pay"),("3","0","","","false","false","Broad","null","Active","+property +agent +Kissimmee +Flor ida "),("3","0","","","false","false","Broad","null","Active","+property +agents +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real + estate +agencies +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +agency +Kissimmee +Florida "),("3","0","","","false","fa lse","Broad","null","Active","+real +estate +agent +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +agents +Kissimmee +Flo rida "),("3","0","","","false","false","Broad","null","Active","+real +estate +broker +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+r eal +estate +brokers +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +companies +Kissimmee +Florida "),("3","0","","","fal se","false","Broad","null","Active","+real +estate +company +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +listing +agen t +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +office +Kissimmee +Florida "),("3","0","","","false","false","Broad","n ull","Active","+real +estate +offices +Kissimmee +Florida "),("3","0","","","true","false","Phrase","null","Active","salary"),("3","0","","","true","false","Phrase","n ull","Active","school"),("3","0","","","true","false","Phrase","null","Active","schools"),("3","0","","","true","false","Phrase","null","Active","software"),("3","0"," ","","true","false","Phrase","null","Active","tax"),("3","0","","","true","false","Phrase","null","Active","training"),("3","0","","","true","false","Phrase","null","A ctive","trulia"),("3","0","","","true","false","Phrase","null","Active","university"),("3","0","","","true","false","Phrase","null","Active","used"),("3","0","","","tr ue","false","Phrase","null","Active","what are"),("3","0","","","true","false","Phrase","null","Active","what do"),("3","0","","","true","false","Phrase","null","Activ e","what is"),("3","0","","","true","false","Phrase","null","Active","zillow"),("3","0","","","true","false","Phrase","null","Active","zoopla"),("4","0","","","false", "false","Broad","null","Active","+a +real +estate +agent +Kissimmee "),("4","0","","","true","false","Phrase","null","Active","appraisal"),("4","0","","","true","false ","Phrase","null","Active","appraiser"),("4","0","","","true","false","Phrase","null","Active","become"),("4","0","","","true","false","Phrase","null","Active","becomi ng"),("4","0","","","true","false","Phrase","null","Active","business"),("4","0","","","false","false","Broad","null","Active","+buy +and +sell +a +home +Kissimmee "), ("4","0","","","false","false","Broad","null","Active","+buy +and +sell +a +house +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +and +sell +home +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +and +sell +homes +Kissimmee "),("4","0","","","false","false","Broad","null","Active ","+buy +and +sell +house +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +and +sell +houses +Kissimmee "),("4","0","","","false","false","B road","null","Active","+buy +sell +a +home +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +sell +a +house +Kissimmee "),("4","0","","","fal se","false","Broad","null","Active","+buy +sell +home +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +sell +homes +Kissimmee "),("4","0","" ,"","false","false","Broad","null","Active","+buy +sell +house +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +sell +houses +Kissimmee "),( "4","0","","","true","false","Phrase","null","Active","career"),("4","0","","","true","false","Phrase","null","Active","careers"),("4","0","","","true","false","Phrase ","null","Active","certification"),("4","0","","","true","false","Phrase","null","Active","class"),("4","0","","","true","false","Phrase","null","Active","classes"),(" 4","0","","","true","false","Phrase","null","Active","course"),("4","0","","","true","false","Phrase","null","Active","courses"),("4","0","","","true","false","Phrase" ,"null","Active","degree"),("4","0","","","true","false","Phrase","null","Active","diploma"),("4","0","","","true","false","Phrase","null","Active","earnings"),("4","0 ","","","true","false","Phrase","null","Active","education"),("4","0","","","true","false","Phrase","null","Active","exam"),("4","0","","","false","false","Broad","nul l","Active","+flat +fee +real +estate +listings +Kissimmee "),("4","0","","","true","false","Phrase","null","Active","from home"),("4","0","","","true","false","Phrase ","null","Active","furniture"),("4","0","","","true","false","Phrase","null","Active","google homes"),("4","0","","","true","false","Phrase","null","Active","haiti"),( "4","0","","","true","false","Phrase","null","Active","how can"),("4","0","","","true","false","Phrase","null","Active","how do"),("4","0","","","true","false","Phrase ","null","Active","how to"),("4","0","","","true","false","Phrase","null","Active","investment"),("4","0","","","true","false","Phrase","null","Active","jamaica"),("4" ,"0","","","true","false","Phrase","null","Active","japan"),("4","0","","","true","false","Phrase","null","Active","job"),("4","0","","","true","false","Phrase","null" ,"Active","jobs"),("4","0","","","true","false","Phrase","null","Active","license"),("4","0","","","true","false","Phrase","null","Active","licensing"),("4","0","","", "true","false","Phrase","null","Active","mobile"),("4","0","","","true","false","Phrase","null","Active","pay"),("4","0","","","false","false","Broad","null","Active", "+property +agent +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+property +agents +Kissimmee "),("4","0","","","false","false","Broad","null"," Active","+real +estate +agencies +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +agency +Kissimmee "),("4","0","","","false","fals e","Broad","null","Active","+real +estate +agent +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +agents +Kissimmee "),("4","0","", "","false","false","Broad","null","Active","+real +estate +broker +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +brokers +Kissimm ee "),("4","0","","","false","false","Broad","null","Active","+real +estate +companies +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +est ate +company +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +listing +agent +Kissimmee "),("4","0","","","false","false","Broad"," null","Active","+real +estate +office +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +offices +Kissimmee "),("4","0","","","true", "false","Phrase","null","Active","salary"),("4","0","","","true","false","Phrase","null","Active","school"),("4","0","","","true","false","Phrase","null","Active","sch ools"),("4","0","","","true","false","Phrase","null","Active","software"),("4","0","","","true","false","Phrase","null","Active","tax"),("4","0","","","true","false"," Phrase","null","Active","training"),("4","0","","","true","false","Phrase","null","Active","trulia"),("4","0","","","true","false","Phrase","null","Active","university "),("4","0","","","true","false","Phrase","null","Active","used"),("4","0","","","true","false","Phrase","null","Active","what are"),("4","0","","","true","false","Phr ase","null","Active","what do"),("4","0","","","true","false","Phrase","null","Active","what is"),("4","0","","","true","false","Phrase","null","Active","zillow"),("4" ,"0","","","true","false","Phrase","null","Active","zoopla"),("6","0","","","false","false","Broad","null","Active","+apartment +property +management"),("6","0","","", "false","false","Broad","null","Active","+commercial +property +management"),("6","0","","","false","false","Broad","null","Active","+commercial +property +manager"),( "6","0","","","false","false","Broad","null","Active","+commercial +property +managers"),("6","0","","","false","false","Broad","null","Active","+home +property +manag ement"),("6","0","","","false","false","Broad","null","Active","+manage +properties"),("6","0","","","false","false","Broad","null","Active","+manage +property"),("6", "0","","","false","false","Broad","null","Active","+management +for +properties"),("6","0","","","false","false","Broad","null","Active","+management +for +property"), ("6","0","","","false","false","Broad","null","Active","+management +properties"),("6","0","","","false","false","Broad","null","Active","+management +property"),("6", "0","","","false","false","Broad","null","Active","+managing +properties"),("6","0","","","false","false","Broad","null","Active","+managing +property"),("6","0","","" ,"false","false","Broad","null","Active","+properties +management"),("6","0","","","false","false","Broad","null","Active","+property +management"),("6","0","","","fal se","false","Broad","null","Active","+property +management +co"),("6","0","","","false","false","Broad","null","Active","+property +management +companies"),("6","0","" ,"","false","false","Broad","null","Active","+property +management +company"),("6","0","","","false","false","Broad","null","Active","+property +management +firms"),(" 6","0","","","false","false","Broad","null","Active","+property +management +services"),("6","0","","","false","false","Broad","null","Active","+property +manager"),(" 6","0","","","false","false","Broad","null","Active","+property +manager +companies"),("6","0","","","false","false","Broad","null","Active","+property +managers"),("6 ","0","","","false","false","Broad","null","Active","+property +managing"),("6","0","","","false","false","Broad","null","Active","+property +managment"),("6","0",""," ","false","false","Broad","null","Active","+real +property +management"),("6","0","","","false","false","Exact","null","Active","apartment property management"),("6"," 0","","","true","false","Phrase","null","Active","become"),("6","0","","","true","false","Phrase","null","Active","becoming"),("6","0","","","true","false","Phrase","n ull","Active","career"),("6","0","","","true","false","Phrase","null","Active","careers"),("6","0","","","true","false","Phrase","null","Active","certification"),("6", "0","","","false","false","Exact","null","Active","commercial property management"),("6","0","","","false","false","Exact","null","Active","commercial property manager "),("6","0","","","false","false","Exact","null","Active","commercial property managers"),("6","0","","","true","false","Phrase","null","Active","courses"),("6","0","" ,"","true","false","Phrase","null","Active","degree"),("6","0","","","true","false","Phrase","null","Active","diploma"),("6","0","","","true","false","Phrase","null"," Active","earnings"),("6","0","","","true","false","Phrase","null","Active","exam"),("6","0","","","false","false","Exact","null","Active","home property management"),( "6","0","","","true","false","Phrase","null","Active","how can"),("6","0","","","true","false","Phrase","null","Active","how do"),("6","0","","","true","false","Phrase ","null","Active","how to"),("6","0","","","true","false","Phrase","null","Active","job"),("6","0","","","true","false","Phrase","null","Active","jobs"),("6","0","","" ,"false","false","Exact","null","Active","manage properties"),("6","0","","","false","false","Exact","null","Active","manage property"),("6","0","","","false","false", "Exact","null","Active","management for properties"),("6","0","","","false","false","Exact","null","Active","management for property"),("6","0","","","false","false"," Exact","null","Active","management properties"),("6","0","","","false","false","Exact","null","Active","management property"),("6","0","","","false","false","Exact","n ull","Active","managing properties"),("6","0","","","false","false","Exact","null","Active","managing property"),("6","0","","","true","false","Phrase","null","Active" ,"pay"),("6","0","","","false","false","Exact","null","Active","properties management"),("6","0","","","false","false","Exact","null","Active","property management"),( "6","0","","","false","false","Exact","null","Active","property management co"),("6","0","","","false","false","Exact","null","Active","property management companies") ,("6","0","","","false","false","Exact","null","Active","property management company"),("6","0","","","false","false","Exact","null","Active","property management firm s"),("6","0","","","false","false","Exact","null","Active","property management services"),("6","0","","","false","false","Exact","null","Active","property manager"),( "6","0","","","false","false","Exact","null","Active","property manager companies"),("6","0","","","false","false","Exact","null","Active","property managers"),("6","0 ","","","false","false","Exact","null","Active","property managing"),("6","0","","","false","false","Exact","null","Active","property managment"),("6","0","","","false ","false","Exact","null","Active","real property management"),("6","0","","","true","false","Phrase","null","Active","salary"),("6","0","","","true","false","Phrase"," null","Active","tax"),("6","0","","","true","false","Phrase","null","Active","training"),("6","0","","","true","false","Phrase","null","Active","university"),("6","0", "","","true","false","Phrase","null","Active","what are"),("6","0","","","true","false","Phrase","null","Active","what is"),("7","0","","","false","false","Broad","nul l","Active","+apartment +property +management +Nags +Head +NC "),("7","0","","","true","false","Phrase","null","Active","become"),("7","0","","","true","false","Phrase ","null","Active","becoming"),("7","0","","","true","false","Phrase","null","Active","career"),("7","0","","","true","false","Phrase","null","Active","careers"),("7"," 0","","","true","false","Phrase","null","Active","certification"),("7","0","","","false","false","Broad","null","Active","+commercial +property +management +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+commercial +property +manager +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active ","+commercial +property +managers +Nags +Head +NC "),("7","0","","","true","false","Phrase","null","Active","courses"),("7","0","","","true","false","Phrase","null"," Active","degree"),("7","0","","","true","false","Phrase","null","Active","diploma"),("7","0","","","true","false","Phrase","null","Active","earnings"),("7","0","",""," true","false","Phrase","null","Active","exam"),("7","0","","","false","false","Broad","null","Active","+home +property +management +Nags +Head +NC "),("7","0","","","t rue","false","Phrase","null","Active","how can"),("7","0","","","true","false","Phrase","null","Active","how do"),("7","0","","","true","false","Phrase","null","Active ","how to"),("7","0","","","true","false","Phrase","null","Active","job"),("7","0","","","true","false","Phrase","null","Active","jobs"),("7","0","","","false","false" ,"Broad","null","Active","+manage +properties +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+manage +property +Nags +Head +NC "),("7","0", "","","false","false","Broad","null","Active","+management +for +properties +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+management +for +property +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+management +properties +Nags +Head +NC "),("7","0","","","false","false","Broad" ,"null","Active","+management +property +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+managing +properties +Nags +Head +NC "),("7","0","" ,"","false","false","Broad","null","Active","+managing +property +Nags +Head +NC "),("7","0","","","true","false","Phrase","null","Active","pay"),("7","0","","","false ","false","Broad","null","Active","+properties +management +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +management +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +management +co +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+p roperty +management +companies +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +management +company +Nags +Head +NC "),("7","0","" ,"","false","false","Broad","null","Active","+property +management +firms +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +managem ent +services +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +manager +Nags +Head +NC "),("7","0","","","false","false","Broad"," null","Active","+property +manager +companies +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +managers +Nags +Head +NC "),("7","0 ","","","false","false","Broad","null","Active","+property +managing +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +managment +N ags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+real +property +management +Nags +Head +NC "),("7","0","","","true","false","Phrase","null"," Active","salary"),("7","0","","","true","false","Phrase","null","Active","tax"),("7","0","","","true","false","Phrase","null","Active","training"),("7","0","","","true ","false","Phrase","null","Active","university"),("7","0","","","true","false","Phrase","null","Active","what are"),("7","0","","","true","false","Phrase","null","Acti ve","what is"),("8","0","","","false","false","Broad","null","Active","+apartment +property +management +Nags +Head "),("8","0","","","true","false","Phrase","null","A ctive","become"),("8","0","","","true","false","Phrase","null","Active","becoming"),("8","0","","","true","false","Phrase","null","Active","career"),("8","0","","","tr ue","false","Phrase","null","Active","careers"),("8","0","","","true","false","Phrase","null","Active","certification"),("8","0","","","false","false","Broad","null"," Active","+commercial +property +management +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+commercial +property +manager +Nags +Head "),("8","0 ","","","false","false","Broad","null","Active","+commercial +property +managers +Nags +Head "),("8","0","","","true","false","Phrase","null","Active","courses"),("8", "0","","","true","false","Phrase","null","Active","degree"),("8","0","","","true","false","Phrase","null","Active","diploma"),("8","0","","","true","false","Phrase","n ull","Active","earnings"),("8","0","","","true","false","Phrase","null","Active","exam"),("8","0","","","false","false","Broad","null","Active","+home +property +manag ement +Nags +Head "),("8","0","","","true","false","Phrase","null","Active","how can"),("8","0","","","true","false","Phrase","null","Active","how do"),("8","0","","", "true","false","Phrase","null","Active","how to"),("8","0","","","true","false","Phrase","null","Active","job"),("8","0","","","true","false","Phrase","null","Active", "jobs"),("8","0","","","false","false","Broad","null","Active","+manage +properties +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+manage +pro perty +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+management +for +properties +Nags +Head "),("8","0","","","false","false","Broad","null", "Active","+management +for +property +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+management +properties +Nags +Head "),("8","0","","","fals e","false","Broad","null","Active","+management +property +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+managing +properties +Nags +Head "),( "8","0","","","false","false","Broad","null","Active","+managing +property +Nags +Head "),("8","0","","","true","false","Phrase","null","Active","pay"),("8","0","","", "false","false","Broad","null","Active","+properties +management +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +management +Nags +He ad "),("8","0","","","false","false","Broad","null","Active","+property +management +co +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+propert y +management +companies +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +management +company +Nags +Head "),("8","0","","","false","f alse","Broad","null","Active","+property +management +firms +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +management +services +Nag s +Head "),("8","0","","","false","false","Broad","null","Active","+property +manager +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +manager +companies +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +managers +Nags +Head "),("8","0","","","false","false","Broad","n ull","Active","+property +managing +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +managment +Nags +Head "),("8","0","","","false","f alse","Broad","null","Active","+real +property +management +Nags +Head "),("8","0","","","true","false","Phrase","null","Active","salary"),("8","0","","","true","false ","Phrase","null","Active","tax"),("8","0","","","true","false","Phrase","null","Active","training"),("8","0","","","true","false","Phrase","null","Active","university "),("8","0","","","true","false","Phrase","null","Active","what are"),("8","0","","","true","false","Phrase","null","Active","what is")]
2015-05-11 06:40:55.304 (2) [P2T1]: Warning(s) detected in statement [insert into `content_editor_google`.`tmp4` (`adGroupID`,`searchEngineIdentifier`,`destinationURL` ,`exemptionRequest`,`isNegative`,`isPaused`,`keywordType`,`maxCPC`,`status`,`text`) values ("1","0","","","false","false","Exact","null","Active","a real estate agent" ),("1","0","","","false","false","Phrase","null","Active","affordable real estate agent"),("1","0","","","true","false","Phrase","null","Active","appraisal"),("1","0", "","","true","false","Phrase","null","Active","appraiser"),("1","0","","","true","false","Phrase","null","Active","become"),("1","0","","","true","false","Phrase","nul l","Active","becoming"),("1","0","","","true","false","Phrase","null","Active","business"),("1","0","","","false","false","Exact","null","Active","buy and sell a home" ),("1","0","","","false","false","Exact","null","Active","buy and sell a house"),("1","0","","","false","false","Exact","null","Active","buy and sell home"),("1","0"," ","","false","false","Exact","null","Active","buy and sell homes"),("1","0","","","false","false","Exact","null","Active","buy and sell house"),("1","0","","","false", "false","Exact","null","Active","buy and sell houses"),("1","0","","","false","false","Exact","null","Active","buy sell a home"),("1","0","","","false","false","Exact" ,"null","Active","buy sell a house"),("1","0","","","false","false","Exact","null","Active","buy sell home"),("1","0","","","false","false","Exact","null","Active","bu y sell homes"),("1","0","","","false","false","Exact","null","Active","buy sell house"),("1","0","","","false","false","Exact","null","Active","buy sell houses"),("1", "0","","","true","false","Phrase","null","Active","career"),("1","0","","","true","false","Phrase","null","Active","careers"),("1","0","","","true","false","Phrase","n ull","Active","certification"),("1","0","","","true","false","Phrase","null","Active","class"),("1","0","","","true","false","Phrase","null","Active","classes"),("1"," 0","","","false","false","Phrase","null","Active","commercial estate agents"),("1","0","","","false","false","Phrase","null","Active","commercial real estate agent"),( "1","0","","","true","false","Phrase","null","Active","course"),("1","0","","","true","false","Phrase","null","Active","courses"),("1","0","","","true","false","Phrase ","null","Active","degree"),("1","0","","","true","false","Phrase","null","Active","diploma"),("1","0","","","true","false","Phrase","null","Active","earnings"),("1"," 0","","","true","false","Phrase","null","Active","education"),("1","0","","","true","false","Phrase","null","Active","exam"),("1","0","","","false","false","Phrase","n ull","Active","find a real estate agent"),("1","0","","","false","false","Exact","null","Active","flat fee real estate listings"),("1","0","","","true","false","Phrase ","null","Active","from home"),("1","0","","","true","false","Phrase","null","Active","furniture"),("1","0","","","true","false","Phrase","null","Active","google homes "),("1","0","","","true","false","Phrase","null","Active","haiti"),("1","0","","","true","false","Phrase","null","Active","how can"),("1","0","","","true","false","Phr ase","null","Active","how do"),("1","0","","","true","false","Phrase","null","Active","how to"),("1","0","","","true","false","Phrase","null","Active","investment"),(" 1","0","","","true","false","Phrase","null","Active","jamaica"),("1","0","","","true","false","Phrase","null","Active","japan"),("1","0","","","true","false","Phrase", "null","Active","job"),("1","0","","","true","false","Phrase","null","Active","jobs"),("1","0","","","true","false","Phrase","null","Active","license"),("1","0","","", "false","false","Phrase","null","Active","licensed real estate agent"),("1","0","","","true","false","Phrase","null","Active","licensing"),("1","0","","","false","fals e","Phrase","null","Active","list of estate agents"),("1","0","","","false","false","Phrase","null","Active","local real estate agent"),("1","0","","","true","false"," Phrase","null","Active","mobile"),("1","0","","","true","false","Phrase","null","Active","pay"),("1","0","","","false","false","Exact","null","Active","property agent" ),("1","0","","","false","false","Exact","null","Active","property agents"),("1","0","","","false","false","Phrase","null","Active","property agents"),("1","0","",""," false","false","Phrase","null","Active","property estate agents"),("1","0","","","false","false","Exact","null","Active","real estate agencies"),("1","0","","","false" ,"false","Phrase","null","Active","real estate agencies"),("1","0","","","false","false","Exact","null","Active","real estate agency"),("1","0","","","false","false"," Exact","null","Active","real estate agent"),("1","0","","","false","false","Phrase","null","Active","real estate agent fees"),("1","0","","","false","false","Phrase"," null","Active","real estate agent for rentals"),("1","0","","","false","false","Phrase","null","Active","real estate agent near me"),("1","0","","","false","false","Ph rase","null","Active","real estate agent services"),("1","0","","","false","false","Exact","null","Active","real estate agents"),("1","0","","","false","false","Phrase ","null","Active","real estate agents"),("1","0","","","false","false","Exact","null","Active","real estate broker"),("1","0","","","false","false","Exact","null","Act ive","real estate brokers"),("1","0","","","false","false","Phrase","null","Active","real estate brokers"),("1","0","","","false","false","Exact","null","Active","real estate companies"),("1","0","","","false","false","Phrase","null","Active","real estate companies"),("1","0","","","false","false","Exact","null","Active","real estat e company"),("1","0","","","false","false","Exact","null","Active","real estate listing agent"),("1","0","","","false","false","Exact","null","Active","real estate off ice"),("1","0","","","false","false","Exact","null","Active","real estate offices"),("1","0","","","false","false","Phrase","null","Active","real estate offices"),("1" ,"0","","","false","false","Exact","null","Active","realestate agents"),("1","0","","","false","false","Phrase","null","Active","realestate agents"),("1","0","","","tr ue","false","Phrase","null","Active","salary"),("1","0","","","true","false","Phrase","null","Active","school"),("1","0","","","true","false","Phrase","null","Active", "schools"),("1","0","","","true","false","Phrase","null","Active","software"),("1","0","","","true","false","Phrase","null","Active","tax"),("1","0","","","false","fal se","Phrase","null","Active","top real estate agents"),("1","0","","","true","false","Phrase","null","Active","training"),("1","0","","","true","false","Phrase","null" ,"Active","trulia"),("1","0","","","true","false","Phrase","null","Active","university"),("1","0","","","true","false","Phrase","null","Active","used"),("1","0","","", "true","false","Phrase","null","Active","what are"),("1","0","","","true","false","Phrase","null","Active","what do"),("1","0","","","true","false","Phrase","null","Ac tive","what is"),("1","0","","","true","false","Phrase","null","Active","zillow"),("1","0","","","true","false","Phrase","null","Active","zoopla"),("2","0","","","fals e","false","Broad","null","Active","+a +real +estate +agent +Kissimmee +FL "),("2","0","","","true","false","Phrase","null","Active","appraisal"),("2","0","","","true" ,"false","Phrase","null","Active","appraiser"),("2","0","","","true","false","Phrase","null","Active","become"),("2","0","","","true","false","Phrase","null","Active", "becoming"),("2","0","","","true","false","Phrase","null","Active","business"),("2","0","","","false","false","Broad","null","Active","+buy +and +sell +a +home +Kissim mee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +and +sell +a +house +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active"," +buy +and +sell +home +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +and +sell +homes +Kissimmee +FL "),("2","0","","","false","false" ,"Broad","null","Active","+buy +and +sell +house +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +and +sell +houses +Kissimmee +FL "),(" 2","0","","","false","false","Broad","null","Active","+buy +sell +a +home +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +sell +a +hous e +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +sell +home +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active"," +buy +sell +homes +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+buy +sell +house +Kissimmee +FL "),("2","0","","","false","false","Broad", "null","Active","+buy +sell +houses +Kissimmee +FL "),("2","0","","","true","false","Phrase","null","Active","career"),("2","0","","","true","false","Phrase","null","A ctive","careers"),("2","0","","","true","false","Phrase","null","Active","certification"),("2","0","","","true","false","Phrase","null","Active","class"),("2","0",""," ","true","false","Phrase","null","Active","classes"),("2","0","","","true","false","Phrase","null","Active","course"),("2","0","","","true","false","Phrase","null","Ac tive","courses"),("2","0","","","true","false","Phrase","null","Active","degree"),("2","0","","","true","false","Phrase","null","Active","diploma"),("2","0","","","tru e","false","Phrase","null","Active","earnings"),("2","0","","","true","false","Phrase","null","Active","education"),("2","0","","","true","false","Phrase","null","Acti ve","exam"),("2","0","","","false","false","Broad","null","Active","+flat +fee +real +estate +listings +Kissimmee +FL "),("2","0","","","true","false","Phrase","null", "Active","from home"),("2","0","","","true","false","Phrase","null","Active","furniture"),("2","0","","","true","false","Phrase","null","Active","google homes"),("2"," 0","","","true","false","Phrase","null","Active","haiti"),("2","0","","","true","false","Phrase","null","Active","how can"),("2","0","","","true","false","Phrase","nul l","Active","how do"),("2","0","","","true","false","Phrase","null","Active","how to"),("2","0","","","true","false","Phrase","null","Active","investment"),("2","0","" ,"","true","false","Phrase","null","Active","jamaica"),("2","0","","","true","false","Phrase","null","Active","japan"),("2","0","","","true","false","Phrase","null","A ctive","job"),("2","0","","","true","false","Phrase","null","Active","jobs"),("2","0","","","true","false","Phrase","null","Active","license"),("2","0","","","true","f alse","Phrase","null","Active","licensing"),("2","0","","","true","false","Phrase","null","Active","mobile"),("2","0","","","true","false","Phrase","null","Active","pa y"),("2","0","","","false","false","Broad","null","Active","+property +agent +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+property +agent s +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +agencies +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Ac tive","+real +estate +agency +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +agent +Kissimmee +FL "),("2","0","","","false","f alse","Broad","null","Active","+real +estate +agents +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +broker +Kissimmee +FL "), ("2","0","","","false","false","Broad","null","Active","+real +estate +brokers +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +companies +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +company +Kissimmee +FL "),("2","0","","","false","false","Broad","n ull","Active","+real +estate +listing +agent +Kissimmee +FL "),("2","0","","","false","false","Broad","null","Active","+real +estate +office +Kissimmee +FL "),("2","0" ,"","","false","false","Broad","null","Active","+real +estate +offices +Kissimmee +FL "),("2","0","","","true","false","Phrase","null","Active","salary"),("2","0",""," ","true","false","Phrase","null","Active","school"),("2","0","","","true","false","Phrase","null","Active","schools"),("2","0","","","true","false","Phrase","null","Ac tive","software"),("2","0","","","true","false","Phrase","null","Active","tax"),("2","0","","","true","false","Phrase","null","Active","training"),("2","0","","","true ","false","Phrase","null","Active","trulia"),("2","0","","","true","false","Phrase","null","Active","university"),("2","0","","","true","false","Phrase","null","Active ","used"),("2","0","","","true","false","Phrase","null","Active","what are"),("2","0","","","true","false","Phrase","null","Active","what do"),("2","0","","","true","f alse","Phrase","null","Active","what is"),("2","0","","","true","false","Phrase","null","Active","zillow"),("2","0","","","true","false","Phrase","null","Active","zoop la"),("3","0","","","false","false","Broad","null","Active","+a +real +estate +agent +Kissimmee +Florida "),("3","0","","","true","false","Phrase","null","Active","app raisal"),("3","0","","","true","false","Phrase","null","Active","appraiser"),("3","0","","","true","false","Phrase","null","Active","become"),("3","0","","","true","fa lse","Phrase","null","Active","becoming"),("3","0","","","true","false","Phrase","null","Active","business"),("3","0","","","false","false","Broad","null","Active","+b uy +and +sell +a +home +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +and +sell +a +house +Kissimmee +Florida "),("3","0","",""," false","false","Broad","null","Active","+buy +and +sell +home +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +and +sell +homes +Ki ssimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +and +sell +house +Kissimmee +Florida "),("3","0","","","false","false","Broad","null" ,"Active","+buy +and +sell +houses +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +sell +a +home +Kissimmee +Florida "),("3","0"," ","","false","false","Broad","null","Active","+buy +sell +a +house +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +sell +home +Kis simmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +sell +homes +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Acti ve","+buy +sell +house +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+buy +sell +houses +Kissimmee +Florida "),("3","0","","","true"," false","Phrase","null","Active","career"),("3","0","","","true","false","Phrase","null","Active","careers"),("3","0","","","true","false","Phrase","null","Active","cer tification"),("3","0","","","true","false","Phrase","null","Active","class"),("3","0","","","true","false","Phrase","null","Active","classes"),("3","0","","","true","f alse","Phrase","null","Active","course"),("3","0","","","true","false","Phrase","null","Active","courses"),("3","0","","","true","false","Phrase","null","Active","degr ee"),("3","0","","","true","false","Phrase","null","Active","diploma"),("3","0","","","true","false","Phrase","null","Active","earnings"),("3","0","","","true","false" ,"Phrase","null","Active","education"),("3","0","","","true","false","Phrase","null","Active","exam"),("3","0","","","false","false","Broad","null","Active","+flat +fe e +real +estate +listings +Kissimmee +Florida "),("3","0","","","true","false","Phrase","null","Active","from home"),("3","0","","","true","false","Phrase","null","Act ive","furniture"),("3","0","","","true","false","Phrase","null","Active","google homes"),("3","0","","","true","false","Phrase","null","Active","haiti"),("3","0","","" ,"true","false","Phrase","null","Active","how can"),("3","0","","","true","false","Phrase","null","Active","how do"),("3","0","","","true","false","Phrase","null","Act ive","how to"),("3","0","","","true","false","Phrase","null","Active","investment"),("3","0","","","true","false","Phrase","null","Active","jamaica"),("3","0","","","t rue","false","Phrase","null","Active","japan"),("3","0","","","true","false","Phrase","null","Active","job"),("3","0","","","true","false","Phrase","null","Active","jo bs"),("3","0","","","true","false","Phrase","null","Active","license"),("3","0","","","true","false","Phrase","null","Active","licensing"),("3","0","","","true","false ","Phrase","null","Active","mobile"),("3","0","","","true","false","Phrase","null","Active","pay"),("3","0","","","false","false","Broad","null","Active","+property +a gent +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+property +agents +Kissimmee +Florida "),("3","0","","","false","false","Broad","nu ll","Active","+real +estate +agencies +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +agency +Kissimmee +Florida "),("3", "0","","","false","false","Broad","null","Active","+real +estate +agent +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +a gents +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +broker +Kissimmee +Florida "),("3","0","","","false","false","Broad ","null","Active","+real +estate +brokers +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +companies +Kissimmee +Florida " ),("3","0","","","false","false","Broad","null","Active","+real +estate +company +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real + estate +listing +agent +Kissimmee +Florida "),("3","0","","","false","false","Broad","null","Active","+real +estate +office +Kissimmee +Florida "),("3","0","","","fals e","false","Broad","null","Active","+real +estate +offices +Kissimmee +Florida "),("3","0","","","true","false","Phrase","null","Active","salary"),("3","0","","","true ","false","Phrase","null","Active","school"),("3","0","","","true","false","Phrase","null","Active","schools"),("3","0","","","true","false","Phrase","null","Active"," software"),("3","0","","","true","false","Phrase","null","Active","tax"),("3","0","","","true","false","Phrase","null","Active","training"),("3","0","","","true","fals e","Phrase","null","Active","trulia"),("3","0","","","true","false","Phrase","null","Active","university"),("3","0","","","true","false","Phrase","null","Active","used "),("3","0","","","true","false","Phrase","null","Active","what are"),("3","0","","","true","false","Phrase","null","Active","what do"),("3","0","","","true","false"," Phrase","null","Active","what is"),("3","0","","","true","false","Phrase","null","Active","zillow"),("3","0","","","true","false","Phrase","null","Active","zoopla"),(" 4","0","","","false","false","Broad","null","Active","+a +real +estate +agent +Kissimmee "),("4","0","","","true","false","Phrase","null","Active","appraisal"),("4","0 ","","","true","false","Phrase","null","Active","appraiser"),("4","0","","","true","false","Phrase","null","Active","become"),("4","0","","","true","false","Phrase","n ull","Active","becoming"),("4","0","","","true","false","Phrase","null","Active","business"),("4","0","","","false","false","Broad","null","Active","+buy +and +sell +a +home +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +and +sell +a +house +Kissimmee "),("4","0","","","false","false","Broad","null","Act ive","+buy +and +sell +home +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +and +sell +homes +Kissimmee "),("4","0","","","false","false"," Broad","null","Active","+buy +and +sell +house +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +and +sell +houses +Kissimmee "),("4","0","", "","false","false","Broad","null","Active","+buy +sell +a +home +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +sell +a +house +Kissimmee " ),("4","0","","","false","false","Broad","null","Active","+buy +sell +home +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +sell +homes +Kis simmee "),("4","0","","","false","false","Broad","null","Active","+buy +sell +house +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+buy +sell +h ouses +Kissimmee "),("4","0","","","true","false","Phrase","null","Active","career"),("4","0","","","true","false","Phrase","null","Active","careers"),("4","0","",""," true","false","Phrase","null","Active","certification"),("4","0","","","true","false","Phrase","null","Active","class"),("4","0","","","true","false","Phrase","null"," Active","classes"),("4","0","","","true","false","Phrase","null","Active","course"),("4","0","","","true","false","Phrase","null","Active","courses"),("4","0","","","t rue","false","Phrase","null","Active","degree"),("4","0","","","true","false","Phrase","null","Active","diploma"),("4","0","","","true","false","Phrase","null","Active ","earnings"),("4","0","","","true","false","Phrase","null","Active","education"),("4","0","","","true","false","Phrase","null","Active","exam"),("4","0","","","false" ,"false","Broad","null","Active","+flat +fee +real +estate +listings +Kissimmee "),("4","0","","","true","false","Phrase","null","Active","from home"),("4","0","",""," true","false","Phrase","null","Active","furniture"),("4","0","","","true","false","Phrase","null","Active","google homes"),("4","0","","","true","false","Phrase","null ","Active","haiti"),("4","0","","","true","false","Phrase","null","Active","how can"),("4","0","","","true","false","Phrase","null","Active","how do"),("4","0","",""," true","false","Phrase","null","Active","how to"),("4","0","","","true","false","Phrase","null","Active","investment"),("4","0","","","true","false","Phrase","null","Ac tive","jamaica"),("4","0","","","true","false","Phrase","null","Active","japan"),("4","0","","","true","false","Phrase","null","Active","job"),("4","0","","","true","f alse","Phrase","null","Active","jobs"),("4","0","","","true","false","Phrase","null","Active","license"),("4","0","","","true","false","Phrase","null","Active","licens ing"),("4","0","","","true","false","Phrase","null","Active","mobile"),("4","0","","","true","false","Phrase","null","Active","pay"),("4","0","","","false","false","Br oad","null","Active","+property +agent +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+property +agents +Kissimmee "),("4","0","","","false","fa lse","Broad","null","Active","+real +estate +agencies +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +agency +Kissimmee "),("4","0 ","","","false","false","Broad","null","Active","+real +estate +agent +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +agents +Kiss immee "),("4","0","","","false","false","Broad","null","Active","+real +estate +broker +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +est ate +brokers +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +companies +Kissimmee "),("4","0","","","false","false","Broad","null" ,"Active","+real +estate +company +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +listing +agent +Kissimmee "),("4","0","","","fal se","false","Broad","null","Active","+real +estate +office +Kissimmee "),("4","0","","","false","false","Broad","null","Active","+real +estate +offices +Kissimmee "),( "4","0","","","true","false","Phrase","null","Active","salary"),("4","0","","","true","false","Phrase","null","Active","school"),("4","0","","","true","false","Phrase" ,"null","Active","schools"),("4","0","","","true","false","Phrase","null","Active","software"),("4","0","","","true","false","Phrase","null","Active","tax"),("4","0"," ","","true","false","Phrase","null","Active","training"),("4","0","","","true","false","Phrase","null","Active","trulia"),("4","0","","","true","false","Phrase","null" ,"Active","university"),("4","0","","","true","false","Phrase","null","Active","used"),("4","0","","","true","false","Phrase","null","Active","what are"),("4","0",""," ","true","false","Phrase","null","Active","what do"),("4","0","","","true","false","Phrase","null","Active","what is"),("4","0","","","true","false","Phrase","null","A ctive","zillow"),("4","0","","","true","false","Phrase","null","Active","zoopla"),("6","0","","","false","false","Broad","null","Active","+apartment +property +managem ent"),("6","0","","","false","false","Broad","null","Active","+commercial +property +management"),("6","0","","","false","false","Broad","null","Active","+commercial + property +manager"),("6","0","","","false","false","Broad","null","Active","+commercial +property +managers"),("6","0","","","false","false","Broad","null","Active","+ home +property +management"),("6","0","","","false","false","Broad","null","Active","+manage +properties"),("6","0","","","false","false","Broad","null","Active","+man age +property"),("6","0","","","false","false","Broad","null","Active","+management +for +properties"),("6","0","","","false","false","Broad","null","Active","+managem ent +for +property"),("6","0","","","false","false","Broad","null","Active","+management +properties"),("6","0","","","false","false","Broad","null","Active","+managem ent +property"),("6","0","","","false","false","Broad","null","Active","+managing +properties"),("6","0","","","false","false","Broad","null","Active","+managing +prop erty"),("6","0","","","false","false","Broad","null","Active","+properties +management"),("6","0","","","false","false","Broad","null","Active","+property +management" ),("6","0","","","false","false","Broad","null","Active","+property +management +co"),("6","0","","","false","false","Broad","null","Active","+property +management +co mpanies"),("6","0","","","false","false","Broad","null","Active","+property +management +company"),("6","0","","","false","false","Broad","null","Active","+property +m anagement +firms"),("6","0","","","false","false","Broad","null","Active","+property +management +services"),("6","0","","","false","false","Broad","null","Active","+p roperty +manager"),("6","0","","","false","false","Broad","null","Active","+property +manager +companies"),("6","0","","","false","false","Broad","null","Active","+pro perty +managers"),("6","0","","","false","false","Broad","null","Active","+property +managing"),("6","0","","","false","false","Broad","null","Active","+property +mana gment"),("6","0","","","false","false","Broad","null","Active","+real +property +management"),("6","0","","","false","false","Exact","null","Active","apartment propert y management"),("6","0","","","true","false","Phrase","null","Active","become"),("6","0","","","true","false","Phrase","null","Active","becoming"),("6","0","","","true ","false","Phrase","null","Active","career"),("6","0","","","true","false","Phrase","null","Active","careers"),("6","0","","","true","false","Phrase","null","Active"," certification"),("6","0","","","false","false","Exact","null","Active","commercial property management"),("6","0","","","false","false","Exact","null","Active","commer cial property manager"),("6","0","","","false","false","Exact","null","Active","commercial property managers"),("6","0","","","true","false","Phrase","null","Active"," courses"),("6","0","","","true","false","Phrase","null","Active","degree"),("6","0","","","true","false","Phrase","null","Active","diploma"),("6","0","","","true","fal se","Phrase","null","Active","earnings"),("6","0","","","true","false","Phrase","null","Active","exam"),("6","0","","","false","false","Exact","null","Active","home pr operty management"),("6","0","","","true","false","Phrase","null","Active","how can"),("6","0","","","true","false","Phrase","null","Active","how do"),("6","0","",""," true","false","Phrase","null","Active","how to"),("6","0","","","true","false","Phrase","null","Active","job"),("6","0","","","true","false","Phrase","null","Active"," jobs"),("6","0","","","false","false","Exact","null","Active","manage properties"),("6","0","","","false","false","Exact","null","Active","manage property"),("6","0"," ","","false","false","Exact","null","Active","management for properties"),("6","0","","","false","false","Exact","null","Active","management for property"),("6","0","" ,"","false","false","Exact","null","Active","management properties"),("6","0","","","false","false","Exact","null","Active","management property"),("6","0","","","fals e","false","Exact","null","Active","managing properties"),("6","0","","","false","false","Exact","null","Active","managing property"),("6","0","","","true","false","Ph rase","null","Active","pay"),("6","0","","","false","false","Exact","null","Active","properties management"),("6","0","","","false","false","Exact","null","Active","pr operty management"),("6","0","","","false","false","Exact","null","Active","property management co"),("6","0","","","false","false","Exact","null","Active","property m anagement companies"),("6","0","","","false","false","Exact","null","Active","property management company"),("6","0","","","false","false","Exact","null","Active","pro perty management firms"),("6","0","","","false","false","Exact","null","Active","property management services"),("6","0","","","false","false","Exact","null","Active", "property manager"),("6","0","","","false","false","Exact","null","Active","property manager companies"),("6","0","","","false","false","Exact","null","Active","proper ty managers"),("6","0","","","false","false","Exact","null","Active","property managing"),("6","0","","","false","false","Exact","null","Active","property managment"), ("6","0","","","false","false","Exact","null","Active","real property management"),("6","0","","","true","false","Phrase","null","Active","salary"),("6","0","","","tru e","false","Phrase","null","Active","tax"),("6","0","","","true","false","Phrase","null","Active","training"),("6","0","","","true","false","Phrase","null","Active","u niversity"),("6","0","","","true","false","Phrase","null","Active","what are"),("6","0","","","true","false","Phrase","null","Active","what is"),("7","0","","","false" ,"false","Broad","null","Active","+apartment +property +management +Nags +Head +NC "),("7","0","","","true","false","Phrase","null","Active","become"),("7","0","",""," true","false","Phrase","null","Active","becoming"),("7","0","","","true","false","Phrase","null","Active","career"),("7","0","","","true","false","Phrase","null","Acti ve","careers"),("7","0","","","true","false","Phrase","null","Active","certification"),("7","0","","","false","false","Broad","null","Active","+commercial +property +m anagement +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+commercial +property +manager +Nags +Head +NC "),("7","0","","","false","false"," Broad","null","Active","+commercial +property +managers +Nags +Head +NC "),("7","0","","","true","false","Phrase","null","Active","courses"),("7","0","","","true","fal se","Phrase","null","Active","degree"),("7","0","","","true","false","Phrase","null","Active","diploma"),("7","0","","","true","false","Phrase","null","Active","earnin gs"),("7","0","","","true","false","Phrase","null","Active","exam"),("7","0","","","false","false","Broad","null","Active","+home +property +management +Nags +Head +NC "),("7","0","","","true","false","Phrase","null","Active","how can"),("7","0","","","true","false","Phrase","null","Active","how do"),("7","0","","","true","false","P hrase","null","Active","how to"),("7","0","","","true","false","Phrase","null","Active","job"),("7","0","","","true","false","Phrase","null","Active","jobs"),("7","0", "","","false","false","Broad","null","Active","+manage +properties +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+manage +property +Nags + Head +NC "),("7","0","","","false","false","Broad","null","Active","+management +for +properties +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Acti ve","+management +for +property +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+management +properties +Nags +Head +NC "),("7","0","","","f alse","false","Broad","null","Active","+management +property +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+managing +properties +Nags +He ad +NC "),("7","0","","","false","false","Broad","null","Active","+managing +property +Nags +Head +NC "),("7","0","","","true","false","Phrase","null","Active","pay"), ("7","0","","","false","false","Broad","null","Active","+properties +management +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +m anagement +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +management +co +Nags +Head +NC "),("7","0","","","false","false","Broad ","null","Active","+property +management +companies +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +management +company +Nags +He ad +NC "),("7","0","","","false","false","Broad","null","Active","+property +management +firms +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active ","+property +management +services +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +manager +Nags +Head +NC "),("7","0","","","fal se","false","Broad","null","Active","+property +manager +companies +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +managers +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+property +managing +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+p roperty +managment +Nags +Head +NC "),("7","0","","","false","false","Broad","null","Active","+real +property +management +Nags +Head +NC "),("7","0","","","true","fal se","Phrase","null","Active","salary"),("7","0","","","true","false","Phrase","null","Active","tax"),("7","0","","","true","false","Phrase","null","Active","training") ,("7","0","","","true","false","Phrase","null","Active","university"),("7","0","","","true","false","Phrase","null","Active","what are"),("7","0","","","true","false", "Phrase","null","Active","what is"),("8","0","","","false","false","Broad","null","Active","+apartment +property +management +Nags +Head "),("8","0","","","true","fals e","Phrase","null","Active","become"),("8","0","","","true","false","Phrase","null","Active","becoming"),("8","0","","","true","false","Phrase","null","Active","career "),("8","0","","","true","false","Phrase","null","Active","careers"),("8","0","","","true","false","Phrase","null","Active","certification"),("8","0","","","false","fa lse","Broad","null","Active","+commercial +property +management +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+commercial +property +manager + Nags +Head "),("8","0","","","false","false","Broad","null","Active","+commercial +property +managers +Nags +Head "),("8","0","","","true","false","Phrase","null","Act ive","courses"),("8","0","","","true","false","Phrase","null","Active","degree"),("8","0","","","true","false","Phrase","null","Active","diploma"),("8","0","","","true ","false","Phrase","null","Active","earnings"),("8","0","","","true","false","Phrase","null","Active","exam"),("8","0","","","false","false","Broad","null","Active","+ home +property +management +Nags +Head "),("8","0","","","true","false","Phrase","null","Active","how can"),("8","0","","","true","false","Phrase","null","Active","how do"),("8","0","","","true","false","Phrase","null","Active","how to"),("8","0","","","true","false","Phrase","null","Active","job"),("8","0","","","true","false","Phr ase","null","Active","jobs"),("8","0","","","false","false","Broad","null","Active","+manage +properties +Nags +Head "),("8","0","","","false","false","Broad","null"," Active","+manage +property +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+management +for +properties +Nags +Head "),("8","0","","","false","f alse","Broad","null","Active","+management +for +property +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+management +properties +Nags +Head ") ,("8","0","","","false","false","Broad","null","Active","+management +property +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+managing +proper ties +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+managing +property +Nags +Head "),("8","0","","","true","false","Phrase","null","Active"," pay"),("8","0","","","false","false","Broad","null","Active","+properties +management +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +management +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +management +co +Nags +Head "),("8","0","","","false","false","Broad","nul l","Active","+property +management +companies +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +management +company +Nags +Head "),("8" ,"0","","","false","false","Broad","null","Active","+property +management +firms +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +mana gement +services +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +manager +Nags +Head "),("8","0","","","false","false","Broad","null" ,"Active","+property +manager +companies +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +managers +Nags +Head "),("8","0","","","fals e","false","Broad","null","Active","+property +managing +Nags +Head "),("8","0","","","false","false","Broad","null","Active","+property +managment +Nags +Head "),("8" ,"0","","","false","false","Broad","null","Active","+real +property +management +Nags +Head "),("8","0","","","true","false","Phrase","null","Active","salary"),("8","0 ","","","true","false","Phrase","null","Active","tax"),("8","0","","","true","false","Phrase","null","Active","training"),("8","0","","","true","false","Phrase","null" ,"Active","university"),("8","0","","","true","false","Phrase","null","Active","what are"),("8","0","","","true","false","Phrase","null","Active","what is")] executed by user [spike]
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 1 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 2 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 3 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 4 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 5 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 6 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 7 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 8 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 9 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 10 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 11 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 12 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 13 (1366)
2015-05-11 06:40:55.305 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 14 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 15 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 16 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 17 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 18 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 19 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 20 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 21 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 22 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 23 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 24 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 25 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 26 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 27 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 28 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 29 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 30 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 31 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 32 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 33 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 34 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 35 (1366)
2015-05-11 06:40:55.306 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 36 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 37 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 38 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 39 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 40 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 41 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 42 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 43 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 44 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 45 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 46 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 47 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 48 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 49 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 50 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 51 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 52 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 53 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 54 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 55 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 56 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 57 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 58 (1366)
2015-05-11 06:40:55.307 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 59 (1366)
2015-05-11 06:40:55.308 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 60 (1366)
2015-05-11 06:40:55.308 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 61 (1366)
2015-05-11 06:40:55.308 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 62 (1366)
2015-05-11 06:40:55.308 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 63 (1366)
2015-05-11 06:40:55.308 (2) [P2T1]: Incorrect decimal value: 'null' for column 'maxCPC' at row 64 (1366)
2015-05-11 06:40:55.308 (5) [P2T1]: recordAsSubs("db", 64, "P2T1")
2015-05-11 06:40:55.308 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.308 (5) [P2T1]: ProfilerRec.end("db", true): ret=64
2015-05-11 06:40:55.308 (4) [P2T1]: time=0.064
2015-05-11 06:40:55.308 (4) [P2T1]: Query executed in 0.064s
2015-05-11 06:40:55.308 (5) [P2T1]: SQL execute() returned false
2015-05-11 06:40:55.308 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.308 (4) [P2T1]: spike: SQL->[create temporary table `content_editor_google`.`tmp5` engine=innodb character set utf8mb4 collate utf8mb4_unicode_ci s elect * from `content_editor_google`.`tmp4`]
2015-05-11 06:40:55.389 (5) [P2T1]: recordAsSubs("db", 81, "P2T1")
2015-05-11 06:40:55.389 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.389 (5) [P2T1]: ProfilerRec.end("db", true): ret=81
2015-05-11 06:40:55.389 (4) [P2T1]: time=0.081
2015-05-11 06:40:55.390 (4) [P2T1]: Query executed in 0.081s
2015-05-11 06:40:55.390 (5) [P2T1]: SQL execute() returned false
2015-05-11 06:40:55.390 (5) [P2T1]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer
2015-05-11 06:40:55.390 (5) [P2T1]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer
2015-05-11 06:40:55.390 (5) [P2T1]: quoteValue(), nothing special about it=>[2], type=class java.lang.Integer
2015-05-11 06:40:55.390 (5) [P2T1]: quoteValue(), nothing special about it=>[4], type=class java.lang.Integer
2015-05-11 06:40:55.390 (5) [P2T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer
2015-05-11 06:40:55.391 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.391 (4) [P2T1]: spike: SQL->[create temporary table `content_editor_google`.`tmp6` engine=innodb character set utf8mb4 collate utf8mb4_unicode_ci ( select `content_editor_google`.`gce_keyword`.`id` AS `id_gce`,`content_editor_google`.`tmp4`.`id` AS `id_struct`,`content_editor_google`.`gce_keyword`.`adGroupID` AS ` adGroupID_gce`,`content_editor_google`.`tmp4`.`adGroupID` AS `adGroupID_struct`,`content_editor_google`.`gce_keyword`.`searchEngineIdentifier` AS `searchEngineIdentifi er_gce`,`content_editor_google`.`tmp4`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_google`.`gce_keyword`.`text` AS `text_gce`,`content_ editor_google`.`tmp4`.`text` AS `text_struct`,`content_editor_google`.`gce_keyword`.`keywordType` AS `keywordType_gce`,`content_editor_google`.`tmp4`.`keywordType` AS `keywordType_struct`,`content_editor_google`.`gce_keyword`.`maxCPC` AS `maxCPC_gce`,`content_editor_google`.`tmp4`.`maxCPC` AS `maxCPC_struct`,`content_editor_google`. `gce_keyword`.`exemptionRequest` AS `exemptionRequest_gce`,`content_editor_google`.`tmp4`.`exemptionRequest` AS `exemptionRequest_struct`,`content_editor_google`.`gce_ keyword`.`destinationURL` AS `destinationURL_gce`,`content_editor_google`.`tmp4`.`destinationURL` AS `destinationURL_struct`,`content_editor_google`.`gce_keyword`.`isP aused` AS `isPaused_gce`,`content_editor_google`.`tmp4`.`isPaused` AS `isPaused_struct`,`content_editor_google`.`gce_keyword`.`isNegative` AS `isNegative_gce`,`content _editor_google`.`tmp4`.`isNegative` AS `isNegative_struct`,`content_editor_google`.`gce_keyword`.`status` AS `status_gce`,`content_editor_google`.`tmp4`.`status` AS `s tatus_struct` from `content_editor_google`.`gce_keyword` left join `content_editor_google`.`tmp4` on (((`content_editor_google`.`gce_keyword`.`adGroupID`=`content_edit or_google`.`tmp4`.`adGroupID`) and (`content_editor_google`.`gce_keyword`.`text`=`content_editor_google`.`tmp4`.`text`) and (`content_editor_google`.`gce_keyword`.`key wordType`=`content_editor_google`.`tmp4`.`keywordType`) and (`content_editor_google`.`gce_keyword`.`isNegative`=`content_editor_google`.`tmp4`.`isNegative`))) left joi n `content_editor_google`.`gce_adGroup` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_keyword`.`adGroupID`)) left join `content_editor_g oogle`.`gce_campaign` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) where ((`content_editor_google`.`gce_keywor d`.`status`!="Deleted") and (`content_editor_google`.`gce_adGroup`.`status`!="Deleted") and (`content_editor_google`.`gce_campaign`.`searchEngineUserID`=1) and (`conte nt_editor_google`.`gce_campaign`.`id` in (1,2,4,5)))) union (select `content_editor_google`.`gce_keyword`.`id` AS `id_gce`,`content_editor_google`.`tmp5`.`id` AS `id_s truct`,`content_editor_google`.`gce_keyword`.`adGroupID` AS `adGroupID_gce`,`content_editor_google`.`tmp5`.`adGroupID` AS `adGroupID_struct`,`content_editor_google`.`g ce_keyword`.`searchEngineIdentifier` AS `searchEngineIdentifier_gce`,`content_editor_google`.`tmp5`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`conten t_editor_google`.`gce_keyword`.`text` AS `text_gce`,`content_editor_google`.`tmp5`.`text` AS `text_struct`,`content_editor_google`.`gce_keyword`.`keywordType` AS `keyw ordType_gce`,`content_editor_google`.`tmp5`.`keywordType` AS `keywordType_struct`,`content_editor_google`.`gce_keyword`.`maxCPC` AS `maxCPC_gce`,`content_editor_google `.`tmp5`.`maxCPC` AS `maxCPC_struct`,`content_editor_google`.`gce_keyword`.`exemptionRequest` AS `exemptionRequest_gce`,`content_editor_google`.`tmp5`.`exemptionReques t` AS `exemptionRequest_struct`,`content_editor_google`.`gce_keyword`.`destinationURL` AS `destinationURL_gce`,`content_editor_google`.`tmp5`.`destinationURL` AS `dest inationURL_struct`,`content_editor_google`.`gce_keyword`.`isPaused` AS `isPaused_gce`,`content_editor_google`.`tmp5`.`isPaused` AS `isPaused_struct`,`content_editor_go ogle`.`gce_keyword`.`isNegative` AS `isNegative_gce`,`content_editor_google`.`tmp5`.`isNegative` AS `isNegative_struct`,`content_editor_google`.`gce_keyword`.`status` AS `status_gce`,`content_editor_google`.`tmp5`.`status` AS `status_struct` from `content_editor_google`.`tmp5` left join `content_editor_google`.`gce_keyword` on (((`c ontent_editor_google`.`gce_keyword`.`adGroupID`=`content_editor_google`.`tmp5`.`adGroupID`) and (`content_editor_google`.`gce_keyword`.`text`=`content_editor_google`.` tmp5`.`text`) and (`content_editor_google`.`gce_keyword`.`keywordType`=`content_editor_google`.`tmp5`.`keywordType`) and (`content_editor_google`.`gce_keyword`.`isNega tive`=`content_editor_google`.`tmp5`.`isNegative`))) where ((`content_editor_google`.`gce_keyword`.`text` is null) and (`content_editor_google`.`tmp5`.`status`!="Disab led")))]
2015-05-11 06:40:55.945 (5) [P2T1]: recordAsSubs("db", 554, "P2T1")
2015-05-11 06:40:55.946 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.946 (5) [P2T1]: ProfilerRec.end("db", true): ret=554
2015-05-11 06:40:55.946 (4) [P2T1]: time=0.554
2015-05-11 06:40:55.946 (4) [P2T1]: Query executed in 0.554s
2015-05-11 06:40:55.946 (5) [P2T1]: SQL execute() returned false
2015-05-11 06:40:55.949 (4) [P2T1]: DB IsolationLevel -> 4
2015-05-11 06:40:55.950 (4) [P2T1]: DB AutoCommit -> false
2015-05-11 06:40:55.951 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.951 (4) [P2T1]: spike: SQL->[start transaction]
2015-05-11 06:40:55.953 (5) [P2T1]: recordAsSubs("db", 2, "P2T1")
2015-05-11 06:40:55.953 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.953 (5) [P2T1]: ProfilerRec.end("db", true): ret=2
2015-05-11 06:40:55.953 (4) [P2T1]: time=0.0020
2015-05-11 06:40:55.953 (4) [P2T1]: Query executed in 0.002s
2015-05-11 06:40:55.953 (5) [P2T1]: SQL execute() returned false
2015-05-11 06:40:55.955 (5) [P2T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer
2015-05-11 06:40:55.955 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.955 (4) [P2T1]: spike: SQL->[insert into `content_editor_google`.`gce_keywordPendingChange` (`content_editor_google`.`gce_keywordPendingChange`.`ke ywordID`,`content_editor_google`.`gce_keywordPendingChange`.`type`,`content_editor_google`.`gce_keywordPendingChange`.`tryCount`,`content_editor_google`.`gce_keywordPe ndingChange`.`isFailed`) select `content_editor_google`.`tmp6`.`id_gce`,"delete" AS `type`,0 AS `tryCount`,"false" AS `isFailed` from `content_editor_google`.`tmp6` wh ere ((`content_editor_google`.`tmp6`.`text_struct` is null)) on duplicate key update `type`="delete",`tryCount`=0,`isFailed`="false"], genflags=no
2015-05-11 06:40:55.959 (5) [P2T1]: recordAsSubs("db", 4, "P2T1")
2015-05-11 06:40:55.959 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.959 (5) [P2T1]: ProfilerRec.end("db", true): ret=4
2015-05-11 06:40:55.959 (4) [P2T1]: time=0.0040
2015-05-11 06:40:55.959 (4) [P2T1]: Query executed in 0.004s, 0 row(s) affected
2015-05-11 06:40:55.959 (3) [P2T1]: No deleted keywords found
2015-05-11 06:40:55.959 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.959 (4) [P2T1]: spike: SQL->[insert into `gce_keyword` (`content_editor_google`.`gce_keyword`.`adGroupID`,`content_editor_google`.`gce_keyword`.`ke ywordType`,`content_editor_google`.`gce_keyword`.`text`,`content_editor_google`.`gce_keyword`.`maxCPC`,`content_editor_google`.`gce_keyword`.`destinationURL`,`content_ editor_google`.`gce_keyword`.`isNegative`,`content_editor_google`.`gce_keyword`.`isPaused`,`content_editor_google`.`gce_keyword`.`status`,`content_editor_google`.`gce_ keyword`.`exemptionRequest`) select `content_editor_google`.`tmp6`.`adGroupID_struct`,`content_editor_google`.`tmp6`.`keywordType_struct`,`content_editor_google`.`tmp6 `.`text_struct`,`content_editor_google`.`tmp6`.`maxCPC_struct`,`content_editor_google`.`tmp6`.`destinationURL_struct`,`content_editor_google`.`tmp6`.`isNegative_struct `,`content_editor_google`.`tmp6`.`isPaused_struct`,`content_editor_google`.`tmp6`.`status_struct`,`content_editor_google`.`tmp6`.`exemptionRequest_struct` from `conten t_editor_google`.`tmp6` where ((`content_editor_google`.`tmp6`.`text_gce` is null))], genflags=no
2015-05-11 06:40:55.963 (5) [P2T1]: recordAsSubs("db", 4, "P2T1")
2015-05-11 06:40:55.963 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.963 (5) [P2T1]: ProfilerRec.end("db", true): ret=4
2015-05-11 06:40:55.963 (4) [P2T1]: time=0.0040
2015-05-11 06:40:55.964 (4) [P2T1]: Query executed in 0.004s, 0 row(s) affected
2015-05-11 06:40:55.965 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.965 (4) [P2T1]: spike: SQL->[insert into `gce_keywordPendingChange` (`content_editor_google`.`gce_keywordPendingChange`.`keywordID`,`content_editor _google`.`gce_keywordPendingChange`.`type`,`content_editor_google`.`gce_keywordPendingChange`.`tryCount`,`content_editor_google`.`gce_keywordPendingChange`.`isFailed`) select `content_editor_google`.`gce_keyword`.`id`,"add" AS `type`,0 AS `tryCount`,"false" AS `isFailed` from `content_editor_google`.`tmp6` join `gce_keyword` on (((` content_editor_google`.`tmp6`.`adGroupID_struct`=`content_editor_google`.`gce_keyword`.`adGroupID`) and (`content_editor_google`.`tmp6`.`isNegative_struct`=`content_ed itor_google`.`gce_keyword`.`isNegative`) and (`content_editor_google`.`tmp6`.`isPaused_struct`=`content_editor_google`.`gce_keyword`.`isPaused`) and (`content_editor_g oogle`.`tmp6`.`keywordType_struct`=`content_editor_google`.`gce_keyword`.`keywordType`) and (`content_editor_google`.`tmp6`.`text_struct`=`content_editor_google`.`gce_ keyword`.`text`) and (`content_editor_google`.`tmp6`.`status_struct`=`content_editor_google`.`gce_keyword`.`status`) and (`content_editor_google`.`tmp6`.`destinationUR L_struct`=`content_editor_google`.`gce_keyword`.`destinationURL`) and (`content_editor_google`.`tmp6`.`searchEngineIdentifier_gce` is null))) left join `gce_keywordPen dingChange` on ((`content_editor_google`.`gce_keywordPendingChange`.`keywordID`=`content_editor_google`.`tmp6`.`id_struct`)) where ((`content_editor_google`.`tmp6`.`te xt_gce` is null) and (`content_editor_google`.`gce_keywordPendingChange`.`keywordID` is null))], genflags=no
2015-05-11 06:40:55.969 (5) [P2T1]: recordAsSubs("db", 4, "P2T1")
2015-05-11 06:40:55.969 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.969 (5) [P2T1]: ProfilerRec.end("db", true): ret=4
2015-05-11 06:40:55.970 (4) [P2T1]: time=0.0040
2015-05-11 06:40:55.970 (4) [P2T1]: Query executed in 0.004s, 0 row(s) affected
2015-05-11 06:40:55.970 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.970 (4) [P2T1]: spike: SQL->[replace into `gce_keywordPendingChange` (`gce_keywordPendingChange`.`keywordID`,`gce_keywordPendingChange`.`type`,`gce _keywordPendingChange`.`tryCount`,`gce_keywordPendingChange`.`isFailed`) select `gce_keyword`.`ID`,"update","0","false" from `content_editor_google`.`tmp6` join `gce_k eyword` on ((`content_editor_google`.`tmp6`.`ID_gce`=`gce_keyword`.`ID`)) where (((((((`content_editor_google`.`tmp6`.`adGroupID_gce` is not null)) and ((`content_edit or_google`.`tmp6`.`adGroupID_struct` is not null))))) and ((`content_editor_google`.`tmp6`.`isNegative_gce`!=`content_editor_google`.`tmp6`.`isNegative_struct`))))], g enflags=no
2015-05-11 06:40:55.976 (5) [P2T1]: recordAsSubs("db", 6, "P2T1")
2015-05-11 06:40:55.976 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.976 (5) [P2T1]: ProfilerRec.end("db", true): ret=6
2015-05-11 06:40:55.976 (4) [P2T1]: time=0.0060
2015-05-11 06:40:55.976 (4) [P2T1]: Query executed in 0.006s, 0 row(s) affected
2015-05-11 06:40:55.977 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.977 (4) [P2T1]: spike: SQL->[replace into `gce_keywordPendingUpdate` (`gce_keywordPendingUpdate`.`keywordID`,`gce_keywordPendingUpdate`.`destinatio nURL`,`gce_keywordPendingUpdate`.`isNegative`,`gce_keywordPendingUpdate`.`isPaused`,`gce_keywordPendingUpdate`.`status`) select `gce_keyword`.`ID`,`content_editor_goog le`.`tmp6`.`destinationURL_struct`,`content_editor_google`.`tmp6`.`isNegative_struct`,`content_editor_google`.`tmp6`.`isPaused_struct`,`content_editor_google`.`tmp6`.` status_struct` from `content_editor_google`.`tmp6` join `gce_keyword` on ((`content_editor_google`.`tmp6`.`ID_gce`=`gce_keyword`.`ID`)) where (((((((`content_editor_go ogle`.`tmp6`.`adGroupID_gce` is not null)) and ((`content_editor_google`.`tmp6`.`adGroupID_struct` is not null))))) and ((`content_editor_google`.`tmp6`.`isNegative_gc e`!=`content_editor_google`.`tmp6`.`isNegative_struct`))))], genflags=no
2015-05-11 06:40:55.981 (5) [P2T1]: recordAsSubs("db", 4, "P2T1")
2015-05-11 06:40:55.981 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.981 (5) [P2T1]: ProfilerRec.end("db", true): ret=4
2015-05-11 06:40:55.981 (4) [P2T1]: time=0.0040
2015-05-11 06:40:55.981 (4) [P2T1]: Query executed in 0.004s, 0 row(s) affected
2015-05-11 06:40:55.981 (3) [P2T1]: Deleting 0 keywords and adding 0 keywords and Updated 0.
2015-05-11 06:40:55.981 (4) [P2T1]: spike: SQL->[commit]
2015-05-11 06:40:55.981 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.982 (5) [P2T1]: recordAsSubs("db", 1, "P2T1")
2015-05-11 06:40:55.982 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.983 (5) [P2T1]: ProfilerRec.end("db", true): ret=1
2015-05-11 06:40:55.983 (4) [P2T1]: time=0.0010
2015-05-11 06:40:55.983 (4) [P2T1]: Query executed in 0.001s
2015-05-11 06:40:55.983 (4) [P2T1]: DB AutoCommit -> true
2015-05-11 06:40:55.984 (4) [P2T1]: DB IsolationLevel -> 4
2015-05-11 06:40:55.985 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.985 (4) [P2T1]: spike: SQL->[select distinct `adGroupID_gce`,`adGroupID_struct` from `content_editor_google`.`tmp6` where (((((((`text_gce` is null )) or ((`text_struct` is null))))) or ((((((((`content_editor_google`.`tmp6`.`text_gce` is not null)) and ((`content_editor_google`.`tmp6`.`text_struct` is not null))) )) and ((`content_editor_google`.`tmp6`.`isNegative_gce`!=`content_editor_google`.`tmp6`.`isNegative_struct`)))))))]
2015-05-11 06:40:55.989 (5) [P2T1]: recordAsSubs("db", 4, "P2T1")
2015-05-11 06:40:55.989 (5) [P2T1]: addSub("db")
2015-05-11 06:40:55.989 (5) [P2T1]: ProfilerRec.end("db", true): ret=4
2015-05-11 06:40:55.989 (4) [P2T1]: time=0.0040
2015-05-11 06:40:55.989 (4) [P2T1]: Query executed in 0.004s
2015-05-11 06:40:55.993 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:55.994 (4) [P2T1]: spike: SQL->[drop table `content_editor_google`.`tmp4`]
2015-05-11 06:40:56.004 (5) [P2T1]: recordAsSubs("db", 10, "P2T1")
2015-05-11 06:40:56.004 (5) [P2T1]: addSub("db")
2015-05-11 06:40:56.004 (5) [P2T1]: ProfilerRec.end("db", true): ret=10
2015-05-11 06:40:56.004 (4) [P2T1]: time=0.01
2015-05-11 06:40:56.005 (4) [P2T1]: Query executed in 0.010s
2015-05-11 06:40:56.005 (5) [P2T1]: SQL execute() returned false
2015-05-11 06:40:56.005 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:56.005 (4) [P2T1]: spike: SQL->[drop table `content_editor_google`.`tmp5`]
2015-05-11 06:40:56.016 (5) [P2T1]: recordAsSubs("db", 11, "P2T1")
2015-05-11 06:40:56.016 (5) [P2T1]: addSub("db")
2015-05-11 06:40:56.016 (5) [P2T1]: ProfilerRec.end("db", true): ret=11
2015-05-11 06:40:56.016 (4) [P2T1]: time=0.011
2015-05-11 06:40:56.016 (4) [P2T1]: Query executed in 0.011s
2015-05-11 06:40:56.016 (5) [P2T1]: SQL execute() returned false
2015-05-11 06:40:56.017 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:56.017 (4) [P2T1]: spike: SQL->[drop table `content_editor_google`.`tmp6`]
2015-05-11 06:40:56.022 (5) [P2T1]: recordAsSubs("db", 5, "P2T1")
2015-05-11 06:40:56.023 (5) [P2T1]: addSub("db")
2015-05-11 06:40:56.023 (5) [P2T1]: ProfilerRec.end("db", true): ret=5
2015-05-11 06:40:56.023 (4) [P2T1]: time=0.0050
2015-05-11 06:40:56.023 (4) [P2T1]: Query executed in 0.005s
2015-05-11 06:40:56.023 (5) [P2T1]: SQL execute() returned false
2015-05-11 06:40:56.023 (5) [P2T1]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer
2015-05-11 06:40:56.023 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:56.023 (4) [P2T1]: spike: SQL->[select `content_editor_google`.`gce_adGroup`.`name`,`content_editor_google`.`gce_adGroup`.`id` from `content_editor_go ogle`.`gce_adGroup` where ((((`content_editor_google`.`gce_adGroup`.`campaignID`=1)) and ((`content_editor_google`.`gce_adGroup`.`status`!="Deleted"))))]
2015-05-11 06:40:56.025 (5) [P2T1]: recordAsSubs("db", 2, "P2T1")
2015-05-11 06:40:56.025 (5) [P2T1]: addSub("db")
2015-05-11 06:40:56.025 (5) [P2T1]: ProfilerRec.end("db", true): ret=2
2015-05-11 06:40:56.025 (4) [P2T1]: time=0.0020
2015-05-11 06:40:56.025 (4) [P2T1]: Query executed in 0.002s
2015-05-11 06:40:56.026 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:56.026 (4) [P2T1]: spike: SQL->[create temporary table `content_editor_google`.`tmp7` engine=innodb character set utf8mb4 collate utf8mb4_unicode_ci s elect * from `content_editor_google`.`gce_textAd` where ("0")]
2015-05-11 06:40:56.066 (5) [P2T1]: recordAsSubs("db", 40, "P2T1")
2015-05-11 06:40:56.066 (5) [P2T1]: addSub("db")
2015-05-11 06:40:56.066 (5) [P2T1]: ProfilerRec.end("db", true): ret=40
2015-05-11 06:40:56.066 (4) [P2T1]: time=0.04
2015-05-11 06:40:56.066 (4) [P2T1]: Query executed in 0.040s
2015-05-11 06:40:56.066 (5) [P2T1]: SQL execute() returned false
2015-05-11 06:40:56.066 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:56.066 (4) [P2T1]: spike: SQL->[ALTER TABLE `content_editor_google`.`tmp7` ADD KEY (adGroupID)], genflags=no
2015-05-11 06:40:56.102 (5) [P2T1]: recordAsSubs("db", 36, "P2T1")
2015-05-11 06:40:56.103 (5) [P2T1]: addSub("db")
2015-05-11 06:40:56.103 (5) [P2T1]: ProfilerRec.end("db", true): ret=36
2015-05-11 06:40:56.103 (4) [P2T1]: time=0.036
2015-05-11 06:40:56.103 (4) [P2T1]: Query executed in 0.036s, 0 row(s) affected
2015-05-11 06:40:56.103 (4) [P2T1]: affected[add_key] = 0
2015-05-11 06:40:56.103 (5) [P2T1]: quoteValue(), nothing special about it=>[2], type=class java.lang.Integer
2015-05-11 06:40:56.103 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:56.103 (4) [P2T1]: spike: SQL->[select `content_editor_google`.`gce_adGroup`.`name`,`content_editor_google`.`gce_adGroup`.`id` from `content_editor_go ogle`.`gce_adGroup` where ((((`content_editor_google`.`gce_adGroup`.`campaignID`=2)) and ((`content_editor_google`.`gce_adGroup`.`status`!="Deleted"))))]
2015-05-11 06:40:56.105 (5) [P2T1]: recordAsSubs("db", 2, "P2T1")
2015-05-11 06:40:56.106 (5) [P2T1]: addSub("db")
2015-05-11 06:40:56.106 (5) [P2T1]: ProfilerRec.end("db", true): ret=2
2015-05-11 06:40:56.106 (4) [P2T1]: time=0.0020
2015-05-11 06:40:56.106 (4) [P2T1]: Query executed in 0.002s
2015-05-11 06:40:56.106 (5) [P2T1]: quoteValue(), nothing special about it=>[4], type=class java.lang.Integer
2015-05-11 06:40:56.106 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:56.106 (4) [P2T1]: spike: SQL->[select `content_editor_google`.`gce_adGroup`.`name`,`content_editor_google`.`gce_adGroup`.`id` from `content_editor_go ogle`.`gce_adGroup` where ((((`content_editor_google`.`gce_adGroup`.`campaignID`=4)) and ((`content_editor_google`.`gce_adGroup`.`status`!="Deleted"))))]
2015-05-11 06:40:56.109 (5) [P2T1]: recordAsSubs("db", 3, "P2T1")
2015-05-11 06:40:56.109 (5) [P2T1]: addSub("db")
2015-05-11 06:40:56.109 (5) [P2T1]: ProfilerRec.end("db", true): ret=3
2015-05-11 06:40:56.109 (4) [P2T1]: time=0.0030
2015-05-11 06:40:56.109 (4) [P2T1]: Query executed in 0.003s
2015-05-11 06:40:56.109 (5) [P2T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer
2015-05-11 06:40:56.109 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:56.109 (4) [P2T1]: spike: SQL->[select `content_editor_google`.`gce_adGroup`.`name`,`content_editor_google`.`gce_adGroup`.`id` from `content_editor_go ogle`.`gce_adGroup` where ((((`content_editor_google`.`gce_adGroup`.`campaignID`=5)) and ((`content_editor_google`.`gce_adGroup`.`status`!="Deleted"))))]
2015-05-11 06:40:56.111 (5) [P2T1]: recordAsSubs("db", 2, "P2T1")
2015-05-11 06:40:56.111 (5) [P2T1]: addSub("db")
2015-05-11 06:40:56.111 (5) [P2T1]: ProfilerRec.end("db", true): ret=2
2015-05-11 06:40:56.111 (4) [P2T1]: time=0.0020
2015-05-11 06:40:56.111 (4) [P2T1]: Query executed in 0.002s
2015-05-11 06:40:56.114 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2015-05-11 06:40:56.114 (4) [P2T1]: spike: SQL->[insert into `content_editor_google`.`tmp7` (`adGroupID`,`searchEngineIdentifier`,`headline`,`description1`,`descriptio n2`,`displayURL`,`destinationURL`,`exemptionRequest`,`isDisapproved`,`status`,`devicePreference`) values ("1","0","
","A Wealth Of Exper ience & Expertise.","Kissimmee\'s Real Estate.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("1","0","Top Real Estate Agents","Kissim mee\'s Real Estate.","A Wealth Of Experience & Expertise.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("1","0","
{KeyWord:Real Estate Agents}","We\'ll Guide You Through The Market.","We Have Local Real Estate Insight.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("1 ","0","Real Estate Agents","We Have Local Real Estate Insight.","We\'ll Guide You Through The Market.","martiantourism.com","http://martiantourism.com","","false","Ena bled","null"),("2","0","
{KeyWord:Top Real Estate Agents}","A Wealth Of Experience & Expertise.","Kissimmee\'s Real Estate.","martiantourism.com","http://martiantourism .com","","false","Enabled","null"),("2","0","Top Real Estate Agents","Kissimmee\'s Real Estate.","A Wealth Of Experience & Expertise.","martiantourism.com","http://mar tiantourism.com","","false","Enabled","null"),("2","0","
{KeyWord:Real Estate Agents}","We\'ll Guide You Through The Market.","We Have Local Real Estate Insight.","mart iantourism.com","http://martiantourism.com","","false","Enabled","null"),("2","0","Real Estate Agents","We Have Local Real Estate Insight.","We\'ll Guide You Through T he Market.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("3","0","
{KeyWord:Top Real Estate Agents}","A Wealth Of Experience & Experti se.","Kissimmee\'s Real Estate.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("3","0","Top Real Estate Agents","Kissimmee\'s Real Est ate.","A Wealth Of Experience & Expertise.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("3","0","
{KeyWord:Real Estate Agents}","We\' ll Guide You Through The Market.","We Have Local Real Estate Insight.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("3","0","Real Est ate Agents","We Have Local Real Estate Insight.","We\'ll Guide You Through The Market.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),( "4","0","
{KeyWord:Top Real Estate Agents}","A Wealth Of Experience & Expertise.","Kissimmee\'s Real Estate.","martiantourism.com","http://martiantourism.com","","false ","Enabled","null"),("4","0","Top Real Estate Agents","Kissimmee\'s Real Estate.","A Wealth Of Experience & Expertise.","martiantourism.com","http://martiantourism.com ","","false","Enabled","null"),("4","0","
{KeyWord:Real Estate Agents}","We\'ll Guide You Through The Market.","We Have Local Real Estate Insight.","martiantourism.com" ,"http://martiantourism.com","","false","Enabled","null"),("4","0","Real Estate Agents","We Have Local Real Estate Insight.","We\'ll Guide You Through The Market.","ma rtiantourism.com","http://martiantourism.com","","false","Enabled","null"),("6","0","We Manage Property","Top Quality Property Management.","Contact Us We\'re In Your Area.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("6","0","
{KeyWord:Property Managers}","Let Us Take Care Of Everything.","Come To Us For Property Management.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("6","0","
{KeyWord:We Manage Property}","Contact Us! We\'re In Your Area.","Top Quality Property Management.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("6","0","Property Managers","Come To U s For Property Management.","Let Us Take Care Of Everything.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("7","0","We Manage Propert y","Top Quality Property Management.","Contact Us We\'re In Your Area.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("7","0","
{KeyWor d:Property Managers}","Let Us Take Care Of Everything.","Come To Us For Property Management.","martiantourism.com","http://martiantourism.com","","false","Enabled","nu ll"),("7","0","
{KeyWord:We Manage Property}","Contact Us! We\'re In Your Area.","Top Quality Property Management.","martiantourism.com","http://martiantourism.com","", "false","Enabled","null"),("7","0","Property Managers","Come To Us For Property Management.","Let Us Take Care Of Everything.","martiantourism.com","http://martiantour ism.com","","false","Enabled","null"),("8","0","We Manage Property","Top Quality Property Management.","Contact Us We\'re In Your Area.","martiantourism.com","http://m artiantourism.com","","false","Enabled","null"),("8","0","
{KeyWord:Property Managers}","Let Us Take Care Of Everything.","Come To Us For Property Management.","martian tourism.com","http://martiantourism.com","","false","Enabled","null"),("8","0","
{KeyWord:We Manage Property}","Contact Us! We\'re In Your Area.","Top Quality Property Management.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("8","0","Property Managers","Come To Us For Property Management.","Let Us T ake Care Of Everything.","martiantourism.com","http://martiantourism.com","","false","Enabled","null")], genflags=no
2015-05-11 06:40:56.120 (2) [P2T1]: Warning(s) detected in statement [insert into `content_editor_google`.`tmp7` (`adGroupID`,`searchEngineIdentifier`,`headline`,`desc ription1`,`description2`,`displayURL`,`destinationURL`,`exemptionRequest`,`isDisapproved`,`status`,`devicePreference`) values ("1","0","
","A Wealth Of Experience & Expertise.","Kissimmee\'s Real Estate.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("1","0","Top Real E state Agents","Kissimmee\'s Real Estate.","A Wealth Of Experience & Expertise.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("1","0", "
{KeyWord:Real Estate Agents}","We\'ll Guide You Through The Market.","We Have Local Real Estate Insight.","martiantourism.com","http://martiantourism.com","","false", "Enabled","null"),("1","0","Real Estate Agents","We Have Local Real Estate Insight.","We\'ll Guide You Through The Market.","martiantourism.com","http://martiantourism .com","","false","Enabled","null"),("2","0","
{KeyWord:Top Real Estate Agents}","A Wealth Of Experience & Expertise.","Kissimmee\'s Real Estate.","martiantourism.com"," http://martiantourism.com","","false","Enabled","null"),("2","0","Top Real Estate Agents","Kissimmee\'s Real Estate.","A Wealth Of Experience & Expertise.","martiantou rism.com","http://martiantourism.com","","false","Enabled","null"),("2","0","
{KeyWord:Real Estate Agents}","We\'ll Guide You Through The Market.","We Have Local Real E state Insight.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("2","0","Real Estate Agents","We Have Local Real Estate Insight.","We\'l l Guide You Through The Market.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("3","0","
{KeyWord:Top Real Estate Agents}","A Wealth Of Experience & Expertise.","Kissimmee\'s Real Estate.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("3","0","Top Real Estate Agents"," Kissimmee\'s Real Estate.","A Wealth Of Experience & Expertise.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("3","0","
{KeyWord:Real Estate Agents}","We\'ll Guide You Through The Market.","We Have Local Real Estate Insight.","martiantourism.com","http://martiantourism.com","","false","Enabled","null "),("3","0","Real Estate Agents","We Have Local Real Estate Insight.","We\'ll Guide You Through The Market.","martiantourism.com","http://martiantourism.com","","false ","Enabled","null"),("4","0","
{KeyWord:Top Real Estate Agents}","A Wealth Of Experience & Expertise.","Kissimmee\'s Real Estate.","martiantourism.com","http://martiant ourism.com","","false","Enabled","null"),("4","0","Top Real Estate Agents","Kissimmee\'s Real Estate.","A Wealth Of Experience & Expertise.","martiantourism.com","http ://martiantourism.com","","false","Enabled","null"),("4","0","
{KeyWord:Real Estate Agents}","We\'ll Guide You Through The Market.","We Have Local Real Estate Insight." ,"martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("4","0","Real Estate Agents","We Have Local Real Estate Insight.","We\'ll Guide You Thr ough The Market.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("6","0","We Manage Property","Top Quality Property Management.","Conta ct Us We\'re In Your Area.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("6","0","
{KeyWord:Property Managers}","Let Us Take Care Of E verything.","Come To Us For Property Management.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("6","0","
{KeyWord:We Manage Property}" ,"Contact Us! We\'re In Your Area.","Top Quality Property Management.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("6","0","Property Managers","Come To Us For Property Management.","Let Us Take Care Of Everything.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("7"," 0","We Manage Property","Top Quality Property Management.","Contact Us We\'re In Your Area.","martiantourism.com","http://martiantourism.com","","false","Enabled","nul l"),("7","0","
{KeyWord:Property Managers}","Let Us Take Care Of Everything.","Come To Us For Property Management.","martiantourism.com","http://martiantourism.com","", "false","Enabled","null"),("7","0","
{KeyWord:We Manage Property}","Contact Us! We\'re In Your Area.","Top Quality Property Management.","martiantourism.com","http://ma rtiantourism.com","","false","Enabled","null"),("7","0","Property Managers","Come To Us For Property Management.","Let Us Take Care Of Everything.","martiantourism.com ","http://martiantourism.com","","false","Enabled","null"),("8","0","We Manage Property","Top Quality Property Management.","Contact Us We\'re In Your Area.","martiant ourism.com","http://martiantourism.com","","false","Enabled","null"),("8","0","
{KeyWord:Property Managers}","Let Us Take Care Of Everything.","Come To Us For Property Management.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("8","0","
{KeyWord:We Manage Property}","Contact Us! We\'re In Your Area."," Top Quality Property Management.","martiantourism.com","http://martiantourism.com","","false","Enabled","null"),("8","0","Property Managers","Come To Us For Property M anagement.","Let Us Take Care Of Everything.","martiantourism.com","http://martiantourism.com","","false","Enabled","null")] executed by user [spike]
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 1 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 2 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 3 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 4 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 5 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 6 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 7 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 8 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 9 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 10 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 11 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 12 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 13 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 14 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 15 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 16 (1366)
2015-05-11 06:40:56.120 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 17 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 18 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 19 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 20 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 21 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 22 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 23 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 24 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 25 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 26 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 27 (1366)
2015-05-11 06:40:56.121 (2) [P2T1]: Incorrect integer value: 'null' for column 'devicePreference' at row 28 (1366)
Note: Could not reproduce in QA