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

 Hanumantha Rao Melam (Hanumantha Rao M)
Synechron
Lead System Architect
Synechron
US
Hanumantha Rao M Member since 2011 7 posts
Synechron
Posted: Oct 23, 2020
Last activity: Nov 11, 2020
Posted: 23 Oct 2020 18:32 EDT
Last activity: 11 Nov 2020 15:35 EST
Closed

Getting unsupported ccsid error when call stored procedure on external DB2

Application built on WAS server and we need to connect external database DB2 and execute stored procedure.  

Added procedure name in Connect-SQL rule and passed all required input through activity. After execute getting error as "[jcc][t4][10275][10041][3.68.61] Unsupported ccsid, encoding, or locale: "Cp037". ERRORCODE=-4220, SQLSTATE=22021".

 

Please share your thoughts to resolve this issue.

Thanks.  

To see attachments, please log in.
Pega Platform 8.4.1
Cloud Services

Posted: 4 years ago
Posted: 25 Oct 2020 23:29 EDT
Hanumantha Rao Melam (Hanumantha Rao M)
Synechron
Lead System Architect
Synechron
US

Thanks Kevin for sharing your thoughts.

I did verify this link before I post in PDN. As no one confirmed that upgrading to latest driver was the solve the issue or not, I did not pay attention to this article.

I will try and share the updates. Please do let me know, if any other options available.

To see attachments, please log in.
Posted: 4 years ago
Posted: 11 Nov 2020 15:35 EST
Hanumantha Rao Melam (Hanumantha Rao M)
Synechron
Lead System Architect
Synechron
US

Still no progress after pointing to latest DB2 drivers. Data-Admin-DB-Name test connection is success, but Connect-SQL rule fail to execute stored procedure at run time.

As a alternate approach, I am able to execute stored procedure successfully with java code.

 

Seems some issue with Connect-SQL rule, which is unable to locate and run few java classes at run time.

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