[ArcGIS 9.3.1]Geocode addresses failed. Failed to execute (Geocode Addresses)

Discussion created by present on Jan 26, 2011
Latest reply on May 27, 2011 by lorieme

This is what I want to do in ArcGIS 9.3.1:

A geoprocessing model gets address records from a database (Employees), geocodes them and generates a feature class. The goal of the geoprocessing model is to be used by a website to display addresses on the map based on user input (e.g. Employee's state).

The model is simple: Make Query Table (with query parameter) to get addresses --> Geocode Addresses to generate feature class (in %scratchworkspace%).

But every time I ran that model, it gave me the same generic error: ERROR 000010: Geocode addresses failed. Failed to execute (Geocode Addresses).

The same address locator (ESRI Street_addresses_US) used in the model works fine in ArcCatalog to geocode the same database table (in Employees), so both the address locator and source addresses are good.

The model and Employees database (fake data) are attached here. Could somebody give me a hint where is the problem?

Thanks a lot in advance!