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

Import of records to Data Table is not inserting/updating record

SA-18946

Summary



When attempting to import records for a class which is mapped to an external table, the import appears successful but after a refresh the data table shows the records have not been updated.


Error Messages



NBAM_EXTERNAL.MKT_CLUB ExternalMKTData pxUpdateOperator , pxUpdateOpName , pxUpdateSystemID , pxCreateDateTime , pxCreateOpName , pxCreateSystemID , pxCreateOperator
From: (unknown)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInSaveStatementWithoutStream(PageDatabaseMapperImpl.java:1651)

2015-08-18 10:21:43,550 [ WebContainer : 1091] [TABTHREAD3] [ ] [ MKT:01.01.01] ( internal.access.DatabaseImpl) ERROR user001|xx.xx.xx.xx MarketingAdmin - There was a problem with the database when getting a list:
com.pega.pegarules.pub.database.BadTableMappingException: Database-General trying to retrieve property pxInsHandle from a fully exposed table that does not contain it
From: (HB0B5057B942B94CE1CF33366E5599AC1:xx.xx.xx.xx)


Steps to Reproduce

  1. Map a class to external table.
  2. Select Data option from case designer left panel.
  3. Add the class and go to the Data Type rule.
  4. Go to records tab and use the import option to try adding records. This will show successful update or addition of records.
  5. Click ok and refresh the data in the data table. The records will not be updated or inserted or deleted.


Root Cause



There is an issue with validation code in Pega if it is an externally mapped table.

Resolution



Apply HFix-25680.
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

100% 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