Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-7626

Getting error on closing or re-opening the project

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: Release Branch 14.12, Trunk, Release Branch 15.12
    • Fix Version/s: Trunk
    • Component/s: scrum
    • Labels:
      None

      Description

      Steps to regenerate issue:
      1. Navigate to 'SCRUM' -> 'Project/Sprint'.
      2. Open an existing project or create one.
      3. Press 'Close' button.

      The Following error occurred:

      [java] 2016-06-21 12:05:50,649 |http-nio-8443-exec-1 |GenericDelegator              |E| Failure in create operation for entity [WorkEffortGoodStandard]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortGoodStandard][createdStamp,2016-06-21 12:05:50.649(java.sql.Timestamp)][createdTxStamp,2016-06-21 12:05:50.502(java.sql.Timestamp)][fromDate,2016-06-21 12:05:50.574(java.sql.Timestamp)][lastUpdatedStamp,2016-06-21 12:05:50.649(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-21 12:05:50.502(java.sql.Timestamp)][statusId,WEGS_CREATED(java.lang.String)][workEffortGoodStdTypeId,SCRUM_PRO_WORKEFF(java.lang.String)][workEffortId,DEMO-PROJECT-1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_GOOD_STANDARD (WORK_EFFORT_ID, PRODUCT_ID, WORK_EFFORT_GOOD_STD_TYPE_ID, FROM_DATE, THRU_DATE, STATUS_ID, ESTIMATED_QUANTITY, ESTIMATED_COST, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'PRODUCT_ID'  cannot accept a NULL value.)). Rolling back transaction.
           [java] 2016-06-21 12:05:50,649 |http-nio-8443-exec-1 |TransactionUtil               |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
           [java] java.lang.Exception: Failure in create operation for entity [WorkEffortGoodStandard]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortGoodStandard][createdStamp,2016-06-21 12:05:50.649(java.sql.Timestamp)][createdTxStamp,2016-06-21 12:05:50.502(java.sql.Timestamp)][fromDate,2016-06-21 12:05:50.574(java.sql.Timestamp)][lastUpdatedStamp,2016-06-21 12:05:50.649(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-21 12:05:50.502(java.sql.Timestamp)][statusId,WEGS_CREATED(java.lang.String)][workEffortGoodStdTypeId,SCRUM_PRO_WORKEFF(java.lang.String)][workEffortId,DEMO-PROJECT-1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_GOOD_STANDARD (WORK_EFFORT_ID, PRODUCT_ID, WORK_EFFORT_GOOD_STD_TYPE_ID, FROM_DATE, THRU_DATE, STATUS_ID, ESTIMATED_QUANTITY, ESTIMATED_COST, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'PRODUCT_ID'  cannot accept a NULL value.)). Rolling back transaction.
           [java] 	at org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:360) [ofbiz-entity.jar:?]
           [java] 	at org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:301) [ofbiz-entity.jar:?]
           [java] 	at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:925) [ofbiz-entity.jar:?]
           [java] 	at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:770) [ofbiz-entity.jar:?]
           [java] 	at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) [ofbiz-minilang.jar:?]
           [java] 	at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:305) [ofbiz-minilang.jar:?]
           [java] 	at org.ofbiz.minilang.method.conditional.MasterIf.exec(MasterIf.java:81) [ofbiz-minilang.jar:?]
           [java] 	at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:305) [ofbiz-minilang.jar:?]
           [java] 	at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:452) [ofbiz-minilang.jar:?]
           [java] 	at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:269) [ofbiz-minilang.jar:?]
           [java] 	at org.ofbiz.minilang.SimpleMethod.runSimpleEvent(SimpleMethod.java:252) [ofbiz-minilang.jar:?]
           [java] 	at org.ofbiz.webapp.event.SimpleEventHandler.invoke(SimpleEventHandler.java:75) [ofbiz-webapp.jar:?]
           [java] 	at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:757) [ofbiz-webapp.jar:?]
           [java] 	at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:477) [ofbiz-webapp.jar:?]
           [java] 	at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:210) [ofbiz-webapp.jar:?]
           [java] 	at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:89) [ofbiz-webapp.jar:?]
           [java] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) [servlet-api-3.1.jar:?]
           [java] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [servlet-api-3.1.jar:?]
           [java] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:326) [ofbiz-webapp.jar:?]
           [java] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522) [tomcat-8.0.33-catalina.jar:8.0.33]
           [java] 	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095) [tomcat-8.0.33-tomcat-coyote.jar:8.0.33]
           [java] 	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672) [tomcat-8.0.33-tomcat-coyote.jar:8.0.33]
           [java] 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502) [tomcat-8.0.33-tomcat-coyote.jar:8.0.33]
           [java] 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458) [tomcat-8.0.33-tomcat-coyote.jar:8.0.33]
           [java] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_60]
           [java] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_60]
           [java] 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-8.0.33-tomcat-util.jar:8.0.33]
           [java] 	at java.lang.Thread.run(Thread.java:745) [?:1.8.0_60]
           [java] 2016-06-21 12:05:50,649 |http-nio-8443-exec-1 |CreateValue
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                aditi17 Aditi Patidar
                Reporter:
                aditi17 Aditi Patidar
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: