Bug in OfbizSetup Create Customer Step

[Derek Lew-2]

Type: Bug

Affects Versions: Trunk, 14.12

 

Description:

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/SetupEven
ts.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$fhBdrGD
kWvhPdxOX3PW8g1ucPP4(java.lang.String)][disabledDateTime,null()][enabled,Y(j
ava.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,null(
)][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdat
edStamp,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()][requi
rePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Lon
g)][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"/>

 

 

Best regards.
 
Derek Lew

 

[Jacques Le Roux]

Could you please create a Jira issue following https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best+Practices ?

Thanks

Jacques


Le 15/07/2016 à 03:21, Derek Lew a écrit :

> Type: Bug
>
> Affects Versions: Trunk, 14.12
>
>  
>
> Description:
>
> 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/SetupEven
> ts.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$fhBdrGD
> kWvhPdxOX3PW8g1ucPP4(java.lang.String)][disabledDateTime,null()][enabled,Y(j
> ava.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,null(
> )][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdat
> edStamp,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()][requi
> rePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Lon
> g)][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"/>
>
>  
>
>  
>
> Best regards.
>    
> Derek Lew
>
>  
>
>

[Derek Lew-2]

OFBIZ-7797

Best regards.
 
Derek Lew


-----Original Message-----
From: Jacques Le Roux [mailto:[hidden email]]
Sent: Friday, 15 July 2016 12:10 PM
To: [hidden email]
Subject: Re: Bug in OfbizSetup Create Customer Step

Could you please create a Jira issue following
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best
+Practices ?

Thanks

Jacques


Le 15/07/2016 à 03:21, Derek Lew a écrit :

> Type: Bug
>
> Affects Versions: Trunk, 14.12
>
>  
>
> Description:
>
> 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/Set
> upEven ts.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$f
> hBdrGD
> kWvhPdxOX3PW8g1ucPP4(java.lang.String)][disabledDateTime,null()][enabl
> ed,Y(j
> ava.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem
> ,null(
> )][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][las
> tUpdat
> edStamp,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()]
> [requi
> rePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.la
> ng.Lon g)][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"/>
>
>  
>
>  
>
> Best regards.
>    
> Derek Lew
>
>  
>
>