2020-11-03 03:03:59,127 |27.0.0.1-8009-exec-4 |RequestHandler |E| Request setCurrentSearchFromHistory caused an error with the following message: java.lang.IllegalArgumentException: Could not set current search options to history index [0], only [0] entries in the history list. 2020-11-03 04:18:37,735 |27.0.0.1-8009-exec-9 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2020-11-03 06:10:50,341 |27.0.0.1-8009-exec-3 |GenericDelegator |E| Failure in create operation for entity [Person]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)). Rolling back transaction. 2020-11-03 06:10:50,357 |27.0.0.1-8009-exec-3 |GenericDelegator |E| Failure in storeAll operation: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)) (Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.))). Rolling back transaction. org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)) (Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.))) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:904) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1326) [ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1282) [ofbiz.jar:?] at org.apache.ofbiz.party.party.PartyServices.createPerson(PartyServices.java:172) [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.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) [ofbiz.jar:?] at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [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:103) [ofbiz.jar:?] at org.apache.ofbiz.minilang.method.callops.CallService.exec(CallService.java:217) [ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:310) [ofbiz.jar:?] at org.apache.ofbiz.minilang.method.conditional.EmptyCondition.exec(EmptyCondition.java:80) [ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:310) [ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:457) [ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:274) [ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSimpleEvent(SimpleMethod.java:257) [ofbiz.jar:?] at org.apache.ofbiz.webapp.event.SimpleEventHandler.invoke(SimpleEventHandler.java:75) [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.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.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:100) [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.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337) [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.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:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)) 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:?] ... 63 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.) 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:?] ... 63 more Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100. 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:?] ... 63 more Caused by: org.apache.derby.iapi.error.StandardException: A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100. 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.iapi.types.SQLChar.hasNonBlankChars(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(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:?] ... 63 more 2020-11-03 06:10:50,513 |27.0.0.1-8009-exec-3 |ServiceUtil |E| {errorMessage=Could not add person info (write failure): $org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)) (Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.))) (org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)) (Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)))), responseMessage=error} 2020-11-03 06:10:50,513 |27.0.0.1-8009-exec-3 |ServiceDispatcher |E| Error in Service [createPerson]: Could not add person info (write failure): $org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)) (Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.))) (org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)) (Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)))) 2020-11-03 06:10:50,544 |27.0.0.1-8009-exec-3 |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.SimpleEventHandler.invoke(SimpleEventHandler.java:88) [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.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.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:100) [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.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337) [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.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.GenericDelegator.storeAll(GenericDelegator.java:1326) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1282) ~[ofbiz.jar:?] at org.apache.ofbiz.party.party.PartyServices.createPerson(PartyServices.java:172) ~[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.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) ~[ofbiz.jar:?] at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) ~[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:103) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.method.callops.CallService.exec(CallService.java:217) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:310) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.method.conditional.EmptyCondition.exec(EmptyCondition.java:80) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:310) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:457) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:274) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSimpleEvent(SimpleMethod.java:257) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.event.SimpleEventHandler.invoke(SimpleEventHandler.java:75) ~[ofbiz.jar:?] ... 43 more 2020-11-03 06:10:50,544 |27.0.0.1-8009-exec-3 |SimpleEventHandler |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.SimpleEventHandler.invoke(SimpleEventHandler.java:88) [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.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.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:100) [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.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337) [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.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.GenericDelegator.storeAll(GenericDelegator.java:1326) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1282) ~[ofbiz.jar:?] at org.apache.ofbiz.party.party.PartyServices.createPerson(PartyServices.java:172) ~[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.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) ~[ofbiz.jar:?] at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) ~[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:103) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.method.callops.CallService.exec(CallService.java:217) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:310) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.method.conditional.EmptyCondition.exec(EmptyCondition.java:80) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:310) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:457) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:274) ~[ofbiz.jar:?] at org.apache.ofbiz.minilang.SimpleMethod.runSimpleEvent(SimpleMethod.java:257) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.event.SimpleEventHandler.invoke(SimpleEventHandler.java:75) ~[ofbiz.jar:?] ... 43 more 2020-11-03 06:10:50,544 |27.0.0.1-8009-exec-3 |RequestHandler |E| Request submitAnonContact caused an error with the following message: Error:Could not add person info (write failure): $org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)) (Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.))) (org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)) (Error while inserting: [GenericEntity:Person][createdStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][createdTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][firstName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastName,After all, you still need to buy food, pay bills, help relatives in such a difficult time. 1 https://investmentreturn.page.link/pcptMVNchJU8dGqE9 (java.lang.String)][lastUpdatedStamp,2020-11-03 06:10:50.28(java.sql.Timestamp)][lastUpdatedTxStamp,2020-11-03 06:10:50.091(java.sql.Timestamp)][partyId,10058(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'After all, you still need to buy food, pay bills, h&' to length 100.)))) 2020-11-03 07:15:12,957 |27.0.0.1-8009-exec-9 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2020-11-03 08:47:36,561 |27.0.0.1-8009-exec-5 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2020-11-03 12:28:54,257 |27.0.0.1-8009-exec-2 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2020-11-03 21:24:42,681 |27.0.0.1-8009-exec-7 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail}