Skip to main content
This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

SQL insert error during Pega Marketing upgrade

SA-47468

Summary



After upgrading to Pega Marketing 7.31, an SQL insert fails.


Error Messages



981 [http-nio-8080-exec-7] [ STANDARD] [ ] [ Your_App:01.01.01] (dbms.JdbcConnectionManagerImpl) ERROR Your_System|127.0.0.1 Your_user - Not returning connection 2 for database "pegadata" to the pool as it previously encountered the following error
User ID: my_user
Last SQL: INSERT INTO PSFAPRD.MKT_SYS_QUEUES SELECT * FROM PSFAPRD.pr_sys_queues WHERE PXOBJCLASS = 'System-Queue-ProgramRun'
java.sql.SQLSyntaxErrorException: ORA-00947: not enough values



Steps to Reproduce

  1. Upgrade Pega Marketing from 7.21 or 7.22 to 7.31.
  2. Run the 'UpgradeToMktSysQueueTable' activity.


Root Cause



A defect in Pegasystems’ code or rules. Missing column declarations and a mismatch in the number of columns.


Resolution



Apply HFix-39276.


Suggest Edit

Published December 28, 2017 - Updated December 2, 2021

Did you find this article helpful?
Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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

Pega Community 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
Contact us