[jira] [Comment Edited] (OFBIZ-11401) getEntityRefData service has a weird issue

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-11401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17114681#comment-17114681 ]

Ankush Upadhyay edited comment on OFBIZ-11401 at 5/23/20, 10:46 AM:
--------------------------------------------------------------------

[~pierresmits], Yes you got it correctly, this is the case of missing entity labels.

 

[~pierresmits], [~jleroux]

I tried to print the list of entities for them the exception is getting printed on service run.

Here are the list:

[FinAccountTransType, FinAccountType, FixedAssetIdentType, FixedAssetProductType, FixedAssetStdCostType, FixedAssetType, InvoiceItemType, InvoiceType, AcctgTransType, GlAccountClass, GlAccountType, GlFiscalType, GlResourceType, ProductAverageCostType, PaymentMethodType, PaymentType, RateType, TaxAuthorityAssocType, TaxAuthorityRateType, DataSource, Enumeration, EnumerationType, CountryAddressFormat, Geo, GeoAssocType, GeoPoint, GeoType, CustomMethod, PortalPage, CustomScreen, StatusItem, StatusType, StatusValidChange, VisualTheme, Uom, UomGroup, UomType, Content, ContentAssocPredicate, ContentAssocType, ContentOperation, ContentPurposeType, ContentType, CharacterSet, DataCategory, DataResourceType, DataTemplateType, MetaDataPredicate, MimeType, MimeTypeHtmlTemplate, DocumentType, SurveyApplType, SurveyQuestionType, WebSiteContentType, ExampleItem, ExampleStatus, ExampleType, ExampleFeature, ExampleFeatureAppl, ExampleFeatureApplType, EmplLeaveReasonType, EmplLeaveType, MrpEventType, TechDataCalendar, TechDataCalendarWeek, ContactListType, SegmentGroupType, TrackingCodeType, OrderAdjustmentType, OrderBlacklistType, OrderContentType, OrderItemType, OrderType, QuoteType, CustRequestResolution, CustRequestType, RequirementType, WorkReqFulfType, ReturnAdjustmentType, ReturnReason, ReturnType, ShoppingListType, AgreementItemType, AgreementType, TermType, CommunicationEventPrpTyp, CommunicationEventType, ContactMechPurposeType, ContactMechType, PartyClassificationType, PartyContentType, PartyIdentificationType, PartyRelationshipType, PartyType, RoleType, ProdCatalog, ProdCatalogCategory, ProdCatalogCategoryType, ProdCatalogInvFacility, ProdCatalogRole, ProductAndCategoryMember, ProductCategory, ProductCategoryAndMember, ProductCategoryAttribute, ProductCategoryContent, ProductCategoryContentAndInfo, ProductCategoryContentType, ProductCategoryGlAccount, ProductCategoryLink, ProductCategoryMember, ProductCategoryMemberAndRole, ProductCategoryRole, ProductCategoryRollup, ProductCategoryRollupAndChild, ProductCategoryRollupAndRole, ProductCategoryType, ProductCategoryTypeAttr, ConfigOptionProductOption, ProdConfItemContent, ProdConfItemContentType, ProductConfig, ProductConfigAndProduct, ProductConfigConfig, ProductConfigItem, ProductConfigOption, ProductConfigOptionIactn, ProductConfigProduct, ProductConfigStats, CostComponent, CostComponentAttribute, CostComponentCalc, CostComponentType, CostComponentTypeAttr, ProductCostComponentCalc, Container, ContainerAndGeoPoint, ContainerGeoPoint, ContainerType, Facility, FacilityAndContactMech, FacilityAssocType, FacilityAttribute, FacilityCalendar, FacilityCalendarType, FacilityCarrierShipment, FacilityContactMech, FacilityContactMechPurpose, FacilityContent, FacilityContentDetail, FacilityGroup, FacilityGroupMember, FacilityGroupRole, FacilityGroupRollup, FacilityGroupType, FacilityLocation, FacilityLocationAndGeoPoint, FacilityLocationGeoPoint, FacilityParty, FacilityType, FacilityTypeAttr, ProductFacility, ProductFacilityAndPostalAddress, ProductFacilityAssoc, ProductFacilityLocation, ProductFacilityLocationQuantityTest, ProductFacilityLocationView, ProdFeaGrpAppAndProdFeaApp, ProductFeature, ProductFeatureAndAppl, ProductFeatureAppl, ProductFeatureApplAttr, ProductFeatureApplType, ProductFeatureCatGrpAppl, ProductFeatureCategory, ProductFeatureCategoryAppl, ProductFeatureDataResource, ProductFeatureGroup, ProductFeatureGroupAndAppl, ProductFeatureGroupAppl, ProductFeatureIactn, ProductFeatureIactnType, ProductFeatureType, BalanceInventoryItemsView, InventoryItem, InventoryItemAndDetail, InventoryItemAndLocation, InventoryItemAttribute, InventoryItemDetail, InventoryItemDetailForSum, InventoryItemDetailSummary, InventoryItemLabel, InventoryItemLabelAppl, InventoryItemLabelType, InventoryItemStatus, InventoryItemStatusForCount, InventoryItemTempRes, InventoryItemType, InventoryItemTypeAttr, InventoryItemVariance, InventoryTransfer, Lot, PhysicalInventory, PhysicalInventoryAndVariance, VarianceReason, ProductFeaturePrice, ProductPaymentMethodType, ProductPrice, ProductPriceAction, ProductPriceActionType, ProductPriceAutoNotice, ProductPriceChange, ProductPriceCond, ProductPricePurpose, ProductPriceRule, ProductPriceType, QuantityBreak, QuantityBreakType, SaleType, GoodIdentification, GoodIdentificationAndProduct, GoodIdentificationType, Product, ProductAndAssoc, ProductAndPriceView, ProductAssoc, ProductAssocType, ProductAttribute, ProductCalculatedInfo, ProductContent, ProductContentAndInfo, ProductContentType, ProductGeo, ProductGlAccount, ProductGroupOrder, ProductInventoryItem, ProductKeyword, ProductMaint, ProductMaintType, ProductMeter, ProductMeterType, ProductReview, ProductRole, ProductSearchConstraint, ProductSearchResult, ProductType, ProductTypeAttr, ProductVirtualAndAssocPrices, ProductVirtualAndVariantInfo, VendorProduct, OldProductPromoCodeEmail, ProdPromoCodeContactMech, ProductPromo, ProductPromoAction, ProductPromoCategory, ProductPromoCode, ProductPromoCodeEmailParty, ProductPromoCodeParty, ProductPromoCond, ProductPromoContent, ProductPromoProduct, ProductPromoRule, ProductPromoUse, ProductPromoUseCheck, ProductStore, ProductStoreCatalog, ProductStoreEmailSetting, ProductStoreFacility, ProductStoreFacilityByOrder, ProductStoreFinActSetting, ProductStoreGroup, ProductStoreGroupMember, ProductStoreGroupRole, ProductStoreGroupRollup, ProductStoreGroupType, ProductStoreKeywordOvrd, ProductStorePaymentSetting, ProductStorePromoAndAppl, ProductStorePromoAppl, ProductStoreRole, ProductStoreShipmentMeth, ProductStoreShipmentMethView, ProductStoreSurveyAppl, ProductStoreTelecomSetting, ProductStoreVendorPayment, ProductStoreVendorShipment, ProductSubscriptionResource, Subscription, SubscriptionActivity, SubscriptionAndCommEvent, SubscriptionAttribute, SubscriptionCommEvent, SubscriptionFulfillmentPiece, SubscriptionResource, SubscriptionType, SubscriptionTypeAttr, MarketInterest, ReorderGuideline, SupplierPrefOrder, SupplierProduct, SupplierProductAndProduct, SupplierProductFeature, SupplierRatingType, SecurityGroup, SecurityPermission, RejectionReason, ShipmentType, ServerHitType, WorkEffortAssocType, WorkEffortAssocTypeAttr, WorkEffortPurposeType, WorkEffortType]

