Hello3-error while loading seed data

[Arshitha K M]

hi,
I am new to ofbiz. I  met trouble during loading the seed data(hello3),

The Following Errors Occurred:
ERROR: parsing file: ERROR parsing Entity Xml file:
org.xml.sax.SAXException: A transaction error occurred reading
data<br/>org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:HelloHobby][createdStamp,2019-04-29
12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29
12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29
12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29
12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the
following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL
value.))
the entity i want to load seed data is having only two columns HelloHobbyId
and Description,i did'nt get that,why error message showing as
'HelloPersonId' cannot accept a null value.

I tried to load seed data into another entity HelloPerson and that was
successful.
Could you please help me to fix the error.

[Pierre Smits-3]

Please check your entity definition and compare that against what you want
to inject in the table.

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Mon, Apr 29, 2019 at 11:24 AM Arshitha K M <[hidden email]> wrote:

> hi,
> I am new to ofbiz. I  met trouble during loading the seed data(hello3),
>
> The Following Errors Occurred:
> ERROR: parsing file: ERROR parsing Entity Xml file:
> org.xml.sax.SAXException: A transaction error occurred reading
> data<br/>org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:HelloHobby][createdStamp,2019-04-29
> 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29
>
> 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29
> 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29
> 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the
> following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL
> value.))
> the entity i want to load seed data is having only two columns HelloHobbyId
> and Description,i did'nt get that,why error message showing as
> 'HelloPersonId' cannot accept a null value.
>
> I tried to load seed data into another entity HelloPerson and that was
> successful.
> Could you please help me to fix the error.
>

[Jacques Le Roux]

Hi,

Your message has been moderated.

Please subscribe to the user ML for such questions and then use your email client
See also why here http://ofbiz.apache.org/mailing-lists.html

You will get a better support , it's more fair to share with everybody  and people can answer you on the ML rather than directly to you
The wider the audience the better the answers you might get

Also it's more work for moderators who have to accept your messages as long as you have not subscribed.
I'll personally no longer accept them (other moderators still could)

Thanks

Jacques

Le 29/04/2019 à 09:45, Arshitha K M a écrit :

> hi,
> I am new to ofbiz. I  met trouble during loading the seed data(hello3),
>
> The Following Errors Occurred:
> ERROR: parsing file: ERROR parsing Entity Xml file:
> org.xml.sax.SAXException: A transaction error occurred reading
> data<br/>org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:HelloHobby][createdStamp,2019-04-29
> 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29
> 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29
> 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29
> 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the
> following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL
> value.))
> the entity i want to load seed data is having only two columns HelloHobbyId
> and Description,i did'nt get that,why error message showing as
> 'HelloPersonId' cannot accept a null value.
>
> I tried to load seed data into another entity HelloPerson and that was
> successful.
> Could you please help me to fix the error.
>

[Aditya Sharma]

Hi Arshitha,

I suspect that either you have defined the entity at two places or maybe
previously you had an entity with the same name but with field
HelloHobbyId as "not null".

HTH

Thanks and Regards,
*Aditya Sharma* | Enterprise Software Engineer
HotWax Systems <http://www.hotwaxsystems.com/>
Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore,
M.P 452010
Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/>



On Mon, Apr 29, 2019 at 3:30 PM Jacques Le Roux <
[hidden email]> wrote:

