[ https://issues.apache.org/jira/browse/OFBIZ-11686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17185141#comment-17185141 ] Jacques Le Roux commented on OFBIZ-11686: ----------------------------------------- Hi James, I still see it after a "git pull && cleanAll eclipse loadAll ofbiz" This is the trace of a call to https://localhost:8443/ecomseo, and then several F5 (update) in browser: {noformat} ____ __________ _ / __ \/ ____/ __ )(_)___ / / / / /_ / __ / /_ / / /_/ / __/ / /_/ / / / /_ \____/_/ /_____/_/ /___/ is started and ready. 2020-08-26 14:07:40,351 |main |ContainerLoader |I| Started container birt-container 2020-08-26 14:07:40,828 |OFBiz-JobPoller |JobManager |I| No crashed jobs to re-schedule 2020-08-26 14:07:40,942 |OFBiz-JobQueue-1 |TransactionUtil |W| No transaction in place, so not suspending. 2020-08-26 14:07:40,947 |OFBiz-JobQueue-1 |SequenceUtil |W| Lock failed; no sequence row was found, will try to add a new one for sequence: JobSandbox 2020-08-26 14:07:40,961 |OFBiz-JobQueue-1 |SequenceUtil |I| Got bank of sequenced IDs for [JobSandbox]; curSeqId=10000, maxSeqId=10100, bankSize=100 2020-08-26 14:07:40,967 |OFBiz-JobQueue-1 |PersistedServiceJob |I| Job [Delete auto-save shopping list for anonymous users] Id [8009] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:40,981 |OFBiz-JobQueue-1 |AbstractEngine |I| Loaded Service Locations: {eedcc-test=https://localhost:8443/webtools/control/httpService, entity-sync-http=https://localhost:8443/webtools/control/httpServ ice, rita-rmi=rmi://localhost:1099/RMIDispatcher, main-rmi=rmi://localhost:1099/RMIDispatcher, main-soap=http://localhost:8080/webtools/control/SOAPService, entity-sync-rmi=rmi://localhost:1099/RMIDispatcher, main-http=http://localhost:8 080/webtools/control/httpService} 2020-08-26 14:07:40,989 |OFBiz-JobQueue-0 |PersistedServiceJob |I| Job [Create Future Period] Id [FUTURE_PERIOD] -- Next runtime: Tue Sep 01 14:07:40 CEST 2020 2020-08-26 14:07:40,996 |OFBiz-JobQueue-0 |ScriptUtil |I| The following 3 scripting engines were found: 2020-08-26 14:07:40,996 |OFBiz-JobQueue-0 |ScriptUtil |I| Engine name: Oracle Nashorn 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Version: 1.8.0_202 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Language: ECMAScript 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Engine supports the following extensions: 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| js 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Engine has the following short names: 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| nashorn 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Nashorn 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| js 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| JS 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| JavaScript 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| javascript 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| ECMAScript 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| ecmascript 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Engine name: BeanShell Engine 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Version: 1.0 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Language: BeanShell 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Engine supports the following extensions: 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| bsh 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| java 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Engine has the following short names: 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| beanshell 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| bsh 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| java 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Engine name: Groovy Scripting Engine 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Version: 2.0 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Language: Groovy 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Engine supports the following extensions: 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| groovy 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Engine has the following short names: 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| groovy 2020-08-26 14:07:40,997 |OFBiz-JobQueue-0 |ScriptUtil |I| Groovy 2020-08-26 14:07:41,027 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/autoDeleteAutoSaveShoppingList] finished in [51] milliseconds 2020-08-26 14:07:41,036 |OFBiz-JobQueue-1 |PersistedServiceJob |I| Job [Create Also Bought Product Associations] Id [8008] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:41,179 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/createAlsoBoughtProductAssocsForOrder] finished in [72] milliseconds 2020-08-26 14:07:41,182 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/createAlsoBoughtProductAssocsForOrder] finished in [2] milliseconds 2020-08-26 14:07:41,182 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/createAlsoBoughtProductAssocs] finished in [146] milliseconds 2020-08-26 14:07:41,195 |OFBiz-JobQueue-1 |PersistedServiceJob |I| Job [Replacement Held Order Auto-Cancel] Id [8007] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:41,259 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/autoCancelReplacementOrders] finished in [64] milliseconds 2020-08-26 14:07:41,267 |OFBiz-JobQueue-1 |PersistedServiceJob |I| Job [Auto-create Fixed Asset Maintenances] Id [FAM_AUTO_CREATE] -- Next runtime: Wed Aug 26 15:07:41 CEST 2020 2020-08-26 14:07:41,407 |OFBiz-JobQueue-1 |Log |I| [CommonPermissionServices.xml#genericBasePermissionCheck line 59] This simple-method-call is deprecated! Please use a service-call of genericBasePermissionC heck instead. 2020-08-26 14:07:42,469 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/genericBasePermissionCheck] finished in [1060] milliseconds 2020-08-26 14:07:42,497 |OFBiz-JobQueue-1 |UtilProperties |I| ResourceBundle DefaultMessagesUiLabels (en) created in 0.027s with 11 properties 2020-08-26 14:07:42,499 |OFBiz-JobQueue-1 |ServiceEcaCondition |W| doRealCompare returned null, returning false 2020-08-26 14:07:42,499 |OFBiz-JobQueue-1 |ServiceEcaRule |I| For Service ECA [fixedAssetPermissionCheck] on [return] got false for condition: [hasPermission][equals][false][true][Boolean] 2020-08-26 14:07:42,499 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/fixedAssetPermissionCheck] finished in [1231] milliseconds 2020-08-26 14:07:42,508 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [default/createFuturePeriod] finished in [1516] milliseconds 2020-08-26 14:07:42,514 |OFBiz-JobQueue-0 |PersistedServiceJob |I| Job [Clear EntitySyncRemove Info] Id [8200] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:42,519 |OFBiz-JobQueue-0 |EntitySyncServices |I| Running cleanSyncRemoveInfo 2020-08-26 14:07:42,575 |OFBiz-JobQueue-0 |EntitySyncServices |I| In cleanSyncRemoveInfo removed [0] values with TX timestamp before [2020-08-25 14:07:42.548] 2020-08-26 14:07:42,576 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [default/cleanSyncRemoveInfo] finished in [62] milliseconds 2020-08-26 14:07:42,607 |OFBiz-JobQueue-0 |PersistedServiceJob |W| Persisted Job [9000] references a RecurrenceInfo, recommend using TemporalExpression instead 2020-08-26 14:07:42,626 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/createMaintsFromTimeInterval] finished in [1359] milliseconds 2020-08-26 14:07:42,629 |OFBiz-JobQueue-0 |PersistedServiceJob |I| Job [Auto Reconcile Financial Account] Id [9000] -- Next runtime: Fri Aug 28 00:00:00 CEST 2020 2020-08-26 14:07:42,631 |OFBiz-JobQueue-1 |PersistedServiceJob |I| Job [BackOrder Notification] Id [8000] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:42,652 |OFBiz-JobQueue-1 |InventoryServices |I| OOS Inventory Items: 0 2020-08-26 14:07:42,652 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/checkInventoryAvailability] finished in [21] milliseconds 2020-08-26 14:07:42,657 |OFBiz-JobQueue-1 |PersistedServiceJob |I| Job [Purge Old Store Auto-Entered Promos] Id [8100] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:42,696 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/purgeOldStoreAutoPromos] finished in [38] milliseconds 2020-08-26 14:07:42,705 |OFBiz-JobQueue-1 |PersistedServiceJob |I| Job [Send Email] Id [SENDEMAIL] -- Next runtime: Wed Aug 26 14:22:42 CEST 2020 2020-08-26 14:07:42,970 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [default/autoFinAccountReconciliation] finished in [341] milliseconds 2020-08-26 14:07:42,976 |OFBiz-JobQueue-0 |PersistedServiceJob |I| Job [Re-Try Failed Auths NSF] Id [8004] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:42,999 |OFBiz-JobQueue-0 |PaymentGatewayServices |I| Processing failed order re-auth(s) 2020-08-26 14:07:43,000 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [default/retryFailedAuthNsfs] finished in [24] milliseconds 2020-08-26 14:07:43,007 |OFBiz-JobQueue-0 |PersistedServiceJob |I| Job [Re-Try Failed Auths] Id [8001] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:43,013 |OFBiz-JobQueue-0 |PaymentGatewayServices |I| Processing failed order re-auth(s) 2020-08-26 14:07:43,013 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [default/retryFailedAuths] finished in [6] milliseconds 2020-08-26 14:07:43,019 |OFBiz-JobQueue-0 |PersistedServiceJob |I| Job [Run Auto-Reorders] Id [8003] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:43,034 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [default/runShoppingListAutoReorder] finished in [14] milliseconds 2020-08-26 14:07:43,039 |OFBiz-JobQueue-0 |PersistedServiceJob |I| Job [Extend expired Subscriptions] Id [8005] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:43,199 |OFBiz-JobQueue-0 |UtilProperties |I| ResourceBundle OrderUiLabels (en) created in 0.116s with 1011 properties 2020-08-26 14:07:43,201 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [default/runSubscriptionAutoReorders] finished in [161] milliseconds 2020-08-26 14:07:43,210 |OFBiz-JobQueue-0 |PersistedServiceJob |W| Persisted Job [8500] references a RecurrenceInfo, recommend using TemporalExpression instead 2020-08-26 14:07:43,224 |OFBiz-JobQueue-0 |PersistedServiceJob |I| Job [Generate Invoice template] Id [8500] -- Next runtime: Mon Sep 14 22:00:00 CEST 2020 2020-08-26 14:07:43,287 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/sendEmailDated] finished in [582] milliseconds 2020-08-26 14:07:43,294 |OFBiz-JobQueue-1 |PersistedServiceJob |I| Job [Cancels all orders after date] Id [8006] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:43,323 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [default/autoGenerateInvoiceFromExistingInvoice] finished in [53] milliseconds 2020-08-26 14:07:43,327 |OFBiz-JobQueue-0 |PersistedServiceJob |I| Job [Run Nominated Service on Subscription Expiry] Id [8010] -- Next runtime: Thu Aug 27 00:00:00 CEST 2020 2020-08-26 14:07:43,334 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [default/runServiceOnSubscriptionExpiry] finished in [6] milliseconds 2020-08-26 14:07:43,372 |OFBiz-JobQueue-1 |ServiceDispatcher |T| Sync service [default/cancelAllBackOrders] finished in [78] milliseconds 2020-08-26 14:08:46,950 |jsse-nio-8443-exec-3 |ControlEventListener |I| Creating session: hidden sessionId by default. 2020-08-26 14:08:48,042 |jsse-nio-8443-exec-3 |SeoContextFilter |I| Can NOT forward this url: /ecomseo 2020-08-26 14:08:48,085 |jsse-nio-8443-exec-3 |ConfigXMLReader |I| controller loaded: 0.005s, 289 requests, 96 views in file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/webapp/ecommerce/WEB-INF/controller.xml 2020-08-26 14:08:48,085 |jsse-nio-8443-exec-3 |ConfigXMLReader |I| controller loaded: 0.031s, 0 requests, 0 views in file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/webapp/ecomseo/WEB-INF/controller.xml 2020-08-26 14:08:48,094 |jsse-nio-8443-exec-3 |ControlServlet |T| [[[ecomseo::main (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:48,097 |jsse-nio-8443-exec-3 |VisitHandler |I| Found visitorId [10000] in cookie 2020-08-26 14:08:48,120 |jsse-nio-8443-exec-3 |TransactionUtil |W| No transaction in place, so not suspending. 2020-08-26 14:08:48,125 |jsse-nio-8443-exec-3 |SequenceUtil |W| Lock failed; no sequence row was found, will try to add a new one for sequence: Visitor 2020-08-26 14:08:48,134 |jsse-nio-8443-exec-3 |SequenceUtil |I| Got bank of sequenced IDs for [Visitor]; curSeqId=10000, maxSeqId=10100, bankSize=100 2020-08-26 14:08:48,138 |jsse-nio-8443-exec-3 |VisitHandler |I| The visitorId [10000] found in cookie was invalid, creating new Visitor with ID [10000] 2020-08-26 14:08:48,140 |jsse-nio-8443-exec-3 |TransactionUtil |W| No transaction in place, so not suspending. 2020-08-26 14:08:48,143 |jsse-nio-8443-exec-3 |SequenceUtil |W| Lock failed; no sequence row was found, will try to add a new one for sequence: Visit 2020-08-26 14:08:48,148 |jsse-nio-8443-exec-3 |SequenceUtil |I| Got bank of sequenced IDs for [Visit]; curSeqId=10000, maxSeqId=10100, bankSize=100 2020-08-26 14:08:48,191 |jsse-nio-8443-exec-3 |RequestHandler |I| This is the first request in this visit. Hidden sessionId by default. 2020-08-26 14:08:48,195 |jsse-nio-8443-exec-3 |LoginWorker |I| Running autoLogin check. 2020-08-26 14:08:48,359 |jsse-nio-8443-exec-3 |RequestHandler |I| Rendering View [main]. Hidden sessionId by default. 2020-08-26 14:08:48,391 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getUserPreferenceGroup] finished in [26] milliseconds 2020-08-26 14:08:48,737 |jsse-nio-8443-exec-3 |FreeMarkerWorker |I| loading properties: file:/C:/projectsASF/Git/ofbiz-framework/build/resources/main/org/apache/ofbiz/webapp/freemarkerTransforms.properties 2020-08-26 14:08:48,738 |jsse-nio-8443-exec-3 |FreeMarkerWorker |I| loading properties: file:/C:/projectsASF/Git/ofbiz-framework/build/resources/main/org/apache/ofbiz/widget/freemarkerTransforms.properties 2020-08-26 14:08:48,743 |jsse-nio-8443-exec-3 |FreeMarkerWorker |I| loading properties: file:/C:/projectsASF/Git/ofbiz-framework/build/resources/main/org/apache/ofbiz/content/freemarkerTransforms.properties 2020-08-26 14:08:48,745 |jsse-nio-8443-exec-3 |FreeMarkerWorker |I| loading properties: file:/C:/projectsASF/Git/ofbiz-framework/build/resources/main/org/apache/ofbiz/product/freemarkerTransforms.properties 2020-08-26 14:08:48,763 |jsse-nio-8443-exec-3 |ScreenFactory |I| Got 17 screens in 0.136s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/CommonScreens.xml 2020-08-26 14:08:49,297 |jsse-nio-8443-exec-3 |UtilProperties |I| ResourceBundle EcommerceUiLabels (en_US) created in 0.086s with 316 properties 2020-08-26 14:08:49,413 |jsse-nio-8443-exec-3 |UtilProperties |I| ResourceBundle ContentUiLabels (en_US) created in 0.115s with 566 properties 2020-08-26 14:08:49,609 |jsse-nio-8443-exec-3 |UtilProperties |I| ResourceBundle CommonUiLabels (en_US) created in 0.196s with 925 properties 2020-08-26 14:08:49,838 |jsse-nio-8443-exec-3 |UtilProperties |I| ResourceBundle ProductUiLabels (en_US) created in 0.229s with 2618 properties 2020-08-26 14:08:49,986 |jsse-nio-8443-exec-3 |UtilProperties |I| ResourceBundle AccountingUiLabels (en_US) created in 0.148s with 1594 properties 2020-08-26 14:08:50,079 |jsse-nio-8443-exec-3 |UtilProperties |I| ResourceBundle PartyUiLabels (en_US) created in 0.093s with 836 properties 2020-08-26 14:08:50,145 |jsse-nio-8443-exec-3 |UtilProperties |I| ResourceBundle OrderUiLabels (en_US) created in 0.066s with 0 properties 2020-08-26 14:08:50,339 |jsse-nio-8443-exec-3 |UtilProperties |I| ResourceBundle ProductEntityLabels (en_US) created in 0.05s with 388 properties 2020-08-26 14:08:50,703 |jsse-nio-8443-exec-3 |ScreenFactory |I| Got 9 screens in 0.006s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/CartScreens.xml 2020-08-26 14:08:50,828 |jsse-nio-8443-exec-3 |ScreenFactory |I| Got 38 screens in 0.083s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/CatalogScreens.xml 2020-08-26 14:08:51,846 |jsse-nio-8443-exec-6 |ControlEventListener |I| Creating session: hidden sessionId by default. 2020-08-26 14:08:51,846 |jsse-nio-8443-exec-5 |ControlEventListener |I| Creating session: hidden sessionId by default. 2020-08-26 14:08:51,848 |jsse-nio-8443-exec-6 |CategoryWorker |I| [CategoryWorker.getCatalogTopCategory] Setting new top category: CATALOG1 2020-08-26 14:08:51,852 |jsse-nio-8443-exec-5 |CategoryWorker |I| [CategoryWorker.getCatalogTopCategory] Setting new top category: CATALOG1 2020-08-26 14:08:51,874 |jsse-nio-8443-exec-9 |ControlEventListener |I| Creating session: hidden sessionId by default. 2020-08-26 14:08:51,874 |jsse-nio-8443-exec-9 |CategoryWorker |I| [CategoryWorker.getCatalogTopCategory] Setting new top category: CATALOG1 2020-08-26 14:08:51,893 |jsse-nio-8443-exec-7 |ControlEventListener |I| Creating session: hidden sessionId by default. 2020-08-26 14:08:51,893 |jsse-nio-8443-exec-7 |CategoryWorker |I| [CategoryWorker.getCatalogTopCategory] Setting new top category: CATALOG1 2020-08-26 14:08:51,894 |jsse-nio-8443-exec-1 |ControlEventListener |I| Creating session: hidden sessionId by default. 2020-08-26 14:08:51,894 |jsse-nio-8443-exec-1 |CategoryWorker |I| [CategoryWorker.getCatalogTopCategory] Setting new top category: CATALOG1 2020-08-26 14:08:52,022 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [116] milliseconds 2020-08-26 14:08:52,172 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [12] milliseconds 2020-08-26 14:08:52,193 |jsse-nio-8443-exec-3 |ScreenFactory |I| Got 7 screens in 0.008s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/EmailContactListScreens.xml 2020-08-26 14:08:52,526 |jsse-nio-8443-exec-3 |ScreenFactory |I| Got 8 screens in 0.004s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/ContentScreens.xml 2020-08-26 14:08:52,539 |jsse-nio-8443-exec-3 |ProductStoreWorker |I| getSurvey for product null 2020-08-26 14:08:52,682 |jsse-nio-8443-exec-3 |ScreenFactory |I| Got 6 screens in 0.024s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/ForumScreens.xml 2020-08-26 14:08:52,788 |jsse-nio-8443-exec-3 |ScreenFactory |I| Got 15 screens in 0.021s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/blog/BlogScreens.xml 2020-08-26 14:08:53,191 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getProductCategoryAndLimitedMembers] finished in [7] milliseconds 2020-08-26 14:08:53,691 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [74] milliseconds 2020-08-26 14:08:53,696 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [2] milliseconds 2020-08-26 14:08:53,740 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [10] milliseconds 2020-08-26 14:08:53,747 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [7] milliseconds 2020-08-26 14:08:53,748 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,750 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,821 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [3] milliseconds 2020-08-26 14:08:53,832 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [11] milliseconds 2020-08-26 14:08:53,844 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [1] milliseconds 2020-08-26 14:08:53,849 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [5] milliseconds 2020-08-26 14:08:53,861 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [2] milliseconds 2020-08-26 14:08:53,864 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [2] milliseconds 2020-08-26 14:08:53,883 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [9] milliseconds 2020-08-26 14:08:53,897 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,923 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [1] milliseconds 2020-08-26 14:08:53,925 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,926 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,930 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,931 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,933 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,936 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,938 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,941 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,944 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [2] milliseconds 2020-08-26 14:08:53,946 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,958 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [2] milliseconds 2020-08-26 14:08:53,960 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [2] milliseconds 2020-08-26 14:08:53,962 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [2] milliseconds 2020-08-26 14:08:53,967 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,975 |jsse-nio-8443-exec-3 |PriceServices |I| There is more than one DEFAULT_PRICE with the currencyUomId USD and productId PEPPERS-G, using the latest found with price: 1.000 2020-08-26 14:08:53,975 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [5] milliseconds 2020-08-26 14:08:53,978 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:53,990 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [1] milliseconds 2020-08-26 14:08:53,995 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [3] milliseconds 2020-08-26 14:08:54,005 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [1] milliseconds 2020-08-26 14:08:54,007 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:54,716 |jsse-nio-8443-exec-3 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:08:55,450 |jsse-nio-8443-exec-3 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,466 |jsse-nio-8443-exec-3 |ControlServlet |T| [[[ecomseo::main (Domain:https://localhost)] Request Done- total:7.372,since last([ecomseo::main (D...):7.372]] 2020-08-26 14:08:55,466 |jsse-nio-8443-exec-3 |SeoContextFilter |W| [Filtered request]: /ecomseo 2020-08-26 14:08:55,954 |jsse-nio-8443-exec-9 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=MiniSignUpForContactList 2020-08-26 14:08:55,954 |jsse-nio-8443-exec-7 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary 2020-08-26 14:08:55,954 |jsse-nio-8443-exec-6 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-1 2020-08-26 14:08:55,954 |jsse-nio-8443-exec-2 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductCategories 2020-08-26 14:08:55,954 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,954 |jsse-nio-8443-exec-7 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,954 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,954 |jsse-nio-8443-exec-2 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,955 |jsse-nio-8443-exec-9 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,955 |jsse-nio-8443-exec-2 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,955 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,955 |jsse-nio-8443-exec-7 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,955 |jsse-nio-8443-exec-9 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,956 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,956 |jsse-nio-8443-exec-7 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,956 |jsse-nio-8443-exec-2 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,958 |jsse-nio-8443-exec-4 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-3 2020-08-26 14:08:55,958 |jsse-nio-8443-exec-8 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-2 2020-08-26 14:08:55,958 |jsse-nio-8443-exec-8 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,959 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,960 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,961 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,961 |jsse-nio-8443-exec-8 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,962 |jsse-nio-8443-exec-8 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,966 |jsse-nio-8443-exec-9 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,967 |jsse-nio-8443-exec-2 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,968 |jsse-nio-8443-exec-6 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,969 |jsse-nio-8443-exec-8 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,969 |jsse-nio-8443-exec-7 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,971 |jsse-nio-8443-exec-4 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,972 |jsse-nio-8443-exec-6 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,972 |jsse-nio-8443-exec-2 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,972 |jsse-nio-8443-exec-8 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,972 |jsse-nio-8443-exec-7 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,973 |jsse-nio-8443-exec-4 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,973 |jsse-nio-8443-exec-9 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,975 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.021,since last([ecomseo::getJs (...):0.021]] 2020-08-26 14:08:55,980 |jsse-nio-8443-exec-8 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.022,since last([ecomseo::getJs (...):0.022]] 2020-08-26 14:08:55,980 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.021,since last([ecomseo::getJs (...):0.021]] 2020-08-26 14:08:55,981 |jsse-nio-8443-exec-6 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-5 2020-08-26 14:08:55,982 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,982 |jsse-nio-8443-exec-4 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=CategoryDetail 2020-08-26 14:08:55,983 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,983 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,983 |jsse-nio-8443-exec-8 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-6 2020-08-26 14:08:55,983 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,983 |jsse-nio-8443-exec-8 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,984 |jsse-nio-8443-exec-6 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,984 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,984 |jsse-nio-8443-exec-6 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,984 |jsse-nio-8443-exec-8 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,985 |jsse-nio-8443-exec-8 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,985 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.003,since last([ecomseo::getJs (...):0.003]] 2020-08-26 14:08:55,985 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,986 |jsse-nio-8443-exec-4 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,986 |jsse-nio-8443-exec-8 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,986 |jsse-nio-8443-exec-4 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,987 |jsse-nio-8443-exec-6 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-4 2020-08-26 14:08:55,987 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:55,988 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.005,since last([ecomseo::getJs (...):0.005]] 2020-08-26 14:08:55,988 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:55,989 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:55,989 |jsse-nio-8443-exec-6 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:55,989 |jsse-nio-8443-exec-8 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,990 |jsse-nio-8443-exec-6 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:55,991 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.004,since last([ecomseo::getJs (...):0.004]] 2020-08-26 14:08:56,019 |jsse-nio-8443-exec-8 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception: rollback called in Entity Engine SQLProcessor at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:362) [main/:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:190) [main/:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) [main/:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897) [main/:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:538) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:249) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:97) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:75) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:367) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?] at org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:88) [main/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:233) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:328) [main/:?] at org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:66) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 2020-08-26 14:08:56,019 |jsse-nio-8443-exec-7 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception: rollback called in Entity Engine SQLProcessor at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:362) [main/:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:190) [main/:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) [main/:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897) [main/:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:538) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:249) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:97) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:75) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:367) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?] at org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:88) [main/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:233) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:328) [main/:?] at org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:66) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 2020-08-26 14:08:56,023 |jsse-nio-8443-exec-7 |GenericDelegator |E| Failure in create operation for entity [ServerHit]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServerHit][content Id,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.954(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomse o/getJs?name=ProductSummary(java.lang.String)][runningTimeMillis,17(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing t he following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONT ENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key cons traint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)). Rolling back transaction. 2020-08-26 14:08:56,023 |jsse-nio-8443-exec-8 |GenericDelegator |E| Failure in create operation for entity [ServerHit]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServerHit][content Id,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.983(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomse o/getJs?name=ProductSummary-6(java.lang.String)][runningTimeMillis,4(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CON TENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key con straint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)). Rolling back transaction. 2020-08-26 14:08:56,032 |jsse-nio-8443-exec-8 |TransactionUtil |I| Transaction rolled back 2020-08-26 14:08:56,032 |jsse-nio-8443-exec-7 |TransactionUtil |I| Transaction rolled back 2020-08-26 14:08:56,032 |jsse-nio-8443-exec-7 |ServerHitBin |W| Error saving ServerHit: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntit y:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.954(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://l ocalhost:8443/ecomseo/getJs?name=ProductSummary(java.lang.String)][runningTimeMillis,17(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Excepti on while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST _NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)) (Error while inserting: [GenericEntity:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.95 4(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomseo/getJs?name=ProductSummary(java.lang.String)][runningTimeMillis,17(java.la ng.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_ DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VAL UES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVE R_HIT'.))) 2020-08-26 14:08:56,032 |jsse-nio-8443-exec-8 |ServerHitBin |W| Error saving ServerHit: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntit y:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.983(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://l ocalhost:8443/ecomseo/getJs?name=ProductSummary-6(java.lang.String)][runningTimeMillis,4(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Except ion while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOS T_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a uniqu e or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)) (Error while inserting: [GenericEntity:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.9 83(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomseo/getJs?name=ProductSummary-6(java.lang.String)][runningTimeMillis,4(java. lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_STAR T_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) V ALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SER VER_HIT'.))) 2020-08-26 14:08:56,032 |jsse-nio-8443-exec-7 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.078,since last([ecomseo::getJs (...):0.078]] 2020-08-26 14:08:56,033 |jsse-nio-8443-exec-8 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.049,since last([ecomseo::getJs (...):0.049]] 2020-08-26 14:08:56,034 |jsse-nio-8443-exec-7 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-8 2020-08-26 14:08:56,035 |jsse-nio-8443-exec-7 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:56,036 |jsse-nio-8443-exec-7 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:56,036 |jsse-nio-8443-exec-7 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:56,037 |jsse-nio-8443-exec-7 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:56,037 |jsse-nio-8443-exec-7 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:56,043 |jsse-nio-8443-exec-7 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.008,since last([ecomseo::getJs (...):0.008]] 2020-08-26 14:08:56,043 |jsse-nio-8443-exec-9 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception: rollback called in Entity Engine SQLProcessor at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:362) [main/:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:190) [main/:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) [main/:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897) [main/:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:538) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:249) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:97) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:75) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:367) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?] at org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:88) [main/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:233) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:328) [main/:?] at org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:66) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 2020-08-26 14:08:56,043 |jsse-nio-8443-exec-9 |GenericDelegator |E| Failure in create operation for entity [ServerHit]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServerHit][content Id,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.954(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomse o/getJs?name=MiniSignUpForContactList(java.lang.String)][runningTimeMillis,15(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while e xecuting the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INT ERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primar y key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)). Rolling back transaction. 2020-08-26 14:08:56,048 |jsse-nio-8443-exec-9 |TransactionUtil |I| Transaction rolled back 2020-08-26 14:08:56,048 |jsse-nio-8443-exec-9 |ServerHitBin |W| Error saving ServerHit: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntit y:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.954(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://l ocalhost:8443/ecomseo/getJs?name=MiniSignUpForContactList(java.lang.String)][runningTimeMillis,15(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (S QL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, S ERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value i n a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)) (Error while inserting: [GenericEntity:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 1 4:08:55.954(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomseo/getJs?name=MiniSignUpForContactList(java.lang.String)][runningT imeMillis,15(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CO NTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_ CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL20082614043845 0' defined on 'SERVER_HIT'.))) 2020-08-26 14:08:56,048 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.094,since last([ecomseo::getJs (...):0.094]] 2020-08-26 14:08:56,054 |jsse-nio-8443-exec-9 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-7 2020-08-26 14:08:56,055 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:08:56,056 |jsse-nio-8443-exec-9 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:08:56,057 |jsse-nio-8443-exec-9 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:08:56,057 |jsse-nio-8443-exec-9 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:08:56,058 |jsse-nio-8443-exec-9 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:08:56,061 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.006,since last([ecomseo::getJs (...):0.006]] 2020-08-26 14:08:56,061 |jsse-nio-8443-exec-2 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception: rollback called in Entity Engine SQLProcessor at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:362) [main/:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:190) [main/:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) [main/:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897) [main/:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:538) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:249) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:97) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:75) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:367) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?] at org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:88) [main/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:233) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:328) [main/:?] at org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:66) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 2020-08-26 14:08:56,063 |jsse-nio-8443-exec-2 |GenericDelegator |E| Failure in create operation for entity [ServerHit]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServerHit][content Id,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.954(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomse o/getJs?name=ProductCategories(java.lang.String)][runningTimeMillis,17(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executin g the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_C ONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key c onstraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)). Rolling back transaction. 2020-08-26 14:08:56,071 |jsse-nio-8443-exec-2 |TransactionUtil |I| Transaction rolled back 2020-08-26 14:08:56,071 |jsse-nio-8443-exec-2 |ServerHitBin |W| Error saving ServerHit: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntit y:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55.954(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://l ocalhost:8443/ecomseo/getJs?name=ProductCategories(java.lang.String)][runningTimeMillis,17(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exce ption while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_H OST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a uni que or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)) (Error while inserting: [GenericEntity:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:08:55 .954(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomseo/getJs?name=ProductCategories(java.lang.String)][runningTimeMillis,17(j ava.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_ START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_I D) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.))) 2020-08-26 14:08:56,071 |jsse-nio-8443-exec-2 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.117,since last([ecomseo::getJs (...):0.117]] 2020-08-26 14:10:26,689 |jsse-nio-8443-exec-5 |SeoContextFilter |I| Can NOT forward this url: /ecomseo 2020-08-26 14:10:26,713 |jsse-nio-8443-exec-5 |ConfigXMLReader |I| controller loaded: 0.003s, 289 requests, 96 views in file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/webapp/ecommerce/WEB-INF/controller.xml 2020-08-26 14:10:26,713 |jsse-nio-8443-exec-5 |ConfigXMLReader |I| controller loaded: 0.015s, 0 requests, 0 views in file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/webapp/ecomseo/WEB-INF/controller.xml 2020-08-26 14:10:26,713 |jsse-nio-8443-exec-5 |ControlServlet |T| [[[ecomseo::main (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:26,714 |jsse-nio-8443-exec-5 |RequestHandler |I| Rendering View [main]. Hidden sessionId by default. 2020-08-26 14:10:26,716 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getUserPreferenceGroup] finished in [1] milliseconds 2020-08-26 14:10:26,725 |jsse-nio-8443-exec-5 |ScreenFactory |I| Got 17 screens in 0.006s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/CommonScreens.xml 2020-08-26 14:10:27,181 |jsse-nio-8443-exec-5 |ScreenFactory |I| Got 9 screens in 0.009s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/CartScreens.xml 2020-08-26 14:10:27,197 |jsse-nio-8443-exec-5 |ScreenFactory |I| Got 38 screens in 0.006s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/CatalogScreens.xml 2020-08-26 14:10:27,745 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:27,765 |jsse-nio-8443-exec-5 |ScreenFactory |I| Got 7 screens in 0.005s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/EmailContactListScreens.xml 2020-08-26 14:10:27,966 |jsse-nio-8443-exec-5 |ScreenFactory |I| Got 8 screens in 0.004s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/ContentScreens.xml 2020-08-26 14:10:27,967 |jsse-nio-8443-exec-5 |ProductStoreWorker |I| getSurvey for product null 2020-08-26 14:10:27,985 |jsse-nio-8443-exec-5 |ScreenFactory |I| Got 6 screens in 0.006s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/ForumScreens.xml 2020-08-26 14:10:28,004 |jsse-nio-8443-exec-5 |ScreenFactory |I| Got 15 screens in 0.007s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/ecommerce/widget/blog/BlogScreens.xml 2020-08-26 14:10:28,413 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getProductCategoryAndLimitedMembers] finished in [1] milliseconds 2020-08-26 14:10:28,778 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [22] milliseconds 2020-08-26 14:10:28,780 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,790 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,792 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,795 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,807 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [2] milliseconds 2020-08-26 14:10:28,809 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,818 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [2] milliseconds 2020-08-26 14:10:28,819 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,829 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [1] milliseconds 2020-08-26 14:10:28,831 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,853 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [2] milliseconds 2020-08-26 14:10:28,855 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,868 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [1] milliseconds 2020-08-26 14:10:28,870 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,871 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,873 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,874 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,876 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,877 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,879 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,880 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,882 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,887 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [2] milliseconds 2020-08-26 14:10:28,895 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [1] milliseconds 2020-08-26 14:10:28,896 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,897 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,900 |jsse-nio-8443-exec-5 |PriceServices |I| There is more than one DEFAULT_PRICE with the currencyUomId USD and productId PEPPERS-G, using the latest found with price: 1.000 2020-08-26 14:10:28,901 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,902 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,910 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/getInventoryAvailableByFacility] finished in [1] milliseconds 2020-08-26 14:10:28,911 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:28,921 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:29,150 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [ecommerce/calculateProductPrice] finished in [1] milliseconds 2020-08-26 14:10:29,562 |jsse-nio-8443-exec-5 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:29,563 |jsse-nio-8443-exec-5 |ControlServlet |T| [[[ecomseo::main (Domain:https://localhost)] Request Done- total:2.85,since last([ecomseo::main (D...):2.85]] 2020-08-26 14:10:29,563 |jsse-nio-8443-exec-5 |SeoContextFilter |W| [Filtered request]: /ecomseo 2020-08-26 14:10:30,292 |jsse-nio-8443-exec-9 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-1 2020-08-26 14:10:30,292 |jsse-nio-8443-exec-3 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary 2020-08-26 14:10:30,292 |jsse-nio-8443-exec-6 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-2 2020-08-26 14:10:30,292 |jsse-nio-8443-exec-8 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=MiniSignUpForContactList 2020-08-26 14:10:30,292 |jsse-nio-8443-exec-3 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,292 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,292 |jsse-nio-8443-exec-8 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,293 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,293 |jsse-nio-8443-exec-4 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-4 2020-08-26 14:10:30,294 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,294 |jsse-nio-8443-exec-2 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-3 2020-08-26 14:10:30,294 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,294 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,295 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,295 |jsse-nio-8443-exec-6 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,295 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,295 |jsse-nio-8443-exec-4 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,295 |jsse-nio-8443-exec-6 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,296 |jsse-nio-8443-exec-4 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,296 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.002,since last([ecomseo::getJs (...):0.002]] 2020-08-26 14:10:30,296 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.004,since last([ecomseo::getJs (...):0.004]] 2020-08-26 14:10:30,297 |jsse-nio-8443-exec-2 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,297 |jsse-nio-8443-exec-4 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-6 2020-08-26 14:10:30,297 |jsse-nio-8443-exec-6 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-5 2020-08-26 14:10:30,297 |jsse-nio-8443-exec-2 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,297 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,297 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,298 |jsse-nio-8443-exec-2 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,298 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,298 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,298 |jsse-nio-8443-exec-2 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,298 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,298 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,298 |jsse-nio-8443-exec-4 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,298 |jsse-nio-8443-exec-6 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,299 |jsse-nio-8443-exec-6 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,299 |jsse-nio-8443-exec-4 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,299 |jsse-nio-8443-exec-2 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,300 |jsse-nio-8443-exec-3 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,300 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.003,since last([ecomseo::getJs (...):0.003]] 2020-08-26 14:10:30,300 |jsse-nio-8443-exec-9 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,300 |jsse-nio-8443-exec-9 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,301 |jsse-nio-8443-exec-9 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,301 |jsse-nio-8443-exec-4 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-7 2020-08-26 14:10:30,301 |jsse-nio-8443-exec-9 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,301 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,302 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,302 |jsse-nio-8443-exec-4 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,302 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.009,since last([ecomseo::getJs (...):0.009]] 2020-08-26 14:10:30,302 |jsse-nio-8443-exec-4 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,303 |jsse-nio-8443-exec-4 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,304 |jsse-nio-8443-exec-4 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.003,since last([ecomseo::getJs (...):0.003]] 2020-08-26 14:10:30,300 |jsse-nio-8443-exec-8 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,305 |jsse-nio-8443-exec-8 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,305 |jsse-nio-8443-exec-8 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,306 |jsse-nio-8443-exec-8 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,308 |jsse-nio-8443-exec-9 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=CategoryDetail 2020-08-26 14:10:30,308 |jsse-nio-8443-exec-3 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,308 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,309 |jsse-nio-8443-exec-3 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,309 |jsse-nio-8443-exec-9 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,309 |jsse-nio-8443-exec-9 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,309 |jsse-nio-8443-exec-3 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,309 |jsse-nio-8443-exec-9 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,313 |jsse-nio-8443-exec-9 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,314 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.006,since last([ecomseo::getJs (...):0.006]] 2020-08-26 14:10:30,319 |jsse-nio-8443-exec-8 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception: rollback called in Entity Engine SQLProcessor at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:362) [main/:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:190) [main/:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) [main/:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897) [main/:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:538) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:249) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:97) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:75) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:367) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?] at org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:88) [main/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:233) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:328) [main/:?] at org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:66) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 2020-08-26 14:10:30,320 |jsse-nio-8443-exec-8 |GenericDelegator |E| Failure in create operation for entity [ServerHit]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServerHit][content Id,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.292(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomse o/getJs?name=MiniSignUpForContactList(java.lang.String)][runningTimeMillis,13(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while e xecuting the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INT ERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primar y key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)). Rolling back transaction. 2020-08-26 14:10:30,319 |jsse-nio-8443-exec-2 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception: rollback called in Entity Engine SQLProcessor at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:362) [main/:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:190) [main/:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) [main/:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897) [main/:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:538) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:249) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:97) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:75) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:367) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?] at org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:88) [main/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:233) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:328) [main/:?] at org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:66) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 2020-08-26 14:10:30,320 |jsse-nio-8443-exec-2 |GenericDelegator |E| Failure in create operation for entity [ServerHit]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServerHit][content Id,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.297(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomse o/getJs?name=ProductSummary-3(java.lang.String)][runningTimeMillis,1(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CON TENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key con straint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)). Rolling back transaction. 2020-08-26 14:10:30,326 |jsse-nio-8443-exec-2 |TransactionUtil |I| Transaction rolled back 2020-08-26 14:10:30,326 |jsse-nio-8443-exec-8 |TransactionUtil |I| Transaction rolled back 2020-08-26 14:10:30,326 |jsse-nio-8443-exec-2 |ServerHitBin |W| Error saving ServerHit: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntit y:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.297(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://l ocalhost:8443/ecomseo/getJs?name=ProductSummary-3(java.lang.String)][runningTimeMillis,1(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Except ion while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOS T_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a uniqu e or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)) (Error while inserting: [GenericEntity:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.2 97(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomseo/getJs?name=ProductSummary-3(java.lang.String)][runningTimeMillis,1(java. lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_STAR T_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) V ALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SER VER_HIT'.))) 2020-08-26 14:10:30,326 |jsse-nio-8443-exec-2 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.029,since last([ecomseo::getJs (...):0.029]] 2020-08-26 14:10:30,326 |jsse-nio-8443-exec-8 |ServerHitBin |W| Error saving ServerHit: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntit y:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.292(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://l ocalhost:8443/ecomseo/getJs?name=MiniSignUpForContactList(java.lang.String)][runningTimeMillis,13(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (S QL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, S ERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value i n a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)) (Error while inserting: [GenericEntity:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 1 4:10:30.292(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomseo/getJs?name=MiniSignUpForContactList(java.lang.String)][runningT imeMillis,13(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CO NTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_ CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL20082614043845 0' defined on 'SERVER_HIT'.))) 2020-08-26 14:10:30,326 |jsse-nio-8443-exec-8 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.034,since last([ecomseo::getJs (...):0.034]] 2020-08-26 14:10:30,327 |jsse-nio-8443-exec-2 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductCategories 2020-08-26 14:10:30,327 |jsse-nio-8443-exec-2 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,328 |jsse-nio-8443-exec-2 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,328 |jsse-nio-8443-exec-2 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,329 |jsse-nio-8443-exec-2 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,329 |jsse-nio-8443-exec-2 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,331 |jsse-nio-8443-exec-2 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.004,since last([ecomseo::getJs (...):0.004]] 2020-08-26 14:10:30,343 |jsse-nio-8443-exec-3 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception: rollback called in Entity Engine SQLProcessor at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:362) [main/:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:190) [main/:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) [main/:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897) [main/:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:538) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:249) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:97) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:75) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:367) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?] at org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:88) [main/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:233) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:328) [main/:?] at org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:66) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 2020-08-26 14:10:30,343 |jsse-nio-8443-exec-6 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception: rollback called in Entity Engine SQLProcessor at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:362) [main/:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:190) [main/:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) [main/:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897) [main/:?] at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:538) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:249) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:97) [main/:?] at org.apache.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:75) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:367) [main/:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?] at org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:88) [main/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:233) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:328) [main/:?] at org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:66) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 2020-08-26 14:10:30,344 |jsse-nio-8443-exec-3 |GenericDelegator |E| Failure in create operation for entity [ServerHit]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServerHit][content Id,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.292(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomse o/getJs?name=ProductSummary(java.lang.String)][runningTimeMillis,17(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing t he following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONT ENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key cons traint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)). Rolling back transaction. 2020-08-26 14:10:30,344 |jsse-nio-8443-exec-6 |GenericDelegator |E| Failure in create operation for entity [ServerHit]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServerHit][content Id,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.297(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomse o/getJs?name=ProductSummary-5(java.lang.String)][runningTimeMillis,2(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CON TENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key con straint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)). Rolling back transaction. 2020-08-26 14:10:30,351 |jsse-nio-8443-exec-3 |TransactionUtil |I| Transaction rolled back 2020-08-26 14:10:30,351 |jsse-nio-8443-exec-6 |TransactionUtil |I| Transaction rolled back 2020-08-26 14:10:30,351 |jsse-nio-8443-exec-6 |ServerHitBin |W| Error saving ServerHit: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntit y:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.297(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://l ocalhost:8443/ecomseo/getJs?name=ProductSummary-5(java.lang.String)][runningTimeMillis,2(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Except ion while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOS T_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a uniqu e or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)) (Error while inserting: [GenericEntity:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.2 97(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomseo/getJs?name=ProductSummary-5(java.lang.String)][runningTimeMillis,2(java. lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_STAR T_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) V ALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SER VER_HIT'.))) 2020-08-26 14:10:30,351 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.054,since last([ecomseo::getJs (...):0.054]] 2020-08-26 14:10:30,351 |jsse-nio-8443-exec-3 |ServerHitBin |W| Error saving ServerHit: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntit y:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.292(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://l ocalhost:8443/ecomseo/getJs?name=ProductSummary(java.lang.String)][runningTimeMillis,17(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Excepti on while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST _NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVER_HIT'.)) (Error while inserting: [GenericEntity:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-26 14:10:30.29 2(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo(java.lang.String)][requestUrl,https://localhost:8443/ecomseo/getJs?name=ProductSummary(java.lang.String)][runningTimeMillis,17(java.la ng.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_ DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VAL UES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL200826140438450' defined on 'SERVE R_HIT'.))) 2020-08-26 14:10:30,351 |jsse-nio-8443-exec-3 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.059,since last([ecomseo::getJs (...):0.059]] 2020-08-26 14:10:30,352 |jsse-nio-8443-exec-6 |SeoContextFilter |I| Can NOT forward this url: /ecomseo/getJs?name=ProductSummary-8 2020-08-26 14:10:30,352 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2020-08-26 14:10:30,354 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2020-08-26 14:10:30,354 |jsse-nio-8443-exec-6 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=js overrideViewUri=null Hidden sessionId by default. 2020-08-26 14:10:30,354 |jsse-nio-8443-exec-6 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsResponseFromRequest] from [request], result is [success] 2020-08-26 14:10:30,355 |jsse-nio-8443-exec-6 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2020-08-26 14:10:30,356 |jsse-nio-8443-exec-6 |ControlServlet |T| [[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.004,since last([ecomseo::getJs (...):0.004]] {noformat} HTH > multi-block attribute for html-template tag > ------------------------------------------- > > Key: OFBIZ-11686 > URL: https://issues.apache.org/jira/browse/OFBIZ-11686 > Project: OFBiz > Issue Type: Improvement > Components: framework/widget > Affects Versions: Upcoming Branch > Reporter: James Yong > Assignee: James Yong > Priority: Minor > Fix For: Trunk > > Attachments: OFBIZ-11686.patch, OFBIZ-11686.patch, OFBIZ-11686.patch > > > Propose a new <script-template> widget tag that adds an external script after body tag. > The external script will contain the rendered result of the specified template file location. > e.g. > {code:xml} > <html> > <script-template location="component://order/template/quote/test.ftl"/> > {code} > <platform-specific> > will render as: > {code:xml} > </body> > <script src=“/ordermgr/control/getJs?name=test” type="application/javascript"/></script> > </html> > {code} > This will allow inline script from a freemarker file, to be rendered as external script in html. > > Discussion was started at [https://lists.apache.org/thread.html/r7f8db3a8f5de057c5c5ca6c00608e477acfeaf5507a20b72b8daa3a8%40%3Cdev.ofbiz.apache.org%3E] > > *15th May 2020* > While extracting the scripts from html-template to script-template and testing the changes, I found the process to be cumbersome. > So I made a change not to use script-template tag but add a multi-block attribute to html-template tag. > When *multi-block=true*, inline scripts will be extracted automatically from script tag and converted to external script. > So no need to manually extract script from the existing freemarker template. > Coding for script-template tag is removed -- This message was sent by Atlassian Jira (v8.3.4#803005) |
Free forum by Nabble | Edit this page |