Looks like for all of them, FieldDescription also missing and thus printing exception for each field.

According to service it also try to get entity description from ModelEntity object and the field description from ModelField object, I think we can simply print warning about the missing entity description and field description.

Please let us know your thoughts.


was (Author: ankush.upadhyay):
[~pierresmits], Yes you got it correctly, this is the case of missing entity labels.

 

[~pierresmits], [~jleroux]

I tried to print the list of entities for them the exception is getting printed on service run.

Here are the list:

[FinAccountTransType, FinAccountType, FixedAssetIdentType, FixedAssetProductType, FixedAssetStdCostType, FixedAssetType, InvoiceItemType, InvoiceType, AcctgTransType, GlAccountClass, GlAccountType, GlFiscalType, GlResourceType, ProductAverageCostType, PaymentMethodType, PaymentType, RateType, TaxAuthorityAssocType, TaxAuthorityRateType, DataSource, Enumeration, EnumerationType, CountryAddressFormat, Geo, GeoAssocType, GeoPoint, GeoType, CustomMethod, PortalPage, CustomScreen, StatusItem, StatusType, StatusValidChange, VisualTheme, Uom, UomGroup, UomType, Content, ContentAssocPredicate, ContentAssocType, ContentOperation, ContentPurposeType, ContentType, CharacterSet, DataCategory, DataResourceType, DataTemplateType, MetaDataPredicate, MimeType, MimeTypeHtmlTemplate, DocumentType, SurveyApplType, SurveyQuestionType, WebSiteContentType, ExampleItem, ExampleStatus, ExampleType, ExampleFeature, ExampleFeatureAppl, ExampleFeatureApplType, EmplLeaveReasonType, EmplLeaveType, MrpEventType, TechDataCalendar, TechDataCalendarWeek, ContactListType, SegmentGroupType, TrackingCodeType, OrderAdjustmentType, OrderBlacklistType, OrderContentType, OrderItemType, OrderType, QuoteType, CustRequestResolution, CustRequestType, RequirementType, WorkReqFulfType, ReturnAdjustmentType, ReturnReason, ReturnType, ShoppingListType, AgreementItemType, AgreementType, TermType, CommunicationEventPrpTyp, CommunicationEventType, ContactMechPurposeType, ContactMechType, PartyClassificationType, PartyContentType, PartyIdentificationType, PartyRelationshipType, PartyType, RoleType, ProdCatalog, ProdCatalogCategory, ProdCatalogCategoryType, ProdCatalogInvFacility, ProdCatalogRole, ProductAndCategoryMember, ProductCategory, ProductCategoryAndMember, ProductCategoryAttribute, ProductCategoryContent, ProductCategoryContentAndInfo, ProductCategoryContentType, ProductCategoryGlAccount, ProductCategoryLink, ProductCategoryMember, ProductCategoryMemberAndRole, ProductCategoryRole, ProductCategoryRollup, ProductCategoryRollupAndChild, ProductCategoryRollupAndRole, ProductCategoryType, ProductCategoryTypeAttr, ConfigOptionProductOption, ProdConfItemContent, ProdConfItemContentType, ProductConfig, ProductConfigAndProduct, ProductConfigConfig, ProductConfigItem, ProductConfigOption, ProductConfigOptionIactn, ProductConfigProduct, ProductConfigStats, CostComponent, CostComponentAttribute, CostComponentCalc, CostComponentType, CostComponentTypeAttr, ProductCostComponentCalc, Container, ContainerAndGeoPoint, ContainerGeoPoint, ContainerType, Facility, FacilityAndContactMech, FacilityAssocType, FacilityAttribute, FacilityCalendar, FacilityCalendarType, FacilityCarrierShipment, FacilityContactMech, FacilityContactMechPurpose, FacilityContent, FacilityContentDetail, FacilityGroup, FacilityGroupMember, FacilityGroupRole, FacilityGroupRollup, FacilityGroupType, FacilityLocation, FacilityLocationAndGeoPoint, FacilityLocationGeoPoint, FacilityParty, FacilityType, FacilityTypeAttr, ProductFacility, ProductFacilityAndPostalAddress, ProductFacilityAssoc, ProductFacilityLocation, ProductFacilityLocationQuantityTest, ProductFacilityLocationView, ProdFeaGrpAppAndProdFeaApp, ProductFeature, ProductFeatureAndAppl, ProductFeatureAppl, ProductFeatureApplAttr, ProductFeatureApplType, ProductFeatureCatGrpAppl, ProductFeatureCategory, ProductFeatureCategoryAppl, ProductFeatureDataResource, ProductFeatureGroup, ProductFeatureGroupAndAppl, ProductFeatureGroupAppl, ProductFeatureIactn, ProductFeatureIactnType, ProductFeatureType, BalanceInventoryItemsView, InventoryItem, InventoryItemAndDetail, InventoryItemAndLocation, InventoryItemAttribute, InventoryItemDetail, InventoryItemDetailForSum, InventoryItemDetailSummary, InventoryItemLabel, InventoryItemLabelAppl, InventoryItemLabelType, InventoryItemStatus, InventoryItemStatusForCount, InventoryItemTempRes, InventoryItemType, InventoryItemTypeAttr, InventoryItemVariance, InventoryTransfer, Lot, PhysicalInventory, PhysicalInventoryAndVariance, VarianceReason, ProductFeaturePrice, ProductPaymentMethodType, ProductPrice, ProductPriceAction, ProductPriceActionType, ProductPriceAutoNotice, ProductPriceChange, ProductPriceCond, ProductPricePurpose, ProductPriceRule, ProductPriceType, QuantityBreak, QuantityBreakType, SaleType, GoodIdentification, GoodIdentificationAndProduct, GoodIdentificationType, Product, ProductAndAssoc, ProductAndPriceView, ProductAssoc, ProductAssocType, ProductAttribute, ProductCalculatedInfo, ProductContent, ProductContentAndInfo, ProductContentType, ProductGeo, ProductGlAccount, ProductGroupOrder, ProductInventoryItem, ProductKeyword, ProductMaint, ProductMaintType, ProductMeter, ProductMeterType, ProductReview, ProductRole, ProductSearchConstraint, ProductSearchResult, ProductType, ProductTypeAttr, ProductVirtualAndAssocPrices, ProductVirtualAndVariantInfo, VendorProduct, OldProductPromoCodeEmail, ProdPromoCodeContactMech, ProductPromo, ProductPromoAction, ProductPromoCategory, ProductPromoCode, ProductPromoCodeEmailParty, ProductPromoCodeParty, ProductPromoCond, ProductPromoContent, ProductPromoProduct, ProductPromoRule, ProductPromoUse, ProductPromoUseCheck, ProductStore, ProductStoreCatalog, ProductStoreEmailSetting, ProductStoreFacility, ProductStoreFacilityByOrder, ProductStoreFinActSetting, ProductStoreGroup, ProductStoreGroupMember, ProductStoreGroupRole, ProductStoreGroupRollup, ProductStoreGroupType, ProductStoreKeywordOvrd, ProductStorePaymentSetting, ProductStorePromoAndAppl, ProductStorePromoAppl, ProductStoreRole, ProductStoreShipmentMeth, ProductStoreShipmentMethView, ProductStoreSurveyAppl, ProductStoreTelecomSetting, ProductStoreVendorPayment, ProductStoreVendorShipment, ProductSubscriptionResource, Subscription, SubscriptionActivity, SubscriptionAndCommEvent, SubscriptionAttribute, SubscriptionCommEvent, SubscriptionFulfillmentPiece, SubscriptionResource, SubscriptionType, SubscriptionTypeAttr, MarketInterest, ReorderGuideline, SupplierPrefOrder, SupplierProduct, SupplierProductAndProduct, SupplierProductFeature, SupplierRatingType, SecurityGroup, SecurityPermission, RejectionReason, ShipmentType, ServerHitType, WorkEffortAssocType, WorkEffortAssocTypeAttr, WorkEffortPurposeType, WorkEffortType]

