> 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 14.12, Trunk, Release Branch 15.12
> Environment: Windows 10
> Reporter: Derek Lew
> Assignee: Jacques Le Roux
>
> 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"/>
Locked