> Hi,
>
> Your message has been moderated.
>
> Please subscribe to the user ML for such questions and then use your email
> client
> See also why here http://ofbiz.apache.org/mailing-lists.html
>
> You will get a better support , it's more fair to share with everybody
> and people can answer you on the ML rather than directly to you
> The wider the audience the better the answers you might get
>
> Also it's more work for moderators who have to accept your messages as
> long as you have not subscribed.
> I'll personally no longer accept them (other moderators still could)
>
> Thanks
>
> Jacques
>
> Le 29/04/2019 à 09:45, Arshitha K M a écrit :
> > hi,
> > I am new to ofbiz. I  met trouble during loading the seed data(hello3),
> >
> > The Following Errors Occurred:
> > ERROR: parsing file: ERROR parsing Entity Xml file:
> > org.xml.sax.SAXException: A transaction error occurred reading
> > data<br/>org.ofbiz.entity.GenericEntityException:
> > org.ofbiz.entity.GenericEntityException:
> > org.ofbiz.entity.GenericEntityException: Error while inserting:
> > [GenericEntity:HelloHobby][createdStamp,2019-04-29
> > 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29
> >
> 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29
> > 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29
> > 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the
> > following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION,
> > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP)
> > VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL
> > value.))
> > the entity i want to load seed data is having only two columns
> HelloHobbyId
> > and Description,i did'nt get that,why error message showing as
> > 'HelloPersonId' cannot accept a null value.
> >
> > I tried to load seed data into another entity HelloPerson and that was
> > successful.
> > Could you please help me to fix the error.
> >
>

[Deepak Dixit-4]

Hi Arshita,

Could you please share the entity definitions?

If you are modifying entity definition, please make sure to alter the
database table. As ofbiz does not alter the table if pk is added or
modified, or column size changed.

You need to run a manual query to alter the table.

Kind Regards,
Deepak Dixit
DIRECTOR OF PRODUCT ENGINEERING
mobile: [phone]
email: [hidden email]
*www.hotwax.co <http://www.hotwax.co/>*


On Mon, Apr 29, 2019 at 3:47 PM Aditya Sharma <
[hidden email]> wrote:

> Hi Arshitha,
>
> I suspect that either you have defined the entity at two places or maybe
> previously you had an entity with the same name but with field
> HelloHobbyId as "not null".
>
> HTH
>
> Thanks and Regards,
> *Aditya Sharma* | Enterprise Software Engineer
> HotWax Systems <http://www.hotwaxsystems.com/>
> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> Indore,
> M.P 452010
> Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/>
>
>
>
> On Mon, Apr 29, 2019 at 3:30 PM Jacques Le Roux <
> [hidden email]> wrote:
>
> > Hi,
> >
> > Your message has been moderated.
> >
> > Please subscribe to the user ML for such questions and then use your
> email
> > client
> > See also why here http://ofbiz.apache.org/mailing-lists.html
> >
> > You will get a better support , it's more fair to share with everybody
> > and people can answer you on the ML rather than directly to you
> > The wider the audience the better the answers you might get
> >
> > Also it's more work for moderators who have to accept your messages as
> > long as you have not subscribed.
> > I'll personally no longer accept them (other moderators still could)
> >
> > Thanks
> >
> > Jacques
> >
> > Le 29/04/2019 à 09:45, Arshitha K M a écrit :
> > > hi,
> > > I am new to ofbiz. I  met trouble during loading the seed data(hello3),
> > >
> > > The Following Errors Occurred:
> > > ERROR: parsing file: ERROR parsing Entity Xml file:
> > > org.xml.sax.SAXException: A transaction error occurred reading
> > > data<br/>org.ofbiz.entity.GenericEntityException:
> > > org.ofbiz.entity.GenericEntityException:
> > > org.ofbiz.entity.GenericEntityException: Error while inserting:
> > > [GenericEntity:HelloHobby][createdStamp,2019-04-29
> > > 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29
> > >
> >
> 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29
> > > 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29
> > > 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the
> > > following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION,
> > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> > CREATED_TX_STAMP)
> > > VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a
> NULL
> > > value.))
> > > the entity i want to load seed data is having only two columns
> > HelloHobbyId
> > > and Description,i did'nt get that,why error message showing as
> > > 'HelloPersonId' cannot accept a null value.
> > >
> > > I tried to load seed data into another entity HelloPerson and that was
> > > successful.
> > > Could you please help me to fix the error.
> > >
> >
>

[Aditya Sharma]

