elasticsearch assumes location extension streetaddress2 field is of date datatype

Issue showing-up in several environments and causes order creation to fail. May be linked to AML-2484. Reproducing the issue could also be dependent on search re-indexing.

Example of log output:

2013-11-25 19:34:33,342-142831 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=Etc/UTC, principalId=1787c0a0-1ba4-4c70-9412-746b090c582a, requestId=516594e2-c6f3-4450-a09c-f0e758395f5e, locale=en_US, authToken=W4F5S2V5ZJQYIVCBOJO4ZSUNUH4D5DJA67COLKRLBRNE6QBXVYNTTH2OJDSNG53AB2ZWGLMIOH3W7H6B2QJCDW4F7QKZQ3TYJPIOT6KNLIVEZINOUWYW7ECDLKBSVL66UURG55RE7NBZ56BMGSMVY6CAKYQZPYLMIZHESHGNOKXQB277CYNJZYXA442M6JR4DPFISNEX5YGGRJSJWGOBVZ63QGQLCCDTPOCO7KLQQAAQDR3AANMRBVQ2OB3ASLEPFFT5EM2ZN3B5QQGW3WZR5OGDV4CPIHXRX4Q5V4RA26IO6XVM55KR7KX644NR6KS5F4K2PJ4CR2MO2YY4DKSEYBCK74K5QH5EEEKYBYKGVVJRKYS4AQ5AAAIXU6OHYBWOTUFCLJ5UUZ2KDAZDIFQMJ4BUNKRYDEXTEA4EIB6MJG345WJ4X5LY3HVOLI7IP3WMQ2U4KGJNDVXKQFFDQSVDUYYEQTC323OR6A6JZEI45LMKKVBUX4MP5FGGLH5GDT5BAB4UNZHCMHXTIACKTZDPAVJVTVAZYUQELDVZMA6FL746MTWAVZEUPH5K2KR62S76GWTDAWG6QXOW67WDN462BSVKTMGKTTR5P5SEF3U47ESMDWCQ66SR735U2A3NROMRKXQIKDSXZLCV24GKBP7OSEL6HLORIAI4X4WHSUI5P32BG77OYLJTCS33WAS7ZZTJBUMWKMM36DRUL3ZILOHZEO5C72HSTYQIKXYV2246M35PMWTPLRGSYI3VW55EZXT7HC2ERNFPMGOZUUNARW6E33CHHNWTNODIX5FYMWS2JTCICUUJM4TSFALOA6AOQAV6CQ7HPJC32KUVVALCPOBVEKBZFXDQKFYEVPYKXGCDT75J6K6LTOWN5WCIPEZ5PS3NELEJASFSGRZWARSZYQXPKWSOD5WMOVLZGTJVUD7SZMEYLIYLNMAFVCSGQV2WJUGOU7IGRIWRRSSZEFOFLBUKU27JP6D6ZAM565RA56IPXKBRRXWRDZ34JC7GHYTO4VET5QUVQV6SN5QXIJXYX7LIJ6YGSBSJHFPYCNF56Y35OV5EKO3COMZHTDWKOML3M5BKMAJLR76NSONGT5BH5GY2QFJNR6WWIUXVLQDGWMD2EXUTXP6SIXV52O6GGW6FEZYWRANJISZA3IYNIFNKNVVFSVJ6FSSLOC74QI6JHU5OCU6LIXINB75I4EREDFQKYO4BSP3MBGOPSQORIKTQOBX75H2YOXITZCVXXJXMMFCDS7CM5A7UWDWZXAKQKLQEDAJFBS2U3KQW7OWTOOND76NYB67IKBJU53JSAQQICHBW47VV6RIQSNNW4EGERII5UWTNUPQCVCSZ6HGZUYOXVAS5XZPQDQ7METD3O557BIQKRL2ABOCRHKSOGK54O4U3YC7H3NXXWZ27XEFZPYEPEGGQGFEXL6N37JOASBRP7RQDFWJOPNXRE75NJFF7FSYUXT262ZUTTJE4GZ4ZRTJZGQVV6LXTGD7WMUJXDMVQLQE47OV7L2U7LSXHMVFONLEUVA3VJO3U4T67FHD6X2XCKU2UTDYXZ2TU5XY3MBDIPMGIXQR3EI3J572A====, hostname=70.166.144.17, ipAddress=70.166.144.17] - Created JSON: {"id":"3cd2e6b4-110a-4a71-b616-119d2536a948","realm":"com.thesearchagency/5d688ffe-4f19-4d24-9691-60c96ae30220","name":"Pizza","comment":"","associatedMerchant":

{"id":"e3fe6508-3497-4b13-8022-2e08183a501a","name":"Patricks Pizza","customerId":"Patricks Pizza"}

,"semLandingPageURL":"http://www.pizza.co.jp","currencyCode":"JPY","countryCode":"JP","timeZone":"Asia/Tokyo","state":"QUOTE","billingInfoCaptured":true,"campaignTargets":[{"status":"VALID","service":null,"businessArea":

{"id":"50105","title":"カースピーカー"}

,"location":

{"id":"200008","title":"07　福島県"}

,"localeName":"ja_JP","campaignDataList":[]}],"distributionBudgets":[

{"service":"GOOGLE","budget":1.5,"markupBudget":3,"markupMultiplier":1}

],"serviceEstimates":[],"creator":

{"id":"1787c0a0-1ba4-4c70-9412-746b090c582a","name":"LionBridge Admin User"}

,"creationDate":"2013-11-25T19:34:32.785Z","modifier":

{"id":"1787c0a0-1ba4-4c70-9412-746b090c582a","name":"LionBridge Admin User"}

,"modificationDate":"2013-11-25T19:34:32.785Z","campaignDataList":[{"type":"location","attributes":{"postalCode":"163-8636","streetAddress1":"3 Chome-17-7","streetAddress2":"","countryCode":"JP","number":"","provinceName":"Japan","companyName":"Mizuho Trust & Banking Shinjuku Bra","isEnabled":"true","city":"Tokyo"}}]}
2013-11-25 19:34:33,367-142856 [http-8080-1] ERROR com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=Etc/UTC, principalId=1787c0a0-1ba4-4c70-9412-746b090c582a, requestId=516594e2-c6f3-4450-a09c-f0e758395f5e, locale=en_US, authToken=W4F5S2V5ZJQYIVCBOJO4ZSUNUH4D5DJA67COLKRLBRNE6QBXVYNTTH2OJDSNG53AB2ZWGLMIOH3W7H6B2QJCDW4F7QKZQ3TYJPIOT6KNLIVEZINOUWYW7ECDLKBSVL66UURG55RE7NBZ56BMGSMVY6CAKYQZPYLMIZHESHGNOKXQB277CYNJZYXA442M6JR4DPFISNEX5YGGRJSJWGOBVZ63QGQLCCDTPOCO7KLQQAAQDR3AANMRBVQ2OB3ASLEPFFT5EM2ZN3B5QQGW3WZR5OGDV4CPIHXRX4Q5V4RA26IO6XVM55KR7KX644NR6KS5F4K2PJ4CR2MO2YY4DKSEYBCK74K5QH5EEEKYBYKGVVJRKYS4AQ5AAAIXU6OHYBWOTUFCLJ5UUZ2KDAZDIFQMJ4BUNKRYDEXTEA4EIB6MJG345WJ4X5LY3HVOLI7IP3WMQ2U4KGJNDVXKQFFDQSVDUYYEQTC323OR6A6JZEI45LMKKVBUX4MP5FGGLH5GDT5BAB4UNZHCMHXTIACKTZDPAVJVTVAZYUQELDVZMA6FL746MTWAVZEUPH5K2KR62S76GWTDAWG6QXOW67WDN462BSVKTMGKTTR5P5SEF3U47ESMDWCQ66SR735U2A3NROMRKXQIKDSXZLCV24GKBP7OSEL6HLORIAI4X4WHSUI5P32BG77OYLJTCS33WAS7ZZTJBUMWKMM36DRUL3ZILOHZEO5C72HSTYQIKXYV2246M35PMWTPLRGSYI3VW55EZXT7HC2ERNFPMGOZUUNARW6E33CHHNWTNODIX5FYMWS2JTCICUUJM4TSFALOA6AOQAV6CQ7HPJC32KUVVALCPOBVEKBZFXDQKFYEVPYKXGCDT75J6K6LTOWN5WCIPEZ5PS3NELEJASFSGRZWARSZYQXPKWSOD5WMOVLZGTJVUD7SZMEYLIYLNMAFVCSGQV2WJUGOU7IGRIWRRSSZEFOFLBUKU27JP6D6ZAM565RA56IPXKBRRXWRDZ34JC7GHYTO4VET5QUVQV6SN5QXIJXYX7LIJ6YGSBSJHFPYCNF56Y35OV5EKO3COMZHTDWKOML3M5BKMAJLR76NSONGT5BH5GY2QFJNR6WWIUXVLQDGWMD2EXUTXP6SIXV52O6GGW6FEZYWRANJISZA3IYNIFNKNVVFSVJ6FSSLOC74QI6JHU5OCU6LIXINB75I4EREDFQKYO4BSP3MBGOPSQORIKTQOBX75H2YOXITZCVXXJXMMFCDS7CM5A7UWDWZXAKQKLQEDAJFBS2U3KQW7OWTOOND76NYB67IKBJU53JSAQQICHBW47VV6RIQSNNW4EGERII5UWTNUPQCVCSZ6HGZUYOXVAS5XZPQDQ7METD3O557BIQKRL2ABOCRHKSOGK54O4U3YC7H3NXXWZ27XEFZPYEPEGGQGFEXL6N37JOASBRP7RQDFWJOPNXRE75NJFF7FSYUXT262ZUTTJE4GZ4ZRTJZGQVV6LXTGD7WMUJXDMVQLQE47OV7L2U7LSXHMVFONLEUVA3VJO3U4T67FHD6X2XCKU2UTDYXZ2TU5XY3MBDIPMGIXQR3EI3J572A====, hostname=70.166.144.17, ipAddress=70.166.144.17] - Indexing 1 items has failed! failure in bulk execution:
[0]: index [com.thesearchagency_5d688ffe-4f19-4d24-9691-60c96ae30220.temp], type [order], id [3cd2e6b4-110a-4a71-b616-119d2536a948], message [MapperParsingException[Failed to parse [campaignDataList.attributes.streetAddress2]]; nested: MapperParsingException[failed to parse date field [], tried both date format [dateOptionalTime], and timestamp number]; nested: IllegalArgumentException[Invalid format: ""]; ]