Create new record failed: pxCreateRecord API failed.
I'm not able to add Data type in the data tab, it has appear error "Create new record failed: pxCreateRecord API failed". Could you please give me a solution for this issue?
Accepted Solution
EPAM Systems, Inc.
ES
Hi Anuradha,
Thanks for posting on PSC.
Probable 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
Solution: 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;
Reference: Create a new record failed
Hope it helps, kindly acknowledge by marking this reply as answered/helpful for larger Pega audience.
Regards,
Asif
Learning
IN
Hello Anuradha,
Kindly check the below link with the similar issue:-
https://community.pega.com/support/support-articles/unable-insert-or-update-records-data-table
Hope this helps.
Thanks,
Hari
Pegasystems Inc.
IN
Hi ,
May be the logs can help in this to undersatnd the exact issue. But check if this is happening only for a specific class where you are trying to create data type or with specific name of the Data type.
Accepted Solution
EPAM Systems, Inc.
ES
Hi Anuradha,
Thanks for posting on PSC.
Probable 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
Solution: 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;
Reference: Create a new record failed
Hope it helps, kindly acknowledge by marking this reply as answered/helpful for larger Pega audience.
Regards,
Asif
Randstad Technologies
US
Solution provided here is a bad one. We can't add BLOB in any external table just like that! If that is the case then why even pega is not using these columns in external tables used in pega application? Pega Engineering team needs to come up with a proper solution for this issue.
Thanks,
Rajib
Pegasystems Inc.
IN
Hi,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.