[jira] [Created] (OFBIZ-7797) Bug in OfbizSetup Create Customer Step

[Nicolas Malin (Jira)]

Derek Lew created OFBIZ-7797:
--------------------------------

             Summary: Bug in OfbizSetup Create Customer Step
                 Key: OFBIZ-7797
                 URL: https://issues.apache.org/jira/browse/OFBIZ-7797
             Project: OFBiz
          Issue Type: Bug
          Components: commonext/setup
    Affects Versions: Release Branch 15.12, Trunk, Release Branch 14.12
         Environment: Windows 10
            Reporter: Derek Lew


When running the OFBiz Setup Application, the following exception was thrown.


The Following Errors Occurred:
ERROR: Could not complete the Create Customer [file:/E:/OfBiz14.12/applications/commonext/script/org/ofbiz/setup/SetupEvents.xml#createOrganization] process [problem invoking the [createCustomTimePeriod] service with the map named [customTimePeriodCtx] containing [{fromDate=2016-01-01, periodNum=1, userLogin=[GenericEntity:UserLogin][createdStamp,2016-07-13 18:19:01.72(java.sql.Timestamp)][createdTxStamp,2016-07-13 18:19:01.608(java.sql.Timestamp)][currentPassword,$SHA$wN7vvoeHKomFb$fhBdrGDkWvhPdxOX3PW8g1ucPP4(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2016-07-13 18:19:52.017(java.sql.Timestamp)][lastUpdatedTxStamp,2016-07-13 18:19:51.994(java.sql.Timestamp)][partyId,null()][passwordHint,null()][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLdapDn,null()][userLoginId,admin(java.lang.String)], isClosed=N, periodTypeId=FISCAL_YEAR, organizationPartyId=10006, periodName=2016, locale=en_US, thruDate=2016-12-31}]: Type check failed for field [createCustomTimePeriod.fromDate]; expected type is [java.sql.Timestamp]; actual type is [java.sql.Date]Type check failed for field [createCustomTimePeriod.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.sql.Date]]
•

In \applications\commonext\script\org\ofbiz\setup\SetupEvents.xml

250       <set field="customTimePeriodCtx.fromDate" from-field="fromDateStamp" type="Date"/>
251       <set field="customTimePeriodCtx.thruDate" value="${groovy:org.ofbiz.base.util.UtilDateTime.toSqlDate(endMonth ,endDate , curYearString)}" type="Date"/>

Need to change to:

250        <set field="customTimePeriodCtx.fromDate" from-field="fromDateStamp" type="java.sql.Timestamp"/>
251        <set field="customTimePeriodCtx.thruDate" value="${groovy:org.ofbiz.base.util.UtilDateTime.toSqlDate(endMonth ,endDate , curYearString)}" type="java.sql.Timestamp"/>





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)