Error with HR module

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Error with HR module

porkiey
I was just adding a new employee into the following page:
https://demo.hotwaxmedia.com/humanres/control/createEmployee

got this nice error:
The Following Errors Occurred:

Error:Error:Error:ERROR: Could not complete the Create Contact Mechanism [file:/demo/deployments/demo.hotwaxmedia.com/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:ContactMech][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)][createdStamp,2008-12-31 03:46:06.696(java.sql.Timestamp)][createdTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)][lastUpdatedStamp,2008-12-31 03:46:06.696(java.sql.Timestamp)][lastUpdatedTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Column 'CONTACT_MECH_ID' cannot accept a NULL value.))] calling service createContactMech in createPostalAddress calling service createPostalAddress in createPartyPostalAddress calling service createPartyPostalAddress in createPartyContactMechs

Checked and i dont think there was anything strange in the data i was trying to submit.

Cheers
Sam
Reply | Threaded
Open this post in threaded view
|

Re: Error with HR module

BJ Freeman
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

(Column 'CONTACT_MECH_ID' cannot accept a NULL value.)
have to follow the change to see where this is not being supplied


Sam Hamilton sent the following on 12/31/2008 1:43 AM:
> I was just adding a new employee into the following page:
> https://demo.hotwaxmedia.com/humanres/control/createEmployee
>
> got this nice error:
> The Following Errors Occurred:
>
> Error:Error:Error:ERROR: Could not complete the Create Contact Mechanism [file:/demo/deployments/demo.hotwaxmedia.com/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:ContactMech][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)][createdStamp,2008-12-31 03:46:06.696(java.sql.Timestamp)][createdTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)][lastUpdatedStamp,2008-12-31 03:46:06.696(java.sql.Timestamp)][lastUpdatedTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Column 'CONTACT_MECH_ID' cannot accept a NULL value.))] calling service createContactMech in createPostalAddress calling service createPostalAddress
 in createPartyPostalAddress calling service createPartyPostalAddress in createPartyContactMechs
>
> Checked and i dont think there was anything strange in the data i was trying to submit.
>
> Cheers
> Sam
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJW2jZrP3NbaWWqE4RAiRsAJ0UKNiK5DVVir474J+TtXyhgPIsEQCfSutM
nY2y37JOheFkwm3U2Be0MYM=
=Nd6M
-----END PGP SIGNATURE-----
Reply | Threaded
Open this post in threaded view
|

Re: Error with HR module

Jacques Le Roux
Administrator
In reply to this post by porkiey
Fixed in revision: 730397 . This is due to recent changes in simple-method tags
It needs more work, I'm looking at it

Jacques

From: "Sam Hamilton" <[hidden email]>

>I was just adding a new employee into the following page:
> https://demo.hotwaxmedia.com/humanres/control/createEmployee
>
> got this nice error:
> The Following Errors Occurred:
>
> Error:Error:Error:ERROR: Could not complete the Create Contact Mechanism
> [file:/demo/deployments/demo.hotwaxmedia.com/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech]
> process [problem creating the newValue value: Error while inserting:
> [GenericEntity:ContactMech][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)][createdStamp,2008-12-31
> 03:46:06.696(java.sql.Timestamp)][createdTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)][lastUpdatedStamp,2008-12-31
> 03:46:06.696(java.sql.Timestamp)][lastUpdatedTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)] (SQL Exception while executing
> the following:INSERT INTO OFBIZ.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Column 'CONTACT_MECH_ID' cannot accept a
> NULL value.))] calling service createContactMech in createPostalAddress calling service createPostalAddress in
> createPartyPostalAddress calling service createPartyPostalAddress in createPartyContactMechs
>
> Checked and i dont think there was anything strange in the data i was trying to submit.
>
> Cheers
> Sam
>

Reply | Threaded
Open this post in threaded view
|

Re: Error with HR module

Jacques Le Roux
Administrator
In reply to this post by porkiey
This (and other related errors) should be definitively fixed in 730433

Jacques

From: "Sam Hamilton" <[hidden email]>

>I was just adding a new employee into the following page:
> https://demo.hotwaxmedia.com/humanres/control/createEmployee
>
> got this nice error:
> The Following Errors Occurred:
>
> Error:Error:Error:ERROR: Could not complete the Create Contact Mechanism
> [file:/demo/deployments/demo.hotwaxmedia.com/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech]
> process [problem creating the newValue value: Error while inserting:
> [GenericEntity:ContactMech][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)][createdStamp,2008-12-31
> 03:46:06.696(java.sql.Timestamp)][createdTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)][lastUpdatedStamp,2008-12-31
> 03:46:06.696(java.sql.Timestamp)][lastUpdatedTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)] (SQL Exception while executing
> the following:INSERT INTO OFBIZ.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Column 'CONTACT_MECH_ID' cannot accept a
> NULL value.))] calling service createContactMech in createPostalAddress calling service createPostalAddress in
> createPartyPostalAddress calling service createPartyPostalAddress in createPartyContactMechs
>
> Checked and i dont think there was anything strange in the data i was trying to submit.
>
> Cheers
> Sam
>

Reply | Threaded
Open this post in threaded view
|

Re: Error with HR module

porkiey
In reply to this post by Jacques Le Roux
Thanks Jacques


On 31/12/2008 22:00, "Jacques Le Roux" <[hidden email]> wrote:

Fixed in revision: 730397 . This is due to recent changes in simple-method tags
It needs more work, I'm looking at it

Jacques

From: "Sam Hamilton" <[hidden email]>

>I was just adding a new employee into the following page:
> https://demo.hotwaxmedia.com/humanres/control/createEmployee
>
> got this nice error:
> The Following Errors Occurred:
>
> Error:Error:Error:ERROR: Could not complete the Create Contact Mechanism
> [file:/demo/deployments/demo.hotwaxmedia.com/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech]
> process [problem creating the newValue value: Error while inserting:
> [GenericEntity:ContactMech][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)][createdStamp,2008-12-31
> 03:46:06.696(java.sql.Timestamp)][createdTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)][lastUpdatedStamp,2008-12-31
> 03:46:06.696(java.sql.Timestamp)][lastUpdatedTxStamp,2008-12-31 03:46:06.658(java.sql.Timestamp)] (SQL Exception while executing
> the following:INSERT INTO OFBIZ.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Column 'CONTACT_MECH_ID' cannot accept a
> NULL value.))] calling service createContactMech in createPostalAddress calling service createPostalAddress in
> createPartyPostalAddress calling service createPartyPostalAddress in createPartyContactMechs
>
> Checked and i dont think there was anything strange in the data i was trying to submit.
>
> Cheers
> Sam
>



Sam Hamilton
CTO
Virtual Village

Tel: +86 (21) 6271 3051
Fax: +86 (21) 6271 3021
Mobile: +86 (135) 2451 4480
E-mail: [hidden email]