[
https://issues.apache.org/jira/browse/OFBIZ-13129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17871060#comment-17871060
]
sameeralwosaby commented on OFBIZ-13129:
----------------------------------------
Now Working,
I really appreciate your support. Thank you for all.
> Apache ofbiz 14/15 with PostgreSQL 13 db on docker
> --------------------------------------------------
>
> Key: OFBIZ-13129
> URL: https://issues.apache.org/jira/browse/OFBIZ-13129
> Project: OFBiz
> Issue Type: Bug
> Components: Docker
> Affects Versions: 18.12.14, 18.12.15
> Reporter: sameeralwosaby
> Priority: Major
>
> Hi All,
> This below issues coming when try install apache ofbiz 18.12.14/15 with
> PostgreSQL 13 db on docker ,but when we try with old versions like 8.12.10 or
> with 22.01. it's working properly.
> please any solution
> *------------------------------------------------------*
> > Task :compileJava UP-TO-DATE
> > Task :compileGroovy UP-TO-DATE
> > Task :processResources
> > Task :classes
> > Task :jar
> > Task :startScripts
> > Task :distTar
> > Task :distZip
> > Task :assemble
> > Task :checkstyleMain
> Checkstyle rule violations were found. See the report at:
> file:///ofbiz/build/reports/checkstyle/main.html
> Checkstyle files with violations: 1043
> Checkstyle violations by severity: [error:38219]
> > Task :compileTestJava UP-TO-DATE
> > Task :compileTestGroovy
> > Task :processTestResources NO-SOURCE
> > Task :testClasses
> > Task :checkstyleTest
> Checkstyle rule violations were found. See the report at:
> file:///ofbiz/build/reports/checkstyle/test.html
> Checkstyle files with violations: 6
> Checkstyle violations by severity: [error:34]
> > Task :test
> > Task :check
> > Task :build
> > Task :ofbiz --load-data readers=seed,seed-initial
> Config.java using configuration file load-data.properties
> Set OFBIZ_HOME to - /ofbiz
> Admin socket not configured; set to port 0
> Shutdown hook disabled
> 2024-08-05 07:25:31,619 |main |ContainerLoader
> |I| [Startup] Loading containers...
> 2024-08-05 07:25:31,913 |main |ContainerLoader
> |I| Loading container: component-container
> 2024-08-05 07:25:31,936 |main |ComponentContainer
> |I| Auto-Loading component directory : [/ofbiz/framework]
> 2024-08-05 07:25:31,993 |main |ComponentContainer
> |I| Added class path for component : [base]
> 2024-08-05 07:25:32,027 |main |ComponentContainer
> |I| Added class path for component : [entity]
> 2024-08-05 07:25:32,059 |main |ComponentContainer
> |I| Added class path for component : [security]
> 2024-08-05 07:25:32,092 |main |ComponentContainer
> |I| Added class path for component : [datafile]
> 2024-08-05 07:25:32,122 |main |ComponentContainer
> |I| Added class path for component : [minilang]
> 2024-08-05 07:25:32,171 |main |ComponentContainer
> |I| Added class path for component : [common]
> 2024-08-05 07:25:32,238 |main |ComponentContainer
> |I| Added class path for component : [service]
> 2024-08-05 07:25:32,276 |main |ComponentContainer
> |I| Added class path for component : [catalina]
> 2024-08-05 07:25:32,334 |main |ComponentContainer
> |I| Added class path for component : [entityext]
> 2024-08-05 07:25:32,366 |main |ComponentContainer
> |I| Added class path for component : [webapp]
> 2024-08-05 07:25:32,390 |main |ComponentContainer
> |I| Added class path for component : [widget]
> 2024-08-05 07:25:32,410 |main |ComponentContainer
> |I| Added class path for component : [testtools]
> 2024-08-05 07:25:32,432 |main |ComponentContainer
> |I| Added class path for component : [webtools]
> 2024-08-05 07:25:32,432 |main |ComponentContainer
> |I| Auto-Loading component directory : [/ofbiz/themes]
> 2024-08-05 07:25:32,536 |main |ComponentContainer
> |I| Added class path for component : [bluelight]
> 2024-08-05 07:25:32,536 |main |ComponentContainer
> |I| Added class path for component : [common-theme]
> 2024-08-05 07:25:32,536 |main |ComponentContainer
> |I| Added class path for component : [flatgrey]
> 2024-08-05 07:25:32,536 |main |ComponentContainer
> |I| Added class path for component : [rainbowstone]
> 2024-08-05 07:25:32,536 |main |ComponentContainer
> |I| Added class path for component : [tomahawk]
> 2024-08-05 07:25:32,536 |main |ComponentContainer
> |I| Auto-Loading component directory : [/ofbiz/applications]
> 2024-08-05 07:25:32,565 |main |ComponentContainer
> |I| Added class path for component : [datamodel]
> 2024-08-05 07:25:32,584 |main |ComponentContainer
> |I| Added class path for component : [party]
> 2024-08-05 07:25:32,603 |main |ComponentContainer
> |I| Added class path for component : [securityext]
> 2024-08-05 07:25:32,622 |main |ComponentContainer
> |I| Added class path for component : [content]
> 2024-08-05 07:25:32,642 |main |ComponentContainer
> |I| Added class path for component : [workeffort]
> 2024-08-05 07:25:32,668 |main |ComponentContainer
> |I| Added class path for component : [product]
> 2024-08-05 07:25:32,687 |main |ComponentContainer
> |I| Added class path for component : [manufacturing]
> 2024-08-05 07:25:32,707 |main |ComponentContainer
> |I| Added class path for component : [accounting]
> 2024-08-05 07:25:32,731 |main |ComponentContainer
> |I| Added class path for component : [humanres]
> 2024-08-05 07:25:32,750 |main |ComponentContainer
> |I| Added class path for component : [order]
> 2024-08-05 07:25:32,769 |main |ComponentContainer
> |I| Added class path for component : [marketing]
> 2024-08-05 07:25:32,788 |main |ComponentContainer
> |I| Added class path for component : [commonext]
> 2024-08-05 07:25:32,788 |main |ComponentContainer
> |I| Auto-Loading component directory : [/ofbiz/plugins]
> 2024-08-05 07:25:33,155 |main |ComponentContainer
> |I| Added class path for component : [AlmusbahEmail]
> 2024-08-05 07:25:33,155 |main |ComponentContainer
> |I| Added class path for component : [assetmaint]
> 2024-08-05 07:25:33,156 |main |ComponentContainer
> |I| Added class path for component : [bi]
> 2024-08-05 07:25:33,156 |main |ComponentContainer
> |I| Not loading component [birt] because it's disabled
> 2024-08-05 07:25:33,156 |main |ComponentContainer
> |I| Added class path for component : [cmssite]
> 2024-08-05 07:25:33,156 |main |ComponentContainer
> |I| Added class path for component : [ebay]
> 2024-08-05 07:25:33,156 |main |ComponentContainer
> |I| Not loading component [ebaystore] because it's disabled
> 2024-08-05 07:25:33,156 |main |ComponentContainer
> |I| Added class path for component : [ecommerce]
> 2024-08-05 07:25:33,157 |main |ComponentContainer
> |I| Added class path for component : [example]
> 2024-08-05 07:25:33,157 |main |ComponentContainer
> |I| Added class path for component : [exampleext]
> 2024-08-05 07:25:33,157 |main |ComponentContainer
> |I| Added class path for component : [ldap]
> 2024-08-05 07:25:33,157 |main |ComponentContainer
> |I| Added class path for component : [lucene]
> 2024-08-05 07:25:33,157 |main |ComponentContainer
> |I| Added class path for component : [multiflex]
> 2024-08-05 07:25:33,157 |main |ComponentContainer
> |I| Added class path for component : [myportal]
> 2024-08-05 07:25:33,158 |main |ComponentContainer
> |I| Added class path for component : [passport]
> 2024-08-05 07:25:33,158 |main |ComponentContainer
> |I| Added class path for component : [pricat]
> 2024-08-05 07:25:33,158 |main |ComponentContainer
> |I| Added class path for component : [projectmgr]
> 2024-08-05 07:25:33,158 |main |ComponentContainer
> |I| Added class path for component : [scrum]
> 2024-08-05 07:25:33,159 |main |ComponentContainer
> |I| Added class path for component : [solr]
> 2024-08-05 07:25:33,159 |main |ComponentContainer
> |I| Added class path for component : [webpos]
> 2024-08-05 07:25:33,162 |main |ComponentContainer
> |I| All components loaded
> 2024-08-05 07:25:33,162 |main |ContainerLoader
> |I| Loaded container: component-container
> 2024-08-05 07:25:33,162 |main |ContainerLoader
> |I| [Startup] Loading component containers...
> 2024-08-05 07:25:33,163 |main |ContainerLoader
> |I| Loading container: service-container
> 2024-08-05 07:25:33,170 |main |ContainerLoader
> |I| Loaded container: service-container
> 2024-08-05 07:25:33,170 |main |ContainerLoader
> |I| Loading container: dataload-container
> 2024-08-05 07:25:33,208 |delegator-startup-1 |DelegatorFactoryImpl
> |I| Creating new delegator [default] (delegator-startup-1)
> 2024-08-05 07:25:34,244 |delegator-startup-1 |ModelViewEntity
> |W| [TestingCryptoRawView]: Conversion for complex-alias needs to be
> implemented for cache and in-memory eval
> stuff to work correctly, will not work for alias: rawEncryptedValue
> 2024-08-05 07:25:34,244 |delegator-startup-1 |ModelViewEntity
> |W| [TestingCryptoRawView]: Conversion for complex-alias needs to be
> implemented for cache and in-memory eval
> stuff to work correctly, will not work for alias: rawSaltedEncryptedValue
> 2024-08-05 07:25:34,346 |delegator-startup-1 |ModelViewEntity
> |W| [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs
> to be i mplemented for cache and in-memory
> eval stuff to work correctly, will not work for alias: quantityOrdered
> 2024-08-05 07:25:34,346 |delegator-startup-1 |ModelViewEntity
> |W| [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs
> to be i mplemented for cache and in-memory
> eval stuff to work correctly, will not work for alias: quantityOpen
> 2024-08-05 07:25:34,347 |delegator-startup-1 |ModelViewEntity
> |W| [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias
> needs to b e implemented for cache and
> in-memory eval stuff to work correctly, will not work for alias:
> quantityOrdered
> 2024-08-05 07:25:34,347 |delegator-startup-1 |ModelViewEntity
> |W| [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias
> needs to b e implemented for cache and
> in-memory eval stuff to work correctly, will not work for alias: quantityOpen
> 2024-08-05 07:25:34,351 |delegator-startup-1 |ModelViewEntity
> |W| [OrderReportSalesGroupByProduct]: Conversion for complex-alias needs to
> be imple mented for cache and in-memory
> eval stuff to work correctly, will not work for alias: quantityOrdered
> 2024-08-05 07:25:34,352 |delegator-startup-1 |ModelViewEntity
> |W| [OrderReportSalesGroupByProduct]: Conversion for complex-alias needs to
> be imple mented for cache and in-memory
> eval stuff to work correctly, will not work for alias: amount
> 2024-08-05 07:25:34,355 |delegator-startup-1 |ModelViewEntity
> |W| [OrderItemAndShipGrpInvResAndItemSum]: Conversion for complex-alias needs
> to be implemented for cache and in-memory
> eval stuff to work correctly, will not work for alias: quantityOrdered
> 2024-08-05 07:25:34,357 |delegator-startup-1 |ModelViewEntity
> |W| [OrderItemAndShipGrpInvResAndItemSum]: Conversion for complex-alias needs
> to be implemented for cache and in-memory
> eval stuff to work correctly, will not work for alias: totQuantityAvailable
> 2024-08-05 07:25:34,360 |delegator-startup-1 |ModelViewEntity
> |W| [ExampleStatusDetail]: Conversion for complex-alias needs to be
> implemented for cache and in-memory eval
> stuff to work correctly, will not work for alias: statusDelay
> 2024-08-05 07:25:34,374 |delegator-startup-1 |ModelViewEntity
> |W| [ProjectPhaseTaskActualRatedHoursView]: Conversion for complex-alias
> needs to be implemented for cache and
> in-memory eval stuff to work correctly, will not work for alias:
> totalRatedHours
> 2024-08-05 07:25:34,505 |delegator-startup-1 |ModelReader
> |I| Finished loading entities; #Entities=868 #ViewEntities=321 #Fields=9147
> #Relatio nships=2976
> #AutoRelationships=2178
> 2024-08-05 07:25:34,546 |delegator-startup-1 |GenericDelegator
> |I| Doing entity definition check...
> 2024-08-05 07:25:34,550 |delegator-startup-1 |ModelEntityChecker
> |I| [initReservedWords] array length = 1025
> 2024-08-05 07:25:34,656 |delegator-startup-1 |GenericDelegator
> |W| =-=-=-=-= Found 3 warnings when checking the entity definitions:
> 2024-08-05 07:25:34,657 |delegator-startup-1 |GenericDelegator
> |W| [RelationFieldTypesDifferent] The field type (id) of email_status_code of
> entity email_status is not the same as
> field type (name) of email_status_code of entity msbhr_almusbah_email for
> relation msbhr_almusbah_email.
> 2024-08-05 07:25:34,657 |delegator-startup-1 |GenericDelegator
> |W| [FieldNameRW] Column name STATUS of entity msbhr_almusbah_email is a
> reserved wo rd.
> 2024-08-05 07:25:34,657 |delegator-startup-1 |GenericDelegator
> |W| [RelationFieldTypesDifferent] The field type (name) of email_status_code
> of enti ty msbhr_almusbah_email is not the
> same as field type (id) of email_status_code of entity email_status for
> relation email_status.
> 2024-08-05 07:25:34,660 |OFBiz-batch-1 |GenericDelegator
> |I| Delegator "default" initializing helper "localderbyolap" for entity group
> "org.a pache.ofbiz.olap".
> 2024-08-05 07:25:34,664 |OFBiz-batch-1 |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with addMissing=true
> 2024-08-05 07:25:34,668 |OFBiz-batch-2 |GenericDelegator
> |I| Delegator "default" initializing helper "localpostgres" for entity group
> "org.ap ache.ofbiz".
> 2024-08-05 07:25:34,668 |OFBiz-batch-3 |GenericDelegator
> |I| Delegator "default" initializing helper "localderbytenant" for entity
> group "org .apache.ofbiz.tenant".
> 2024-08-05 07:25:34,686 |OFBiz-batch-3 |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with addMissing=true
> 2024-08-05 07:25:34,693 |OFBiz-batch-2 |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with addMissing=true
> 2024-08-05 07:25:35,151 |OFBiz-batch-2 |DatabaseUtil
> |E| Unable to establish a connection with the database for helperName
> [localpostgres ]... Error was:
> java.sql.SQLException: Unable to acquire a new connection from the pool
> 2024-08-05 07:25:35,151 |OFBiz-batch-2 |DatabaseUtil
> |E| Unable to establish a connection with the database, no additional
> information av ailable.
> 2024-08-05 07:25:35,151 |OFBiz-batch-2 |DatabaseUtil
> |E| Could not get table name information from the database, aborting.
> 2024-08-05 07:25:36,213 |OFBiz-batch-3 |DatabaseUtil
> |I| Database Product Name is Apache Derby
> 2024-08-05 07:25:36,213 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Product Name is Apache Derby
> 2024-08-05 07:25:36,213 |OFBiz-batch-3 |DatabaseUtil
> |I| Database Product Version is 10.14.2.0 - (1828579)
> 2024-08-05 07:25:36,213 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Product Version is 10.14.2.0 - (1828579)
> 2024-08-05 07:25:36,213 |OFBiz-batch-3 |DatabaseUtil
> |I| Database Driver Name is Apache Derby Embedded JDBC Driver
> 2024-08-05 07:25:36,213 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Driver Name is Apache Derby Embedded JDBC Driver
> 2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil
> |I| Database Driver Version is 10.14.2.0 - (1828579)
> 2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil
> |I| Database Driver JDBC Version is 4.2
> 2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil
> |I| Database Setting/Support Information (those with a * should be true):
> 2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil
> |I| - supports transactions [true]*
> 2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil
> |I| - isolation None [false]
> 2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil
> |I| - isolation ReadCommitted [true]
> 2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil
> |I| - isolation ReadUncommitted [true]
> 2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil
> |I| - isolation RepeatableRead [true]
> 2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil
> |I| - isolation Serializable [true]
> 2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil
> |I| - forward only type [true]
> 2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil
> |I| - scroll sensitive type [false]
> 2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil
> |I| - scroll insensitive type [true]
> 2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil
> |I| - is case sensitive [false]
> 2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil
> |I| - stores LowerCase [false]
> 2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil
> |I| - stores MixedCase [false]
> 2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil
> |I| - stores UpperCase [true]
> 2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil
> |I| - max table name length [128]
> 2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil
> |I| - max column name length [128]
> 2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil
> |I| - concurrent connections [0]
> 2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil
> |I| - concurrent statements [0]
> 2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil
> |I| - ANSI SQL92 Entry [true]
> 2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil
> |I| - ANSI SQL92 Intermediate [false]
> 2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil
> |I| - ANSI SQL92 Full [false]
> 2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil
> |I| - ODBC SQL Grammar Core [false]
> 2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil
> |I| - ODBC SQL Grammar Extended [false]
> 2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum [true]
> 2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil
> |I| - outer joins [true]*
> 2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil
> |I| - limited outer joins [true]
> 2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil
> |I| - full outer joins [false]
> 2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil
> |I| - group by [true]*
> 2024-08-05 07:25:36,218 |OFBiz-batch-3 |DatabaseUtil
> |I| - group by not in select [true]
> 2024-08-05 07:25:36,214 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Driver Version is 10.14.2.0 - (1828579)
> 2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Driver JDBC Version is 4.2
> 2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Setting/Support Information (those with a * should be true):
> 2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil
> |I| - supports transactions [true]*
> 2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation None [false]
> 2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation ReadCommitted [true]
> 2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation ReadUncommitted [true]
> 2024-08-05 07:25:36,224 |OFBiz-batch-3 |DatabaseUtil
> |I| - column aliasing [true]
> 2024-08-05 07:25:36,224 |OFBiz-batch-3 |DatabaseUtil
> |I| - order by not in select [false]
> 2024-08-05 07:25:36,224 |OFBiz-batch-3 |DatabaseUtil
> |I| - alter table add column [true]*
> 2024-08-05 07:25:36,225 |OFBiz-batch-3 |DatabaseUtil
> |I| - non-nullable column [true]*
> 2024-08-05 07:25:36,226 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation RepeatableRead [true]
> 2024-08-05 07:25:36,226 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation Serializable [true]
> 2024-08-05 07:25:36,227 |OFBiz-batch-1 |DatabaseUtil
> |I| - forward only type [true]
> 2024-08-05 07:25:36,227 |OFBiz-batch-1 |DatabaseUtil
> |I| - scroll sensitive type [false]
> 2024-08-05 07:25:36,227 |OFBiz-batch-3 |DatabaseUtil
> |I| - default fetchsize [1]
> 2024-08-05 07:25:36,228 |OFBiz-batch-3 |DatabaseUtil
> |I| - named parameters [ SKIPPED ]
> 2024-08-05 07:25:36,228 |OFBiz-batch-3 |DatabaseUtil
> |I| Getting Table Info From Database
> 2024-08-05 07:25:36,229 |OFBiz-batch-1 |DatabaseUtil
> |I| - scroll insensitive type [true]
> 2024-08-05 07:25:36,229 |OFBiz-batch-1 |DatabaseUtil
> |I| - is case sensitive [false]
> 2024-08-05 07:25:36,230 |OFBiz-batch-1 |DatabaseUtil
> |I| - stores LowerCase [false]
> 2024-08-05 07:25:36,230 |OFBiz-batch-1 |DatabaseUtil
> |I| - stores MixedCase [false]
> 2024-08-05 07:25:36,230 |OFBiz-batch-1 |DatabaseUtil
> |I| - stores UpperCase [true]
> 2024-08-05 07:25:36,231 |OFBiz-batch-1 |DatabaseUtil
> |I| - max table name length [128]
> 2024-08-05 07:25:36,240 |OFBiz-batch-1 |DatabaseUtil
> |I| - max column name length [128]
> 2024-08-05 07:25:36,241 |OFBiz-batch-1 |DatabaseUtil
> |I| - concurrent connections [0]
> 2024-08-05 07:25:36,241 |OFBiz-batch-1 |DatabaseUtil
> |I| - concurrent statements [0]
> 2024-08-05 07:25:36,241 |OFBiz-batch-1 |DatabaseUtil
> |I| - ANSI SQL92 Entry [true]
> 2024-08-05 07:25:36,242 |OFBiz-batch-1 |DatabaseUtil
> |I| - ANSI SQL92 Intermediate [false]
> 2024-08-05 07:25:36,244 |OFBiz-batch-1 |DatabaseUtil
> |I| - ANSI SQL92 Full [false]
> 2024-08-05 07:25:36,246 |OFBiz-batch-1 |DatabaseUtil
> |I| - ODBC SQL Grammar Core [false]
> 2024-08-05 07:25:36,264 |OFBiz-batch-1 |DatabaseUtil
> |I| - ODBC SQL Grammar Extended [false]
> 2024-08-05 07:25:36,264 |OFBiz-batch-1 |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum [true]
> 2024-08-05 07:25:36,265 |OFBiz-batch-1 |DatabaseUtil
> |I| - outer joins [true]*
> 2024-08-05 07:25:36,266 |OFBiz-batch-1 |DatabaseUtil
> |I| - limited outer joins [true]
> 2024-08-05 07:25:36,266 |OFBiz-batch-1 |DatabaseUtil
> |I| - full outer joins [false]
> 2024-08-05 07:25:36,267 |OFBiz-batch-1 |DatabaseUtil
> |I| - group by [true]*
> 2024-08-05 07:25:36,267 |OFBiz-batch-1 |DatabaseUtil
> |I| - group by not in select [true]
> 2024-08-05 07:25:36,269 |OFBiz-batch-1 |DatabaseUtil
> |I| - column aliasing [true]
> 2024-08-05 07:25:36,270 |OFBiz-batch-1 |DatabaseUtil
> |I| - order by not in select [false]
> 2024-08-05 07:25:36,270 |OFBiz-batch-1 |DatabaseUtil
> |I| - alter table add column [true]*
> 2024-08-05 07:25:36,271 |OFBiz-batch-1 |DatabaseUtil
> |I| - non-nullable column [true]*
> 2024-08-05 07:25:36,272 |OFBiz-batch-1 |DatabaseUtil
> |I| - default fetchsize [1]
> 2024-08-05 07:25:36,272 |OFBiz-batch-1 |DatabaseUtil
> |I| - named parameters [ SKIPPED ]
> 2024-08-05 07:25:36,273 |OFBiz-batch-1 |DatabaseUtil
> |I| Getting Table Info From Database
> 2024-08-05 07:25:36,664 |OFBiz-batch-3 |DatabaseUtil
> |W| Entity [Component] has no table in the database
> 2024-08-05 07:25:36,664 |OFBiz-batch-1 |DatabaseUtil
> |W| Entity [CurrencyDimension] has no table in the database
> 2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil
> |W| Entity [DateDimension] has no table in the database
> 2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil
> |W| Entity [InventoryItemFact] has no table in the database
> 2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil
> |W| Entity [ProductDimension] has no table in the database
> 2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil
> |W| Entity [SalesInvoiceItemFact] has no table in the database
> 2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil
> |W| Entity [SalesOrderItemFact] has no table in the database
> 2024-08-05 07:25:36,667 |OFBiz-batch-3 |DatabaseUtil
> |W| Entity [Tenant] has no table in the database
> 2024-08-05 07:25:36,667 |OFBiz-batch-3 |DatabaseUtil
> |W| Entity [TenantComponent] has no table in the database
> 2024-08-05 07:25:36,668 |OFBiz-batch-3 |DatabaseUtil
> |W| Entity [TenantDataSource] has no table in the database
> 2024-08-05 07:25:36,668 |OFBiz-batch-3 |DatabaseUtil
> |W| Entity [TenantDomainName] has no table in the database
> 2024-08-05 07:25:36,669 |OFBiz-batch-3 |DatabaseUtil
> |W| Entity [TenantKeyEncryptingKey] has no table in the database
> 2024-08-05 07:25:36,722 |pool-3-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.COMPONENT]
> 2024-08-05 07:25:36,726 |pool-2-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.CURRENCY_DIMENSION]
> 2024-08-05 07:25:36,748 |pool-3-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.TENANT]
> 2024-08-05 07:25:36,766 |pool-2-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.DATE_DIMENSION]
> 2024-08-05 07:25:36,775 |pool-3-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.TENANT_COMPONENT]
> 2024-08-05 07:25:36,795 |pool-2-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.INVENTORY_ITEM_FACT]
> 2024-08-05 07:25:36,800 |pool-3-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.TENANT_DATA_SOURCE]
> 2024-08-05 07:25:36,817 |pool-2-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.PRODUCT_DIMENSION]
> 2024-08-05 07:25:36,819 |pool-3-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.TENANT_DOMAIN_NAME]
> 2024-08-05 07:25:36,838 |pool-3-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.TENANT_KEY_ENCRYPTING_KEY]
> 2024-08-05 07:25:36,846 |pool-2-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.SALES_INVOICE_ITEM_FACT]
> 2024-08-05 07:25:36,879 |pool-3-thread-1 |DatabaseUtil
> |I| Created 2 foreign key indices for entity [TenantComponent]
> 2024-08-05 07:25:36,891 |pool-2-thread-1 |DatabaseUtil
> |I| Created table [OFBIZ.SALES_ORDER_ITEM_FACT]
> 2024-08-05 07:25:36,898 |pool-3-thread-1 |DatabaseUtil
> |I| Created 1 foreign key indices for entity [TenantDataSource]
> 2024-08-05 07:25:36,912 |pool-3-thread-1 |DatabaseUtil
> |I| Created 1 foreign key indices for entity [TenantDomainName]
> 2024-08-05 07:25:36,925 |pool-3-thread-1 |DatabaseUtil
> |I| Created 1 foreign key indices for entity [TenantKeyEncryptingKey]
> 2024-08-05 07:25:36,925 |OFBiz-batch-3 |DatabaseUtil
> |I| ==== TOTAL Foreign Key Indices Created: 5
> 2024-08-05 07:25:36,955 |pool-2-thread-1 |DatabaseUtil
> |I| Created 3 foreign key indices for entity [InventoryItemFact]
> 2024-08-05 07:25:36,961 |OFBiz-batch-3 |DatabaseUtil
> |I| Created 2 foreign keys for entity [TenantComponent]
> 2024-08-05 07:25:36,968 |OFBiz-batch-3 |DatabaseUtil
> |I| Created 1 foreign keys for entity [TenantDataSource]
> 2024-08-05 07:25:36,984 |OFBiz-batch-3 |DatabaseUtil
> |I| Created 1 foreign keys for entity [TenantDomainName]
> 2024-08-05 07:25:36,992 |OFBiz-batch-3 |DatabaseUtil
> |I| Created 1 foreign keys for entity [TenantKeyEncryptingKey]
> 2024-08-05 07:25:36,993 |OFBiz-batch-3 |DatabaseUtil
> |I| ==== TOTAL Foreign Keys Created: 5
> 2024-08-05 07:25:37,013 |pool-2-thread-1 |DatabaseUtil
> |I| Created 3 foreign key indices for entity [SalesInvoiceItemFact]
> 2024-08-05 07:25:37,021 |pool-3-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [Component]
> 2024-08-05 07:25:37,049 |pool-3-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [Tenant]
> 2024-08-05 07:25:37,064 |pool-2-thread-1 |DatabaseUtil
> |I| Created 3 foreign key indices for entity [SalesOrderItemFact]
> 2024-08-05 07:25:37,065 |OFBiz-batch-1 |DatabaseUtil
> |I| ==== TOTAL Foreign Key Indices Created: 9
> 2024-08-05 07:25:37,077 |pool-3-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [TenantComponent]
> 2024-08-05 07:25:37,093 |OFBiz-batch-1 |DatabaseUtil
> |I| Created 3 foreign keys for entity [InventoryItemFact]
> 2024-08-05 07:25:37,117 |pool-3-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [TenantDataSource]
> 2024-08-05 07:25:37,140 |OFBiz-batch-1 |DatabaseUtil
> |I| Created 3 foreign keys for entity [SalesInvoiceItemFact]
> 2024-08-05 07:25:37,142 |pool-3-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [TenantDomainName]
> 2024-08-05 07:25:37,166 |pool-3-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [TenantKeyEncryptingKey]
> 2024-08-05 07:25:37,167 |OFBiz-batch-3 |DatabaseUtil
> |I| ==== TOTAL Declared Indices Created: 12
> 2024-08-05 07:25:37,167 |OFBiz-batch-1 |DatabaseUtil
> |I| Created 3 foreign keys for entity [SalesOrderItemFact]
> 2024-08-05 07:25:37,167 |OFBiz-batch-1 |DatabaseUtil
> |I| ==== TOTAL Foreign Keys Created: 9
> 2024-08-05 07:25:37,192 |pool-2-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [CurrencyDimension]
> 2024-08-05 07:25:37,217 |pool-2-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [DateDimension]
> 2024-08-05 07:25:37,242 |pool-2-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [InventoryItemFact]
> 2024-08-05 07:25:37,275 |pool-2-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [ProductDimension]
> 2024-08-05 07:25:37,305 |pool-2-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [SalesInvoiceItemFact]
> 2024-08-05 07:25:37,336 |pool-2-thread-1 |DatabaseUtil
> |I| Created 2 declared indices for entity [SalesOrderItemFact]
> 2024-08-05 07:25:37,336 |OFBiz-batch-1 |DatabaseUtil
> |I| ==== TOTAL Declared Indices Created: 12
> 2024-08-05 07:25:37,396 |kJoinPool-1-worker-1 |EntityEcaUtil
> |I| Loaded [11] Entity ECA definitions from
> /ofbiz/applications/content/entitydef/ee
> cas.xml in loader main
> 2024-08-05 07:25:37,400 |OFBiz-batch-3 |ServiceGroupReader
> |I| Loaded [1] Group definitions from
> file:/ofbiz/framework/common/servicedef/groups
> _test.xml
> 2024-08-05 07:25:37,409 |kJoinPool-1-worker-1 |EntityEcaUtil
> |I| Loaded [4] Entity ECA definitions from
> /ofbiz/applications/workeffort/entitydef/
> eecas.xml in loader main
> 2024-08-05 07:25:37,410 |OFBiz-batch-3 |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/ofbiz/framework/entityext/servicedef/gro
> ups.xml
> 2024-08-05 07:25:37,415 |OFBiz-batch-3 |ServiceGroupReader
> |I| Loaded [2] Group definitions from
> file:/ofbiz/applications/workeffort/servicedef
> /service_groups.xml
> 2024-08-05 07:25:37,418 |OFBiz-batch-3 |ServiceGroupReader
> |I| Loaded [1] Group definitions from
> file:/ofbiz/applications/product/servicedef/gr
> oups.xml
> 2024-08-05 07:25:37,419 |kJoinPool-1-worker-1 |EntityEcaUtil
> |I| Loaded [14] Entity ECA definitions from
> /ofbiz/applications/product/entitydef/ee
> cas.xml in loader main
> 2024-08-05 07:25:37,422 |OFBiz-batch-3 |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/ofbiz/applications/accounting/servicedef
> /groups.xml
> 2024-08-05 07:25:37,425 |kJoinPool-1-worker-1 |EntityEcaUtil
> |I| Loaded [2] Entity ECA definitions from
> /ofbiz/applications/accounting/entitydef/
> eecas.xml in loader main
> 2024-08-05 07:25:37,430 |kJoinPool-1-worker-1 |EntityEcaUtil
> |I| Loaded [3] Entity ECA definitions from
> /ofbiz/applications/order/entitydef/eecas
> .xml in loader main
> 2024-08-05 07:25:37,440 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [3] Service ECA Rules from
> file:/ofbiz/framework/common/servicedef/secas_
> test.xml
> 2024-08-05 07:25:37,445 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [0] Service ECA Rules from
> file:/ofbiz/framework/common/servicedef/secas_
> cdyne.xml
> 2024-08-05 07:25:37,453 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [3] Service ECA Rules from
> file:/ofbiz/framework/service/servicedef/secas
> _test_se.xml
> 2024-08-05 07:25:37,461 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [25] Service ECA Rules from
> file:/ofbiz/applications/party/servicedef/sec
> as.xml
> 2024-08-05 07:25:37,466 |kJoinPool-1-worker-1 |EntityEcaUtil
> |I| Loaded [15] Entity ECA definitions from
> /ofbiz/plugins/lucene/entitydef/eecas_pr
> oduct.xml in loader main
> 2024-08-05 07:25:37,472 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [25] Service ECA Rules from
> file:/ofbiz/applications/content/servicedef/s
> ecas.xml
> 2024-08-05 07:25:37,478 |kJoinPool-1-worker-1 |EntityEcaUtil
> |I| Loaded [1] Entity ECA definitions from
> /ofbiz/plugins/projectmgr/entitydef/eecas
> .xml in loader main
> 2024-08-05 07:25:37,484 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [10] Service ECA Rules from
> file:/ofbiz/applications/workeffort/servicede
> f/secas.xml
> 2024-08-05 07:25:37,492 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [26] Service ECA Rules from
> file:/ofbiz/applications/product/servicedef/s
> ecas.xml
> 2024-08-05 07:25:37,498 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [23] Service ECA Rules from
> file:/ofbiz/applications/product/servicedef/s
> ecas_shipment.xml
> 2024-08-05 07:25:37,510 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [4] Service ECA Rules from
> file:/ofbiz/applications/manufacturing/service
> def/secas.xml
> 2024-08-05 07:25:37,527 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [23] Service ECA Rules from
> file:/ofbiz/applications/accounting/servicede
> f/secas.xml
> 2024-08-05 07:25:37,532 |kJoinPool-1-worker-1 |EntityEcaUtil
> |I| Loaded [0] Entity ECA definitions from
> /ofbiz/plugins/solr/entitydef/eecas.xml i
> n loader main
> 2024-08-05 07:25:37,546 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [8] Service ECA Rules from
> file:/ofbiz/applications/accounting/servicedef
> /secas_payment.xml
> 2024-08-05 07:25:37,556 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [22] Service ECA Rules from
> file:/ofbiz/applications/accounting/servicede
> f/secas_ledger.xml
> 2024-08-05 07:25:37,564 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [6] Service ECA Rules from
> file:/ofbiz/applications/accounting/servicedef
> /secas_invoice.xml
> 2024-08-05 07:25:37,575 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [80] Service ECA Rules from
> file:/ofbiz/applications/order/servicedef/sec
> as.xml
> 2024-08-05 07:25:37,602 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [10] Service ECA Rules from
> file:/ofbiz/applications/marketing/servicedef
> /secas.xml
> 2024-08-05 07:25:37,634 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [0] Service ECA Rules from
> file:/ofbiz/applications/commonext/servicedef/
> secas.xml
> 2024-08-05 07:25:37,651 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [5] Service ECA Rules from
> file:/ofbiz/plugins/assetmaint/servicedef/seca
> s.xml
> 2024-08-05 07:25:37,657 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [5] Service ECA Rules from
> file:/ofbiz/plugins/bi/servicedef/secas.xml
> 2024-08-05 07:25:37,665 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [1] Service ECA Rules from
> file:/ofbiz/plugins/ebay/servicedef/secas.xml
> 2024-08-05 07:25:37,671 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [3] Service ECA Rules from
> file:/ofbiz/plugins/example/servicedef/secas.x
> ml
> 2024-08-05 07:25:37,685 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [9] Service ECA Rules from
> file:/ofbiz/plugins/scrum/servicedef/secas.xml
> 2024-08-05 07:25:37,713 |kJoinPool-1-worker-1 |ServiceEcaUtil
> |I| Loaded [0] Service ECA Rules from
> file:/ofbiz/plugins/solr/servicedef/secas.xml
> 2024-08-05 07:25:37,730 |OFBiz-batch-3 |GenericDelegator
> |E| Failure in removeByCondition operation for entity [ServiceSemaphore]:
> org.apache
> .ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred
> in deleteByCondition (Unable to establish a connection with the database.
> (Unable to acquire a new connection from
> the pool)). Rolling back transaction.
> org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> occurred in deleteByCondition (Unable to establish a connection with the
> database. ( Unable to acquire a new
> connection from the pool))
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1125)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1083)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1074)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:105)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:136)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:167)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.getLocalDispatcher(ServiceDispatcher.java:147)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.GenericDispatcherFactory.createLocalDispatcher(GenericDispatcherFactory.java:40)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceContainer.getLocalDispatcher(ServiceContainer.java:92)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entityext.EntityServiceFactory.getLocalDispatcher(EntityServiceFactory.java:34)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entityext.EntityServiceFactory.getDispatchContext(EntityServiceFactory.java:39)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entityext.eca.DelegatorEcaHandler.lambda$setDelegator$0(DelegatorEcaHandler.java:61)
> ~[ofbiz.jar:?]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> ~[?:1.8.0_422]
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> ~[?:1.8.0_422]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> ~[?:1.8.0_422]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> ~[?:1.8.0_422]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> ~[?:1.8.0_422]
> at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_422]
> Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Unable to
> establish a connection with the database. (Unable to acquire a new connection
> from the p ool)
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122)
> ~[ofbiz.jar:?]
> ... 19 more
> Caused by: java.sql.SQLException: Unable to acquire a new connection from the
> pool
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122)
> ~[ofbiz.jar:?]
> ... 19 more
> Caused by: java.util.NoSuchElementException: Unable to activate object
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122)
> ~[ofbiz.jar:?]
> ... 19 more
> Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122)
> ~[ofbiz.jar:?]
> ... 19 more
> 2024-08-05 07:25:37,736 |OFBiz-batch-3 |TransactionUtil
> |I| Transaction rolled back
> 2024-08-05 07:25:37,736 |OFBiz-batch-3 |ServiceDispatcher
> |E| null
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> occurred in deleteByCondition (Unabl e to
> establish a connection with the database. (Unable to acquire a new connection
> from the pool)) (Generic Entity Exception occurred in deleteByCondition
> (Unabl e to establish a connection with
> the database. (Unable to acquire a new connection from the pool)))
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1135)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1083)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1074)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:105)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:136)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:167)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.getLocalDispatcher(ServiceDispatcher.java:147)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.GenericDispatcherFactory.createLocalDispatcher(GenericDispatcherFactory.java:40)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceContainer.getLocalDispatcher(ServiceContainer.java:92)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entityext.EntityServiceFactory.getLocalDispatcher(EntityServiceFactory.java:34)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entityext.EntityServiceFactory.getDispatchContext(EntityServiceFactory.java:39)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entityext.eca.DelegatorEcaHandler.lambda$setDelegator$0(DelegatorEcaHandler.java:61)
> ~[ofbiz.jar:?]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> ~[?:1.8.0_422]
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> ~[?:1.8.0_422]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> ~[?:1.8.0_422]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> ~[?:1.8.0_422]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> ~[?:1.8.0_422]
> at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_422]
> Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity
> Exception occurred in deleteByCondition (Unable to establish a connection
> with the database. (Unable to acquire a
> new connection from the pool))
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1125)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118)
> ~[ofbiz.jar:?]
> ... 17 more
> Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Unable to
> establish a connection with the database. (Unable to acquire a new connection
> from the p ool)
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118)
> ~[ofbiz.jar:?]
> ... 17 more
> Caused by: java.sql.SQLException: Unable to acquire a new connection from the
> pool
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118)
> ~[ofbiz.jar:?]
> ... 17 more
> Caused by: java.util.NoSuchElementException: Unable to activate object
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118)
> ~[ofbiz.jar:?]
> ... 17 more
> Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118)
> ~[ofbiz.jar:?]
> ... 17 more
> 2024-08-05 07:25:37,802 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [126] Services from
> file:/ofbiz/framework/common/servicedef/services.xml
> 2024-08-05 07:25:37,810 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [2] Services from
> file:/ofbiz/framework/common/servicedef/services_cdyne.
> xml
> 2024-08-05 07:25:37,819 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [18] Services from
> file:/ofbiz/framework/common/servicedef/services_email
> .xml
> 2024-08-05 07:25:37,826 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [3] Services from
> file:/ofbiz/framework/common/servicedef/services_enum.x
> ml
> 2024-08-05 07:25:37,833 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [6] Services from
> file:/ofbiz/framework/common/servicedef/services_method
> .xml
> 2024-08-05 07:25:37,841 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [12] Services from
> file:/ofbiz/framework/common/servicedef/services_geo.x
> ml
> 2024-08-05 07:25:37,849 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [1] Services from
> file:/ofbiz/framework/common/servicedef/services_qrcode
> .xml
> 2024-08-05 07:25:37,882 |main |EntityDataLoadContainer
> |I| =-=-=-=-=-=-= Doing a data load using delegator 'default' with the
> following fil es:
> 2024-08-05 07:25:37,887 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,887 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/CommonSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,887 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/CommonSystemPropertyData.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/CommonTypeData.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/CurrencyData.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/CountryCodeData.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_AU.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_BG.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_BR.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_CA.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_CH.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_CN.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_CO.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_DE.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_ES.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_FR.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_IE.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_IL.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_IN.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_IT.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_JP.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_MX.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_MY.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_NL.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_NZ.xml
> 2024-08-05 07:25:37,888 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_PL.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_TH.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_UK.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/GeoData_US.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/LanguageData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/UnitData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/PeriodData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/common/data/CommonPortletData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/service/data/ScheduledServiceData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/service/data/ServiceSeedData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/service/data/ServiceSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/entityext/data/EntityExtTypeData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/webtools/data/WebtoolsSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/themes/bluelight/data/BlueLightThemeData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/themes/common-theme/data/CommonThemeData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/themes/flatgrey/data/FlatGreyThemeData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/themes/rainbowstone/data/RainbowStoneThemeData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/themes/tomahawk/data/TomahawkThemeData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/PartySeedData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/SecurityExtSeedData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/ProductSeedData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/ContentSeedData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/WorkEffortSeedData.xml
> 2024-08-05 07:25:37,889 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/ManufacturingSeedData.xml
> 2024-08-05 07:25:37,890 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/AccountingSeedData.xml
> 2024-08-05 07:25:37,908 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [20] Services from
> file:/ofbiz/framework/common/servicedef/services_secur
> ity.xml
> 2024-08-05 07:25:37,890 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/HumanResSeedData.xml
> 2024-08-05 07:25:37,909 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/OrderSeedData.xml
> 2024-08-05 07:25:37,909 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/MarketingSeedData.xml
> 2024-08-05 07:25:37,912 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/datamodel/data/seed/CommonExtSeedData.xml
> 2024-08-05 07:25:37,915 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/party/data/PartyTypeData.xml
> 2024-08-05 07:25:37,915 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/party/data/PartyGeoPointData.xml
> 2024-08-05 07:25:37,915 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/party/data/PartyPortletData.xml
> 2024-08-05 07:25:37,921 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [27] Services from
> file:/ofbiz/framework/common/servicedef/services_test.
> xml
> 2024-08-05 07:25:37,937 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/content/data/ContentHelpData.xml
> 2024-08-05 07:25:37,937 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/content/data/ContentHttpErrorData.xml
> 2024-08-05 07:25:37,937 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/content/data/ContentPortletData.xml
> 2024-08-05 07:25:37,937 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/content/data/PartyHelpData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/content/data/WebtoolsHelpData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/workeffort/data/WorkEffortTypeData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/workeffort/data/WorkEffortPortletData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/product/data/ProductHelpData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/product/data/ProductSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/product/data/FacilitySecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/product/data/ApiSchemaDhl.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/product/data/ProductPortletData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/product/data/PromoCustomMethodData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/manufacturing/data/ManufacturingSecurityPermissionSeedD
> ata.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/manufacturing/data/ManufacturingHelpData_EN.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/manufacturing/data/ManufacturingHelpData_NL.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/accounting/data/AccountingHelpData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/accounting/data/AccountingSecurityPermissionSeedData.xm
> l
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/accounting/data/AccountingPortletData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/humanres/data/HumanResHelpData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/humanres/data/HumanResSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/humanres/data/HumanResPortletData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/order/data/OrderTypeData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/order/data/OrderPortletData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/order/data/OrderSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/order/data/OrderHelpData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/marketing/data/MarketingSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/marketing/data/MarketingHelpData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/marketing/data/SfaPortletData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/commonext/data/CommonExtSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,938 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/commonext/data/CommonExtHelpData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/commonext/data/SystemInfoPortletData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/commonext/data/SetupData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/commonext/data/OfbizSetupSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/AlmusbahEmail/data/AlmusbahEmailTypeData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/plugins/AlmusbahEmail/data/AlmusbahEmailSecurityPermissionSeedData.x
> ml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/plugins/assetmaint/data/AssetMaintSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/assetmaint/data/AssetMaintSeedData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/bi/data/BiTypeData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/bi/data/BiSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/ebay/data/EbaySecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/ebay/data/EbayTypeData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/ebay/data/EbayHelpData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/ecommerce/data/EcommerceTypeData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/ecommerce/data/EcommerceSecurityData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/ecommerce/data/EcommerceSystemPropertyData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/example/data/ExampleTypeData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/example/data/ExampleSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/example/data/ExamplePortletData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/example/data/ExamplePortalSeedData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/example/data/ExampleHelpData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/multiflex/data/MultiflexThemeData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/myportal/data/MyPortalSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/passport/data/OAuth2CommonSeedData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/pricat/data/PricatData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/projectmgr/data/ProjectMgrTypeData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/projectmgr/data/ProjectMgrHelpData.xml
> 2024-08-05 07:25:37,939 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/plugins/projectmgr/data/ProjectMgrSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/projectmgr/data/ProjectMgrPortletData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/scrum/data/scrumTypeData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/scrum/data/scrumSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/scrum/data/scrumHelpData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/webpos/data/WebPosSecurityPermissionSeedData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/webpos/data/PosSecurityData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/webpos/data/PosTypeData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/service/data/ScheduledServices.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/framework/entityext/data/EntityScheduledServices.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/datamodel/data/seed-initial/PartySeedInitialData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/datamodel/data/seed-initial/WorkEffortSeedInitialData.x
> ml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/product/data/ProductScheduledServices.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/product/data/CatalogSystemPropertyData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I|
> file:/ofbiz/applications/accounting/data/AccountingScheduledServiceData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/order/data/OrderScheduledServices.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/applications/order/data/OrderSystemPropertyData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/bi/data/BiSystemPropertyData.xml
> 2024-08-05 07:25:37,940 |main |EntityDataLoadContainer
> |I| file:/ofbiz/plugins/projectmgr/data/ProjectMgrSystemPropertyData.xml
> 2024-08-05 07:25:37,941 |main |EntityDataLoadContainer
> |I| =-=-=-=-=-=-= Starting the data load...
> 2024-08-05 07:25:37,947 |main |EntitySaxReader
> |I| Beginning import from URL:
> file:/ofbiz/framework/security/data/SecurityPermissio
> nSeedData.xml
> 2024-08-05 07:25:37,952 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [34] Services from
> file:/ofbiz/framework/service/servicedef/services.xml
> 2024-08-05 07:25:37,965 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [28] Services from
> file:/ofbiz/framework/service/servicedef/services_test
> _se.xml
> 2024-08-05 07:25:37,966 |main |EntitySaxReader
> |I| Transaction Timeout set to 2 hours (7200 seconds)
> 2024-08-05 07:25:38,005 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [68] Services from
> file:/ofbiz/framework/entityext/servicedef/services.xm
> l
> 2024-08-05 07:25:38,017 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [6] Services from
> file:/ofbiz/framework/entityext/servicedef/services_gro
> up.xml
> org.apache.ofbiz.base.start.StartupException: Cannot init()
> dataload-container (org.apache.ofbiz.entity.GenericEntityException:
> [loadData]: Error loading XML Res ource
> "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error
> was: A transaction error occurred reading data (A transaction error occurred
> re ading data) ([loadData]: Error loading
> XML Resource
> "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error
> was: A transaction error occurred reading
> data (A transaction error occurred reading data)))
> at
> org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:136)
> at
> org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:99)
> at
> org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:69)
> at
> org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:218)
> at
> org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71)
> at org.apache.ofbiz.base.start.Start.main(Start.java:85)
> 2024-08-05 07:25:38,024 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [3] Services from
> file:/ofbiz/framework/entityext/servicedef/services_syn
> chronization.xml
> Caused by: org.apache.ofbiz.base.container.ContainerException:
> org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML
> Resource "file:/ofbi
> z/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A
> transaction error occurred reading data (A transaction error occurred reading
> data) ([loa dData]: Error loading XML
> Resource
> "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error
> was: A transaction error occurred reading data (A
> transaction error occurred reading data))
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:445)
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184)
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:116)
> at
> org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:134)
> ... 5 more
> Caused by: org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error
> loading XML Resource
> "file:/ofbiz/framework/security/data/SecurityPermissionSeedData
> .xml"; Error was: A transaction error occurred reading
> data (A transaction error occurred reading data)
> at
> org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:275)
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:437)
> ... 8 more
> Caused by: org.xml.sax.SAXException: A transaction error occurred reading data
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a
> connection with the database. (Unable t o
> acquire a new connection from the pool) (Unable to establish a connection
> with the database. (Unable to acquire a new connection from the pool))
> at
> org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:240)
> at
> org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205)
> at
> org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268)
> ... 9 more
> Caused by: org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a
> connection with the database . (Unable to
> acquire a new connection from the pool) (Unable to establish a connection
> with the database. (Unable to acquire a new connection from the pool))
> at
> org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1358)
> at
> org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
> at
> org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
> ... 11 more
> Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Unable to
> establish a connection with the database. (Unable to acquire a new connection
> from the p ool)
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264)
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:351)
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488)
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466)
> at
> org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81)
> at
> org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1314)
> ... 13 more
> Caused by: java.sql.SQLException: Unable to acquire a new connection from the
> pool
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145)
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ... 19 more
> Caused by: java.util.NoSuchElementException: Unable to activate object
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474)
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
> ... 25 more
> Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771)
> at
> org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263)
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775)
> at
> org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414)
> at
> org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434)
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465)
> ... 27 more
> 2024-08-05 07:25:38,024 |main |GenericDelegator
> |E| Failure in storeAll operation:
> org.apache.ofbiz.entity.GenericDataSourceExceptio
> n: Unable to establish a connection with the database. (Unable to
> acquire a new connection from the pool). Rolling back transaction.
> org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a
> connection with the database. (Unable to acquire a new connection from the
> pool)
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:351)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1314)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:437)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:116)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:134)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:99)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:69)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:218)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71)
> ~[ofbiz.jar:?]
> at org.apache.ofbiz.base.start.Start.main(Start.java:85)
> ~[ofbiz.jar:?]
> Caused by: java.sql.SQLException: Unable to acquire a new connection from the
> pool
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ~[ofbiz.jar:?]
> ... 19 more
> Caused by: java.util.NoSuchElementException: Unable to activate object
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ~[ofbiz.jar:?]
> ... 19 more
> Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775)
> ~[postgresql-9.1-901.jdbc4.jar:?]
> at
> org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
> ~[commons-pool2-2.6.0.jar:2.6.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
> ~[commons-dbcp2-2.5.0.jar:2.5.0]
> at
> org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
> ~[ofbiz.jar:?]
> ... 19 more
> > Task :ofbiz --load-data readers=seed,seed-initial FAILED
> FAILURE: Build failed with an exception.
> * What went wrong:
> Execution failed for task ':ofbiz --load-data readers=seed,seed-initial'.
> > Process 'command '/opt/java/openjdk/bin/java'' finished with non-zero exit
> > value 1
> * Try:
> Run with --stacktrace option to get the stack trace. Run with --info or
> --debug option to get more log output. Run with --scan to get full insights.
> * Get more help at https://help.gradle.org
> BUILD FAILED in 1m 53s
> 13 actionable tasks: 10 executed, 3 up-to-date
> samir@amgmdchr1:~/ofbizPros/almusbahemail/docker-postgres-ofbiz-main$
> 2024-08-05 07:25:38,017 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [6] Services from
> file:/ofbiz/framework/entityext/servicedef/services_gro
> up.xml
> org.apache.ofbiz.base.start.StartupException: Cannot init()
> dataload-container (org.apache.ofbiz.entity.GenericEntityException:
> [loadData]: Error loading XML Res ource
> "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error
> was: A transaction error occurred reading data (A transaction error occurred
> re ading data) ([loadData]: Error loading
> XML Resource
> "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error
> was: A transaction error occurred reading
> data (A transaction error occurred reading data)))
> at
> org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:136)
> at
> org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:99)
> at
> org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:69)
> at
> org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:218)
> at
> org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71)
> at org.apache.ofbiz.base.start.Start.main(Start.java:85)
> 2024-08-05 07:25:38,024 |kJoinPool-1-worker-1 |ModelServiceReader
> |I| Loaded [3] Services from
> file:/ofbiz/framework/entityext/servicedef/services_syn
> chronization.xml
> Caused by: org.apache.ofbiz.base.container.ContainerException:
> org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML
> Resource "file:/ofbi
> z/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A
> transaction error occurred reading data (A transaction error occurred reading
> data) ([loa dData]: Error loading XML
> Resource
> "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error
> was: A transaction error occurred reading data (A
> transaction error occurred reading data))
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:445)
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184)
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:116)
> at
> org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:134)
> ... 5 more
> Caused by: org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error
> loading XML Resource
> "file:/ofbiz/framework/security/data/SecurityPermissionSeedData
> .xml"; Error was: A transaction error occurred reading
> data (A transaction error occurred reading data)
> at
> org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:275)
> at
> org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:437)
> ... 8 more
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
