HDL error loading Location
This is the Location.dat we used to load.
METADATA|Location|SourceSystemId|SourceSystemOwner|EffectiveStartDate|EffectiveEndDate|SetCode|LocationImageURL|ActiveStatus|MainphoneAreaCode|MainphoneCountryCode|MainphoneExtension|MainphoneSubscriberNumber|FaxAreaCode|FaxCountryCode|FaxExtension|FaxSubscriberNumber|OtherphoneAreaCode|OtherphoneCountryCode|OtherphoneExtension|OtherphoneSubscriberNumber|OfficialLanguageCode|EmailAddress|ShipToSiteFlag|ShipToLocationId|ReceivingSiteFlag|BillToSiteFlag|OfficeSiteFlag|DesignatedReceiverId|InventoryOrganizationId|GeoHierarchyNodeId|GeoHierarchyNodeCode|LocationCode|LocationName|Description|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Building|Country|FloorNumber|LongPostalCode|PostalCode|Region1|Region2|Region3|TimezoneCode|TownOrCity
MERGE|Location|LOCWCBAB|WHRAPS|1900/01/01|1916/12/31|WCB||A|||||||||||||US||Y||Y|Y|Y|||||AB|Abbotsford Area Office|Abbotsford Area Office|123 Street|||||CA|||V9V 1A1|British Columbia|BC|||Abbotsford
Value for Region1 = British Columbia
Value for Region2 = BC
This used to work fine, but after we setup Province Hierarchy in "Manage Geographies", HDL errors with "You need to enter a valid province, city, or postal code for the address."