You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Michael Brohl (JIRA)" <ji...@apache.org> on 2017/09/10 10:20:00 UTC

[jira] [Comment Edited] (OFBIZ-7473) Induce Model XML from Database throws exception

    [ https://issues.apache.org/jira/browse/OFBIZ-7473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16160287#comment-16160287 ] 

Michael Brohl edited comment on OFBIZ-7473 at 9/10/17 10:19 AM:
----------------------------------------------------------------

Additional information from [~allan.zarsuela] in OFBIZ-9582:

Environment:

Ubuntu 16.04
Apache OFBiz Version 16.11.03
MySQL DB Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper
mysql-connector-java-5.1.37-bin.jar

I installed 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.

Steps to duplicate Bug:
1. Download and install apache-ofbiz-16.11.03 version
2. Log in username and password respectively as admin ofbiz.
3. 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')))



was (Author: mbrohl):
Additional information from [~allan.zarsuela] in OFBIZ-9582:



I installed 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.

Steps to duplicate Bug:
1. Download and install apache-ofbiz-16.11.03 version
2. Log in username and password respectively as admin ofbiz.
3. 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')))


> Induce Model XML from Database throws exception
> -----------------------------------------------
>
>                 Key: OFBIZ-7473
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-7473
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework/webtools
>    Affects Versions: Trunk
>            Reporter: Gopal Yadav
>            Assignee: Jacques Le Roux
>             Fix For: Upcoming Release
>
>         Attachments: OFBIZ-7473.patch
>
>
> Go to Webtools -> Import/Export -> Induce Model XML from Database (https://localhost:8443/webtools/control/view/ModelInduceFromDb)
> An exception is thrown: javax.servlet.ServletException: File [/entity/ModelInduceFromDb.jsp] not found.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)