BadTableMappingException- Cannot write property <unknown> to a decimal column
Getting the below error when an activity is run to update the database with case properties-
There was a problem with the database when getting a list: com.pega.pegarules.pub.database.BadTableMappingException: Cannot write property <unknown> to a decimal column--its value, "Pipeline", is not a decimal: code: <none> SQLState: <none> Message: <none>
I checked the data types of the columns in the DB, there is no property with Decimal type.
Can someone pls help me with this. (Pasting the full logs below) Thanks!
Getting the below error when an activity is run to update the database with case properties-
There was a problem with the database when getting a list: com.pega.pegarules.pub.database.BadTableMappingException: Cannot write property <unknown> to a decimal column--its value, "Pipeline", is not a decimal: code: <none> SQLState: <none> Message: <none>
I checked the data types of the columns in the DB, there is no property with Decimal type.
Can someone pls help me with this. (Pasting the full logs below) Thanks!
There was a problem with the database when getting a list: com.pega.pegarules.pub.database.BadTableMappingException: Cannot write property <unknown> to a decimal column--its value, "Pipeline", is not a decimal: code: <none> SQLState: <none> Message: <none> at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.setStmtInsert(PageDatabaseMapperImpl.java:2158) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInDataStoreStatementFromValList(PageDatabaseMapperImpl.java:1088) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.access.Lister.getStatementReady(Lister.java:495) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.access.Lister.getStatement(Lister.java:470) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:397) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:190) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:126) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:73) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:3193) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:3173) ~[prprivate-data.jar:?] at com.pegarules.generated.activity.ra_action_update_cand_proj_raw_5d9e2d360411838f5385f330d74be6cc.step7_12_circum0(ra_action_update_cand_proj_raw_5d9e2d360411838f5385f330d74be6cc.java:3173) ~[?:?] at com.pegarules.generated.activity.ra_action_update_cand_proj_raw_5d9e2d360411838f5385f330d74be6cc.step7_0_circum0(ra_action_update_cand_proj_raw_5d9e2d360411838f5385f330d74be6cc.java:719) ~[?:?] at com.pegarules.generated.activity.ra_action_update_cand_proj_raw_5d9e2d360411838f5385f330d74be6cc.perform(ra_action_update_cand_proj_raw_5d9e2d360411838f5385f330d74be6cc.java:162) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2855) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:653) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivities(ThreadRunner.java:580) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivities(PRThreadImpl.java:512) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.async.agent.QueueProcessor.executeBatchTask(QueueProcessor.java:305) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:361) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1174) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1380) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1123) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1004) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:831) ~[prprivate-session.jar:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_202] at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_202]