Skip to main content
Contact a Moderator

Question

2
Replies
752
Views
 prashant nagargoje (prashantn5424) Vodafone Shared Services India
Vodafone Shared Services India
IN
prashantn5424 Member since 2016 20 posts
Vodafone Shared Services India
Posted: November 7, 2016
Last activity: December 5, 2016
Posted: 7 Nov 2016 8:56 EST
Last activity: 5 Dec 2016 4:06 EST
Closed
Solved

Exception in dynamic sql query

Report

Hi,

 

While passing whole SQL query dynamically for ConnectSQL, I am getting below exception.

"Missing IN or OUT parameter at index 1". Though the query is getting formed well when checked via Tracer, still getting this error.

Help me if am missing anything in configuration.

 

Thanks,

Prashant

 

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Posted: 7 Nov 2016 9:32 EST
Rajiv Nistala (nistr) PEGA Senior Manager - Engineering
Pegasystems
IN

Please share the configuration of the Rule-Connect-SQL and the tracer XML. Also, share the version of the Pega platform being used.

Accepted Solution

Posted: 5 years ago
Posted: 5 Dec 2016 3:06 EST
prashant nagargoje (prashantn5424) Vodafone Shared Services India
Vodafone Shared Services India
IN

Hi,

The issue is resolved now and this was due to mistake in configuration. ASIS keyword was used while forming sql query dynamically in property-set and the property holding whole sql query is only passed to ConnectSQL which was creating issue.
ASIS keyword is not needed while forming query dynamically in propertyset.


Thanks,
Prashant 

 

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice