If an SQL statement is copied from one server to another, and the SQL data source is named differently in the original server than in the destination server, the SQL statement will execute in the Statement Builder and will not display any errors. When you configure the copied statement in the Proficy Portal client, however, you will receive the following error message:
Configuration data is unavailable. Please check the connector.
To work around this, on the destination server, add a data source (using the Administration application) with the same name as the data source in the original server.