Error on Accessing Induce Model XML from Database

[Lanzjess]

I install the apache-ofbiz-16.11.03  version to know if it's the same with what I downloaded in SVN that has error in Induce Model XML from Database. And it is so. Accessing the link below I encountered the error message below:

https://localhost:8443/webtools/control/view/ModelInduceFromDb

ERROR in error page, (infinite loop or error page not found with name [/error/error.jsp]), but here is the text just in case it helps you: java.lang.StackOverflowErrorERROR in error page, (infinite loop or error page not found with name [/error/error.jsp]), but here is the text just in case it helps you: java.lang.StackOverflowError

In the log in terminal, I can see below. I already tried to truncate this table server_hit:


 (Error while inserting: [GenericEntity:ServerHit][contentId,webtools.view(java.lang.String)][createdStamp,2017-08-10 16:01:50.212(java.sql.Timestamp)][createdTxStamp,2017-08-10 16:01:50.212(java.sql.Timestamp)][hitStartDateTime,2017-08-10 16:01:33.785(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2017-08-10 16:01:50.212(java.sql.Timestamp)][lastUpdatedTxStamp,2017-08-10 16:01:50.212(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://localhost:8443/webtools/control/main?externalLoginKey=ELe10a3e70-599f-468e-acaa-0eb6b6394a79(java.lang.String)][requestUrl,https://localhost:8443/webtools/control/view/ModelInduceFromDb(java.lang.String)][runningTimeMillis,16425(java.lang.Long)][serverHostName,kexpresstest-ThinkCentre-A58(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10901(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry '10901-webtools.view-2017-08-10 16:01:34-REQUEST' for key 'PRIMARY')))

[Jacques Le Roux]

Thanks for your report Allan,

Indeed, this has stopped to work with R16. It still works with R15.12 branch (tested locally)

The old demo (R13.07) also still works, you might try it from main page http://ofbiz.apache.org/

BTW to see the result in FF you need to look at the source.

We will investigate, please open a Jira about that

https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Contributors+Best+Practices

Jacques


Le 10/08/2017 à 14:07, Lanzjess a écrit :

> I install the apache-ofbiz-16.11.03  version to know if it's the same with
> what I downloaded in SVN that has error in Induce Model XML from Database.
> And it is so. Accessing the link below I encountered the error message
> below:
>
> https://localhost:8443/webtools/control/view/ModelInduceFromDb
>
> ERROR in error page, (infinite loop or error page not found with name
> [/error/error.jsp]), but here is the text just in case it helps you:
> java.lang.StackOverflowErrorERROR in error page, (infinite loop or error
> page not found with name [/error/error.jsp]), but here is the text just in
> case it helps you: java.lang.StackOverflowError
>
> In the log in terminal, I can see below. I already tried to truncate this
> table server_hit:
>
>
>   (Error while inserting:
> [GenericEntity:ServerHit][contentId,webtools.view(java.lang.String)][createdStamp,2017-08-10
> 16:01:50.212(java.sql.Timestamp)][createdTxStamp,2017-08-10
> 16:01:50.212(java.sql.Timestamp)][hitStartDateTime,2017-08-10
> 16:01:33.785(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2017-08-10
> 16:01:50.212(java.sql.Timestamp)][lastUpdatedTxStamp,2017-08-10
> 16:01:50.212(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://localhost:8443/webtools/control/main?externalLoginKey=ELe10a3e70-599f-468e-acaa-0eb6b6394a79(java.lang.String)][requestUrl,https://localhost:8443/webtools/control/view/ModelInduceFromDb(java.lang.String)][runningTimeMillis,16425(java.lang.Long)][serverHostName,kexpresstest-ThinkCentre-A58(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10901(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO SERVER_HIT
> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID,
> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry
> '10901-webtools.view-2017-08-10 16:01:34-REQUEST' for key 'PRIMARY')))
>
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Error-on-Accessing-Induce-Model-XML-from-Database-tp4709440.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Jacques Le Roux]

I had a quick look, it was already not working with preGradle version (r1751307) (where you have to change the path to ModelInduceFromDb.jsp in the
controller to see the same error)

Jacques


Le 10/08/2017 à 14:58, Jacques Le Roux a écrit :

> Thanks for your report Allan,
>
> Indeed, this has stopped to work with R16. It still works with R15.12 branch (tested locally)
>
> The old demo (R13.07) also still works, you might try it from main page http://ofbiz.apache.org/
>
> BTW to see the result in FF you need to look at the source.
>
> We will investigate, please open a Jira about that
>
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Contributors+Best+Practices
>
> Jacques
>
>
> Le 10/08/2017 à 14:07, Lanzjess a écrit :
>> I install the apache-ofbiz-16.11.03 version to know if it's the same with
>> what I downloaded in SVN that has error in Induce Model XML from Database.
>> And it is so. Accessing the link below I encountered the error message
>> below:
>>
>> https://localhost:8443/webtools/control/view/ModelInduceFromDb
>>
>> ERROR in error page, (infinite loop or error page not found with name
>> [/error/error.jsp]), but here is the text just in case it helps you:
>> java.lang.StackOverflowErrorERROR in error page, (infinite loop or error
>> page not found with name [/error/error.jsp]), but here is the text just in
>> case it helps you: java.lang.StackOverflowError
>>
>> In the log in terminal, I can see below. I already tried to truncate this
>> table server_hit:
>>
>>
>>   (Error while inserting:
>> [GenericEntity:ServerHit][contentId,webtools.view(java.lang.String)][createdStamp,2017-08-10
>> 16:01:50.212(java.sql.Timestamp)][createdTxStamp,2017-08-10
>> 16:01:50.212(java.sql.Timestamp)][hitStartDateTime,2017-08-10
>> 16:01:33.785(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2017-08-10
>> 16:01:50.212(java.sql.Timestamp)][lastUpdatedTxStamp,2017-08-10
>> 16:01:50.212(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://localhost:8443/webtools/control/main?externalLoginKey=ELe10a3e70-599f-468e-acaa-0eb6b6394a79(java.lang.String)][requestUrl,https://localhost:8443/webtools/control/view/ModelInduceFromDb(java.lang.String)][runningTimeMillis,16425(java.lang.Long)][serverHostName,kexpresstest-ThinkCentre-A58(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10901(java.lang.String)]
>>
>> (SQL Exception while executing the following:INSERT INTO SERVER_HIT
>> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
>> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
>> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID,
>> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?,
>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry
>> '10901-webtools.view-2017-08-10 16:01:34-REQUEST' for key 'PRIMARY')))
>>
>>
>>
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.com/Error-on-Accessing-Induce-Model-XML-from-Database-tp4709440.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>

[Lanzjess]

Hi Jaques,

Thank you for checking out on this issue. I already created a bug issue
about this.
Please assign this to the concerned person.

Regards,

On Thu, Aug 10, 2017 at 5:53 PM, Jacques Le Roux <
[hidden email]> wrote:

> I had a quick look, it was already not working with preGradle version
> (r1751307) (where you have to change the path to ModelInduceFromDb.jsp in
> the controller to see the same error)
>
> Jacques
>
>
>
> Le 10/08/2017 à 14:58, Jacques Le Roux a écrit :
>
>> Thanks for your report Allan,
>>
>> Indeed, this has stopped to work with R16. It still works with R15.12
>> branch (tested locally)
>>
>> The old demo (R13.07) also still works, you might try it from main page
>> http://ofbiz.apache.org/
>>
>> BTW to see the result in FF you need to look at the source.
>>
>> We will investigate, please open a Jira about that
>>
>> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+
>> Contributors+Best+Practices
>>
>> Jacques
>>
>>
>> Le 10/08/2017 à 14:07, Lanzjess a écrit :
>>
>>> I install the apache-ofbiz-16.11.03 version to know if it's the same with
>>> what I downloaded in SVN that has error in Induce Model XML from
>>> Database.
>>> And it is so. Accessing the link below I encountered the error message
>>> below:
>>>
>>> https://localhost:8443/webtools/control/view/ModelInduceFromDb
>>>
>>> ERROR in error page, (infinite loop or error page not found with name
>>> [/error/error.jsp]), but here is the text just in case it helps you:
>>> java.lang.StackOverflowErrorERROR in error page, (infinite loop or error
>>> page not found with name [/error/error.jsp]), but here is the text just
>>> in
>>> case it helps you: java.lang.StackOverflowError
>>>
>>> In the log in terminal, I can see below. I already tried to truncate this
>>> table server_hit:
>>>
>>>
>>>   (Error while inserting:
>>> [GenericEntity:ServerHit][contentId,webtools.view(java.lang.
>>> String)][createdStamp,2017-08-10
>>> 16:01:50.212(java.sql.Timestamp)][createdTxStamp,2017-08-10
>>> 16:01:50.212(java.sql.Timestamp)][hitStartDateTime,2017-08-10
>>> 16:01:33.785(java.sql.Timestamp)][hitTypeId,REQUEST(java.
>>> lang.String)][lastUpdatedStamp,2017-08-10
>>> 16:01:50.212(java.sql.Timestamp)][lastUpdatedTxStamp,2017-08-10
>>> 16:01:50.212(java.sql.Timestamp)][partyId,admin(java.lang.
>>> String)][referrerUrl,https://localhost:8443/webtools/
>>> control/main?externalLoginKey=ELe10a3e70-599f-468e-acaa-
>>> 0eb6b6394a79(java.lang.String)][requestUrl,https://
>>> localhost:8443/webtools/control/view/ModelInduceFromDb
>>> (java.lang.String)][runningTimeMillis,16425(java.
>>> lang.Long)][serverHostName,kexpresstest-ThinkCentre-A58(
>>> java.lang.String)][serverIpAddress,127.0.1.1(
>>> java.lang.String)][userLoginId,admin(java.lang.String)][
>>> visitId,10901(java.lang.String)]
>>> (SQL Exception while executing the following:INSERT INTO SERVER_HIT
>>> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
>>> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
>>> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
>>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP,
>>> INTERNAL_CONTENT_ID,
>>> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES
>>> (?,
>>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry
>>> '10901-webtools.view-2017-08-10 16:01:34-REQUEST' for key 'PRIMARY')))
>>>
>>>
>>>
>>>
>>> --
>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>> com/Error-on-Accessing-Induce-Model-XML-from-Database-tp4709440.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>
>>
>

--
*Allan L. Zarsuela*

*Software Developer*

[Jacques Le Roux]

Thanks Allan,

You reported at https://issues.apache.org/jira/browse/OFBIZ-9582

There was already https://issues.apache.org/jira/browse/OFBIZ-7473

But for now I keep both (ie I don't close OFBIZ-9582 as a duplicate yet) because they both contain interesting information

Jacques


Le 16/08/2017 à 15:22, Allan Zarsuela a écrit :

> Hi Jaques,
>
> Thank you for checking out on this issue. I already created a bug issue
> about this.
> Please assign this to the concerned person.
>
> Regards,
>
> On Thu, Aug 10, 2017 at 5:53 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
>> I had a quick look, it was already not working with preGradle version
>> (r1751307) (where you have to change the path to ModelInduceFromDb.jsp in
>> the controller to see the same error)
>>
>> Jacques
>>
>>
>>
>> Le 10/08/2017 à 14:58, Jacques Le Roux a écrit :
>>
>>> Thanks for your report Allan,
>>>
>>> Indeed, this has stopped to work with R16. It still works with R15.12
>>> branch (tested locally)
>>>
>>> The old demo (R13.07) also still works, you might try it from main page
>>> http://ofbiz.apache.org/
>>>
>>> BTW to see the result in FF you need to look at the source.
>>>
>>> We will investigate, please open a Jira about that
>>>
>>> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+
>>> Contributors+Best+Practices
>>>
>>> Jacques
>>>
>>>
>>> Le 10/08/2017 à 14:07, Lanzjess a écrit :
>>>
>>>> I install the apache-ofbiz-16.11.03 version to know if it's the same with
>>>> what I downloaded in SVN that has error in Induce Model XML from
>>>> Database.
>>>> And it is so. Accessing the link below I encountered the error message
>>>> below:
>>>>
>>>> https://localhost:8443/webtools/control/view/ModelInduceFromDb
>>>>
>>>> ERROR in error page, (infinite loop or error page not found with name
>>>> [/error/error.jsp]), but here is the text just in case it helps you:
>>>> java.lang.StackOverflowErrorERROR in error page, (infinite loop or error
>>>> page not found with name [/error/error.jsp]), but here is the text just
>>>> in
>>>> case it helps you: java.lang.StackOverflowError
>>>>
>>>> In the log in terminal, I can see below. I already tried to truncate this
>>>> table server_hit:
>>>>
>>>>
>>>>    (Error while inserting:
>>>> [GenericEntity:ServerHit][contentId,webtools.view(java.lang.
>>>> String)][createdStamp,2017-08-10
>>>> 16:01:50.212(java.sql.Timestamp)][createdTxStamp,2017-08-10
>>>> 16:01:50.212(java.sql.Timestamp)][hitStartDateTime,2017-08-10
>>>> 16:01:33.785(java.sql.Timestamp)][hitTypeId,REQUEST(java.
>>>> lang.String)][lastUpdatedStamp,2017-08-10
>>>> 16:01:50.212(java.sql.Timestamp)][lastUpdatedTxStamp,2017-08-10
>>>> 16:01:50.212(java.sql.Timestamp)][partyId,admin(java.lang.
>>>> String)][referrerUrl,https://localhost:8443/webtools/
>>>> control/main?externalLoginKey=ELe10a3e70-599f-468e-acaa-
>>>> 0eb6b6394a79(java.lang.String)][requestUrl,https://
>>>> localhost:8443/webtools/control/view/ModelInduceFromDb
>>>> (java.lang.String)][runningTimeMillis,16425(java.
>>>> lang.Long)][serverHostName,kexpresstest-ThinkCentre-A58(
>>>> java.lang.String)][serverIpAddress,127.0.1.1(
>>>> java.lang.String)][userLoginId,admin(java.lang.String)][
>>>> visitId,10901(java.lang.String)]
>>>> (SQL Exception while executing the following:INSERT INTO SERVER_HIT
>>>> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
>>>> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
>>>> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
>>>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP,
>>>> INTERNAL_CONTENT_ID,
>>>> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES
>>>> (?,
>>>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry
>>>> '10901-webtools.view-2017-08-10 16:01:34-REQUEST' for key 'PRIMARY')))
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>>> com/Error-on-Accessing-Induce-Model-XML-from-Database-tp4709440.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>>
>>>
>