Please join your peers on either March 26 (8pm GMT) or March 28 (8am GMT) to watch as user extraordinaire and forum legend @"lindsay.stevens" demonstrates OpenClinica Insight.

See preview and register at https://openclinica.com/insight-webinar

Insight makes it easy to ask questions of ALL of your clinical and operational data and visualize answers via interactive reports and dashboards. The idea is simple, but the results are powerful: ask your questions, choose your visualizations, then return often for updated, interactive results that link you to all of the underlying data.

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.