Support Article
pxCreateDateTime error after Pega 7.1.7 installation
SA-8920
Summary
You install Pega 7.1.7 on Tomcat and Oracle 11g. When you start the system, you see an error writing property pxCreateDateTime.
Error Messages
2015-04-15 08:36:56,210 [] [ ] [ ] [ ] ( internal.access.DatabaseImpl) ERROR - Encountered database exception in saveAllOrNone
com.pega.pegarules.pub.database.BadTableMappingException: Database-General Cannot write property pxCreateDateTime to a decimal column--its value, "20150415T153656.182 GMT", is not a decimal
From: (BAE31F7F64E62D745C61919D5393311D4)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.setStmtInsert(PageDatabaseMapperImpl.java:2059)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInSaveStatementWithoutStream(PageDatabaseMapperImpl.java:1541)
at com.pega.pegarules.data.internal.access.DatabaseImpl$SaverImpl.saveInstance(DatabaseImpl.java:5225)
at com.pega.pegarules.data.internal.access.DatabaseImpl$SaverImpl.saveAllOrNone(DatabaseImpl.java:5141)
at com.pega.pegarules.session.internal.authorization.context.GlobalContextCache.writeRuleSetListHashToDB(GlobalContextCache.java:2106)
Steps to Reproduce
Start Pega 7.1.7 on tomcat/oracle.
Root Cause
You are using an old version of the Oracle JDBC driver.
Resolution
Either you use a newer version of the JDBC driver or you set this connection property in your datasource.
connectionProperties="oracle.jdbc.V8Compatible=true"
Since you are running Java 6 you should use an ojdbc6.jar for your Oracle 11 database and then you will not need that V8Compatible setting.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.