Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Nagaraju Bollam (NagarajuB0579)
Capgemini

Capgemini
NL
NagarajuB0579 Member since 2014 15 posts
Capgemini
Posted: Mar 11, 2019
Last activity: Mar 12, 2019
Posted: 11 Mar 2019 12:01 EDT
Last activity: 12 Mar 2019 17:00 EDT
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.

Show More

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: Proprietary information hidden)
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***


Show Less
To see attachments, please log in.
Low-Code App Development
Data Integration

We'd prefer it if you saw us at our best.

Pega Collaboration Center 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