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

Error on closing and re-opening of project

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Release Branch 14.12, Trunk, Release Branch 15.12
    • Fix Version/s: Trunk, 14.12.01, 15.12.01
    • Component/s: scrum
    • Labels:
      None

      Description

      Steps to regenerate:

      • Go to the Scrum component and select a project (https://localhost:8443/scrum/control/viewScrumProject?projectId=DEMO-PROJECT-1)
      • Close the project
      • The following error is shown:
        The Following Errors Occurred:
        Exception thrown while creating the "goodStandardMap" GenericValue: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortGoodStandard][createdStamp,2016-06-09 12:16:46.65(java.sql.Timestamp)][createdTxStamp,2016-06-09 12:16:46.248(java.sql.Timestamp)][fromDate,2016-06-09 12:16:46.489(java.sql.Timestamp)][lastUpdatedStamp,2016-06-09 12:16:46.65(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-09 12:16:46.248(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.)) (Error while inserting: [GenericEntity:WorkEffortGoodStandard][createdStamp,2016-06-09 12:16:46.65(java.sql.Timestamp)][createdTxStamp,2016-06-09 12:16:46.248(java.sql.Timestamp)][fromDate,2016-06-09 12:16:46.489(java.sql.Timestamp)][lastUpdatedStamp,2016-06-09 12:16:46.65(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-09 12:16:46.248(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.)))
        

        Attachments

        1. OFBIZ-7262.patch
          1 kB
          Anurag Chandak

          Issue Links

            Activity

              People

              • Assignee:
                arunpati Arun Patidar
                Reporter:
                anurag.chandak@hotwaxsystems.com Anurag Chandak
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: