I am getting the attached error message when trying to use Query Database smart

erickp over 10 years ago

I am getting the attached error message when trying to use Query Database smart service. I am doing a simple select statement: "select univ_name from University where univ_id = 1. (It is my first time using Query Database smart service and I am just trying to execute a simple scenario so ignore how simple the query is and the fact I am using univ_id = 1) I have a CDT called University with both fields univ_id and univ_name. What does the attached error message means? Also, how would I go ahead if I wanted to store the returned univ_name in a process variable? Would I create an output? If yes, how do I tell that output that I want to store the SQL response in my process variable?

Discussion posts and replies are publicly visible

Parents

0 ChristineLHutchison
Certified Lead Developer
over 10 years ago

That error generally means when Appian is trying to validate the table and columns you are going to query via the data source that it can't find a column with that name.

If the query was "validated", you would be able to go to the setup tab and store the output into a pv.

Also, if you have a CDT, you may want to use a query rule or query entity instead so you are not writing the query or having to set the data source in the model after import/export if the data source name is different.

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineLHutchison
Certified Lead Developer
over 10 years ago

That error generally means when Appian is trying to validate the table and columns you are going to query via the data source that it can't find a column with that name.

If the query was "validated", you would be able to go to the setup tab and store the output into a pv.

Also, if you have a CDT, you may want to use a query rule or query entity instead so you are not writing the query or having to set the data source in the model after import/export if the data source name is different.

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data