Question

3
Replies
500
Views
Close popover
Nagaraju Bollam (NagarajuB0579)
Capgemini

Capgemini
NL
NagarajuB0579 Member since 2014 12 posts
Capgemini
Posted: March 11, 2019
Last activity: March 12, 2019
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