[jira] [Created] (OFBIZ-12505) Wrong Field Name Definition in RequirementForms
Schumann Ye created OFBIZ-12505: --- Summary: Wrong Field Name Definition in RequirementForms Key: OFBIZ-12505 URL: https://issues.apache.org/jira/browse/OFBIZ-12505 Project: OFBiz Issue Type: Bug Components: order Affects Versions: 18.12.05 Environment: WIN10, MSSQL Reporter: Schumann Ye Fix For: 18.12.06 The issue exists also in the older version. The field "requirementByDate" form "FindApprovedProductRequirements" in RequirementForms.xml has been set wrongly and it should be "requiredByDate". This causes the result could not be queried out properly as indicated as below: # The result is governed by the service "getRequirementsForSupplier", where reads the list from the view "RequirementAndRole". # In the view entity definition, the field is defined as , but it is not the case in the form "FindApprovedProductRequirements" above. After changing it to the correct name, the bug is solved. -- This message was sent by Atlassian Jira (v8.20.1#820001)
[jira] [Created] (OFBIZ-12504) Some requirement services were missing in Release 18.12.05
Schumann Ye created OFBIZ-12504: --- Summary: Some requirement services were missing in Release 18.12.05 Key: OFBIZ-12504 URL: https://issues.apache.org/jira/browse/OFBIZ-12504 Project: OFBiz Issue Type: Bug Components: order Affects Versions: 18.12.05 Environment: Win10, MSSQL Reporter: Schumann Ye Fix For: 18.12.06 Some requirement services like "createRequirement"/"updateRequirement"/"deleteRequirement" were missing in Release 18.12.05. The original file is located in "order/minilang/requirement/RequirementServices.xml". -- This message was sent by Atlassian Jira (v8.20.1#820001)
[jira] [Created] (OFBIZ-12503) PurcReqAppr.fo.ftl is missing in Release 18.12.05
Schumann Ye created OFBIZ-12503: --- Summary: PurcReqAppr.fo.ftl is missing in Release 18.12.05 Key: OFBIZ-12503 URL: https://issues.apache.org/jira/browse/OFBIZ-12503 Project: OFBiz Issue Type: Bug Components: themes Environment: Win10, MSSQL Reporter: Schumann Ye The file PurcReqAppr.fo.ftl is missing in the release 18.12.05, which will cause error when trying to print out the approved requirement list in Order Component. -- This message was sent by Atlassian Jira (v8.20.1#820001)
[jira] [Created] (OFBIZ-12032) Common theme does not work
Schumann Ye created OFBIZ-12032:
---
Summary: Common theme does not work
Key: OFBIZ-12032
URL: https://issues.apache.org/jira/browse/OFBIZ-12032
Project: OFBiz
Issue Type: Bug
Components: framework/webtools
Affects Versions: 17.12.04
Environment: Win 10, Server 2018, JDK1.8, MSSQL
Reporter: Schumann Ye
Similar as the ticket OFBIZ-10434, I have installed it successfully and run
"gradlew cleanAll loadAll". Databases "ofbiz/ofbizolap/ofbiztenant" are created
in MSSQL also successfully.
"Gradlew ofbiz" can be also run successfully without error but when I try to
access "https://localhost:8443/webtools"; from chrome, I have the following
Error Messages:
2020-09-30 08:06:52,171 |jsse-nio-8443-exec-6 |ConfigXMLReader |I| controller
loaded: 0.004s, 112 requests, 78 views in
file:/D:/Program%20Files/ofbiz/framework/webtools/webapp/webtools/WEB-INF/controller.xml
2020-09-30 08:06:52,198 |jsse-nio-8443-exec-6 |ConfigXMLReader |I| controller
loaded: 0.001s, 48 requests, 22 views in
file:/D:/Program%20Files/ofbiz/framework/common/webcommon/WEB-INF/common-controller.xml
2020-09-30 08:06:52,219 |jsse-nio-8443-exec-6 |ConfigXMLReader |I| controller
loaded: 0.0s, 0 requests, 0 views in
file:/D:/Program%20Files/ofbiz/framework/common/webcommon/WEB-INF/handlers-controller.xml
2020-09-30 08:06:52,251 |jsse-nio-8443-exec-6 |ConfigXMLReader |I| controller
loaded: 0.001s, 26 requests, 10 views in
file:/D:/Program%20Files/ofbiz/framework/common/webcommon/WEB-INF/portal-controller.xml
2020-09-30 08:06:52,280 |jsse-nio-8443-exec-6 |ConfigXMLReader |I| controller
loaded: 0.0s, 30 requests, 13 views in
file:/D:/Program%20Files/ofbiz/framework/common/webcommon/WEB-INF/security-controller.xml
2020-09-30 08:06:52,311 |jsse-nio-8443-exec-6 |ConfigXMLReader |I| controller
loaded: 0.0s, 5 requests, 0 views in
file:/D:/Program%20Files/ofbiz/framework/common/webcommon/WEB-INF/tempexpr-controller.xml
2020-09-30 08:06:52,376 |jsse-nio-8443-exec-6 |RequestHandler |I| This is the
first request in this visit. Hidden sessionId by default.
2020-09-30 08:06:54,320 |jsse-nio-8443-exec-6 |RequestHandler |I| Rendering
View [main]. Hidden sessionId by default.
2020-09-30 08:06:54,357 |jsse-nio-8443-exec-6 |AbstractEngine |I| Loaded
Service Locations:
\{eedcc-test=https://localhost:8443/webtools/control/httpService,
entity-sync-http=https://localhost:8443/webtools/control/httpService,
rita-rmi=rmi://localhost:1099/RMIDispatcher,
main-rmi=rmi://localhost:1099/RMIDispatcher,
main-soap=http://localhost:8080/webtools/control/SOAPService,
entity-sync-rmi=rmi://localhost:1099/RMIDispatcher,
main-http=http://localhost:8080/webtools/control/httpService}
2020-09-30 08:06:54,552 |jsse-nio-8443-exec-6 |ServiceDispatcher |T| Sync
service [webtools/getUserPreferenceGroup] finished in [221] milliseconds
2020-09-30 08:06:54,607 |jsse-nio-8443-exec-6 |ControlServlet |W| Communication
error with the client while processing the request: /webtools/control/main
org.apache.ofbiz.webapp.control.RequestHandlerException: Error in the response
writer/output stream: freemarker.template.TemplateNotFoundException: Template
not found for {color:#FF}name
"component://common-theme/template/macro/HtmlScreenMacroLibrary.ftl".{color}
The name was interpreted by this TemplateLoader: MultiTemplateLoader(loader1 =
org.apache.ofbiz.base.util.template.FreeMarkerWorker$FlexibleTemplateLoader@18d7b49a,
loader2 = StringTemplateLoader(Map \{ })). (Template not found for name
"component://common-theme/template/macro/HtmlScreenMacroLibrary.ftl".
The name was interpreted by this TemplateLoader: MultiTemplateLoader(loader1 =
org.apache.ofbiz.base.util.template.FreeMarkerWorker$FlexibleTemplateLoader@18d7b49a,
loader2 = StringTemplateLoader(Map \{ })).)
at
org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:979)
~[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:657)
~[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217)
[ofbiz.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:686)
[javax.servlet-api-4.0.0.jar:4.0.0]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:791)
[javax.servlet-api-4.0.0.jar:4.0.0]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
[tomcat-catalina-9.0.36.jar:9.0.36]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.36.jar:9.0.36]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
[tomcat-embed-websocket-9.0.31.jar:9.0.31]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.36.jar:9.0.36]
at
org.apache.catalina.core.ApplicationFilterCha
[jira] [Commented] (OFBIZ-11998) Demo Data in conflict with Entity Unique Index when loading data during creation
[ https://issues.apache.org/jira/browse/OFBIZ-11998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17203978#comment-17203978 ] Schumann Ye commented on OFBIZ-11998: - Hi Jacques, OK with thanks. B.R. Schumann > Demo Data in conflict with Entity Unique Index when loading data during > creation > > > Key: OFBIZ-11998 > URL: https://issues.apache.org/jira/browse/OFBIZ-11998 > Project: OFBiz > Issue Type: Improvement > Components: party >Affects Versions: 17.12.04 > Environment: Win10, Java JDK1.8, MSSQL. >Reporter: Schumann Ye >Assignee: Jacques Le Roux >Priority: Minor > Labels: patch > > In party-entitymodel.xml line nr. 2,814 the following is defined: > > > > which goes against with the following code in > applications\securityext\data\UserDemoData.xml. > . > This would cause inserting records into Entity Person failing because the > field CARD_ID should not be identical in this case. > Therefore it's suggested to change the party-entitymodel.xml from : > > > > to > > > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (OFBIZ-11998) Demo Data in conflict with Entity Unique Index when loading data during creation
[ https://issues.apache.org/jira/browse/OFBIZ-11998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17191586#comment-17191586 ] Schumann Ye commented on OFBIZ-11998: - Same for product-entitymodel.xml. It is suggested to change to because it goes against with \applications\accounting\data\StandardCostingDemoData.xml when inserting records for InventoryItem. Same for party-entitymodel.xml. > Demo Data in conflict with Entity Unique Index when loading data during > creation > > > Key: OFBIZ-11998 > URL: https://issues.apache.org/jira/browse/OFBIZ-11998 > Project: OFBiz > Issue Type: Bug > Components: party >Affects Versions: 17.12.04 > Environment: Win10, Java JDK1.8, MSSQL. >Reporter: Schumann Ye >Priority: Minor > Labels: patch > Fix For: 18.12.01 > > > In party-entitymodel.xml line nr. 2,814 the following is defined: > > > > which goes against with the following code in > applications\securityext\data\UserDemoData.xml. > . > This would cause inserting records into Entity Person failing because the > field CARD_ID should not be identical in this case. > Therefore it's suggested to change the party-entitymodel.xml from : > > > > to > > > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (OFBIZ-11998) Demo Data in conflict with Entity Unique Index when loading data during creation
Schumann Ye created OFBIZ-11998: --- Summary: Demo Data in conflict with Entity Unique Index when loading data during creation Key: OFBIZ-11998 URL: https://issues.apache.org/jira/browse/OFBIZ-11998 Project: OFBiz Issue Type: Bug Components: party Affects Versions: 17.12.04 Environment: Win10, Java JDK1.8, MSSQL. Reporter: Schumann Ye Fix For: 18.12.01 In party-entitymodel.xml line nr. 2,814 the following is defined: which goes against with the following code in applications\securityext\data\UserDemoData.xml. . This would cause inserting records into Entity Person failing because the field CARD_ID should not be identical in this case. Therefore it's suggested to change the party-entitymodel.xml from : to -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (OFBIZ-10844) Ecommerce AnonContactus.ftl doesn't work
[ https://issues.apache.org/jira/browse/OFBIZ-10844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16792199#comment-16792199 ] Schumann Ye commented on OFBIZ-10844: - If you tested it with your personal email address (for example, you have filled in a...@example.com), the service will call the Java Email to send email as follows: From: [a...@example.com|mailto:a...@example.com] (the email provided by anonymous user) To: [a...@example.com|mailto:a...@example.com] (the receiving email address as maintained in the party “company”) OFBiz could perform the service successfully because the host server settings with passwords has been maintained correctly in the file general.properties and also in the database table system_property. However, in the real life production environment, when an anonymous user fills in their email address, it is most likely as follows: From: [arandomaddr...@a3partydomain.com|mailto:arandomaddr...@a3partydomain.com] To: [a...@example.com|mailto:a...@example.com] In this case, the settings are not maintained properly for the a3partydomain in the file general.properties and also in the database table system_property. So the services won’t perform correctly as desired. > Ecommerce AnonContactus.ftl doesn't work > > > Key: OFBIZ-10844 > URL: https://issues.apache.org/jira/browse/OFBIZ-10844 > Project: OFBiz > Issue Type: Bug > Components: ecommerce >Affects Versions: 16.11.04 > Environment: Win10 + OFBiz 16.11.04 + mysql. >Reporter: Schumann Ye >Assignee: Pawan Verma >Priority: Minor > Original Estimate: 0h > Remaining Estimate: 0h > > Ecommerce "Contact Us" with anonymous login doesn't work after filling in > email and all necessary info. > The root cause is the simple method "sendContactUsEmailToCompany" within > the file > \applications\party\minilang\communication\CommunicationEventServices.xml has > defined the field "sendFrom" as inputted email address from the anonymous > users. > To fix it, it should be changed as follows: > > While the email "yourmailaddr...@example.com" should have been properly set > up in your system. > It works for me! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (OFBIZ-10844) Ecommerce AnonContactus.ftl doesn't work
Schumann Ye created OFBIZ-10844: --- Summary: Ecommerce AnonContactus.ftl doesn't work Key: OFBIZ-10844 URL: https://issues.apache.org/jira/browse/OFBIZ-10844 Project: OFBiz Issue Type: Bug Components: ecommerce Affects Versions: 16.11.04 Environment: Win10 + OFBiz 16.11.04 + mysql. Reporter: Schumann Ye Ecommerce "Contact Us" with anonymous login doesn't work after filling in email and all necessary info. The root cause is the simple method "sendContactUsEmailToCompany" within the file \applications\party\minilang\communication\CommunicationEventServices.xml has defined the field "sendFrom" as inputted email address from the anonymous users. To fix it, it should be changed as follows: While the email "yourmailaddr...@example.com" should have been properly set up in your system. It works for me! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-10392) FindInventoryEventPlan Error
[
https://issues.apache.org/jira/browse/OFBIZ-10392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16462577#comment-16462577
]
Schumann Ye commented on OFBIZ-10392:
-
I think the solution is found as below:
The original code below in the file FindInventoryEventPlan.groovy
// set the page parameters
viewIndex = Integer.valueOf(parameters.VIEW_INDEX ?: 0)
viewSize = parameters.VIEW_SIZE ?:
EntityUtilProperties.getPropertyAsInteger("widget",
"widget.form.defaultViewSize", 20)
listSize = 0
if (inventoryList)
listSize = inventoryList.size()
lowIndex = viewIndex * viewSize
highIndex = (viewIndex + 1) * viewSize
Shall be changed to
// set the page parameters
viewIndex = Integer.valueOf(parameters.VIEW_INDEX ?: 0)
viewSize = Integer.valueOf(parameters.VIEW_SIZE ?:
EntityUtilProperties.getPropertyAsInteger("widget",
"widget.form.defaultViewSize", 20))
listSize = 0
if (inventoryList)
listSize = inventoryList.size()
lowIndex = viewIndex * viewSize
highIndex = (viewIndex + 1) * viewSize
Then the issue would be solved.
> FindInventoryEventPlan Error
>
>
> Key: OFBIZ-10392
> URL: https://issues.apache.org/jira/browse/OFBIZ-10392
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 16.11.04
> Environment: OS: Windows Server 2008 R2
> Database: MySQL 5.7
> JDK: 1.8.0_131
>Reporter: Schumann Ye
>Priority: Major
>
> After MRP run, in the screen of "Find Inventory Event Planned", the proper
> results show up after clicking the "Find" button with a certain "From Date"
> and leaving the "Product ID" empty.
> Because there are more than 20 records (which exceeds the default viewSize
> 20), so there are more than 1 page.
> When I hit "Next", it shows me the following error:
> Because I am new to groovy, can you pls help me out?
> Thanks
>
> |
> |{color:#ff}*:ERROR MESSAGE:*{color}|
> |org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> screen
> [component://manufacturing/widget/manufacturing/MrpScreens.xml#FindMrpPlannedEvents]:
> java.lang.IllegalArgumentException: Error running script at location
> [component://manufacturing/groovyScripts/mrp/FindInventoryEventPlan.groovy]:
> groovy.lang.MissingMethodException: No signature of method:
> java.lang.Integer.multiply() is applicable for argument types:
> (java.lang.String) values: [20] Possible solutions:
> multiply(java.lang.Number), multiply(java.lang.Character) (Error running
> script at location
> [component://manufacturing/groovyScripts/mrp/FindInventoryEventPlan.groovy]:
> groovy.lang.MissingMethodException: No signature of method:
> java.lang.Integer.multiply() is applicable for argument types:
> (java.lang.String) values: [20] Possible solutions:
> multiply(java.lang.Number), multiply(java.lang.Character))|
> |
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (OFBIZ-10392) FindInventoryEventPlan Error
[ https://issues.apache.org/jira/browse/OFBIZ-10392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16462521#comment-16462521 ] Schumann Ye commented on OFBIZ-10392: - Added full text of error description as below: 2018-05-03 22:23:57,096 |http-nio-443-exec-4 |ScriptUtil |W| Error running script at location [component://manufacturing/groovyScripts/mrp/FindInventoryEventPlan.groovy]: gro ng.MissingMethodException: No signature of method: java.lang.Integer.multiply() is applicable for argument types: (java.lang.String) values: [20] Possible solutions: multiply(java.lang.Number), multiply(java.lang.Character) groovy.lang.MissingMethodException: No signature of method: java.lang.Integer.multiply() is applicable for argument types: (java.lang.String) values: [20] Possible solutions: multiply(java.lang.Number), multiply(java.lang.Character) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.unwrap(ScriptBytecodeAdapter.java:58) ~[groovy-all-2.4.5.jar:2.4.5] at org.codehaus.groovy.runtime.callsite.PojoMetaClassSite.call(PojoMetaClassSite.java:49) ~[groovy-all-2.4.5.jar:2.4.5] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48) ~[groovy-all-2.4.5.jar:2.4.5] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113) ~[groovy-all-2.4.5.jar:2.4.5] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125) ~[groovy-all-2.4.5.jar:2.4.5] at FindInventoryEventPlan.run(FindInventoryEventPlan.groovy:77) ~[?:?] at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) ~[ofbiz.jar:?] at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) [ofbiz.jar:?] at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:984) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:648) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:210) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) [javax.servlet-api-3.1.0.jar:3.1.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [javax.servlet-api-3.1.0.jar:3.1.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-embed-websocket-8.0.39.jar:8.0.39] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:196) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) [tomcat-catalina-8.0.42.jar:8.0.42] at org.apache.catali
[jira] [Created] (OFBIZ-10392) FindInventoryEventPlan Error
Schumann Ye created OFBIZ-10392:
---
Summary: FindInventoryEventPlan Error
Key: OFBIZ-10392
URL: https://issues.apache.org/jira/browse/OFBIZ-10392
Project: OFBiz
Issue Type: Bug
Components: manufacturing
Affects Versions: 16.11.04
Environment: OS: Windows Server 2008 R2
Database: MySQL 5.7
JDK: 1.8.0_131
Reporter: Schumann Ye
After MRP run, in the screen of "Find Inventory Event Planned", the proper
results show up after clicking the "Find" button with a certain "From Date" and
leaving the "Product ID" empty.
Because there are more than 20 records (which exceeds the default viewSize 20),
so there are more than 1 page.
When I hit "Next", it shows me the following error:
Because I am new to groovy, can you pls help me out?
Thanks
|
|{color:#ff}*:ERROR MESSAGE:*{color}|
|org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen
[component://manufacturing/widget/manufacturing/MrpScreens.xml#FindMrpPlannedEvents]:
java.lang.IllegalArgumentException: Error running script at location
[component://manufacturing/groovyScripts/mrp/FindInventoryEventPlan.groovy]:
groovy.lang.MissingMethodException: No signature of method:
java.lang.Integer.multiply() is applicable for argument types:
(java.lang.String) values: [20] Possible solutions: multiply(java.lang.Number),
multiply(java.lang.Character) (Error running script at location
[component://manufacturing/groovyScripts/mrp/FindInventoryEventPlan.groovy]:
groovy.lang.MissingMethodException: No signature of method:
java.lang.Integer.multiply() is applicable for argument types:
(java.lang.String) values: [20] Possible solutions: multiply(java.lang.Number),
multiply(java.lang.Character))|
|
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (OFBIZ-10388) Production Run is not created after MRP run.
[ https://issues.apache.org/jira/browse/OFBIZ-10388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16461066#comment-16461066 ] Schumann Ye commented on OFBIZ-10388: - Sorry that I'd made a mistake. Now the issue is solved. I just need to approve the order and then run MRP then issue is solved. > Production Run is not created after MRP run. > > > Key: OFBIZ-10388 > URL: https://issues.apache.org/jira/browse/OFBIZ-10388 > Project: OFBiz > Issue Type: Bug > Components: manufacturing >Affects Versions: 16.11.04 > Environment: OS: Windows Server 2008 R2 > Database: MySQL 5.7 > JDK: 1.8.0_131 >Reporter: Schumann Ye >Priority: Major > Attachments: mrp_result.PNG > > > I have done the following: > 1. I created a finished goods (with BOM) with 3 raw materials. > 2. Routings tasks & routings and product linkage are all done correctly; > 3. When the requirement method id of the product is set to "When QOH reaches > minimum stock for Product-Facility" and minimum stock of the product > facility is maintained with a certain figure, after MRP is run, I have got > the expected Production Run. > Here below is where I don't understand: > 4. After successfully creating a sales order with the product requirement (30 > pcs), I can see the total ATP becomes negative figure (e.g. -30) because I > don't have enough stock to cover the needed quantity required by the created > sales order. > 5. Then I go to Manufacturing to check MRP running result, it shows me only > the proposed manufacturing order receipt with 5 pcs (as set in the minimum > stock) as shown in the attached png file. > 6. My question is, where is the expected 30 pcs with the expected production > run? > P.S.: I have also tried every single sort of requirement method id in the > Catalog-Product-Inventory but it simply did not work as expected. > Pls help. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (OFBIZ-10388) Production Run is not created after MRP run.
[ https://issues.apache.org/jira/browse/OFBIZ-10388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Schumann Ye closed OFBIZ-10388. --- Resolution: Fixed It's purely my mistake. Now the issue is solved. > Production Run is not created after MRP run. > > > Key: OFBIZ-10388 > URL: https://issues.apache.org/jira/browse/OFBIZ-10388 > Project: OFBiz > Issue Type: Bug > Components: manufacturing >Affects Versions: 16.11.04 > Environment: OS: Windows Server 2008 R2 > Database: MySQL 5.7 > JDK: 1.8.0_131 >Reporter: Schumann Ye >Priority: Major > Attachments: mrp_result.PNG > > > I have done the following: > 1. I created a finished goods (with BOM) with 3 raw materials. > 2. Routings tasks & routings and product linkage are all done correctly; > 3. When the requirement method id of the product is set to "When QOH reaches > minimum stock for Product-Facility" and minimum stock of the product > facility is maintained with a certain figure, after MRP is run, I have got > the expected Production Run. > Here below is where I don't understand: > 4. After successfully creating a sales order with the product requirement (30 > pcs), I can see the total ATP becomes negative figure (e.g. -30) because I > don't have enough stock to cover the needed quantity required by the created > sales order. > 5. Then I go to Manufacturing to check MRP running result, it shows me only > the proposed manufacturing order receipt with 5 pcs (as set in the minimum > stock) as shown in the attached png file. > 6. My question is, where is the expected 30 pcs with the expected production > run? > P.S.: I have also tried every single sort of requirement method id in the > Catalog-Product-Inventory but it simply did not work as expected. > Pls help. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (OFBIZ-10388) Production Run is not created after MRP run.
Schumann Ye created OFBIZ-10388: --- Summary: Production Run is not created after MRP run. Key: OFBIZ-10388 URL: https://issues.apache.org/jira/browse/OFBIZ-10388 Project: OFBiz Issue Type: Bug Components: manufacturing Affects Versions: 16.11.04 Environment: OS: Windows Server 2008 R2 Database: MySQL 5.7 JDK: 1.8.0_131 Reporter: Schumann Ye Attachments: mrp_result.PNG I have done the following: 1. I created a finished goods (with BOM) with 3 raw materials. 2. Routings tasks & routings and product linkage are all done correctly; 3. When the requirement method id of the product is set to "When QOH reaches minimum stock for Product-Facility" and minimum stock of the product facility is maintained with a certain figure, after MRP is run, I have got the expected Production Run. Here below is where I don't understand: 4. After successfully creating a sales order with the product requirement (30 pcs), I can see the total ATP becomes negative figure (e.g. -30) because I don't have enough stock to cover the needed quantity required by the created sales order. 5. Then I go to Manufacturing to check MRP running result, it shows me only the proposed manufacturing order receipt with 5 pcs (as set in the minimum stock) as shown in the attached png file. 6. My question is, where is the expected 30 pcs with the expected production run? P.S.: I have also tried every single sort of requirement method id in the Catalog-Product-Inventory but it simply did not work as expected. Pls help. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (OFBIZ-10321) Multi-level BOM (same raw MM in different level) MRP not supportive
Schumann Ye created OFBIZ-10321:
---
Summary: Multi-level BOM (same raw MM in different level) MRP not
supportive
Key: OFBIZ-10321
URL: https://issues.apache.org/jira/browse/OFBIZ-10321
Project: OFBiz
Issue Type: Bug
Components: manufacturing
Affects Versions: 16.11.04, Release Branch 16.11
Environment: OS: Windows Server 2008 R2
Database: MySQL 5.7
JDK: 1.8.0_131
Reporter: Schumann Ye
For MRP funciton in Manufacturing Manager, I intentionally created a BOM as
follows:
Level 0: Table (Qty 1, finished goods)
Level 1: Wood (Qty 5, raw material)
Level 1: Nails (Qty 20, raw material)
Level 1: Varnish (Qty 1, raw material)
Level 1: TableBoardCover (Qty 1, finished goods)
Level 2: Wood (Qty 1, raw material)
I've done all routing tasks associated with routings and linked with products.
Everything is ok but when I run MRP, I get the following error messages:
Code below:
{code}
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:INSERT INTO MRP_EVENT (MRP_ID, PRODUCT_ID,
EVENT_DATE, MRP_EVENT_TYPE_ID, FACILITY_ID, QUANTI
TY, EVENT_NAME, IS_LATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
(Duplicate entry '10008-{color:#f79232}10010{color}-2018-03-29 16:03:39-MRP_R
EQUIREMENT' for key 'PRIMARY')
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883)
~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:73)
~[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.InventoryEventPlannedServices.createOrUpdateMrpEvent(InventoryEventPlannedServices.java:77)
~[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.processBomComponent(MrpServices.java:568)
~[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:799)
~[ofbiz.jar:?]
... 14 more
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry '10008-{color:#f79232}10010{color}-2018-03-29
16:03:39-MRP_REQUIREMENT' for key 'PRIMARY'
at sun.reflect.GeneratedConstructorAccessor179.newInstance(Unknown
Source) ~[?:?]
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[?:1.8.0_131]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
~[?:1.8.0_131]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at com.mysql.jdbc.Util.getInstance(Util.java:408)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at
com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at
com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at
com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
~[mysql-connector-java-5.1.44-bin.jar:5.1.44]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
o
[jira] [Created] (OFBIZ-10320) A potential bug in Email ForgotPassword Notification
Schumann Ye created OFBIZ-10320:
---
Summary: A potential bug in Email ForgotPassword Notification
Key: OFBIZ-10320
URL: https://issues.apache.org/jira/browse/OFBIZ-10320
Project: OFBiz
Issue Type: Bug
Affects Versions: 16.11.04
Environment: OS: Windows Server 2008 R2
Database: MySQL 5.7
JDK: 1.8.0_131
Reporter: Schumann Ye
Work Steps:
# In the login page: [https://www.myowndomain.com/webtools/control/main], then
click login, then click "forget your passwords".
# Then fill in the User Name that I have already created before, which is
associated with a primary email address.
# Then click "continue" and then hit "email password";
# As I have set the fields correctly in the file general.properties and also
in database table ofbiz.system_property, I receive a system email telling me to
"click here to reset password" with a link.
Then click the link and following the instructions to fill in the new passwords
and then the following error messages pop up. Generally speaking, the error is
about java.lang.NullPointerException.
(BTW, I tried it a couple of times with different locales like en and zh_CN but
all failed.)
Here below I highlighted somethings strange, where I have added some debugging
texts (in yellow background) to see what's going on.
Obviously, in my debugging text Tag ---801--- the keyValue is missing (null).
Maybe that's why it throws a java.lang.NullPointerException.
However, when I compare the codes (where it concerns) of EntityCrypto.java and
LoginWorker.java between 11.04 and 11.03, {color:#f79232}I could not find the
difference So I do NOT understand why it works in my 11.03 but not 11.04.{color}
2018-03-28 10:00:59,870 |http-nio-443-exec-4 |ServerHitBin
|I| Visit delegatorName=default, ServerHitBin delegatorName=default
2018-03-28 10:00:59,878 |http-nio-443-exec-4 |ControlServlet
|T| [[[forgotPassword_step2(Domain:https://www.myowndomain.com)] Request Done-
total:0.146,since last([forgotPassword_s...):0.146]]
2018-03-28 10:01:02,961 |http-nio-443-exec-1 |ControlServlet
|T| [[[forgotPassword_step3(Domain:https://www.myowndomain.com)] Request Begun,
encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
{color:#f79232}2018-03-28 10:01:02,988 |http-nio-443-exec-1 |EntityCrypto
|I| ---804---originalKeyName---is---loginSecretKeyString{color}
{color:#f79232}2018-03-28 10:01:02,988 |http-nio-443-exec-1 |EntityCrypto
|I| ---805---originalKeyName---is---loginSecretKeyString{color}
{color:#f79232}2018-03-28 10:01:02,988 |http-nio-443-exec-1 |EntityCrypto
|I|
[---806---hashRequest---is---org.apache.shiro.crypto.hash.SimpleHashRequest@327dc55e|mailto:---806---hashRequest---is---org.apache.shiro.crypto.hash.SimpleHashRequest@327dc55e]{color}
2018-03-28 10:01:03,066 |http-nio-443-exec-1 |ServiceDispatcher
|I| Service auth failed for userLoginId [MyCreatedUser] because UserLogin
record currentPassword fields did not match; note that the UserLogin object
passed into a service may need to have the currentPassword encrypted.
2018-03-28 10:01:03,067 |http-nio-443-exec-1 |ServiceDispatcher
|T| Sync service [order/getUserPreferenceGroup] finished in [2] milliseconds
2018-03-28 10:01:03,076 |http-nio-443-exec-1 |ScreenFactory
|I| Got 1 screens in 0.009s from:
file:/D:/apache-ofbiz-16.11.04/applications/securityext/widget/EmailSecurityScreens.xml
2018-03-28 10:01:03,137 |http-nio-443-exec-1 |UtilProperties
|I| ResourceBundle EmailPasswordUiLabels (en) created in 0.061s with 6
properties
2018-03-28 10:01:03,217 |http-nio-443-exec-1 |UtilProperties
|I| ResourceBundle SecurityUiLabels (en) created in 0.08s with 58 properties
2018-03-28 10:01:03,238 |http-nio-443-exec-1 |EmailServices
|I| Expanded email subject to: New Password Sent (MyCreatedUser)
2018-03-28 10:01:07,710 |http-nio-443-exec-1 |ServiceDispatcher
|T| Sync service [order/sendMailHiddenInLog] finished in [4471] milliseconds
2018-03-28 10:01:07,711 |http-nio-443-exec-1 |ServiceDispatcher
|T| Sync service [order/sendMailHiddenInLogFromScreen] finished in [4678]
milliseconds
2018-03-28 10:01:07,722 |http-nio-443-exec-1 |RequestHandler
|I| Ran Event
[java:org.apache.ofbiz.securityext.login.LoginEvents#forgotPassword] from
[request], result is [success]
2018-03-28 10:01:07,738 |http-nio-443-exec-1 |ConfigXMLReader
|I| controller loaded: 0.001s, 16 requests, 14 views in
file:/D:/apache-ofbiz-16.11.04/specialpurpose/birt/webapp/ordermgr/WEB-INF/controller.xml
2018-03-28 10:01:07,763 |http-nio-443-exec-1 |ConfigXMLReader
|I| controller loaded: 0.006s, 367 requests, 147 views in
file:/D:/apache-ofbiz
