31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!

Rules upload Fail

I have been upload a rules to the OpenClinica EDC system, after the browse and validate procedure, I press OK to upgrade the file, an Error message had came out see below.




In the log file, some messages about this about this error was written as below:

01/11 14:24:48 [] USER INFO chriszhong o.a.o.c.s.ImportRuleServlet:187 - Total Number of RuleDefs Being imported : 1
01/11 14:24:48 [] USER INFO chriszhong o.a.o.c.s.ImportRuleServlet:188 - Total Number of RuleAssignments Being imported : 1
01/11 14:24:48 [] USER INFO chriszhong o.a.o.c.s.ImportRuleServlet:97 - Chris
01/11 14:24:48 [] LPR INFO chriszhong o.a.o.s.r.RulesPostImportContainerService:286 - # of Valid RuleDefs : 0 , # of InValid RuleDefs : 0 , # of Overwritable RuleDefs : 1
01/11 14:24:48 [] LPR INFO chriszhong o.a.o.s.r.RulesPostImportContainerService:249 - # of Valid RuleSetDefs : 1
01/11 14:24:48 [] LPR INFO chriszhong o.a.o.s.r.RulesPostImportContainerService:250 - # of InValid RuleSetDefs : 0
01/11 14:24:48 [] LPR INFO chriszhong o.a.o.s.r.RulesPostImportContainerService:251 - # of Overwritable RuleSetDefs : 0
01/11 14:24:48 [] USER INFO chriszhong o.a.o.c.s.VerifyImportedRuleServlet:61 - Size of ruleDefs : 1
01/11 14:24:48 [] USER INFO chriszhong o.a.o.c.s.VerifyImportedRuleServlet:62 - Size of ruleSets : 1
01/11 14:24:52 [] USER ERROR chriszhong o.a.o.c.s.VerifyImportedRuleServlet:607 - org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into rule_expression (version, date_created, owner_id, status_id, update_id, context, value, id) values (?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
01/11 14:29:13 [] USER ERROR chriszhong o.a.o.c.s.VerifyImportedRuleServlet:607 - org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into rule_expression (version, date_created, owner_id, status_id, update_id, context, value, id) values (?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

Hopes you could help me to solve this

thx a lot!


Your Kindly

Chris

Best Answers

Sign In or Register to comment.