Support Article
TooManyProperties PegaCS-Data-CommonSayings
SA-69168
Summary
Error occurs when importing PegaCRM_74.jar to the system to upgrade from Pega 7.2.2.
Error Messages
Caused by: com.pega.pegarules.pub.database.BadTableMappingException: Database-BadTableMapping-TooManyProperties PegaCS-Data-CommonSayings DATA.pcs_data_commonsayings PegaDATA Social , Channel , Chat
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInDataStoreSaveStatementWithoutStream(PageDatabaseMapperImpl.java:1580) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInSaveStatementWithoutStream(PageDatabaseMapperImpl.java:1408) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.store.ManagedTransaction.getStatementWithPrepValues(ManagedTransaction.java:1003) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.store.ManagedTransaction.addBatchRdbms(ManagedTransaction.java:905) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.store.ManagedTransaction.performUpdate(ManagedTransaction.java:788) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:891) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:833) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.UpdateProcessor.performOps(UpdateProcessor.java:1520) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:272) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:85) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.store.DataStoreManager.doInTransaction(DataStoreManager.java:253) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.UpdateProcessor.processUpdates(UpdateProcessor.java:202) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2125) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.BasicDeployDataModel.commit(BasicDeployDataModel.java:52) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.issueCommit(SaverLoader.java:1016) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.commitAndClearPendingList(SaverLoader.java:985) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importContents(SaverLoader.java:187) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importContents(SaverLoader.java:82) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.PegaArchiveLoader.performInsertUpdates(PegaArchiveLoader.java:149) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.PegaArchiveLoader.loadArchive(PegaArchiveLoader.java:137) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.PegaArchiveLoader.importWithContext(PegaArchiveLoader.java:110) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.PegaArchiveLoader.importContents(PegaArchiveLoader.java:84) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.PegaArchiveLoader.importContents(PegaArchiveLoader.java:54) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.importable.RuleImportProcessImpl.invokeImport(RuleImportProcessImpl.java:303) ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.importable.AbstractArchiveImportProcess.runImportProcess(AbstractArchiveImportProcess.java:151) ~[prprivate.jar:?]
... 17 more
Steps to Reproduce
Import the PegaCRM_74.jar.
Root Cause
A defect or configuration issue in the operating environment.
The schema changes that added additional columns were manually downloaded and applied. Then user continued with the import without restarting the Import wizard. As a result, the class mapping did not know that the columns were added and failed when instances were imported to the corresponding table.
Resolution
Perform the following local-change:
Rerun the import of the RAP file.
Tags:
Published December 27, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.