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

Create new record failed after upgrade conversion of data tables

SA-18275

Summary



Users upgraded to Pega 7 and there was an attempt to convert data tables to data types. When users tried to add or update records in a recently converted data table, they see the error message "Create new record failed" . This occurs for only a few data tables.

Error Messages



Create new record failed:pxCreateRecord API failed.

Steps to Reproduce



Try adding a new record in data tables.

Root Cause



Some data tables had problems using the existing table during the conversion. The four (4) properties (columns) listed below were missing:
  • pzPVStream
  • pxCommitDateTime
  • pxSaveDateTime
  • pyRuleSetName


Resolution



Perform the following local-change:

Create the four (4) missing columns in the data table as shown in this example SQL statement:

ALTER TABLE dbo.pr_my_data_table ADD pzPVStream BLOB NULL, pxCommitDateTime DATE NULL, pxSaveDateTime DATE NULL, pyRuleSetName VARCHAR (64) NULL;


 
Suggest Edit

Published February 24, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

25% found this useful

Have a question? Get answers now.

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

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