Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
7 subscribers
Views
2711 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
------Query Database -------
azharuddinm
A Score Level 2
over 7 years ago
I am getting following error : SQL query. SQL Message : Missing IN or OUT parameter at index:: 1
query:
select cname from schemaname.tablename where id =acid
OriginalPostID-250708
Discussion posts and replies are publicly visible
0
azharuddinm
A Score Level 2
over 7 years ago
This is query i am using select cname from schemaname.tablename where id =ac!id
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Krishna Chaitanya
A Score Level 1
over 7 years ago
Hi @azharuddinm
check if ac!id has a value and of same type as id in the sql table.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
azharuddinm
A Score Level 2
over 7 years ago
its same both are text
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ammireddys
A Score Level 1
over 7 years ago
Have you checked the ac!id variable has the value associated to it, as per my knowledge this error would throw when there is no value being passed.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
azharuddinm
A Score Level 2
over 7 years ago
i have mapped pv to that ac and the pv variable is populated with value
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
@azharuddinm i think it's better to Debug the process to understand the actual cause whether there is something wrong with query or with Data i.e. id . Try passing static value for id rather than ac! or pv! and try executing the Process, if this works, means there is something wrong with the data as @Ammireddy Srinivasareddy said earlier. If still the same then i recommend try executing the same query Manually in DB
hope this will help you to debug and resolve the issue
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel