Error QE-DEF-0288 occurred while providing the datasource connection value at runtime

Symptom

User wants to select the datasource at runtime and hence has used the following definition for the Content Manager (CM) Datasource in Framework Manager (FM):

#$map_macro{prompt('select datasource','token')}#

where "map_macro" is the parameter map consisting of the key value pair such as:

key value

ora oracle_ds
sql sql_ds

"map_macro" parameter map is based on existing query items ,say <ds> and <dsvalue> where <ds> query item populates the key and <dsvalue> populates the corresponding key's value in the parameter map.

Both <ds> and <dsvalue> query items belong to the same query subject ,say, <datasource>. The underlying table is stored in SQL Server 2000 database.

Now if the user tests the query subject in FM it prompts for the value.User provides the required value but gets the following error:

"QE-DEF-0288 Unable to find the data source ' ' in the content store.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'
UDA-SQL-0196 The table or view "<table name>" was not found in the dictionary."