Object reference not set to an instance of an object

[Dale M.]

I get the error:
"Object reference not set to an instance of an object" or “Error: Default Country Code not found.”
iMIS SOA Web Services requires that the default country code (and all country codes specified in all of your member profiles) match one of the country codes in the “Country_Names” table.

Default Country Code
Assuming this is a US based client, verify that there is an entry in their “Country_Names” table like the following:
COUNTRY = “United States”, COUNTRY_CODE = “US”

Alternatives to “COUNTRY” are “USA” or “US”.

The default country code is specified in the web.config file. The country code that will be used when none is provided, is “US”.

Ex/

<setting key="DefaultCountryCode" value="US"  />

If US should not be the default country, this can be overridden in web.config by changing "DefaultCountryCode" to the country code for your organization.

Profile Country Codes and State/Province Codes
Another related reason this crash might occur is that you have some profiles in your database that have the "Country" field set as "USA", "United States", or "US" and one or more of these Country codes do not exist in the "Country_Names" table.

To find profiles that don't have a country code associated with them, you can run these queries:

select country,* from name where country not in (select country from country_names) and country <> ''

select country,* from name_address where country not in (select country from country_names) and country <> ''

To find state or province codes that won't be recognized in the "state_codes" table, you can run these queries:

select state_province,* from name where state_province not in (select state_province from state_codes) and state_province <> ''
 
select state_province,* from name_address where state_province not in (select state_province from state_codes) and state_province <> ''

Note to GoLightly staff: Make sure "wsdl_cache_off" is true after making this change.

See also, iMIS Bridge Installation Troubleshooting.