[OFBIZ-6555] errors and warning after load-extseed and running ofbiz

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 14.12.01, 12.04.06, 13.07.03, 16.11.01
• Component/s: order
• Assignee: Shi Jinghai
• Reporter: Wai
• Created: 09/Jul/15 18:28
• Updated: 27/Aug/15 02:37
• Resolved: 24/Jul/15 16:34

Description

After running $ ant load-extseed
The error.log file contains the following:

2015-07-09 14:19:24,432 |delegator-startup-1  |ModelViewEntity               |E| [OrderItemQuantityReportGroupByProduct]: [ModelViewEntity.populateFields] ERROR: could not find ModelField for entity name: ItemIssuanceQuantitySum and field: issuedDateTime
2015-07-09 14:19:24,432 |delegator-startup-1  |ModelViewEntity               |E| [OrderItemQuantityReportGroupByProduct]: [populateFields] ERROR: could not find ModelField for field name "issuedDateTime" on entity with name: ItemIssuanceQuantitySum
2015-07-09 14:23:09,750 |OFBiz-batch-3        |DatabaseUtil                  |E| Error adding foreign key: ModelEntity was null for related entity name Tenant

The ofbiz.log contains the following note worthy errors and warnings:

2015-07-09 14:19:24,348 |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
2015-07-09 14:19:24,348 |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
2015-07-09 14:19:24,432 |delegator-startup-1  |ModelViewEntity               |W| [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2015-07-09 14:19:24,432 |delegator-startup-1  |ModelViewEntity               |W| [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen
2015-07-09 14:19:24,432 |delegator-startup-1  |ModelViewEntity               |E| [OrderItemQuantityReportGroupByProduct]: [ModelViewEntity.populateFields] ERROR: could not find ModelField for entity name: ItemIssuanceQuantitySum and field: issuedDateTime
2015-07-09 14:19:24,432 |delegator-startup-1  |ModelViewEntity               |E| [OrderItemQuantityReportGroupByProduct]: [populateFields] ERROR: could not find ModelField for field name "issuedDateTime" on entity with name: ItemIssuanceQuantitySum
2015-07-09 14:19:24,432 |delegator-startup-1  |ModelViewEntity               |W| [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2015-07-09 14:19:24,432 |delegator-startup-1  |ModelViewEntity               |W| [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen
2015-07-09 14:19:24,435 |delegator-startup-1  |ModelViewEntity               |W| [OrderReportSalesGroupByProduct]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2015-07-09 14:19:24,438 |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
2015-07-09 14:19:24,438 |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
2015-07-09 14:19:24,446 |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
2015-07-09 14:19:24,453 |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
2015-07-09 14:19:24,484 |delegator-startup-1  |ModelReader                   |I| Finished loading entities; #Entities=878 #ViewEntities=310 #Fields=9170 #Relationships=2981 #AutoRelationships=2196
2015-07-09 14:19:24,497 |delegator-startup-1  |GenericDelegator              |I| Doing entity definition check...
2015-07-09 14:19:24,500 |delegator-startup-1  |ModelEntityChecker            |I| [initReservedWords] array length = 1025
2015-07-09 14:19:24,602 |OFBiz-batch-1        |GenericDelegator              |I| Delegator "default" initializing helper "localposttenant" for entity group "org.ofbiz.tenant".
2015-07-09 14:19:24,605 |OFBiz-batch-2        |GenericDelegator              |I| Delegator "default" initializing helper "localpostolap" for entity group "org.ofbiz.olap".
2015-07-09 14:19:24,606 |OFBiz-batch-3        |GenericDelegator              |I| Delegator "default" initializing helper "localpostgres" for entity group "org.ofbiz".
2015-07-09 14:19:24,609 |OFBiz-batch-1        |GenericDelegator              |I| Doing database check as requested in entityengine.xml with addMissing=true
2015-07-09 14:19:24,609 |OFBiz-batch-2        |GenericDelegator              |I| Doing database check as requested in entityengine.xml with addMissing=true
2015-07-09 14:19:24,610 |OFBiz-batch-3        |GenericDelegator              |I| Doing database check as requested in entityengine.xml with addMissing=true


When ofbiz is run using the initialized database and a password is configured (using $ ant load-admin-user-login -DuserLoginId=admin). The following collection of errors and warnings are shown in the console output.

2015-07-09 14:31:14,236 |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
2015-07-09 14:31:14,236 |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
2015-07-09 14:31:14,327 |delegator-startup-1  |ModelViewEntity               |W| [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2015-07-09 14:31:14,327 |delegator-startup-1  |ModelViewEntity               |W| [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen
2015-07-09 14:31:14,327 |delegator-startup-1  |ModelViewEntity               |E| [OrderItemQuantityReportGroupByProduct]: [ModelViewEntity.populateFields] ERROR: could not find ModelField for entity name: ItemIssuanceQuantitySum and field: issuedDateTime
2015-07-09 14:31:14,327 |delegator-startup-1  |ModelViewEntity               |E| [OrderItemQuantityReportGroupByProduct]: [populateFields] ERROR: could not find ModelField for field name "issuedDateTime" on entity with name: ItemIssuanceQuantitySum
2015-07-09 14:31:14,327 |delegator-startup-1  |ModelViewEntity               |W| [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2015-07-09 14:31:14,327 |delegator-startup-1  |ModelViewEntity               |W| [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen
2015-07-09 14:31:14,330 |delegator-startup-1  |ModelViewEntity               |W| [OrderReportSalesGroupByProduct]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2015-07-09 14:31:14,333 |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
2015-07-09 14:31:14,333 |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
2015-07-09 14:31:14,340 |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
2015-07-09 14:31:14,347 |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
2015-07-09 14:31:23,315 |OFBiz-JobQueue-0     |TransactionUtil               |W| No transaction in place, so not suspending.
2015-07-09 14:31:23,385 |OFBiz-JobQueue-0     |SequenceUtil                  |W| Lock failed; no sequence row was found, will try to add a new one for sequence: JobSandbox
2015-07-09 14:31:26,342 |OFBiz-JobQueue-1     |PersistedServiceJob           |W| Persisted Job [9000] references a RecurrenceInfo, recommend using TemporalExpression instead
2015-07-09 14:31:27,912 |OFBiz-JobQueue-0     |PersistedServiceJob           |W| Persisted Job [8500] references a RecurrenceInfo, recommend using TemporalExpression instead
2015-07-09 14:31:55,747 |http-bio-8443-exec-2 |TransactionUtil               |W| No transaction in place, so not suspending.
2015-07-09 14:31:55,756 |http-bio-8443-exec-2 |SequenceUtil                  |W| Lock failed; no sequence row was found, will try to add a new one for sequence: Visitor
2015-07-09 14:31:56,026 |http-bio-8443-exec-2 |TransactionUtil               |W| No transaction in place, so not suspending.
2015-07-09 14:31:56,037 |http-bio-8443-exec-2 |SequenceUtil                  |W| Lock failed; no sequence row was found, will try to add a new one for sequence: Visit
2015-07-09 14:32:00,949 |http-bio-8443-exec-8 |HashCrypt                     |W| Warning: detected oldFunnyHex password prefixed with a hashType; this is not valid, please update the value in the database with ({SHA}47b56994cbc2b6d10aa1be30f70165adb305a41a)
2015-07-09 14:32:06,321 |http-bio-8443-exec-9 |HashCrypt                     |W| Warning: detected oldFunnyHex password prefixed with a hashType; this is not valid, please update the value in the database with ({SHA}47b56994cbc2b6d10aa1be30f70165adb305a41a)
2015-07-09 14:32:06,430 |http-bio-8443-exec-9 |HashCrypt                     |W| Warning: detected oldFunnyHex password prefixed with a hashType; this is not valid, please update the value in the database with ({SHA}47b56994cbc2b6d10aa1be30f70165adb305a41a)
2015-07-09 14:32:06,508 |http-bio-8443-exec-9 |SequenceUtil                  |W| Lock failed; no sequence row was found, will try to add a new one for sequence: RuntimeData

Issue Links

• is duplicated by: OFBIZ-6579 ERROR: could not find ModelField for entity name: ItemIssuanceQuantitySum and field: issuedDateTime