Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 prashant nagargoje (prashantn5424)
Vodafone Shared Services India

Vodafone Shared Services India
IN
prashantn5424 Member since 2016 21 posts
Vodafone Shared Services India
Posted: Nov 7, 2016
Last activity: Dec 5, 2016
Posted: 7 Nov 2016 8:56 EST
Last activity: 5 Dec 2016 4:06 EST
Closed
Solved

Exception in dynamic sql query

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

 

To see attachments, please log in.
Data Integration

Accepted Solution

Posted: 9 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 

 

To see attachments, please log in.
Posted: 9 years ago
Posted: 7 Nov 2016 9:32 EST
Rajiv Nistala (nistr) 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.

To see attachments, please log in.

Accepted Solution

Posted: 9 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 

 

To see attachments, please log in.

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