Looks like for all of them, FieldDescription also missing and thus printing exception for each field.

According to service it also try to get entity description from ModelEntity object and the field description from ModelField object, I think we can simply print warning about the missing entity description and field description.

Please let us know you thoughts.

> getEntityRefData service has a weird issue
> ------------------------------------------
>
>                 Key: OFBIZ-11401
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-11401
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework/webtools
>    Affects Versions: Trunk
>            Reporter: Jacques Le Roux
>            Priority: Major
>
> It's reproductible on trunk demo though only visible in log, UI shows no issue
> Here is the log on trunk demo
> {noformat}
> 2020-02-21 21:11:56,445 |ajp-nio-8009-exec-2  |WebToolsServices              |E| null
> java.util.MissingResourceException: Can't find resource for bundle org.apache.ofbiz.base.util.UtilProperties$UtilResourceBundle, key FieldDescription.WorkEffortType.createdTxStamp
> at java.util.ResourceBundle.getObject(ResourceBundle.java:450) ~[?:1.8.0_242]
> at java.util.ResourceBundle.getObject(ResourceBundle.java:444) ~[?:1.8.0_242]
> at java.util.ResourceBundle.getString(ResourceBundle.java:407) ~[?:1.8.0_242]
> at org.apache.ofbiz.webtools.WebToolsServices.getEntityRefData(WebToolsServices.java:685) [main/:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_242]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_242]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_242]
> at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_242]
> at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) [main/:?]
> [...]
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.29.jar:9.0.29]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_242]
> 2020-02-21 21:11:56,445 |ajp-nio-8009-exec-2  |WebToolsServices              |E| null
> java.util.MissingResourceException: Can't find resource for bundle org.apache.ofbiz.base.util.UtilProperties$UtilResourceBundle, key FieldDescription.createdTxStamp
> at java.util.ResourceBundle.getObject(ResourceBundle.java:450) ~[?:1.8.0_242]
> at java.util.ResourceBundle.getObject(ResourceBundle.java:444) ~[?:1.8.0_242]
> at java.util.ResourceBundle.getString(ResourceBundle.java:407) ~[?:1.8.0_242]
> at org.apache.ofbiz.webtools.WebToolsServices.getEntityRefData(WebToolsServices.java:695) [main/:?]
> [...]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_242]
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.29.jar:9.0.29]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_242]
> 2020-02-21 21:11:56,445 |ajp-nio-8009-exec-2  |ServiceDispatcher             |T| Sync service [webtools/getEntityRefData] finished in [5760] milliseconds
> at org.apache.ofbiz.webtools.WebToolsServices.getEntityRefData(WebToolsServices.java:685) [main/:?]
>     {noformat}
> So it repeats almost "ad ib" and eventually stops after 5+ seconds there.
> I guess R17 and R18 are also affected, R16 is OK.

--
This message was sent by Atlassian Jira
(v8.3.4#803005)