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

[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-----

[Jacques Le Roux]

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
>

[Jacques Le Roux]

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
>

[porkiey]

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: [phone]
Fax: [phone]
Mobile: [phone]
E-mail: [hidden email]