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

 Khareem Shaik (Khareem_Shaik)
Virtusa
Senior Architect
Virtusa
US
Khareem_Shaik Member since 2008 6 posts
Virtusa
Posted: Feb 7, 2016
Last activity: Feb 11, 2016
Posted: 7 Feb 2016 15:38 EST
Last activity: 11 Feb 2016 23:05 EST
Closed
Solved

Stored Procedure is throwing error. however, dynamic SQL works fine.

Facing issue while calling stored procedure from pega. same SP is working fine from IBM data studio and dynamic SQL is working fine too.

Error:

There was a problem getting a list: code: -104 SQLState: 42601 Message: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=EXEC;<ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE ASSOCIATE, DRIVER=4.18.60


Pega Version: Pega 7.1.7 Version

Database: DB2

To see attachments, please log in.
Data Integration

Posted: 8 years ago
Posted: 8 Feb 2016 0:04 EST
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Technical Support
Pegasystems Inc.
US

Please elaborate more details:

1. Are you using connect-sql?

2. How exactly did you call the SP from Pega? Share the SP details if possible.

It would also be helpful if you attach the db trace from Pega.

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