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

erickp over 8 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 narasimhaadityac
A Score Level 2
over 8 years ago

@eric, I believe you are on SQL Server, as Text is a type defined for the SQL Server.

Please refer to "Primitive Data Types" under https://forum.appian.com/suite/help/7.7/Defining_a_Custom_Data_Type.html

by default the system would be able to translate the ones provided in the system, if there are any other data types which need to be configured then the way to do is through defining the CDT (through ColumnDefinition ) and using them in either Query Entity or Query Rules. hope this gives an answer why the above error is thrown.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 narasimhaadityac
A Score Level 2
over 8 years ago

@eric, I believe you are on SQL Server, as Text is a type defined for the SQL Server.

Please refer to "Primitive Data Types" under https://forum.appian.com/suite/help/7.7/Defining_a_Custom_Data_Type.html

by default the system would be able to translate the ones provided in the system, if there are any other data types which need to be configured then the way to do is through defining the CDT (through ColumnDefinition ) and using them in either Query Entity or Query Rules. hope this gives an answer why the above error is thrown.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data