Sorry for the noise. I was redirecting to the user mailing list.

Thanks and Regards,
*Aditya Sharma* | Enterprise Software Engineer
HotWax Systems <http://www.hotwaxsystems.com/>
Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore,
M.P 452010
Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/>



On Mon, Apr 29, 2019 at 6:41 PM Aditya Sharma <
[hidden email]> wrote:

> Hi Arshitha,
>
> It would be better if you could please subscribe to user ML first.
> See also why here http://ofbiz.apache.org/mailing-lists.html
>
>
> Please check the database for the table definition.
>
> Thanks and Regards,
> *Aditya Sharma* | Enterprise Software Engineer
> HotWax Systems <http://www.hotwaxsystems.com/>
> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> Indore, M.P 452010
> Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/>
>
>
>
> On Mon, Apr 29, 2019 at 6:35 PM Arshitha K M <[hidden email]> wrote:
>
>> Hello Aditya Sharma,
>>  thank you for your email, I have checked the entity definition nothing
>> found as you mentioned in your mail.
>> Best regards,
>> Arshitha K.M
>>
>>
>>
>>
>> On Mon 29 Apr, 2019, 3:47 PM Aditya Sharma, <
>> [hidden email]> wrote:
>>
>>> Hi Arshitha,
>>>
>>> I suspect that either you have defined the entity at two places or maybe
>>> previously you had an entity with the same name but with field
>>> HelloHobbyId as "not null".
>>>
>>> HTH
>>>
>>> Thanks and Regards,
>>> *Aditya Sharma* | Enterprise Software Engineer
>>> HotWax Systems <http://www.hotwaxsystems.com/>
>>> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
>>> Indore, M.P 452010
>>> Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/>
>>>
>>>
>>>
>>> On Mon, Apr 29, 2019 at 3:30 PM Jacques Le Roux <
>>> [hidden email]> wrote:
>>>
>>>> Hi,
>>>>
>>>> Your message has been moderated.
>>>>
>>>> Please subscribe to the user ML for such questions and then use your
>>>> email client
>>>> See also why here http://ofbiz.apache.org/mailing-lists.html
>>>>
>>>> You will get a better support , it's more fair to share with everybody
>>>> and people can answer you on the ML rather than directly to you
>>>> The wider the audience the better the answers you might get
>>>>
>>>> Also it's more work for moderators who have to accept your messages as
>>>> long as you have not subscribed.
>>>> I'll personally no longer accept them (other moderators still could)
>>>>
>>>> Thanks
>>>>
>>>> Jacques
>>>>
>>>> Le 29/04/2019 à 09:45, Arshitha K M a écrit :
>>>> > hi,
>>>> > I am new to ofbiz. I  met trouble during loading the seed
>>>> data(hello3),
>>>> >
>>>> > The Following Errors Occurred:
>>>> > ERROR: parsing file: ERROR parsing Entity Xml file:
>>>> > org.xml.sax.SAXException: A transaction error occurred reading
>>>> > data<br/>org.ofbiz.entity.GenericEntityException:
>>>> > org.ofbiz.entity.GenericEntityException:
>>>> > org.ofbiz.entity.GenericEntityException: Error while inserting:
>>>> > [GenericEntity:HelloHobby][createdStamp,2019-04-29
>>>> > 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29
>>>> >
>>>> 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29
>>>> > 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29
>>>> > 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the
>>>> > following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION,
>>>> > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
>>>> CREATED_TX_STAMP)
>>>> > VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a
>>>> NULL
>>>> > value.))
>>>> > the entity i want to load seed data is having only two columns
>>>> HelloHobbyId
>>>> > and Description,i did'nt get that,why error message showing as
>>>> > 'HelloPersonId' cannot accept a null value.
>>>> >
>>>> > I tried to load seed data into another entity HelloPerson and that was
>>>> > successful.
>>>> > Could you please help me to fix the error.
>>>> >
>>>>
>>>