You're abslutely spot on ... one of the persistence.xml had this property as "create". This property is by default set to value "update" so didn't even notice, i checked with a fresh installation. Not sure why I changed this to create. Thanks a lot ...
One more question, recently i'm observing the following exception in the server.log during startup, can you tell me what could be the reason. Is it expecting anything at startup which is missing?
14:51:46,568 ERROR [org.drools.persistence.SingleSessionCommandService] (http-/127.0.0.1:8080-4) Could not commit session: java.lang.RuntimeException: Could not find session data for id 1
at org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:222) [drools-persistence-jpa-5.3.1.BRMS.jar:5.3.1.BRMS]