Question

3
Replies
486
Views
NagarajuB0579 Member since 2014 12 posts
Capgemini
Posted: 1 year ago
Last activity: 1 year 7 months ago
Closed

com.pega.pegarules.pub.database.BadTableMappingException: Database-General

Hi All,

We are facing the below error in production, we recently upgraded our application from PEGA 6.1 SP2 to PEGA 7.2.2. But this behavior is weird indeed happens only in some occassions on submitting an assignment but not all the times. Could you please help me on how to fix it. I thought to disable the geolocation on case designer but dont have any case types created in PEGA 7, all we have from are from PEGA 6.

Due to this error, all the cases are throwing error in production but doesn't happen every day.

com.pega.pegarules.pub.database.BadTableMappingException: Database-General Cannot write property pxLatitude to a decimal column--its value, "NaN", is not a decimal
From: (HE5A47C3CCDC78DB062F94BEBA920FEEE:10.93.225.115)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.setStmtInsert(PageDatabaseMapperImpl.java:2094)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInStatementFromPageWithStream(PageDatabaseMapperImpl.java:1383)
at com.pega.pegarules.data.internal.access.Saver.getStatementWithPrepValues(Saver.java:1608)
at com.pega.pegarules.data.internal.access.Saver.addBatch(Saver.java:993)
at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:859)
at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:803)
at com.pega.pegarules.data.internal.access.UpdateProcessor.performOps(UpdateProcessor.java:1391)
at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:245)
at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:82)
at com.pega.pegarules.data.internal.store.DataStoreManager.doInTransaction(DataStoreManager.java:235)
at com.pega.pegarules.data.internal.access.UpdateProcessor.processUpdates(UpdateProcessor.java:178)
at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2066)
at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_6c6c3f21ead5ea2a97cdc30349237e37.step4_circum0(ra_action_commitwitherrorhandling_6c6c3f21ead5ea2a97cdc30349237e37.java:493)
at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_6c6c3f21ead5ea2a97cdc30

***Edited by Moderator Marissa to update SR Details; updated platform capability tags***

Low-Code App Development Data Integration
Moderation Team has archived post
Share this page LinkedIn