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

 Shuang Yao (SHUANGYAO)
Rbc

Rbc
CA
SHUANGYAO Member since 2010 6 posts
Rbc
Posted: Apr 6, 2017
Last activity: Apr 10, 2017
Posted: 6 Apr 2017 14:22 EDT
Last activity: 10 Apr 2017 7:40 EDT
Closed

migrate script error when set buldmover.load=true

We face below error when use migrate script for bulkmover.load=true. migrate from Pega 5.5 to Pega 7.1.8. What could be the root cause?

  1. migrateSystem.xml:501: com.ibm.db2.jcc.am.SqlSyntxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC==;ll. where pxobjclass;LIMIT, DRIVER=3.64.114

***Moderator Edit: Vidyaranjan | Updated Categories***

To see attachments, please log in.
Installation and Deployment

Posted: 7 years ago
Posted: 10 Apr 2017 7:33 EDT
Habeeb Baig (BaigHabeeb)
Virtusa IT Consulting
Lead Decisioning Architect
Virtusa IT Consulting
AE

Its seems you are not using db2jcc4.jar driver, please check your java version and use the db2 driver accordingly

Try this connection property while defining JDBC url to connect database from the scripts 'useJDBC4ColumnNameAndLabelSemantics=2'

 

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