2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [FROM_DATE] of table [OFBIZ.WORK_EFFORT_GOOD_STANDARD] of entity [WorkEffortGoodStandard] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_GOOD_STANDARD] of entity [WorkEffortGoodStandard] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [PRODUCT_ID] of table [OFBIZ.WORK_EFFORT_GOOD_STANDARD] of entity [WorkEffortGoodStandard] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_GOOD_STD_TYPE_ID] of table [OFBIZ.WORK_EFFORT_GOOD_STANDARD] of entity [WorkEffortGoodStandard] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_GOOD_STD_TYPE_ID] of table [OFBIZ.WORK_EFFORT_GOOD_STANDARD_TYPE] of entity [WorkEffortGoodStandardType] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_ICAL_DATA] of entity [WorkEffortIcalData] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [INVENTORY_ITEM_ID] of table [OFBIZ.WORK_EFFORT_INVENTORY_ASSIGN] of entity [WorkEffortInventoryAssign] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_INVENTORY_ASSIGN] of entity [WorkEffortInventoryAssign] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [INVENTORY_ITEM_ID] of table [OFBIZ.WORK_EFFORT_INVENTORY_PRODUCED] of entity [WorkEffortInventoryProduced] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_INVENTORY_PRODUCED] of entity [WorkEffortInventoryProduced] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_KEYWORD] of entity [WorkEffortKeyword] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [KEYWORD] of table [OFBIZ.WORK_EFFORT_KEYWORD] of entity [WorkEffortKeyword] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_NOTE] of entity [WorkEffortNote] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [NOTE_ID] of table [OFBIZ.WORK_EFFORT_NOTE] of entity [WorkEffortNote] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [FROM_DATE] of table [OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT] of entity [WorkEffortPartyAssignment] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT] of entity [WorkEffortPartyAssignment] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [ROLE_TYPE_ID] of table [OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT] of entity [WorkEffortPartyAssignment] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [PARTY_ID] of table [OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT] of entity [WorkEffortPartyAssignment] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_PURPOSE_TYPE_ID] of table [OFBIZ.WORK_EFFORT_PURPOSE_TYPE] of entity [WorkEffortPurposeType] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [USER_LOGIN_ID] of table [OFBIZ.WORK_EFFORT_REVIEW] of entity [WorkEffortReview] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_REVIEW] of entity [WorkEffortReview] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [REVIEW_DATE] of table [OFBIZ.WORK_EFFORT_REVIEW] of entity [WorkEffortReview] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_SEARCH_RESULT_ID] of table [OFBIZ.WORK_EFFORT_SEARCH_CONSTRAINT] of entity [WorkEffortSearchConstraint] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [CONSTRAINT_SEQ_ID] of table [OFBIZ.WORK_EFFORT_SEARCH_CONSTRAINT] of entity [WorkEffortSearchConstraint] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_SEARCH_RESULT_ID] of table [OFBIZ.WORK_EFFORT_SEARCH_RESULT] of entity [WorkEffortSearchResult] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_SKILL_STANDARD] of entity [WorkEffortSkillStandard] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [SKILL_TYPE_ID] of table [OFBIZ.WORK_EFFORT_SKILL_STANDARD] of entity [WorkEffortSkillStandard] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [STATUS_DATETIME] of table [OFBIZ.WORK_EFFORT_STATUS] of entity [WorkEffortStatus] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_STATUS] of entity [WorkEffortStatus] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [STATUS_ID] of table [OFBIZ.WORK_EFFORT_STATUS] of entity [WorkEffortStatus] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [FROM_DATE] of table [OFBIZ.WORK_EFFORT_SURVEY_APPL] of entity [WorkEffortSurveyAppl] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_SURVEY_APPL] of entity [WorkEffortSurveyAppl] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [SURVEY_ID] of table [OFBIZ.WORK_EFFORT_SURVEY_APPL] of entity [WorkEffortSurveyAppl] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [PROCESS_WORK_EFFORT_ID] of table [OFBIZ.WORK_EFFORT_TRANS_BOX] of entity [WorkEffortTransBox] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [TRANSITION_ID] of table [OFBIZ.WORK_EFFORT_TRANS_BOX] of entity [WorkEffortTransBox] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [TO_ACTIVITY_ID] of table [OFBIZ.WORK_EFFORT_TRANS_BOX] of entity [WorkEffortTransBox] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_TYPE_ID] of table [OFBIZ.WORK_EFFORT_TYPE] of entity [WorkEffortType] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [ATTR_NAME] of table [OFBIZ.WORK_EFFORT_TYPE_ATTR] of entity [WorkEffortTypeAttr] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_TYPE_ID] of table [OFBIZ.WORK_EFFORT_TYPE_ATTR] of entity [WorkEffortTypeAttr] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [ORDER_ID] of table [OFBIZ.WORK_ORDER_ITEM_FULFILLMENT] of entity [WorkOrderItemFulfillment] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_ORDER_ITEM_FULFILLMENT] of entity [WorkOrderItemFulfillment] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [ORDER_ITEM_SEQ_ID] of table [OFBIZ.WORK_ORDER_ITEM_FULFILLMENT] of entity [WorkOrderItemFulfillment] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_REQ_FULF_TYPE_ID] of table [OFBIZ.WORK_REQ_FULF_TYPE] of entity [WorkReqFulfType] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [REQUIREMENT_ID] of table [OFBIZ.WORK_REQUIREMENT_FULFILLMENT] of entity [WorkRequirementFulfillment] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [WORK_EFFORT_ID] of table [OFBIZ.WORK_REQUIREMENT_FULFILLMENT] of entity [WorkRequirementFulfillment] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [CERT_PROVISION_ID] of table [OFBIZ.X509_ISSUER_PROVISION] of entity [X509IssuerProvision] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [FROM_DATE] of table [OFBIZ.ZIP_SALES_RULE_LOOKUP] of entity [ZipSalesRuleLookup] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [CITY] of table [OFBIZ.ZIP_SALES_RULE_LOOKUP] of entity [ZipSalesRuleLookup] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [STATE_CODE] of table [OFBIZ.ZIP_SALES_RULE_LOOKUP] of entity [ZipSalesRuleLookup] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [COUNTY] of table [OFBIZ.ZIP_SALES_RULE_LOOKUP] of entity [ZipSalesRuleLookup] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [FROM_DATE] of table [OFBIZ.ZIP_SALES_TAX_LOOKUP] of entity [ZipSalesTaxLookup] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [ZIP_CODE] of table [OFBIZ.ZIP_SALES_TAX_LOOKUP] of entity [ZipSalesTaxLookup] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [COUNTY] of table [OFBIZ.ZIP_SALES_TAX_LOOKUP] of entity [ZipSalesTaxLookup] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [STATE_CODE] of table [OFBIZ.ZIP_SALES_TAX_LOOKUP] of entity [ZipSalesTaxLookup] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:48,176 |OFBiz-batch-2 |DatabaseUtil |E| Column [CITY] of table [OFBIZ.ZIP_SALES_TAX_LOOKUP] of entity [ZipSalesTaxLookup] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2021-05-10 20:42:56,223 |main |UtilXml |E| XmlFileLoader: File file:/C:/Apache24/htdocs/www/polluniverse.com/apache-ofbiz-17.12.03/plugins/ofbizDemo/webapp/ofbizDemo/WEB-INF/controller.xml process error. Line: 56. Error message: cvc-complex-type.2.4.a: Invalid content was found starting with element 'request-map'. One of '{"http://ofbiz.apache.org/Site-Conf":view-map}' is expected. 2021-05-10 20:47:36,242 |27.0.0.1-8009-exec-5 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Unknown request [ofbizdemo]; this request does not exist or cannot be called directly. at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:208) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] 2021-05-10 20:47:36,258 |27.0.0.1-8009-exec-5 |ControlServlet |E| An error occurred, going to the errorPage: file:/C:/Apache24/htdocs/www/polluniverse.com/apache-ofbiz-17.12.03/framework/common/webcommon/error/Error.ftl 2021-05-10 20:54:27,187 |27.0.0.1-8009-exec-2 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Unknown request [ofbizdemo]; this request does not exist or cannot be called directly. at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:208) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] 2021-05-10 20:54:27,187 |27.0.0.1-8009-exec-2 |ControlServlet |E| An error occurred, going to the errorPage: file:/C:/Apache24/htdocs/www/polluniverse.com/apache-ofbiz-17.12.03/framework/common/webcommon/error/Error.ftl 2021-05-10 21:08:49,629 |27.0.0.1-8009-exec-8 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Unknown request [runservice]; this request does not exist or cannot be called directly. at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:208) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] 2021-05-10 21:08:49,629 |27.0.0.1-8009-exec-8 |ControlServlet |E| An error occurred, going to the errorPage: file:/C:/Apache24/htdocs/www/polluniverse.com/apache-ofbiz-17.12.03/framework/common/webcommon/error/Error.ftl 2021-05-10 21:09:04,442 |7.0.0.1-8009-exec-10 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Unknown request [runservice]; this request does not exist or cannot be called directly. at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:208) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] 2021-05-10 21:09:04,457 |7.0.0.1-8009-exec-10 |ControlServlet |E| An error occurred, going to the errorPage: file:/C:/Apache24/htdocs/www/polluniverse.com/apache-ofbiz-17.12.03/framework/common/webcommon/error/Error.ftl 2021-05-10 21:14:56,528 |7.0.0.1-8009-exec-10 |GenericDelegator |E| Failure in create operation for entity [OfbizDemo]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.)). Rolling back transaction. 2021-05-10 21:14:56,528 |7.0.0.1-8009-exec-10 |EntityAutoEngine |E| Error doing entity-auto operation for entity [OfbizDemo] in service [createOfbizDemo]: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.)) (Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.))) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.)) (Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.))) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:904) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) ~[ofbiz.jar:?] at org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:357) ~[ofbiz.jar:?] at org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:114) [ofbiz.jar:?] at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:403) [ofbiz.jar:?] at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:228) [ofbiz.jar:?] at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) [ofbiz.jar:?] at org.apache.ofbiz.webapp.event.CoreEvents.scheduleService(CoreEvents.java:316) [ofbiz.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_201] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_201] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_201] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_201] at org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:100) [ofbiz.jar:?] at org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:80) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:741) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:465) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:91) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:706) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.)) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz.jar:?] ... 50 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz.jar:?] ... 50 more Caused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz.jar:?] ... 50 more Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz.jar:?] ... 50 more 2021-05-10 21:14:56,638 |7.0.0.1-8009-exec-10 |ServiceUtil |E| {errorMessage=Error doing entity-auto operation for entity OfbizDemo in service createOfbizDemo: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.)) (Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.))), responseMessage=error} 2021-05-10 21:14:56,638 |7.0.0.1-8009-exec-10 |ServiceDispatcher |E| Error in Service [createOfbizDemo]: Error doing entity-auto operation for entity OfbizDemo in service createOfbizDemo: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.)) (Error while inserting: [GenericEntity:OfbizDemo][comments,test(java.lang.String)][createdStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][createdTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][firstName,Katie(java.lang.String)][lastName,Qiu(java.lang.String)][lastUpdatedStamp,2021-05-10 21:14:56.481(java.sql.Timestamp)][lastUpdatedTxStamp,2021-05-10 21:14:56.435(java.sql.Timestamp)][ofbizDemoId,10040(java.lang.String)][ofbizDemoTypeId,SAMPLE_DEMO_1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.OFBIZ_DEMO (OFBIZ_DEMO_ID, OFBIZ_DEMO_TYPE_ID, FIRST_NAME, LAST_NAME, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'OFBIZ_DEMO' caused a violation of foreign key constraint 'ODEM_OD_TYPE_ID' for key (SAMPLE_DEMO_1). The statement has been rolled back.))) 2021-05-10 21:14:56,731 |7.0.0.1-8009-exec-10 |TransactionUtil |E| Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception javax.transaction.RollbackException: Unable to commit: transaction marked for rollback at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272) ~[geronimo-transaction-3.1.4.jar:3.1.4] at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) ~[geronimo-transaction-3.1.4.jar:3.1.4] at org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:241) [ofbiz.jar:?] at org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:227) [ofbiz.jar:?] at org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:119) [ofbiz.jar:?] at org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:80) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:741) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:465) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:91) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:706) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] Caused by: org.apache.geronimo.transaction.manager.SetRollbackOnlyException: setRollbackOnly() called. See stacktrace for origin at org.apache.geronimo.transaction.manager.TransactionImpl.setRollbackOnly(TransactionImpl.java:126) ~[geronimo-transaction-3.1.4.jar:3.1.4] at org.apache.geronimo.transaction.manager.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:243) ~[geronimo-transaction-3.1.4.jar:3.1.4] at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:361) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:185) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:112) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) ~[ofbiz.jar:?] at org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:357) ~[ofbiz.jar:?] at org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:114) ~[ofbiz.jar:?] at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:403) ~[ofbiz.jar:?] at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:228) ~[ofbiz.jar:?] at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.event.CoreEvents.scheduleService(CoreEvents.java:316) ~[ofbiz.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_201] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_201] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_201] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_201] at org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:100) ~[ofbiz.jar:?] ... 38 more 2021-05-10 21:14:56,731 |7.0.0.1-8009-exec-10 |JavaEventHandler |E| null org.apache.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: rollback called in Entity Engine SQLProcessorjava.lang.Exception: Current Location Stack (Current Location Stack) at org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:263) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:227) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:119) [ofbiz.jar:?] at org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:80) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:741) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:465) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:91) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:706) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] Caused by: java.lang.Exception: Current Location Stack at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:185) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:112) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) ~[ofbiz.jar:?] at org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:357) ~[ofbiz.jar:?] at org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:114) ~[ofbiz.jar:?] at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:403) ~[ofbiz.jar:?] at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:228) ~[ofbiz.jar:?] at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.event.CoreEvents.scheduleService(CoreEvents.java:316) ~[ofbiz.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_201] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_201] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_201] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_201] at org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:100) ~[ofbiz.jar:?] ... 38 more