You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Aditya Sharma <ad...@hotwaxsystems.com> on 2019/04/29 13:11:01 UTC
Re: Hello3-error while loading seed data
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 <ar...@gmail.com> 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, <
> aditya.sharma@hotwaxsystems.com> 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 <
>> jacques.le.roux@les7arts.com> 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.
>>> >
>>>
>>
Re: Hello3-error while loading seed data
Posted by Aditya Sharma <ad...@hotwaxsystems.com>.
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 <
aditya.sharma@hotwaxsystems.com> 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 <ar...@gmail.com> 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, <
>> aditya.sharma@hotwaxsystems.com> 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 <
>>> jacques.le.roux@les7arts.com> 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.
>>>> >
>>>>
>>>